Question: a) Write at least 10 business rules for the ER Diagram below Horizon PKFK1 | PROTid PK,FK1 PROTdate PK HRZid Equipment PK EQPnumber Haul HRZname

a) Write at least 10 business rules for the ER

a) Write at least 10 business rules for the ER Diagram below Horizon PKFK1 | PROTid PK,FK1 PROTdate PK HRZid Equipment PK EQPnumber Haul HRZname HRZmaterial is part of -----OH EQPserial EQPyear EQPmanufacturer EQPmodel EQPtype EQPdelivery_date EQPtires EQPfleet Production_trucks TS_Crew_Rotation PK PROTid PROTdate PK CRRid -H--Requires -- PK PK CRRdate PROTload PROTtons FK1 EMPid $ FK2 EQPnumber Consumes Contains Drives FUEL PK FULid Crew_Code PK CRCid CRCname FK1 CRRid FK1 CRRdate FULdate Employee FULtype PK EMPid FULlocation FH------Delivers-------- FULamount EMPfirstname FULmotor_hours EMPlastname FULcraft_hours EMPaddress FK1 EMPid EMPzip PROTG EMPtelephone FK2 EQPnumber ) How many entities are in the ER Diagram above and what are they? List composite keys from the above ER Diagram

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 General Management Questions!