Question: Suppose we informally define the data in the database of a deportment ritore as follews: ( 7 ) Eact imployu is replesented. The datis about
Suppose we informally define the data in the database of a deportment ritore as follews:
Eact imployu is replesented. The datis about an empley u consist of employe number, mame, coldthess the departmint that he worts for.
Each department is reprisented. The data about ol youtment. consint of in name, employ us manager & itumn sold
i Eoch ifem sold is represented. The data abut itum sold consis If its name, manufacturur, price, model No asioned by the manufacturer &f an internal item number ansigued by the store
Each manufactures is represented. The dath about manufactios consist of it name, address, item supplied to the store & thie phices.
Give an entity relationship diagham for this database.
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
