Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Draw the E-R diagram (Crow’s Foot Model) and Relationship Schema to show the relationships between the entities and attributes.

Draw the E-R diagram (Crow’s Foot Model) and Relationship Schema to show the relationships between the entities and attributes.

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
See similar textbooks
icon
Related questions
Question
100%
The CJ Secondary School requires a new database management system in their library to
replace their existing manual system. Accordingly, their database should store information about
the members of the library (i.e. students and staff), available books, magazines and such. The
following is a more detailed sample of the data required from the two main entities in the
system.
Library members
• Membership number
• Name
• Type (student/staff/alumni etc.)
• Membership validity
Library items (books/magazines)
• Item ID (i.e. ISBN number, Dewey decimal number)
• Author/Editor
• Edition (optional)
• Abstract
• Publisher
• Title
• Type (book – hard/soft cover, magazine, journal, paper, e-book)
• Loan type (time restricted/red spot/normal)
Also required in the system is a method to track the library loans and returns. Each member of
the library is only allowed a limited number of loans for a fixed period of time. Renewals are
possible only for the first time round (i.e. only one renewal is allowed) for an extension of an extra
week. Items that are overdue are subject to a penalty.
 
  1. List the possible business rules based on the scenario.
  2. Identify all the entities and attributes.
  3. Draw the E-R diagram (Crow’s Foot Model) and Relationship Schema to show the relationships between the entities and attributes.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Transaction Processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS