Project Assignment 2

CSC319 - Database Technology

Due: 11/12/2001

You are a new hire at a local consulting firm and have been assigned to a software development team. Your first project involves the design and implementation of a database system for a video store. Preliminary requirements indicate that the video store operates like a club. That is, only members of the club may borrow from the catalog which contains DVD's, video tapes, and music CD's. The requirements also indicate that the database system must keep track of items in the catalog as well as club members.

Your most recent conversation with your contact at the video store provided the following additional details:

• Members borrow as many DVD's, video tapes, and CD's as they wish.
• Items are classified by genre. That is, movies may be classified as action, comedy etc. and music as classical, jazz, etc.
• Items are classified as either new releases or oldies.
• An item may exist more than once in the catalog. (i.e. the DVD and video tape of a particular movie may be stocked)
• Multiple copies of a particular item may be stocked. (e.g. twenty video tape copies of a particular movie).
• Items may be borrowed for 1 day, 3 days, or a week (7 days).

You have limited time to produce a design. Your design will be presented to managers of the store. The quality of your design will determine if your firm gets the development contract.

Note that the problem definition is somewhat incomplete, so you may have to make assumptions about how information should be represented. Make any reasonable additional assumptions. Do not over complicate the design. Be sure to state your assumptions clearly. You will have one more chance to speak to your contact before the presentation and so you must be prepared to resolve any ambiguities or incomplete information at that time.

You must create an ER diagram using the notation discussed in our text. Use the drawing tool Visio (or any other tool you are familiar with).

Submit hardcopy of the ER model along with any assumptions and additional requirements gleaned from additional interviews with the client.