Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The manager of a trading company wants to keep the following data about customer sales and has created the table below: Customer name Customer ID
The manager of a trading company wants to keep the following data about customer sales and has created the table below:
Customer name | Customer ID | Contact number | Item purchase | Item description | Quantity | Invoice # | Invoice date |
Chan | 301 | 6192 2789 | 409 | Sugar | 3 | 44 | Jan 3, 2021 |
Chan | 301 | 6192 2789 | 420 | Rice | 1 | 44 | Jan 3, 2021 |
Peter | 302 | 8902 2913 | 413 | Noodles | 3 | 45 | Jan 15, 2021 |
Joe | 303 | 2391 1092 | 409 | Sugar | 4 | 46 | Jan 20, 2021 |
Joe | 303 | 2391 1092 | 413 | Salt | 1 | 46 | Jan 20, 2021 |
Chan | 301 | 6192 2789 | 409 | Sugar | 3 | 47 | Jan 31, 2021 |
Required:
- Using the database provided above as an example, identify and explain the major database design problems.
- Recommend a relational database design that can eliminate all problems identified in part (a).
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