Question: Assume that you are going to use a relational database management system (RDBMS) to manage and store the application objects. Based on the diagram attached,

Assume that you are going to use a relational database management system (RDBMS) to manage and store the application objects. Based on the diagram attached, create a relational schema for the restaurant system. Use arrows to show referential integrity constraints. Use a computer-based graphics tool to draw your relational schema (i.e., Gliffy.com, Creatly.com, VISIO, etc.) 1..1 Staff staffNo - firstName 1..1 lastName address -phone -gender dateOfBirth -job

1..1 Staff staffNo - firstName 1..1 lastName address -phone -gender dateOfBirth -job Title - salary -joinedDate 4 Manager -annualCarAllowance -monthlyBonus NextOfKin - firstName - lastName 0..1-address -phone - relationshipToStaff Credit Card credit Card No -type -firstName - lastName - expiryDate - verificationCode 10... 0..1 Customer -customerld -firstName -lastName -address -phone 1..1 -email 0..* 1..1 -reservationid date - time partySize 1..1 reserves - tableld submits 1.1 Reservation 0..* capacity - isReserved + reserve Table(date, time, partySize) + changeReservation(reservationid) + cancelReservation(reservationid) Dining Table 0.. -orderld SalesOrder - date 1..-time +compute Total 1..1 0.." 0.." 1..1 1..1 1.. 0..1 billNo date - - time - amount -receiptNo date -time Bill 1..1 - quantity + computeAmount() + printBill() paymentType -totalAmount OrderLine +computeSub Total() 0..1 CashReceipt + compute TotalAmount(tip) + printReceipt() 1..1 -itemid -name Meal id - mealName description price - total calories 1..1 Recipe 0..1 -recipeld -cookingMethod -preparation Time + compute TotalCalories() Supplies - description - onhand + findVendor() 1..1 1.. Menu -menuld -menuName -start Time - endTime -season RecipeLine - quantity + computeCalories() 1., 1..1 Ingredient - unitOfMeasure - caloriesPerUnit

Step by Step Solution

★★★★★

3.48 Rating (141 Votes )

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!

Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...

Show that the mean square estimate is the mean of the posterior den- sity. Show this by differentiating eq. (13) at the lecture slides with respect to and set the obtained gradient to zero. Now the...

Assume that you are going to hire three new employees for the department store you manage. One will sell shoes, one will manage the toy department, and one will work in the stockroom. Identify the...

Page 1 of 4 SQL Assignment ACCTG 333 - Fall 2019 Professor Perols Due Friday, November 8, 2019 Why should you learn SQL? Technology is drastically changing the accounting industry...and structured...

SQL Assignment ACCTG 333 Fall 2021 (Professor Perols) Why should you learn SQL? Technology is drastically changing the accounting industryand structured query language (SQL) is one of the...

This is what I have so far (not fully sure if this covers all of the Deliverables): Project Description In this project, you will practice designing an application database system from scratch. You...

SQL Assignment ACCTG 333 - Fall 2021 (Professor Perols) Why should you learn SQL? Technology is drastically changing the accounting industry...and structured query language (SQL) is one of the...

Project Description In this project, you will practice designing an application database system from scratch. You need pick a database application and design your own database system with at least 5...

This assignment aims to develop a broad knowledge of storing and managing data to satisfy the organizational requirements. These will be reinforced by developing the practical skills required for...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Let E and F be events such that P(E)=0.4, P(F)=0.5, and P(E U F)=0.6 a) Find P(E n F) b) Find P(E/F) c) Find P(E U F)

Refer to Selected Reference 5. (a) Describe the authors viewpoint about whether the sole goal in using a model should be to find its optimal solution. (b) Summarize the authors viewpoint about the...

Which of the following is a key benefit of using project reporting in QuickBooks Online? Tracking profitability and controlling project costs, creating recurring invoices for clients, monitoring...

Dale Nagel, Keith White, and Issa Mbango have capital balances of $92,000, $74,000, and $6,000, respectively. They share profit or loss on a 4:3:2 basis. White withdraws from the partnership on...

The Stokes Company uses a voucher system and records invoices at gross. Record the following transactions in the voucher register and/or check register as appropriate: 201X Dec. 1 Voucher no. 300 was...

Julie Lane, Sara Miles, and Amber Noll have capital balances of $50,000, $40,000, and $30,000, respectively. The profit and loss ratio is 5:3:2. Assume Noll withdraws from the partnership on December...

Olive Oil Imports is a partnership owned by Magda Stavros and Giannis Metaxas. The partners share profit on a 3:2 basis, respectively. On January 1, 2017, they have capital balances of $95,000 and...

A. Veveris and J. Rubenis share profit on a 2:1 basis, respectively. They have capital balances of $42,000 and $33,000, respectively, when S. Weiss is admitted to the partnership on September 1,...

Why is diversity equity and inclusion DEI important in marketing it helps businesses avoid government regulations if Foster trust and strengthens connections with the verse consumer groups

Contrast the following terms: a. Object class; object b. Abstract class; concrete class

How is a foreign key represented in relational notation?

Find out which, if any, drawing packages, word processors, forms design, and database management systems your university or company supports. Research these packages to determine how they might be...

What is the maximum amount of foreign tax credit that a company will be allowed to take with respect to the income earned by a foreign operation?

What is the difference between the worldwide and territorial approaches to taxation?

Avioco Limited has two branches located in Hong Kong and Australia, each of which manufactures goods primarily for export to countries in the Asia-Pacific region. The corporate income tax rate in...