• 0

Need Urgent Help!


Question

SUBJECT: Database Systems

Hey Neowin.

I have an assignment due soon but I don't understand one of the questions.

It asks us to answer Exercises 12.10 out of a text book named "Database Systems - A practical approach to design, implementation and management"

The questions are as follows:

12.10 Create an ER model for each of the following descriptions:
(a ) Each company operates four departments, and each department belongs to one company
(b ) Each department in part (a) employs one or more employees, and each employee works for one department
(c ) Each of the employees in part (b ) may or may not have one more dependents, and each dependent belongs to one employee
(d ) Each employee in part (c) may or may not have one or more dependents, and each dependent belongs to one employee
(e ) Represent all the ER models described in (a ), (b ), (c ) and (d ) as a single ER model

Unfortunately, I don't understand how to do this.

Would anyone be able to provide any support?

Regards,

Steven Johns

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

You have to draw an ER diagram for each of the situations http://en.wikipedia.org/wiki/Entity-relationship_model

The model should respresent whatever is asked in the question. For example, in (a) You would have a Company entity and a Department entity and you would have to indicate with a line that they are related and show the relationship(one-to-many) between them.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.