Question: Construct an ER diagram for the Worksite database based on the given description. State any assumptions. A worksite has a particular address together with a
Construct an ER diagram for the Worksite database based on the given description. State any assumptions.
A worksite has a particular address together with a description.
A worksite has several named workers with tax file numbers and their tasks, and one worksite has one manager. Building materials are classified by type and with a description.
Truck companies have unique ACN. Company name, phone and address should also be recorded.
Building materials are delivered by trucking companies on a specified date to a manager at the worksite.
There are several manufacturers of each kind of building material, each with their own business name and address.
Based on the given description, model the given business rules, and present your model as an EntityRelationship ER diagram. Carefully state any assumptions you make. In your ER diagram, you must properly denote all applicable concepts, including weak or strong entities, keys, composite or multivalued attributes, relationships and their cardinality and participation constraints.
If you cannot represent any of this information in the ER model, clearly explain what limitations in the ER model restrict you from representing your mode
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
