Tech Tool: Spreadsheet Software or Visio Software
Software Video: ERD and REA Drawing
Refer to the EspressoCoffee invoice shown in Figure 14.12 and the 10 steps to relational database design and development in Figure 14.24. Then complete the following steps.
1. Identify entities involved.
2. Identify the relationships among entities.
3. Identify entity identifiers.
4. Draw an entity relationship diagram.
5. Remove many-to-many relationships, if necessary.
6. Add entity attributes.
7. Print your ERD.
FIGURE 14.12
EspressoCoffee Sales Order (Invoice)
FIGURE 14.24
Relational Database Design and Development
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.