I need to draw a single Entity Relationship Diagram (ERD) to represent the following situation, which is described by means of text and a relational data model.
A relational database has been designed for a company which sells merchandise through magazine advertising. Customers who want to place an order call a toll-free telephone number and place an order for the items that they require. This order is entered through an on-line terminal and is later filled and shipped by the stock room. The customer may pay for the purchase by credit card or pay ‘collect’ (that is, they pay at the time the goods are delivered).
Each table is described below, with the primary key underlined and foreign keys defined.
Originally posted by r937
when is it due, how much of it have you done so far, can we see it, and what's your question?
How do you start a diagram, do you follow the flow of the primary and foreign keys? How do you represent the relationships? I read that they should be expressed as verbs, why can't the primary keys be used in the diagram?