RockNJazz Universal Album is a leading music library in Florida. The library has various branches located in Weston, Miami, Phoenix, and Greensboro. Each branch of the library has a huge collection of music and movie cassettes, DVDs, and CDs that the members of the library can borrow. To borrow CDs, DVDs, or cassettes from the library, the members need to register themselves with the library by paying a nominal non-refundable fee.
To maintain member records, the library has hired an executive who maintains member information in the Member register. The details stored in this register consist of MemberID, MemberName,
Gender, Address, and the amount paid by each member. After registration, a member receives a lifetime membership ID that he/she needs to quote while borrowing from the library. Each time a member borrows or returns a CD, DVD, or cassette, the executive at the issuing counter needs to update the Issue/Return register. The Issue/Return register stores the following details:
MemberID
MemberName
DateofIssue
DateofReturn
ItemID
ItemName
ItemQuantity
Tariff
AmountPaid
Balance
In addition to the Issue/Return register, the executive needs to maintain a Stock register in order to manage the details of the items available in the library. The details stored in the Stock register consist of ItemID, ItemName, ItemType, ItemQuantity, and DateofRelease.
The library is reputed for excellent service and has over twenty thousand active members. In addition, the number of new members is increasing rapidly. Consequently, it has become very difficult for the library to manually manage the records and transactions. Therefore, the management has decided to use a library management application to manage the records and transactions.
The management approaches HighTech Inc. to develop the application. At HighTech Inc., James Blunt and his team have been assigned the task to create the required application. Being the database developer in the team, you have been assigned the task to analyze the application requirements and create the required database and tables. You need to analyze the requirements of the preceding application and perform the following tasks:
1. Identify the various entities and their attributes involved in the application. [5 Marks] 2. Identify the attributes that are unique to each of the entities. [3 Marks] 3. Identify the relationships that may exist among the entities of the application. [2 Marks]
Download Link
|
|
No comments:
Post a Comment