Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITEM(ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCAITON, PRICE,(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANTITY, QUOTED_PRICE))

Determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITEM(ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCAITON, PRICE,(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANTITY, QUOTED_PRICE))

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

ITEM(ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCAITON, PRICE,(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANTITY, QUOTED_PRICE))

SALES REP REP_ID FIRST NAME LAST_NAME Susan 05 10 15 20 ID 125 CUSTOMER CUST_FIRST_ LAST NAME Smith 182 227 294 314 375 435 Richard Donna Daniel 492 NAME Joey Billy Sandra Tom Melanie Samantha Smith James Elmer 543 Angle 616 Sally Garcia Miller Smith Jackson 721 Leslie 795 Randy Rufton Pincher Rascal Jackson Gonzalez Jackson Cruz CITY STATE POSTAL CELL PHONE COMMISSION RATE 42 Mountain Ln Cody WY 307-824-1245 $12,743.16 0.04 87 Pikes Dr Ralston WY 307-406-4321 $20,872.11 0.06 312 Oak Rd Powell WY 307-982-8401 $14,912.92 0.04 19 Lookout Dr Elk Butte WY 307-883-9481 $0.00 0.04 Smith ADDRESS ADDRESS 17 Fourth St 21 Simple Cir 53 Verde In 14 Rock In 1 Rascal Farm Rd 42 Blackwater Way 16 Rockway Rd Hendricks 27 Locklear Ln 199 18th Ave 22 Jackson Farm Rd CITY Blacksmith 75 Stream Rd Cody WY 82414 Garland WY 82435 Powell WY 82440 Ralston WY 82440 STATE POSTAL EMAIL Cody WY 82414 Elk Butte WY 82433 Wapiti WY Powell Garland WY 82435 Ralston Cody 82450 WY 82440 WY 123 Sheepland Elk Butte WY 82433 Rd WY 82440 82414 82414 824-40 82440 82433 .com jsmith 17@example $80.68 .com billyruff@example $43.13 $750.00 10 spinch2@example $156.38 $500.00 15 ssmith5@example $58.60 traseal3@example .com .com .com mjackson5@ example.com jgonzo@example .com ejackson4@ example.com ahendricks7@ example.com scruz5@example BALANCE rblacksmith6@ example.com $17.25 $252.25 $45.20 CREDIT REP LIMIT ID $500.00 05 $315.00 $500.00 10 $230.40 $1,000.00 15 $61.50 $250.00 15 $250.00 05 $500.00 10 $8.33 .com Ismith 12@example $166.65 $1,000.00 10 .com $750.00 05 $500.00 15 $500.00 05
Transcribed Image Text:SALES REP REP_ID FIRST NAME LAST_NAME Susan 05 10 15 20 ID 125 CUSTOMER CUST_FIRST_ LAST NAME Smith 182 227 294 314 375 435 Richard Donna Daniel 492 NAME Joey Billy Sandra Tom Melanie Samantha Smith James Elmer 543 Angle 616 Sally Garcia Miller Smith Jackson 721 Leslie 795 Randy Rufton Pincher Rascal Jackson Gonzalez Jackson Cruz CITY STATE POSTAL CELL PHONE COMMISSION RATE 42 Mountain Ln Cody WY 307-824-1245 $12,743.16 0.04 87 Pikes Dr Ralston WY 307-406-4321 $20,872.11 0.06 312 Oak Rd Powell WY 307-982-8401 $14,912.92 0.04 19 Lookout Dr Elk Butte WY 307-883-9481 $0.00 0.04 Smith ADDRESS ADDRESS 17 Fourth St 21 Simple Cir 53 Verde In 14 Rock In 1 Rascal Farm Rd 42 Blackwater Way 16 Rockway Rd Hendricks 27 Locklear Ln 199 18th Ave 22 Jackson Farm Rd CITY Blacksmith 75 Stream Rd Cody WY 82414 Garland WY 82435 Powell WY 82440 Ralston WY 82440 STATE POSTAL EMAIL Cody WY 82414 Elk Butte WY 82433 Wapiti WY Powell Garland WY 82435 Ralston Cody 82450 WY 82440 WY 123 Sheepland Elk Butte WY 82433 Rd WY 82440 82414 82414 824-40 82440 82433 .com jsmith 17@example $80.68 .com billyruff@example $43.13 $750.00 10 spinch2@example $156.38 $500.00 15 ssmith5@example $58.60 traseal3@example .com .com .com mjackson5@ example.com jgonzo@example .com ejackson4@ example.com ahendricks7@ example.com scruz5@example BALANCE rblacksmith6@ example.com $17.25 $252.25 $45.20 CREDIT REP LIMIT ID $500.00 05 $315.00 $500.00 10 $230.40 $1,000.00 15 $61.50 $250.00 15 $250.00 05 $500.00 10 $8.33 .com Ismith 12@example $166.65 $1,000.00 10 .com $750.00 05 $500.00 15 $500.00 05
INVOICES INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 11/16/2021 294 11/16/2021 182 14216 14219 14222 14224 14228 14231 14233 14237 ITEM ITEM_ID DESCRIPTION AD72 Dog Feeding Station BC33 CA75 DT12 FM23 FS39 FS42 KH81 LD14 LP73 PF19 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 QB92 SP91 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station. Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 lb) Locking Small Dog Door Large Pet Carrier Pump & Filter Kit Quilted Stable Blanket Small Pet Carrier Underground Fence System INVOICE_LINE INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE CA75 AD72 DT12 LD14 14216 14219 14219 14222 14224 14228 14228 14231 14233 14233 14233 14237 ON_HAND 12 10 15 27 41 12 5 24 14 23 5 32 18. 7 34 KH81 FS42 PF19 UF39 KH81 QB92 WB49 LP73 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG DOG FSH HOR CAT DOG HOR 3 2 4 1 4 1 C C A C A B A C B A с 1 2 1 4 LOCATION B B C B UF39 WB49 Insulated Water Bucket FIGURE 2-1 Sample data for KimTav Pet Supplies (Continued) $37.99 $79.99 $39.99 $47.99 $18.99 $124.99 $74.99 $189.99 $19.99 $109.95 4.95 $54.95 PRICE $79.99 $79.99 $39.99 $39.99 $24.95 $39.99 $124.99 $19.99 $49.99 $59.99 $74.99 $119.99 $39.99 $199.99 $79.99
Transcribed Image Text:INVOICES INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 11/16/2021 294 11/16/2021 182 14216 14219 14222 14224 14228 14231 14233 14237 ITEM ITEM_ID DESCRIPTION AD72 Dog Feeding Station BC33 CA75 DT12 FM23 FS39 FS42 KH81 LD14 LP73 PF19 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 QB92 SP91 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station. Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 lb) Locking Small Dog Door Large Pet Carrier Pump & Filter Kit Quilted Stable Blanket Small Pet Carrier Underground Fence System INVOICE_LINE INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE CA75 AD72 DT12 LD14 14216 14219 14219 14222 14224 14228 14228 14231 14233 14233 14233 14237 ON_HAND 12 10 15 27 41 12 5 24 14 23 5 32 18. 7 34 KH81 FS42 PF19 UF39 KH81 QB92 WB49 LP73 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG DOG FSH HOR CAT DOG HOR 3 2 4 1 4 1 C C A C A B A C B A с 1 2 1 4 LOCATION B B C B UF39 WB49 Insulated Water Bucket FIGURE 2-1 Sample data for KimTav Pet Supplies (Continued) $37.99 $79.99 $39.99 $47.99 $18.99 $124.99 $74.99 $189.99 $19.99 $109.95 4.95 $54.95 PRICE $79.99 $79.99 $39.99 $39.99 $24.95 $39.99 $124.99 $19.99 $49.99 $59.99 $74.99 $119.99 $39.99 $199.99 $79.99
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Basic sql queries
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS