Question
Create the Physical ERD using Microsoft Visio or other diagram drawing software. You will design a database for this company so that they wont be
Create the Physical ERD using Microsoft Visio or other diagram drawing software.
You will design a database for this company so that they wont be relying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the separate entities and attributes and design a physical level Entity Relationship Diagram for this company.
| OrderNum | OrderDate | PartNum | Description | NumOrdered | QuotedPrice |
| 21608 | 10/20/2010 | AT94 | Iron | 11 | $21.95 |
| 21610 | 10/20/2010 | DR93 | Gas Range | 1 | $495.00 |
| 21610 | 10/20/2010 | DW11 | Washer | 1 | $399.99 |
| 21613 | 10/21/2010 | KL62 | Dryer | 4 | $329.95 |
| 21614 | 10/21/2010 | KT03 | Dishwasher | 2 | $595.00 |
| 21617 | 10/23/2010 | BV06 | Home Gym | 2 | $794.95 |
| 21617 | 10/23/2010 | CD52 | Microwave Oven | 4 | $150.00 |
| 21619 | 10/23/2010 | DR93 | Gas Range | 1 | $495.00 |
| 21523 | 10/23/2010 | KV29 | Treadmill | 2 | $1290.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Seven NoSQL Databases In A Week Get Up And Running With The Fundamentals And Functionalities Of Seven Of The Most Popular NoSQL Databases
Authors: Aaron Ploetz ,Devram Kandhare ,Sudarshan Kadambi ,Xun Wu
1st Edition
1787288862, 978-1787288867
