Question: Q2. The table below contains sample data for parts and for vendors who supply those parts. In discusing this data with users, we find the

Q2. The table below contains sample data for parts and for vendors who supply those parts. In discusing this data with users, we find the following information regarding functional dependency. Note: underline attributes indicate primary key. (40 points) 1. part number determines description 2. vendor name determines address 3. part number and vendor name together determine unit cost Part NO. 1234 Description Logic Chip 5678 Vendor Name Fast Chips Smart Chips Fast Chips Quality Chips Smart Chips Address Cupertino Phoenix Cupertino Austin Phoenix Unit Cost 10.00 8.00 3.00 2.00 5.00 Memory Chip a. In what normal form is the table as it is currently presented? Why? b. Using the table above, give specific examples of insertion, deletion, and modification anomalies, based on the data. c. Create the set of relations needed to represent the data in 3NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A relation is now Ample A relationship An attribute d. A table A derived attribute is an attribute that Is multi-valued his determined from other attributes c. Consists of a group of attributes d....

Table 4-3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify parts and that...

Task 1: Transform Table4-3 to relations: Table 4-3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not...

Table below contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers ( but not descriptions ) uniquely identify parts and...

Constraints between two sets of attributes oli Domain of attributes Set of candidate keys in a relation The mapping of two relations Part III: ANALYTICAL QUESTIONS (16 points The table below contains...

Table 4 - 3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers ( but not descriptions ) uniquely identify parts and...

Marin Company is currently producing 16,000 units per month, which is 80% of its production capacity. Variable manufacturing costs are currently $8.00 per unit. Fixed manufacturing costs are $56,000...

Consider an office room that is being cooled adequately by a 12,000 Btu/h window air conditioner. Now it is decided to convert this room into a computer room by installing several computers,...

What is the beta for the overall stock market? 1 0 the market risk premium the risk - free rate

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...