Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribed
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) uniquely identify parts and vendor names uniquely identify vendors. PartNo 1234 1234 5678 5678 5678 Description Logic Chip Logic Chip Memory Chip Memory Chip Memory Chip VendorName Fast Chips Smart Chips Fast Chips Quality Chips Smart Chips Address Cupertino Phoenix Cupertino Austin Phoenix UnitCost 10.00 8.00 3.00 2.00 5.00 Question 1 (2 points): Convert this Table to relation (named PART SUPPLIER) in first normal form. Please use the relation schema such as: COURSE (CourseNo, CourseName) Question 2 (3 points): List the functional dependencies in PART SUPPLIER and identify a candidate key. Question c (6 points): Develop a set of 3NF relations from PART SUPPLIER

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago