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:
(7) Eact imployu is replesented. The datis about an empley u consist of employe number, mame, coldthess the departmint that he worts for.
(3) Each department is reprisented. The data about ol youtment. consint of in name, employ us, manager & itumn sold
(i5) 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).
(11) Each manufactures is represented. The dath about manufactios consist of it name, address, item supplied to the store & thie phices.
Give an entity relationship (E-R) diagham for this database.
Suppose we informally define the data in the

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 Programming Questions!