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: 66% (21 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...
-
Buddy Dupree is the accounting manager for On-Time Geeks, a tech support company for individuals and small businesses. As part of his job, Buddy is responsible for preparing the company's trial...
-
An experiment has the four possible mutually exclusive outcomes \(A, B, C\), and \(D\). Check whether the following assignments of probability are permissible: (a) \(P(A)=0.38, P(B)=0.16, P(C)=0.11,...
-
Consider the drug treatment system shown in the figure below. A hemispherical cluster of unhealthy cells is surrounded by a larger hemisphere of stagnant dead tissue (species B), which is turn...
-
1.In Australian juice market, what is the market research and pricing and positioning of new launch juice in the existing market? 2. What kinds of market strategies are used by new product of juice...
-
Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected...
-
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...
-
Discrimination based on physical appearance is not expressly prohibited by the Civil Rights Act. As a result, some hospitality organizations hire only attractive staff members for many of their front...
-
DPCL is a small-sized firm manufacturing hand tools. Its manufacturing plant is situated in Sohar. The company's sales in the year ending December 2014 were OMR 1000 million on an asset base of OMR...
-
Describe the audit procedures you will conduct when you attend the inventory count at the end of Shareware Ltd's financial year.
-
(Future value) Selma and Patty Bouvier are twins, and both work at the Springfield DMV. They decide to save for retirement, which is 30 years away. They'll both receive an annual return of 8 percent...
-
Complete the following table and compute the project's conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If...
-
Q1-Make A paragraph that discusses three root causes of academic dishonesty, and explain what the solution would be for each. What you think are three root causes of plagiarism and academic...
-
Evaluate the integrals in Problems both exactly [e.g. ln(3)] and numerically [e.g. ln(3) 2.243]. 5 Int dt 1
-
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.
-
Please discuss echo of this topic with hundred words at list pleas. Its UNIX and Linux operating systems Discuss on (Unix File System and Directory Navigation) Discuss on (Importance of the shell...
-
How do Windows and Unix systems save settings?
-
Two charges, QA=-6.10 C and QB-4.15 C are placed a distance d=1.50 cm from each other. What is the electric potential energy of this system of charges? Provide your answer in joules with 2 decimal...
Study smarter with the SolutionInn App