The ERD for the Basic Library System - IT Assignment Help

Assignment Task

Basic Library System

Task
Now, answer the following questions:
1) Name the entities in the ERD for the Basic Library System.
2) Name the attributes in the ERD for the Basic Library System
3) List the primary keys for each entity in the ERD for the Basic Library System
4) List the composite attributes identified in the ERD for the Basic Library System.
5) List the relationships in the ERD for the Basic Library System.
6) Write Enterprise Rules that describe the degree and membership for each relationship in the ERD for the Basic Library System.

Task 2-Develop a Database for a Library Information System
Consider the following description for a Library Information System:
A library needs to keep records of current loans of copies of books to borrowers and reservations for book titles. Each borrower is identified by a BORROWER# and each copy of a book title in the library is identified by an ACCESS# as the library may have more than one copy of a given book title. The NAME and ADDRESS of each borrower is held so that communications such as overdue loan reminders can be sent when necessary. The information required about book titles is TITLE, AUTHORS, PUBLISHERS, PUBLICATION DATE, and ISBN. For individual copies of a book title the PURCHASE PRICE and CURRENT PRICE are required, where purchase price is the price the library paid at the time of purchase and current price is the current listed price charged to borrowers who lose books. ISBN is an internationally used identifier for a book title. A borrower may have any number of books out on loan at any one time, but a book may be borrowed by only one borrower at a time. The DUE DATE for each loan is recorded so that overdue notices can be sent out. Book titles out on loan may be reserved by other borrowers pending their return. Borrowers may make a reservation for only one book title at a time. Reservations for a book title are processed in order of the date the reservation was made as copies are returned.
1) List Enterprise Rules and any assumptions that are required to complete an ERD.
2) Develop an ERD for the Library Information System and confirm with your Trainer before proceeding to the next task. To do that you must consider followings:

• Characteristics of entities
• Characteristics of relationships
• Entity-Relationship occurrence diagrams
• Characteristics of attributeso Types of attributes
• Primary Key attributes
• Attribute domain
• Extended characteristics of relationships
• Degree of relationship
• Entity-Relationship occurrence diagrams and degree of relationship
• Membership constraints
• Membership constraints combined with degree of relationships
• Enterprise rules
• Normalising the data model
• Occurrence of attributes
• Multi-valued attributes
• Many: many relationships
• Guidelines for drawing an extended and detailed Entity-Relationship Diagram
• Create a sample Data Dictionary for the ERD (for one entity only) which must contain-
• The entity descriptions (one entity only)
• A list of attributes to be included in the data dictionary from the documentation of the entity (the one you have chosen to describe)
• Attribute name (User name)
• Alias (Synonym)
• Data Source
• Data Structure
• Type
• Length and format
• Characteristics
• Range of values and meanings of values
• Description
• The attribute description.

This IT Assignment has been solved by our IT Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There is one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.