Question 2 (20 points) The following table 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 vendor names uniquely identify vendors Part No Description Vendor Name Address Unit Cost 1234 Logic Chip Fast Chips Cupertino 10 00 Smart Chips Phoenix 8 00 5678 Memory Chip Fast Chips Cupertino 3 00 Quality Chips Austin 2 00 Smart Chips Phoenix 5 00 a Convert this table to a relation (named PART SUPPLIER) in first normal form b Identify the primary key c List the functional dependencies d Decompose PART SUPPLIER into a set of 3NF relations

The Answer is in the image, click to view ...

Question: Question 2. (20 points) The following table contains sample data for parts and for vendors who supply those parts. In discussing these data with users,

Question 2. (20 points)

The following table 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 vendor names uniquely identify vendors.

Part No	Description	Vendor Name	Address	Unit Cost
1234	Logic Chip	Fast Chips	Cupertino	10.00
		Smart Chips	Phoenix	8.00
5678	Memory Chip	Fast Chips	Cupertino	3.00
		Quality Chips	Austin	2.00
		Smart Chips	Phoenix	5.00

a. Convert this table to a relation (named PART SUPPLIER) in first normal form

b. Identify the primary key

c. List the functional dependencies

d. Decompose PART SUPPLIER into a set of 3NF relations.

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 Databases Questions!

Question 2 (11 points) The following table contains sample date for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions)...

The following table 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...

3. Following table contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers uniquely identify parts and that vendor names...

The following table 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...

The following table 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...

3 . The following table 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...

3. The following table 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...

Problem 4-34 (all parts), pp.195-196. For Part (c), identify a modification (update) anomaly only. Do Parts (b) and (d) together. Combine your answer in a single relational schema, and then identify...

Conduct research on the Web sites of either CIO Magazine or CFO Magazine (or another that your instructor suggests) for stories about ERP implementation successes and failures. Using specific...

4 a) Find the total resistance seen by A and B node. 4 b) Find the total capacitance seen by A and B node. -B

The unusual volatility that sometimes occurs at stock index futures expirations is because of the greater uncertainty. True False

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+3 Is the decision green in terms of pollution and the carbon footprint?

=+2 Why are international employment standards important to IHRM?

=+1 Why are local employment laws important to IHRM?