Question: 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

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. Answer the following referential integrity questions using the sequential row numbers shown.

Row Number Menu ID Menu Type Menu Description 1 2645 Breakfast Standard breakfast 2 2700 Lunch Basic lunch 3 3134 Lunch Expensive lunch 4 3688 Dinner Basic dinner 5 3906 Dinner Expensive dinner MENU Relation Row Event Event Event Number Event ID Date Location Time Menu ID 1 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 5 20629 12/31/18 Memphis 11PM 3688 6 21448 12/31/18 Nashville 11:30PM 3688 22264 1/1/19 Memphis 10AM 2645 8 25489 1/1/19 Nashville 9AM 2645 EVENT Relation GO TO THE QUESTIONS ON THE NEXT PAGE

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 Accounting Questions!

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,...

SQL Programming (Simply Answer all the question) This schema is used for inventory management for an OEM Part Inventorv Name Cos Suppli Locatio p id Warehouse i quantit t er Traction Alternator 400...

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...

1. [14 points) Define the following terms Relation Relational Database Schema Superkey Key Primary key Foreign key Referential integrity (or foreign key) constraint 2. 8 points) Consider the AIRLINE...

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...

Metropolitan State University ICS 311 Database Management Systems Homework #2 Due: See Syllabus Total: 16 Points Question 1 (7 Points): Given the following database instance, answer questions 1.1...

Harrah's High Payoff from Customer Information Introduction Harrah's Entertainment, Inc. (or simply Harrah's) is assuming a leadership role in the gaming industry through a business strategy that...

Please help ASAP 2. Which of the following is the correct syntax for a value list? O'Option 15,"Option 2', 'Option 3 "Option 1";"Option 2":"Option 3" "Option 1":"Option 2":"Option 3" 21 3. To create...

15 points) Using the following tables to answer the below query: ID 1 mah W 24 ON MANIS 201 5600 200 55500 200 110 $100.00 24 1100 SO 205 1102 55 200 $109.00 1100 57.00 1) (10 points)SELECT Insurence...

Consult the sources listed for this boxed insert (found at the end of the book), and then develop a list of the advantages and disadvantages of each type of energy. Based on the list, which source of...

why the maximization of shareholders' wealth is the ultimate objective of a firm from the finance perspective.

Bell Pvt . Ltd . , an American glassworks manufacturer, aims to expand its business to France. After considering its alternatives, Bell Pvt . Ltd . worked closely with a French glassworks...

Give an example of a graph in which every node is pivotal for at least two dierent pairs of nodes. Explain your answer. Give an example of a graph having at least four nodes in which there is a...

Write a report on the Analysis of Starbucks

You need to do ratio analysis of Starbucks after reviewing its financial statement 2017: Operating Expenses" Net earnings Adjustment to concile net income to net cash: Depreciation and amortanization...

You need to do Analysis of Liquidity Position of Wal-Mart including multinational working capital management and the common issues and strategies of Wal-Mart

Write a research on a legal case that addresses the legalities of employment screening exams used in the selection process. Requirements: Provide a description of the case. Summarize the important...

b) In order to complete the wing assembly for an experimental aircraft, a company has laid out the major steps and seven tasks involved. These tasks have been labeled A through G in the following...

The feeling of boredom.

2. In this chapter, the reader should reflect on the following concepts:

1. To provide an understanding of how emotions are regulated by the development of relationships between actors in a communication situation.