Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want u to drow it in a square Homework 5. Normalization Due on Question 1. A tabl A+B is the primary key The following

I want u to drow it in a square image text in transcribed
Homework 5. Normalization Due on Question 1. A tabl A+B is the primary key The following dependencies are identified: le contains columns A, B, C, D, E, F, G AD, E EG 1) Normalize this table to 2NF: underline the primary key of each table. 2) Then normalize to 3NF; underline the primary key of each table 3) Then normalize to BCNF underline the primary key of each table uestion2 Neighborhood Hardware is a hardware store. It orders inventory from various distributors. Neighborhood Hardware gives each distributor a DistID. Distributors may carry the same product. Each product has a universal UPC Number and product name. However each distributor has their own in-house distributor product ID (dist prod_id) for products they carry. For instance, Stanley Hammer-Pro has a universal UPC code 9785600021. Acer Inc. would refer to it by its product ID 576-183 HardwareKing would identify it as 4178 BBR Each purchase order has a purchase order date, and it is issued to one distributor. Neighborhood Hardware can purchase multiple products on a purchase order, each product has a purchase quantity 1) Identify a candidate key 2) Identify all FDs in the format of A B, C DistIDDistName U PC-Number ProdName Oty PurOrd PurOrd Num 25278 03/12 DistProdID Date 576-101 576-112 576-109 576-183 101 Acer Inc. 9785600001 Screwdriver 9785600016 Handsaw 9785600007Bolt cutter 9785600021 DOIT Distribution 0-34 9785600023 Chain saw, 16 in 9785600007 Bolt cutter 9785600015 2.75 in. bolt, 12 9785600016 9785600001 Screwdriver 9785600023 Chain saw, 16 in. 9785600021 9785600007 Boit cutter 9785600007 9785600023 Chain saw, 16 in 9785600015 2.75 in 978560002 Stanley Hammer-Pro 3 9785600023 Chainsaw, 16 in. 25279 03/12/12 102 12 0-345115 4-896101 152 BGR 177 BXR 4178 BB Hammer 2528 102 Distribution 0-345115 5115 25283 03/14/1 Bolt cutter 0-345111 4-896101 4178 BBR 4177 BXR 25284 03/14/12 103 Hardwareking

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

Step: 3

blur-text-image

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

Oracle RMAN For Absolute Beginners

Authors: Darl Kuhn

1st Edition

1484207637, 9781484207635

More Books

Students also viewed these Databases questions