Question
Please can you answer this question. Thnks 2) Given the Supplier_Parts relation below with sample data, Determine an appropriate Key. Then list the Functional Dependencies
Please can you answer this question. Thnks
2) Given the Supplier_Parts relation below with sample data, Determine an appropriate Key. Then list the Functional Dependencies and normalize the relation to 3NF.
Supplier_Parts ( PartNumber, Description, Supplier, SupplierCity, Price )
| PartNumber | Description | Supplier | SupplierCity | Price |
| 10010 | 20 TB Disk | Seagate | Cupertino, CA | $100 |
| 10010 | 20 TB Disk | IBM | Armonk, NY | $90 |
| 10010 | 20 TB Disk | Hitachi | Tarrytown, NY | $90 |
| 10220 | 256 GB RAM card | Kensington | Palo Alto, CA | $220 |
| 10220 | 256 GB RAM card | IBM | Armonk, NY | $230 |
| 10222 | 256 GB RAM card | Hewlett Packard | Palo Alto, CA | $310 |
| 10440 | 32 LCD Monitor | IBM | Armonk, NY | $310
|
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
DB2 11 The Database For Big Data And Analytics
Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler
1st Edition
1583473858, 978-1583473856
