Question: Need help with question 2 Homework: Reading: 1. Chapter 3 of LIU Design: 1. Correctness Questions: online 1. Build an ERD for a factory that

Need help with question 2  Need help with question 2 Homework: Reading: 1. Chapter 3 of

Homework: Reading: 1. Chapter 3 of LIU Design: 1. Correctness Questions: online 1. Build an ERD for a factory that represents the following requirements and business rules. Make up your own attributes for each entithy involved. 1) A component can be used to make any of several other components; 2) A component can be made of several other components 3) A component can be constructed from several raw materials; 4) A raw material is used in several components: 5) Each component is produced by a single worker; 6) A worker can produce many kinds of components; 7) A component may need a certain quantity of other components and raw materials; 8) There are two kinds of raw materals: parishable ones time and desirable storage temperature, and non-perishables that does not have expiration time or storage restrictions that have definite expiration 3. Completeness Questions 1. Library System: Create an ERD for a library to keep track of ts readers, books, physical book copies, reservations, checkouts, eurns due dates, late fees. Note that different reader categories often come with different borrowing privileges such as types of books to check out and how long to keep the books. Identity weak entity (or entities), associative entity (ensties), and recursive relationship (relationships). Then draw the complete ERD to model the data requirements Add Comments/ Logon User: TL Like Share Be the first of your friends to like this Blog News Post About Developer 1997-2017 ecourse.org. All rights reserved Privacy Polloy Nows Digest Contact Us Blog Posts

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!