•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 427,800 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,772 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 5234 | Replies: 1
 |
•
•
Join Date: Nov 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I Have to help my bro in his assignment.. am trying to solve it.. have did sth but not able to understand properly..
can u guys help ?
Q: The owners of a video store have asked us to design a database to maintain records of their customers and videos. The Database should be able to indicate when a movie has been checked out and to whom it was checked out. The Database should also be able to recognize that one customer account can have more than one person who can check out movies. (NB: we do not need a list of “old transactions” once the video has been returned, we can forget that the video has ever been rented)
Draw the EER diagram for this database.
Mention all assumptions that you make ?
Thanks
can u guys help ?
Q: The owners of a video store have asked us to design a database to maintain records of their customers and videos. The Database should be able to indicate when a movie has been checked out and to whom it was checked out. The Database should also be able to recognize that one customer account can have more than one person who can check out movies. (NB: we do not need a list of “old transactions” once the video has been returned, we can forget that the video has ever been rented)
Draw the EER diagram for this database.
Mention all assumptions that you make ?
Thanks
•
•
Join Date: Oct 2006
Posts: 10
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
visit this site i hope it will be useful, good luck
http://www.databaseanswers.org/data%5Fmodels/
http://www.databaseanswers.org/data%5Fmodels/
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Help needed with VB Assignment (Visual Basic 4 / 5 / 6)
- assignment help (Database Design)
- OO assignment help (Java)
- Many Errors while doing this assignment (C)
- I need help on my 'address book' assignment! (C++)
Other Threads in the Database Design Forum
- Previous Thread: sql tutorial
- Next Thread: Access Database file conversion
