In the following database, Menu ID is the primary key of the MENU Relation Event ID is the primary key of the EVENT Relation Answer the following questions concisely Do not include extra, introductory or background information There are five questions in this section of the exam Be sure to answer all five questions in your own words Do not copy statements from any source Menu ID Menu Type Menu Description 2645 Breakfast Standard breakfast 2700 Lunch Basic lunch 3134 Lunch Expensive lunch 3688 Dinner Basic dinner 3906 Dinner Expensive dinner MENU Relation Event Event Event ID Date Location Time Menu ID 15367 6 25 18 Memphis 1PM 3134 17008 10 11 18 Memphis 1PM 2700 17562 12 24 18 Nashville 5PM 3688 19341 12 24 18 Nashville 5PM 3906 20629 12 31 18 Memphis 11PM 3688 21448 12 31 18 Nashville 11 30PM 3688 22264 1 1 19 Memphis 10AM 2645 25489 1 1 19 Nashville 9AM 2645 EVENT Relation 1 Menu ID 3688 appears once in the MENU Relation and three times in the EVENT Relation Does this constitute data redundancy Why or why not 2 In terms of referential integrity, if the Delete Rule between the two relations is Cascade and an attempt is made to delete the record for Menu ID 3688 in the MENU Relation, what would or would not happen in each relation 3 Which normal form are these relations in Explain 4 There is a one to many binary relationship between these two tables How do we know its a one to many relationship How do we know its a binary relationship 5 Assume that these two tables constitute the entire database How many foreign keys are there in the MENU relation and what are they How many foreign keys are there in the EVENT relation and what are they Justify your answers

The Answer is in the image, click to view ...

Question: In the following database, Menu ID is the primary key of the MENU Relation. Event ID is the primary key of the EVENT Relation. Answer

In the following database, Menu ID is the primary key of the MENU Relation. Event ID is the primary key of the EVENT Relation. Answer the following questions concisely. Do not include extra, introductory or background information. There are five questions in this section of the exam. Be sure to answer all five questions in your own words. Do not copy statements from any source.

Menu ID Menu Type Menu Description

2645	Breakfast	Standard breakfast
2700	Lunch	Basic lunch
3134	Lunch	Expensive lunch
3688	Dinner	Basic dinner
3906	Dinner	Expensive dinner

MENU Relation

Event Event

Event ID Date Location Time Menu ID

15367	6/25/18	Memphis	1PM	3134
17008	10/11/18	Memphis	1PM	2700
17562	12/24/18	Nashville	5PM	3688
19341	12/24/18	Nashville	5PM	3906
20629	12/31/18	Memphis	11PM	3688
21448	12/31/18	Nashville	11:30PM	3688
22264	1/1/19	Memphis	10AM	2645
25489	1/1/19	Nashville	9AM	2645

EVENT Relation

1. Menu ID 3688 appears once in the MENU Relation and three times in the EVENT Relation. Does this constitute data redundancy? Why or why not?

2. In terms of referential integrity, if the Delete Rule between the two relations is Cascade and an attempt is made to delete the record for Menu ID 3688 in the MENU Relation, what would or would not happen in each relation?

3. Which normal form are these relations in? Explain.

4. There is a one-to-many binary relationship between these two tables. How do we know its a one-to-many relationship? How do we know its a binary relationship?

5. Assume that these two tables constitute the entire database. How many foreign keys are there in the MENU relation and what are they? How many foreign keys are there in the EVENT relation and what are they? Justify your answers.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

V. (15 points) In the following database, Menu ID is the primary key of the MENU Relation. Event ID is the primary key of the EVENT Relation. There is a 1-M relationship between MENU and EVENT....

the dowloaded SAD file is the first screenshot of a spread sheet I uploaded. The other screenshots are the coursework questions. samplecwk 1data.xlsx Q Search CS X File Home Insert Formulas Data BE...

can anyone build a student data base file using python and the information on the photo below The main objective of this assignment is to design and implement A Student Assessment database software...

Read the attached article and answer the following questions in report format: Discuss the factors that drove Harrah's customer relationship strategy. Discuss whether Harrah's business and IT...

Please help, thank you Databases [30 Marks] Grahamstown Residents' Association (GRA) has up to now been keeping track of its members using a spreadsheet but this has become cumbersome because of a...

XYZ Corp has a relation database system. There is a table called Customers that has Customer ID as it's primary key and includes the name, address, and contact information for each customer. There is...

Normalization for Relational Databases The following attributes represent data about a movie copy at an online video rental service. Each movie is identified by a movie number and has a title and...

CIS 3650 Database Management Systems Fall 2022 Assignment 5 Assignment instructions Answer questions related to the scenario below in a Word document. Include your name at the top of the document and...

Hire > Membership Member_Id {pk) Name Gender DOB Tel_No Trainer Trainer_Id {pk) Name Specialty Telephone_No 0..1 |{mandatory,or) Full Member Monthly Fee Parking No Assoc Member Daily Fee Program Type...

Corporation is a company which handles the auction of the different antiques. The company wants to shift from the offline system to the online auction system. For this they have consulted a database...

In the absence of recurring fixed costs (such as those in exercise 12.4), the U-shaped cost curves we will often graph in upcoming chapters presume some particular features of the underlying...

Suppose that in 1984 the total output in a single-good economy was 7000 buckets of chicken. Also suppose that in 1984 each bucket of chicken was priced at $10. Finally, assume that in 2004 the price...

company is considering buying a new equipment ( machine ) with an invoice price of $ 5 0 , 0 0 0 , and it will cost $ 5 , 0 0 0 to ship and $ , 5 0 0 0 to install. Your company hired Santiago as a...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Implement the action steps. After a reasonable time period, assess the results. Has your motivation increased? Has your interest, satisfaction, or performance improved? What else might you do to...

2. Discuss the practical implications for each of the models you use. In other words, what do these models suggest the supervisor should do or say as a consequence of defining the problem from that...

3. What are some of the perspectives on organizational behavior that could explain the apparently high levels of motivation among the four employees? What models might explain Jesss motivation?