Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c . Draw the dependency diagrams that are in 3 NF . ( Hint: You might have to create a few new attributes. Also make

c. Draw the dependency diagrams that are in 3NF.(Hint: You might have to create a few new attributes. Also
make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is,
make sure there are no multivalued attributes, that the naming conventions are met, and so on.)Table 1 :
\table[[\table[[Attribute],[Name]],Sample Value,Sample Value,Sample Value,Sample Value,Sample Value],[INV_NUM,1001,1002,1003,1004,1005],[PROD_NUM,\table[[123-21UUY, SRE-],[657UG]],QER-34256,\table[[SRE-657UG,],[ZZX/3245Q]],\table[[SRE-657UG,],['001278-AB']],ZZX/3245Q],[SALE_DATE,'2022-3-8','2022-3-8','2022-3-8','2022-3-9','2022-1-16'],[PROD_DESC,\table[[Houselite chain],[saw, Rat-tail file]],Sledge hammer,\table[[Rat-tail file,],[Steel tape]],\table[[Rat-tail file, claw],[hammer]],Steel tape]]
\table[[VEND_CODE,235,232,231,232,235,232,231,235],[VEND_NAME,\table[[Shelly],[Smithson,],[Annelise Crystall]],James Johnson,\table[[Annelise],[Crystall,]],\table[[Shelly],[Smithson, James],[Johnson]],Arthur Jones],[QUANT_SOLD,1,3,1,1,2,1,2,1],[PROD_PRICE,$189.99,$2.99,18.63,$6.79,$2.99,$12.95,2.99,$2.99]]
image text in transcribed

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

Concepts Of Database Management

Authors: Joy L. Starks, Philip J. Pratt, Mary Z. Last

9th Edition

1337093424, 978-1337093422

More Books

Students also viewed these Databases questions

Question

How may lost profits be calculated using typical benchmarks?

Answered: 1 week ago