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 Entity-Relationship (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 multi-valued 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 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 Finance Questions!