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...
-
Consider the table below when answering the following questions. For this hypothetical economy, the marginal propensity to consume is constant at all levels of real GDP, and investment spending is...
-
A fleet of refrigerated delivery trucks is acquired on January 5, 2005, at a cost of $930,000 with an estimated useful life of eight years and an estimated salvage value of $150,000. Compute the...
-
Prescott Companys predetermined overhead rate is 200% of direct labor. Information on the companys production activities during September 2013 follows. a. Purchased raw materials on credit, $...
-
There are various types of directors in a corporate organisation. Identify and state theses various types of directors.
-
A ride hailing company has their DB structured in 3 major tables as described in the SCHEMA section below. Write a query to fetch the top 100 users who traveled the most distance using the service....
-
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...
-
1. After looking over the similarities and differences between Amazon and Alibaba in the above table, which do you feel will become significant drivers of future success in the e-Commerce sector? 2....
-
On January 28, 1986, the Space Shuttle Challenger broke apart 73 seconds into its flight, killing all seven crew members aboard. The spacecraft disintegrated 46,000 feet (14 km) above the Atlantic Oce
-
Question 6 a)Explain briefly why it is prudent for investors to create Investment Policy Statement (IPS) when working with a financial advisor (2 marks) b)Describe the strategic asset allocation you...
-
The actual production volume is usually larger than the budged production volume. Please explain how the conservative estimate affects financial statements (i.e., the profit statement and balance...
-
Identify the situation where you would use a simple linear regression. please identify also explain this situation briefly.
-
1. Enter a formula in cell C9 using the PMT function to calculate the monthly payment on a loan using the assumptions listed in the Status Quo scenario. In the PMT formula, use C6 as the monthly...
-
Is the pregnancy status of this group of adolescents typical? Why might that be? See the data in Table 2-7. TABLE 2-7 Demographic Characteristics of 92 Adolescents Completing a Family Planning Survey...
-
A random sample of 10 houses heated with natural gas in a particular area, is selected, and the amount of gas (in therms) used during the month of January is determined for each house. The resulting...
-
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.
-
The European Commission rebuked Greece in 2010 for falsifying public finance data. Which of the following statements is the reason for inaccurate information in the above situation? Group of answer...
-
Discounted Cash flow dan Non Discounted Cash flow. Jelaskan apa maksud dan perbedaan dari dua konsep tersebut. Metode kriteria analisis investasi apa saja yang termasuk dalam masing-masing konsep...
-
Bowling Green Financial is preparing its Budgeted Income Statement for next year. Bowling Green Financial has collected the following information about this statement: Sales for next year total...
Study smarter with the SolutionInn App