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...
Using the hypergeometric distribution, with N = 4, n = 2, and s = 3, determine the following: a. P(x = 0) b. P(x = 1) c. P(x = 2)
Assume that a U.S. company has a foreign subsidiary whose functional currency is the U.S. dollar. Explain how exchange rates between the foreign currency and the dollar would have to change in order...
Refer to the data in Problem 6.36. In exercise Muskoge Company uses a process-costing system. The company manufactures a product that is processed in two departments: Molding and Assembly. In the...
Pak Company produces furniture and uses a joint process to manufacture two grades of wood: X and Z. During October, the company incurred $48,600,000 of joint production cost. Company produced...
Roberto Martinez was the sole force behind In Over Our Heads, Inc., a corporation designed to run a year-round community swimming pool. The enterprise was incorporated in the correct manner in...
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...
This problem was introduced in the text towards the end of the chapter. The information you need to solve this problem is included in the table below. Interpretation: There is a 50% chance that the...
In the circuit of Fig. 4-51 write two loop equations using I 1 and I 2 . Then find the currents and node voltages. A 3A ( 4 3 V 792 B +1 D w 392 12 C
The capacitor in the circuit shown in Fig. 7-37 has initial charge Q 0 = 800 C, with polarity as indicated. If the switch is closed at t = 0, obtain the current and charge, for t > 0. 100 V (+ 10 4 F
A gift shop sells 400 boxes of scented candles a year. The ordering cost is $$60$ for scented candles, and holding cost is $$24$ per box per year. What is the economic order size for scented...
Kay Vickery is angry with Gene Libby. He is behind schedule developing supporting material for tomorrows capital budget committee meeting. When she approached him about his apparent lackadaisical...
Tharpe Painting Company is considering whether to purchase a new spray paint machine that costs $$3,000$ . The machine is expected to save labor, increasing net income by $$450$ per year. The...
You are CEO of Rivet Networks, maker of ultra-high performance network cards for gaming computers, and you are considering whether to launch a new product. The product, the Killer X3000, will cost...
2.) Find the Laplace transform of f(t) 7e-St cos 2t +9 sinh2 2t. Use Laplace Table. %3D
What is the radical position on the dividend policy of the firm?
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.
Old MathJax webview i need Compute key financial ratios all financial ratios are required B D 2020 2019 9,169 118,378 18,423 1,839 10,244 10,748 1,648 3,963 11,048 185,460 8,822 97,719 17,417 731...
L> Moving to another question will save this response Question 1 Which of the following statements is true? o When corporate governance is strong managers may demand excessive pay O When corporate...
Document Malings Review View W Design Layout References ody - 12 - A A A A U. XX A. AD Aalto ABECEDE A AaBbc Acid 2) The Duranceau company has great difficulty controlling its indirect manufacturing...

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