Assume that you are going to use a relational database management system (RDBMS) to manage and store
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these 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...
-
How can the knowledge that a market will work itself back into equilibrium help economist predict future prices?
-
At t = 0, the current through a 45.0-mH inductor is 50.0 mA and is increasing at the rate of 115mA/s. What is the initial energy stored in the inductor, and how long does it take for the energy to...
-
An oil-drilling company knows that it costs \(\$ 25,000\) to sink a test well. If oil is hit, the income for the drilling company will be \(\$ 425,000\). If only natural gas is hit, the income will...
-
Tom Robinson is thinking about buying a portable computer. He has a computer at home, but the portable computer would allow him to work during his frequent business trips. Tom is trying to convince...
-
Operating Transactions, Special Topics, and Financial Statements. The City of Ashland's General Fund had the following post-closing trial balance at April 30, 2010, the end of its fiscal year: During...
-
Spectrum Consulting Company borrowed money from Zions Bank. The note the company signed requires five annual installment payments of $18,500 beginning one year from today. The interest rate on t...
-
Consider the RL circuit shown in Figure 6.25, in which \(R=35 \Omega\) and \(L=10 \mathrm{H}\). When the switch is closed at 0 seconds, the circuit is driven by a 6 V DC voltage source. Assume that...
-
Referring to the US FDA clinical trial phase 2 protocol for patients with major depressive disorder, Summarize primary & secondary efficacy objectives and their associated endpoints, including a...
-
The junction-to-case and case-to-air resistances of a 50-by-50 mm2 chip are 5C/W and 13C/W, respectively. It is assumed that the entire 7 W heat generated at the junction of this chip is dissipated...
-
Zinn Corp. has 3.50 million shares of common stock outstanding.The firm is in steady-state growth, and analysts expect the firm's earnings and dividends to continue to grow at their historical rate...
-
If two circular rods, one steel, and one copper, are both . 7 3 5 m long and 1 . 5 0 cm in diameter, each is subjected to a force with magnitude 3 8 5 0 N that compresses the rod what is the...
-
Two electrons in a vacuum exert force of F = 3 . 2 3 E - 0 8 N on each other. They are then moved so that they are separated by x = 5 . 1 times their original distance. How far apart, in meters, were...
-
Why is it important to record the professional de opportunities that you undertake for your current position and future employment?
-
A 2010 poll suggested that 60 of US adults believe that the use of marijuana should be legel. Is the proportion higher now? Determine the sample size needed to assume a maximum error of 3% with alpha...
-
When you weigh yourself on good old terra firma (solid ground), your weight is 142 lb. In an elevator your apparent weight is 121 lb. What are the direction and magnitude of the elevator's...
-
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...
-
On the Internet find the KPMG India Fraud Survey Report, 2002. a. How many chief executive officers re- ceived the questionnaire? b. How many of the respondents do not have a written fraud policy? c....
-
Using the Internet, locate and review these sites: a. National Fraud Center b. The Fraud Detectives Consultant Network c. Milberg Weiss Bershad Hynes & Lerach d. Mark R. Simmons e. Communications...
-
Go to the Internet and peruse the AICPA's "Catch Me If You Can" online fraud game.
Study smarter with the SolutionInn App