Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

INSTRUCTIONS [20PTS] Given the following INVOICE table structure, assume that the table does not contain repeating groups and that an invoice number may contain more

image text in transcribed

INSTRUCTIONS [20PTS] Given the following INVOICE table structure, assume that the table does not contain repeating groups and that an invoice number may contain more than one product. Also assume any given product is supplied by a single vendor but a vendor can supply many products. INV_NUM PROD_NUM SALE_DATE 211347 AA-E3422QW 15-Jan-10 211347 QD-300932X 15-Jan-10 211347 RU-995748G 15-Jan-10 211348 AA-E 3422QW 15-Jan-10 211349 GH-778345P 16-Jan-10 Table 1: Sample INVOICE RECORDS PROD_LABEL VEND_COD E Rotary sander 211 0.25-in drill bit 211 Band saw 309 Rotary sander 211 Power drill 157 VEND_NAME QUANT_SOLD PROD_PRICE Never Fail, Inc. 1 $49.95 Never Fail, Inc. 8 $3.45 BeGood, Inc. 1 $39.99 Never Fail, Inc. 2 $49.95 ToughGo, Inc. 1 S87.75 1. Write the relational schema, and underline the PK. [5 pts] InvoiceRecord (... 2. Draw the dependency diagram and identify all dependencies, including all partial and transitive dependencies. The following first symbol can be used to draw full dependency and the second symbol can be use to draw partial or transitive dependency. Copy those symbols and resize them as you see fit to add the dependencies. If arrows overlap. change the color. [15 pts] BTD210 - Database Design Principles Pick one(Partial/trans) VEND_COD E VEND_NAME QUANT_SOLD PROD_PRICE INV_NUMPROD_NUM SALE_DATE PROD_LABEL SUBMISSION This is a group submission. Submit a file containing the dependency diagram

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

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions

Question

c. How is trust demonstrated?

Answered: 1 week ago

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago