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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

See More Books

Question Posted: Dec 20, 2015 02:38 AM

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

Figure 4-34 shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff

Question:

Step by Step Answer:

Developing a relational schema based on Figure 434 The notation used here is an alternative way of d...View the full answer

Modern Database Management

Students also viewed these Computer Sciences questions