Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Deaseetafteced Date Range Deaseet rame Deaseet Deacesption Deasect Cede Reataucant Region Name Desseet Peice Amauat Reataucant Identifice Dessert M Offer Deink Mame Dessect Categocy Mame Iopping Name Reataucant Ownecl rame Restaurant Restaveant Ownee2 rame 1 Reataucant Ownec3 Name Reataucant Region Code Contain Reataucant daximum Capacity Humbee N Process M Ei11_ID Generate M Bill Eil1 Date and Iime Gcanuity Amount Booth Iype Iext Eil1_Amount Booth Contain Booth Iype Code Smaking seetion Indicatoe Booth Loc ation Code Booth Capaeity

Deaseetafteced Date Range Deaseet rame Deaseet Deacesption Deasect Cede Reataucant Region Name Desseet Peice Amauat Reataucant Identifice Dessert M Offer Deink Mame Dessect Categocy Mame Iopping Name Reataucant Ownecl rame Restaurant Restaveant Ownee2 rame 1 Reataucant Ownec3 Name Reataucant Region Code Contain Reataucant daximum Capacity Humbee N Process M Ei11_ID Generate M Bill Eil1 Date and Iime Gcanuity Amount Booth Iype Iext Eil1_Amount Booth Contain Booth Iype Code Smaking seetion Indicatoe Booth Loc ation Code Booth Capaeity

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
  • normalize the database shown in ER diagram below (Figure1) up to at least 3NF, Hand In, A complete set of functional dependencies identified
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
mysql> select * from Restaurant; RESTAURANT_ID RESTAURANT_OWNER1_NAME RESTAURANT_OWNER2_NAME RESTAURANT_OWNER3_NAME RESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY | | Paul Smith Mary Doe Bob Jones 123 Bob Jones NE Northeast 50 | | Bill Barker Mary Doe Mary Doe | Mary Doe Mary Doe Mary Doe 124 James Pierce NE Northeast 200 SW SW | SW 125 NULL NULL Southwest 175 100 | 322 | Mike Myers | Mike Myers Mike Myers | Mike Myers 126 NULL Southwest 326 | NULL Southwest 454 NULL NE Northeast 145 789 NULL | NE Northeast 678| mysql> select * from Dessert; DESSERT_CODE | DESSERT_0FFERED_DATE_RANGE | DESSERT_NAME | DESSERT_DESCR | DESSERT_CATEGORY_CODE DRINK_NAME | TOPPNING_NAME | DESSERT_PRICE_AMOUNT | AB | 1999-10-1 | Scary Sundae | Lots of licorice, bats, and hot fudge Holiday, Cookie, Medium Spooky Hot Chocolate | Hot fudge 1999-10-31 2.95 over broomshaped cookies ВС | 1996-1-1 - 2002-12-31 | Banana Split | Three large scoops of ice cream with |Fruit, Frozen, Large | NULL | Hot fudge 4.95 | two fresh bananas and an unbelievable number of toppings, including hot fudge| and strawberry | 2001-6-1 - 2001-9-1 | | Cherries |Small ЕЕ | Summer Refresher | Lots of different types of fruits, |Fruit, Health, Seasonal, | NULL 1.95 |all put into a blender mysql> select * from Bill; | BILL ID | BOOTHCODE | DESSERT CODE | DESSERT OFFERED DATE RANGE | RESTAURANT ID | BILL DATE AND TIME BILL_AMOUNT | GRATUITY_AMOUNT | ВОOTH AB ВОOTH AE ВООTH AB ВООTH AD ВОOTH BC 320 | 20 | 0.5 | 30 | 20 АВ 1999-10-1 - 1999-10-31 454 1999-10-12 20:34:59 |EE | AB | BC | AB 27 2001-6-1 - 2001-9-1 789 2000-10-21 15:30:12 400.5 29 1999-10-1 - 1999-10-31 | 454 1999-10-12 12:34:00 330 77 1996-1-1 - 2002-12-31 789 2000-10-15 20:15:19 1500.99 80 1999-10-1 - 1999-10-31 | 454 1999-10-10 22:25:09 310.5 10.5| mysql> select * from Offer; | DESSERT CODE | DESSERT OFFERED DATE RANGE RESTAURANT ID | АВ 1999-10-1 - 1999-10-31 454 | 789 | 789 BC 1996-1-1 2002-12-31 ЕЕ 2001-6-1 - 2001-9-1 mysql> select * from Booth; ВООTHCODE RESTAURANT_ID | SMOKE_SECTION_INDICATOR | BOOTH_CAPACITY | BOOTHTYP_CODE | BOOTHTYP_TEXT | ВООTH AB ВООTH AD ВООTH AE ВООTH BC 4 T 2| T 8 | T 6 | E | Table | Table | Table | Bench 123 Y 125 N 124 Y 123 Y
Transcribed Image Text:mysql> select * from Restaurant; RESTAURANT_ID RESTAURANT_OWNER1_NAME RESTAURANT_OWNER2_NAME RESTAURANT_OWNER3_NAME RESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY | | Paul Smith Mary Doe Bob Jones 123 Bob Jones NE Northeast 50 | | Bill Barker Mary Doe Mary Doe | Mary Doe Mary Doe Mary Doe 124 James Pierce NE Northeast 200 SW SW | SW 125 NULL NULL Southwest 175 100 | 322 | Mike Myers | Mike Myers Mike Myers | Mike Myers 126 NULL Southwest 326 | NULL Southwest 454 NULL NE Northeast 145 789 NULL | NE Northeast 678| mysql> select * from Dessert; DESSERT_CODE | DESSERT_0FFERED_DATE_RANGE | DESSERT_NAME | DESSERT_DESCR | DESSERT_CATEGORY_CODE DRINK_NAME | TOPPNING_NAME | DESSERT_PRICE_AMOUNT | AB | 1999-10-1 | Scary Sundae | Lots of licorice, bats, and hot fudge Holiday, Cookie, Medium Spooky Hot Chocolate | Hot fudge 1999-10-31 2.95 over broomshaped cookies ВС | 1996-1-1 - 2002-12-31 | Banana Split | Three large scoops of ice cream with |Fruit, Frozen, Large | NULL | Hot fudge 4.95 | two fresh bananas and an unbelievable number of toppings, including hot fudge| and strawberry | 2001-6-1 - 2001-9-1 | | Cherries |Small ЕЕ | Summer Refresher | Lots of different types of fruits, |Fruit, Health, Seasonal, | NULL 1.95 |all put into a blender mysql> select * from Bill; | BILL ID | BOOTHCODE | DESSERT CODE | DESSERT OFFERED DATE RANGE | RESTAURANT ID | BILL DATE AND TIME BILL_AMOUNT | GRATUITY_AMOUNT | ВОOTH AB ВОOTH AE ВООTH AB ВООTH AD ВОOTH BC 320 | 20 | 0.5 | 30 | 20 АВ 1999-10-1 - 1999-10-31 454 1999-10-12 20:34:59 |EE | AB | BC | AB 27 2001-6-1 - 2001-9-1 789 2000-10-21 15:30:12 400.5 29 1999-10-1 - 1999-10-31 | 454 1999-10-12 12:34:00 330 77 1996-1-1 - 2002-12-31 789 2000-10-15 20:15:19 1500.99 80 1999-10-1 - 1999-10-31 | 454 1999-10-10 22:25:09 310.5 10.5| mysql> select * from Offer; | DESSERT CODE | DESSERT OFFERED DATE RANGE RESTAURANT ID | АВ 1999-10-1 - 1999-10-31 454 | 789 | 789 BC 1996-1-1 2002-12-31 ЕЕ 2001-6-1 - 2001-9-1 mysql> select * from Booth; ВООTHCODE RESTAURANT_ID | SMOKE_SECTION_INDICATOR | BOOTH_CAPACITY | BOOTHTYP_CODE | BOOTHTYP_TEXT | ВООTH AB ВООTH AD ВООTH AE ВООTH BC 4 T 2| T 8 | T 6 | E | Table | Table | Table | Bench 123 Y 125 N 124 Y 123 Y
Expert Solution
Step 1 Attributes

Each entity is described through a set of attributes (e.G., Employee = (Name, Address, Birthdate (Age), Salary).

Each attribute has a name, and is related to an entity and a site of felony values. However, the facts approximately attribute area is not offered on the ERD.

In the entity relationship diagram, shown in Figure 8.2, each attribute is represented with the aid of an oval with a call inner.

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS