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

7 Pages498 Words238 Views

Added on 2019-09-21

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

Added on 2019-09-21

Related Documents

STUDENT30SEPTEMBER,2016ITERATION4ASSIGNMENT

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

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

ENHANCED BUSINESS RULES The enhanced business rules after iteration 4 are as follows: There will a separate table to store login detailsA 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 customersA customer account has a single movie queue to add one or more movies to it.A DVD can be rented by one or more customersEach DVD will have unique ID to store its info.Each movie will have unique ID to store its info.Customers rent one or more DVDsA 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

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

End of preview

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