Figure 4-34 shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff
Question:
Figure 4-34 shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. Your assignment is to:
a. Develop a relational schema.
b. Show the functional dependencies.
c. Develop a set of 3NF relations using an enterprise key.
Transcribed Image Text:
RGURE 4-34 EER diagram for a restaurant SEATING RTABLE Seating ID Uses Nbr of Guests Start TimeDate End TimeDate RTable Nor RTable Nbr of Seats RTable Rating EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wage Specialty! Manages Monthly Salary Manages
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 68% (22 reviews)
Developing a relational schema based on Figure 434 The notation used here is an alternative way of d...View the full answer
Answered By
YOGENDRA NAILWAL
As I'm a Ph.D. student, so I'm more focussed on my chemistry laboratory. I have qualified two national level exams viz, GATE, and NET JRF (Rank 68). So I'm highly qualified in chemistry subject. Also, I have two years of teaching experience in this subject, which includes college teacher as well as a personal tutor. I can assure you if you hire me on this particular subject, you are never going to regret it.
Best Regards.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted:
Students also viewed these Computer Sciences questions
-
Figure 4-33 (page 196) shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with...
-
Figure 4-40 shows an EER diagram for a university dining service organization that provides dining services to a major university. a. Transform the EER diagram to a set of relations and develop a...
-
Figure 4-32 shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants....
-
1. Calculate the density of O2, in g/L, at STP. 1.62 g/L b. 0,714 g/L 1.43 g/L. d. 1.14 g/L e. 0.810 g/L a. .
-
A random sample of size n = 13 obtained from a population that is normally distributed results in a sample mean of 45.3 and sample standard deviation of 12.4. An independent sample of size n = 18...
-
Topper Inc. had following inventories on March 1: Finish goods Rs. 15000, WIP Rs. 19070 and Materials Rs. 14000. The work in process control three jobs: Job No. 62 Materials Rs. 2800, Labor Rs. 2100...
-
The basic concept behind a learning organization is: A. The popularity to change. B. The people change. C. The adaptation to change. D. The resources of change.
-
What types of mechanisms can be used to help increase collaboration across business and IS leaders?
-
Case 3-1 Iowa Elevators 1 Describe the company Iowa Elevators. What are the company's businesses? How is the company doing? 2 Carefully consider the company's current purchasing practice and profile....
-
At December 31, 2022, Bramble Corporation reported the following plant assets. Land $ 4,278,000 Buildings $26,530,000 Less: Accumulated depreciation? buildings 17,005,050 9,524,950 Equipment...
-
Table 4-3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify parts and that...
-
Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal...
-
What product is expected when 4-(dimethylamino)pyridine reacts with CH3I?
-
Bridge City Consulting bought a building and the land on which it is located for $182,000 cash. The land is estimated to represent 70 percent of the purchase price. The company paid $22,000 for...
-
The planet Mars has a mass that is 0.11 times Earth's mass and a radius that is 0.54 times Earth's radius. a) How much would a 60.0-kg astronaut weigh if she were to stand on the surface of Mars? b)...
-
Riverbed Company has budgeted the following unit sales: 2022 2023 Quarter Units Quarter Units 1 106,000 1 93,000 2 64,000 3 70,000 4 120,000 The finished goods inventory on hand on December 31, 2021...
-
August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,300 Revenue ($4.259) $ 31,025 Expenses: Packing...
-
The following items were selected from among the transactions completed by Sherwood Co. during the current year: Feb. 15. Purchased merchandise on account from Kirkwood Co., $144,000, terms n/30....
-
In ABC, AB = x cm, BC = 5 cm, AC = (10 x) cm. a. Show that b. Given that cos ABC = 1/7 , work out the value of x. LABC= 4x - 15 2x
-
On 1 July 2021, Croydon Ltd leased ten excavators for five years from Machines4U Ltd. The excavators are expected to have an economic life of 6 years, after which time they will have an expected...
-
Consider a relational database with two relations: course (course-name, room instructor) enrollment (course-name, student-name, grade) Define instances of these relations for three courses, each of...
-
Consider the following bitmap technique for tracking free space in a file. For each block in the file, two bits are maintained in the bitmap. If the block is between 0 and 30 percent full the bits...
-
Give a normalized version of the Index-meta data relation, and explain why using the normalized version would result in worse performance.
-
You are considering a stock investment in one of two firms (LotsofDebt, Incorporated and LotsofEquity, Incorporated), both of which operate in the same industry. LotsofDebt, Incorporated finances its...
-
Blooper Industries must replace its magnoosium purification system. Quick & Dirty Systems sells a relatively cheap purification system for $16 million. The system will last 4 years. Do-It-Right sells...
-
3 2 points Problem 7-1 (LO7.1) Based on the following data, calculate the items requested: Rental Costs Annual rent Buying Costs eBook Hint Print References $ 8,080 Annual mortgage payments Insurance...
Study smarter with the SolutionInn App