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

Added on - 21 Sep 2019

  • 7

    pages

  • 498

    words

  • 102

    views

  • 0

    downloads

Showing pages 1 to 3 of 7 pages
STUDENT30SEPTEMBER,2016ITERATION4ASSIGNMENT
ContentsENHANCED BUSINESS RULES.................................................................................2CONCEPTUAL ERD....................................................................................................3LOGICAL ERD.............................................................................................................4USECASE AND SQL...................................................................................................51|Page
ENHANCED BUSINESS RULESThe 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 sameDVD.Entire address of the customer will be stored in the customer.There will be zero or one DVD for a movie available.2|Page
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document