Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
ure1) up to at least 3NF.

ure1) up to at least 3NF.

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

Normalize the dessert table database shown in ER diagram below (Figure1) up to at least 3NF.

mysql> select * from Dessert; | DESSERT_CODE | DESSERT_OFFERED_DATE_RANGE | DESSERT_NAME | DESSERT_DESCR | DESSERT_CATEGORY_CODE | DRINK_NAME | TOPPNING_NAME | DESSERT_PRICE_AMOUNT | -+-- | Lots of licorice, bats, and hot fudge over broomshaped cookies | Three large scoops of ice cream with | two fresh bananas and an unbelievable number of toppings, including hot fudge| | and strawberry |AB | 1999-10-1 1999-10-31 | Scary Sundae |Holiday, Cookie, Medium | Spooky Hot Chocolate | Hot fudge 2.95 | BC | 1996-1-1 2002-12-31 | Banana Split |Fruit, Frozen, Large | NULL | Hot fudge 4.95 |EE Summer Refresher | Lots of different types of fruits, |Fruit, Health, Seasonal, |Small | 2001-6-1 2001-9-1 NULL | Cherries 1.95 | all put into a blender +-
Transcribed Image Text:mysql> select * from Dessert; | DESSERT_CODE | DESSERT_OFFERED_DATE_RANGE | DESSERT_NAME | DESSERT_DESCR | DESSERT_CATEGORY_CODE | DRINK_NAME | TOPPNING_NAME | DESSERT_PRICE_AMOUNT | -+-- | Lots of licorice, bats, and hot fudge over broomshaped cookies | Three large scoops of ice cream with | two fresh bananas and an unbelievable number of toppings, including hot fudge| | and strawberry |AB | 1999-10-1 1999-10-31 | Scary Sundae |Holiday, Cookie, Medium | Spooky Hot Chocolate | Hot fudge 2.95 | BC | 1996-1-1 2002-12-31 | Banana Split |Fruit, Frozen, Large | NULL | Hot fudge 4.95 |EE Summer Refresher | Lots of different types of fruits, |Fruit, Health, Seasonal, |Small | 2001-6-1 2001-9-1 NULL | Cherries 1.95 | all put into a blender +-
Deasect offeced Date Range Deasect rame Deaacct Deacciption Deaaect Code Reataucant Region Name Deasect Pcice Amount Reataucasnt Identifiec Dessert M Óffer Dcink Name Deasect Categocy Name Iopping Name Reataucant OwAecl Name Restaurant Reataucasnt Ownec2 Name 1 Reataucant Ownec3 Name Reataucant Region Code Contain Reataucant daximum Capacity Mumbee N Process M Eill_ID Generate Bill Eill Date and Iime Ccanuity Aumount Eooth Iype Iext Eill_Aumount Booth Contain N Booth Iype Code Smoking section Indicatoc Eooth Location Code Eooth Capacity
Transcribed Image Text:Deasect offeced Date Range Deasect rame Deaacct Deacciption Deaaect Code Reataucant Region Name Deasect Pcice Amount Reataucasnt Identifiec Dessert M Óffer Dcink Name Deasect Categocy Name Iopping Name Reataucant OwAecl Name Restaurant Reataucasnt Ownec2 Name 1 Reataucant Ownec3 Name Reataucant Region Code Contain Reataucant daximum Capacity Mumbee N Process M Eill_ID Generate Bill Eill Date and Iime Ccanuity Aumount Eooth Iype Iext Eill_Aumount Booth Contain N Booth Iype Code Smoking section Indicatoc Eooth Location Code Eooth Capacity
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar 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