PLEASE DON'T COPY AND PASTE THE ANSWER OF THIS QUESTION FROM OTHER SITES. I DIDNT GET A COMPLETE ANSWER ANYWHERE ELSE. 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. List the possible business rules based on the scenario. Identify all 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.
PLEASE DON'T COPY AND PASTE THE ANSWER OF THIS QUESTION FROM OTHER SITES. I DIDNT GET A COMPLETE ANSWER ANYWHERE ELSE. 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. List the possible business rules based on the scenario. Identify all 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.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
PLEASE DON'T COPY AND PASTE THE ANSWER OF THIS QUESTION FROM OTHER SITES. I DIDNT GET A COMPLETE ANSWER ANYWHERE ELSE.
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.
- List the possible business rules based on the scenario.
- Identify all 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.