Question: I am having a hard time with this assignment, because I do not have the book yet. Any help would be appreciated. Book that is

I am having a hard time with this assignment, because I do not have the book yet. Any help would be appreciated.

Book that is helpful for this assignment:

Database Systems: Introduction to Databases and Data Warehouses; Nenad Kukic, Susan Vrbsky, and Svetlozar; ISBN-10: 013257567-1; ISBN-13: 978-013-257567-6

I am having a hard time with this assignment, because I do

Develop a conceptual model in ERD Plus for a commercial Library using entity-relationship methodology. The library offers a variety of products to its customers. These include books, journals, magazines, multimedia content etc. The products can be loaned by the customers for a fee that is determined by the duration of the loan. Penalty is levied if a loan is not returned by the designated date and time. The database is required to keep track of all the transactions occurring in the library. Besides providing details about the patrons and the holdings, the system should be able to able to point to the specific location where each item is shelved. The system should be able to generate a list of customers and material that are overdue. Use your common knowledge about libraries to develop this conceptual model. Clearly mark/label: 1. Entities 2. Attributes 3. Relationships 4. Primary Key Attributes 5. Participation and Cardinality constraints Organize various objects in the diagram so that it is easy to read. Avoid unnecessary clutter and crossings of relationship lines. Add comments and assumptions as necessary. Create the model in ERD-Plus. When done, save the diagram as an image in PNG format. Insert this image in the Overleaf template. Upload the compiled pdf in BlackBoard. A tutorial to insert a figure in Overleaf is available in Multimedia folder in BlackBoard. Adjust the size of the image so that the diagram is readable. Make effective use of available space and do not leave much empty space. You may have to move entities and relationship lines to optimize the space and improve clarity. The quality of the ER model will be assessed on following metrics: 1. Correctness of various elements of the model. 2. Establishing logical relationships. 1 3. Completeness of the model reflected by including all relevant attributes and entities. A good ERD requires a logical and complete conceptualization and correct representation of entities, attributes, relationship, cardinality constraints, and other important concepts. The model should include all elements that are necessary but not include redundant entities, attributes, and relationships. 4. Complying with instructions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!