IMR_2

Slide 1: 

International Movie Rentals Max Data Plan Maximizing your data maximizes your dollar, that’s what we do. Paul Turner CDD Dennis Siladi CDO Janet Ward CFO

Assumptions : 

Assumptions Currently has only one store. All movies must have a unique ID All movies must be in DVD or VHS format or both Movie must span one and only one DVD or VHS The system must keep information on actors appearing in the inventoried movies Star actors are the actors appearing on the movie label Star actor request from customers Customers may rent multiple movies Customer must have a Video club membership to rent movies Maintain a count of each movie on DVD or VHS

Understanding Your Flow : 

Understanding Your Flow Customer Request Actor Movie Title Rental Transaction Transaction Status

Entities : 

Entities Movies Actors Actors In Movie Actor Request Physical Movie Customer Rental History

Attributes : 

Attributes Movie Attributes Movie_id (primary key) Title (required) Year Genre PGA rating Actors Attributes SAG_id(primary key) Stage name Real name (required) Date of birth (required) Actors In Movie Attributes Movie_id (foreign key) SAG_id (foreign key) Actor request SAG_id Membership_id Request_Date

Attributes : 

Attributes Physical Movie Attributes Bacode (primary key) Copy_number (primary key) Movie_id(foreign key) Format_type (required) Rental Rate (required) Customer Attributes Membership_id (primary key) First_name (required) Last_name (required) Phone_number(required) Address (required) Join_Date (required) Rental History Attributes Membership_id (foreign key) Barcode (foreign key) Copy_number (foreign key) Rental date (required) Return date

International Movie RentalsConceptual Information Model : 

Movie # Movie_Id * title * year o genre o PGA_rating Customer # membership_id * first_name * last_name * phone * address * join_date Physical_Movie # barcode * copy_number * title * format_type o rental_rate Star Actor #SAG_Id * stage_name * real_name * birth_date Future Financial System Information Interface International Movie RentalsConceptual Information Model

Slide 8: 

Rental_History * rental_date * return_date Actor_In_Movie Actor_Request * date Movie # Movie_Id * title * year o genre o PGA_rating Star Actor #SAG_Id * stage_name * real_name * birth_date International Movie Rentals Entity Relationship Diagram Customer # membership_id * first_name * last_name * phone * address * join_date Physical_Movie # barcode * copy_number * title * format_type o rental_rate

System will be able to: : 

System will be able to: Track rentals by customer Track rentals by actor Track rental history by movie Track rental count per movie copy for replacement Track movies that have not been returned on time Member can’t check out a movie that has not been returned.

Recommendation : 

Recommendation We delete actors who do not appear in inventoried movies. Join date will be recorded for additional reporting options such as a member who has not rented a movie for a year. (renewal) After a year rent 5 movies get 1 free Additional advertising options Bar code scanner – easy and accurate data input Future interfaces Financial data Employee data