logo

STUDENT. 30 SEPTEMBER, 2016. ITERATION 4 ASSIGNMENT. ST

   

Added on  2019-09-21

7 Pages498 Words238 Views
STUDENT30SEPTEMBER,2016ITERATION4ASSIGNMENT

ContentsENHANCED BUSINESS RULES.................................................................................2CONCEPTUAL ERD....................................................................................................3LOGICAL ERD.............................................................................................................4USECASE AND SQL...................................................................................................51 |Page

ENHANCED BUSINESS RULES The enhanced business rules after iteration 4 are as follows: There will a separate table to store login detailsA customer must sign up for one account. Each customer will have a unique customer ID which will be there user ID.Each account will have a customer.Each customer must select one DVD rental program at a time.A DVD rental program is selected by one or more customersA customer account has a single movie queue to add one or more movies to it.A DVD can be rented by one or more customersEach DVD will have unique ID to store its info.Each movie will have unique ID to store its info.Customers rent one or more DVDsA customer can have one or more credit card information.A credit card information must belong to a single customer. Each DVD rental program will have unique ID to store its info.Each movie will have an associated DVD to it and there will be copies of same DVD.Entire address of the customer will be stored in the customer.There will be zero or one DVD for a movie available. 2 |Page

End of preview

Want to access all the pages? Upload your documents or become a member.