Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Using your knowledge of KimTay Pet Supplies, 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, LOCATION, PRICE, (INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANITITY, QUOTED_PRICE))

Using your knowledge of KimTay Pet Supplies, 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, LOCATION, PRICE, (INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANITITY, QUOTED_PRICE))

Fundamentals of Information Systems
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter8: System Acquisition And Development
Section: Chapter Questions
Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...
See similar textbooks
icon
Related questions
Question

Using your knowledge of KimTay Pet Supplies, 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, LOCATION, PRICE,

(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANITITY, QUOTED_PRICE))

16 Module 2 DATABASE CONCEPTS important Before learning how to design a database, you need to be fimilir database concepts related to relational databases, which me ierges f änases you examined in Module 1 and that you use throughout the meetinale sentity, attribute, and relationship are important to understand when de concepts of functional dependence and primary keys are database design process. Relational Databases A relational database is a collection of tables like the ones you eninel ir fimTay Pet Supplies in Module 1 and that appear in Figure 2-1. Formally, these tes me called rela- tions, and this is how this type of database gets its name. SALES REP REP_ID FIRST NAME LAST_NAME 05 10 15 20 CUSTOMER CUST FIRST ID NAME 125 Joey 182 227 294 314 375 435 Susan Richard Donna Daniel 616 Billy 721 Tom Sandra Pincher 492 Elmer Samantha Smith James 543 Angie Melanie Jackson Sally Garcia Miller Smith Jackson LAST NAME Smith Leslie Rufton 795 Randy Rascal Gonzalez Jackson Hendricks Cruz Smith ADDRESS CITY 42 Mountain Ln Cody 87 Pikes Dr Ralston 312 Oak Rd Powell 19 Lookout Dr Elk Butte ADDRESS 17 Fourth St Cody 21 Simple Cir Garland 53 Verde Ln 14 Rock Ln 1 Rascal Farm Rd CITY 22 Jackson Farm Rd 27 Locklear Powell Ralston Cody 42 Blackwater Way 16 Rockway Wapiti Rd Garland ase, the whing about the rinary keys em mang about the Powell 199 18th Ave Ralston Elk Butte WY Cody STATE POSTAL EMAIL WY WY WY WY 123 Sheepland Elk Butte WY Rd Blacksmith 75 Stream Rd STATE POSTAL 82414 82440 82440 82433 FIGURE 2-1 Sample data for KimTay Pet Supplies 82414 jsmith 17@examplic .com 82435 82440 82414 WY 82450 billyruff@example spinch2@example 82440 ssmith5@example 82435 82440 82440 .com 82433 mjackson5@ 82433 .com 82414 .com trascal3@example .com example.com jgonzo@example .com ejackson4@@ example.com ahendricks7@ example.com seruz5@example .com Ismith 12@example .com rblacksmith6@ example.com BALANCE CREDIT REP 0.04 $5000 10 $17.25 $251.00 15 $500.00 15 $252.25 $250 (5 $166.65 $230.40 $1,000.00 15 $45.20 $500.00 10 $61.50 $315.00 $750.00 05 $8.33 $500.00 15 $1,000.00 10 $500.00 05
Transcribed Image Text:16 Module 2 DATABASE CONCEPTS important Before learning how to design a database, you need to be fimilir database concepts related to relational databases, which me ierges f änases you examined in Module 1 and that you use throughout the meetinale sentity, attribute, and relationship are important to understand when de concepts of functional dependence and primary keys are database design process. Relational Databases A relational database is a collection of tables like the ones you eninel ir fimTay Pet Supplies in Module 1 and that appear in Figure 2-1. Formally, these tes me called rela- tions, and this is how this type of database gets its name. SALES REP REP_ID FIRST NAME LAST_NAME 05 10 15 20 CUSTOMER CUST FIRST ID NAME 125 Joey 182 227 294 314 375 435 Susan Richard Donna Daniel 616 Billy 721 Tom Sandra Pincher 492 Elmer Samantha Smith James 543 Angie Melanie Jackson Sally Garcia Miller Smith Jackson LAST NAME Smith Leslie Rufton 795 Randy Rascal Gonzalez Jackson Hendricks Cruz Smith ADDRESS CITY 42 Mountain Ln Cody 87 Pikes Dr Ralston 312 Oak Rd Powell 19 Lookout Dr Elk Butte ADDRESS 17 Fourth St Cody 21 Simple Cir Garland 53 Verde Ln 14 Rock Ln 1 Rascal Farm Rd CITY 22 Jackson Farm Rd 27 Locklear Powell Ralston Cody 42 Blackwater Way 16 Rockway Wapiti Rd Garland ase, the whing about the rinary keys em mang about the Powell 199 18th Ave Ralston Elk Butte WY Cody STATE POSTAL EMAIL WY WY WY WY 123 Sheepland Elk Butte WY Rd Blacksmith 75 Stream Rd STATE POSTAL 82414 82440 82440 82433 FIGURE 2-1 Sample data for KimTay Pet Supplies 82414 jsmith 17@examplic .com 82435 82440 82414 WY 82450 billyruff@example spinch2@example 82440 ssmith5@example 82435 82440 82440 .com 82433 mjackson5@ 82433 .com 82414 .com trascal3@example .com example.com jgonzo@example .com ejackson4@@ example.com ahendricks7@ example.com seruz5@example .com Ismith 12@example .com rblacksmith6@ example.com BALANCE CREDIT REP 0.04 $5000 10 $17.25 $251.00 15 $500.00 15 $252.25 $250 (5 $166.65 $230.40 $1,000.00 15 $45.20 $500.00 10 $61.50 $315.00 $750.00 05 $8.33 $500.00 15 $1,000.00 10 $500.00 05
1 INVOICES to estudillte si INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 294 11/16/2021 11/16/2021 182 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 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 a14233 14233 14233 (-01-900 sto olgus 14237 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station INVOICE_LINE 30 de INVOICE_NUM ITEM_ID QUANTITY CA75 AD72 DT12 LD14 KH81 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 14216 14219 14219 14222 14224 14228 14228 14231 ON_HAND 12 15 27 HOND 12 5 24 14 23 5 32 18 7 34 FS42 PF19 UF39 KH81 QB92 WB49 LP73 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG FSH HOR CAT DOG HOR B B C B C A 3 2 4 LOCATION A B A 4 1 1 B 2 1 4 4 3 Database Design Fundamentals QUOTED_PRICE $37.99 $79.99 $39.99 lordonyilno odlico $47.99 oldu labom odmun $18.99 od aqida $19.99 $49.99 RTMIX ed aloldst Tmi od $59.99 no oa bms,215motaro PF19 QB92 $74.991 agor solse tol sidst $119.99 omen seni a'qori solse SP91 $39.99 $199,99 UF39 WB49 Insulated Water Bucket $79.99 01 2016e neowiad gide FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) orquatoria xocod sedamotatto di neger Hylobr $124.99 $74.99 edistasiloque $189.99 $19.99 Oy Yllaoiarlost.or $109.95 $74.95 $54.95 girlanobales od PRICE vino ditw batsioozen af $79.99 0919ilib ai tedi vows $79.99 BX 101dxsinoo etdi $39.99 to 15dmun vim $39.99 $24.95 $39.99 les asob woll $124.99 HELPFUL HINT The names of columns and tables in this text follow a common naming convention in which column names use uppercase letters and replace spaces between words with an underscore (_). For example, Kim Tay Pet Supplies uses the column named FIRST NAME to store first names and the column named INVOICE_NUM to store invoice numbers. alool oy n.00 solev siit turli onimisjob bre Entities, Attributes, and Relationships or old no sida MOTUD sili ni There are some terms and concepts that are very important for you to know when working in the database environment. The terms entity, attribute, and relationship are me fundamental when discussing databases. An entity is like a noun; it is a person, place, thing, or event. For example, the entities of interest to KimTay Pet Supplies are custom-T ers, invoices, and sales reps. The entities that are of interest to a school include students, faculty, and classes; a real estate agency is interested in clients, houses, and agents; and a used car dealer is interested in vehicles, customers, and manufacturers. An attribute is a property of an entity. The term is used here exactly as it is used in everyday English. For example, for the entity person, the list of attributes might include 918 enoijoin1891 Dist150 jprij TRO BOY VSword I-S orugi ni nwode esld WOOLFO ega mor 17
Transcribed Image Text:1 INVOICES to estudillte si INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 294 11/16/2021 11/16/2021 182 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 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 a14233 14233 14233 (-01-900 sto olgus 14237 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station INVOICE_LINE 30 de INVOICE_NUM ITEM_ID QUANTITY CA75 AD72 DT12 LD14 KH81 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 14216 14219 14219 14222 14224 14228 14228 14231 ON_HAND 12 15 27 HOND 12 5 24 14 23 5 32 18 7 34 FS42 PF19 UF39 KH81 QB92 WB49 LP73 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG FSH HOR CAT DOG HOR B B C B C A 3 2 4 LOCATION A B A 4 1 1 B 2 1 4 4 3 Database Design Fundamentals QUOTED_PRICE $37.99 $79.99 $39.99 lordonyilno odlico $47.99 oldu labom odmun $18.99 od aqida $19.99 $49.99 RTMIX ed aloldst Tmi od $59.99 no oa bms,215motaro PF19 QB92 $74.991 agor solse tol sidst $119.99 omen seni a'qori solse SP91 $39.99 $199,99 UF39 WB49 Insulated Water Bucket $79.99 01 2016e neowiad gide FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) orquatoria xocod sedamotatto di neger Hylobr $124.99 $74.99 edistasiloque $189.99 $19.99 Oy Yllaoiarlost.or $109.95 $74.95 $54.95 girlanobales od PRICE vino ditw batsioozen af $79.99 0919ilib ai tedi vows $79.99 BX 101dxsinoo etdi $39.99 to 15dmun vim $39.99 $24.95 $39.99 les asob woll $124.99 HELPFUL HINT The names of columns and tables in this text follow a common naming convention in which column names use uppercase letters and replace spaces between words with an underscore (_). For example, Kim Tay Pet Supplies uses the column named FIRST NAME to store first names and the column named INVOICE_NUM to store invoice numbers. alool oy n.00 solev siit turli onimisjob bre Entities, Attributes, and Relationships or old no sida MOTUD sili ni There are some terms and concepts that are very important for you to know when working in the database environment. The terms entity, attribute, and relationship are me fundamental when discussing databases. An entity is like a noun; it is a person, place, thing, or event. For example, the entities of interest to KimTay Pet Supplies are custom-T ers, invoices, and sales reps. The entities that are of interest to a school include students, faculty, and classes; a real estate agency is interested in clients, houses, and agents; and a used car dealer is interested in vehicles, customers, and manufacturers. An attribute is a property of an entity. The term is used here exactly as it is used in everyday English. For example, for the entity person, the list of attributes might include 918 enoijoin1891 Dist150 jprij TRO BOY VSword I-S orugi ni nwode esld WOOLFO ega mor 17
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Normalization
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
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS