| RESTAURANT_ID | RESTAURANT_OWNER1_NAME | RESTAURANT_OWNER2_NAME | RESTAURANT_OWNER3_NAME | RESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY | | NE | NE SW SW SW | Northeast...



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


| RESTAURANT_ID | RESTAURANT_OWNER1_NAME | RESTAURANT_OWNER2_NAME | RESTAURANT_OWNER3_NAME | RESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY |<br>| NE<br>| NE<br>SW<br>SW<br>SW<br>| Northeast<br>| Northeast<br>| Southwest<br>| Southwest<br>| Southwest<br>| Northeast<br>| Northeast<br>50 |<br>200 |<br>175 |<br>| 123<br>| 124<br>| 125<br>| 126<br>| 326<br>| 454<br>| 789<br>| Bob Jones<br>| Bill Barker<br>| Mary Doe<br>| Mary Doe<br>| Mary Doe<br>| Mary Doe<br>| Mary Doe<br>| Mary Doe<br>| Bob Jones<br>| NULL<br>| NULL<br>| NULL<br>| NULL<br>| NULL<br>Paul Smith<br>James Pierce<br>| NULL<br>| Mike Myers<br>Mike Myers<br>| Mike Myers<br>| Mike Myers<br>100<br>322<br>145 |<br>678 |<br>NE<br>NE<br>

Extracted text: | RESTAURANT_ID | RESTAURANT_OWNER1_NAME | RESTAURANT_OWNER2_NAME | RESTAURANT_OWNER3_NAME | RESTAURANT_REGION_CODE | RESTAURANT_REGION_NAME | RESTAURANT_MAX_CAPACITY | | NE | NE SW SW SW | Northeast | Northeast | Southwest | Southwest | Southwest | Northeast | Northeast 50 | 200 | 175 | | 123 | 124 | 125 | 126 | 326 | 454 | 789 | Bob Jones | Bill Barker | Mary Doe | Mary Doe | Mary Doe | Mary Doe | Mary Doe | Mary Doe | Bob Jones | NULL | NULL | NULL | NULL | NULL Paul Smith James Pierce | NULL | Mike Myers Mike Myers | Mike Myers | Mike Myers 100 322 145 | 678 | NE NE
Deasect offeced Date Range<br>Deasect rame<br>Deaacct Deacciption<br>Deaaect Code<br>Reataucant Region Name<br>Deasect Pcice Amount<br>Reataucasnt Identifiec<br>Dessert<br>M<br>Óffer<br>Dcink Name<br>Deasect Categocy Name<br>Iopping Name<br>Reataucant OwAecl Name<br>Restaurant<br>Reataucasnt Ownec2 Name<br>1<br>Reataucant Ownec3 Name<br>Reataucant Region Code<br>Contain<br>Reataucant daximum Capacity Mumbee<br>N<br>Process<br>M<br>Eill_ID<br>Generate<br>Bill<br>Eill Date and Iime<br>Ccanuity Aumount<br>Eooth Iype Iext<br>Eill_Aumount<br>Booth<br>Contain<br>N<br>Booth Iype Code<br>Smoking section Indicatoc<br>Eooth Location Code<br>Eooth Capacity<br>

Extracted 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

Jun 08, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?