Draw the relational schema (prepare the tables) for the following 3 ERDs. Clearly state every assumption...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw the relational schema (prepare the tables) for the following 3 ERDs. Clearly state every assumption make. Underline the primary keys. Indicate which column(s) the foreign keys are pointing to. that you (15 points) (1) (2) MENU Menu_ID Menu_Description Menu_Type Contains DISH Dish_ID Dish Name Prep Time {Ingredient} RENTER Renter ID First Name Middle_Initial Last Name Address Phone# E_Mail Served_at HE HI Signs EVENT Event ID Event Date Event Location Event Time WORK SCHEDULE Start Time End Time Position RENTAL AGREEMENT Agreement ID Begin_Date End Date Rental Amount Books Supervises TH PROPERTY "B" Property ID Street Address City State Zip No Rooms Base Rate Property Type Emp_ID Name Salary {Skill} BEACH PROPERTY Blocks_to_Beach STAFF (15 points) Property Type = "M" MOUNTAIN PROPERTY {Activity} Elevation Draw the relational schema (prepare the tables) for the following 3 ERDs. Clearly state every assumption make. Underline the primary keys. Indicate which column(s) the foreign keys are pointing to. that you (15 points) (1) (2) MENU Menu_ID Menu_Description Menu_Type Contains DISH Dish_ID Dish Name Prep Time {Ingredient} RENTER Renter ID First Name Middle_Initial Last Name Address Phone# E_Mail Served_at HE HI Signs EVENT Event ID Event Date Event Location Event Time WORK SCHEDULE Start Time End Time Position RENTAL AGREEMENT Agreement ID Begin_Date End Date Rental Amount Books Supervises TH PROPERTY "B" Property ID Street Address City State Zip No Rooms Base Rate Property Type Emp_ID Name Salary {Skill} BEACH PROPERTY Blocks_to_Beach STAFF (15 points) Property Type = "M" MOUNTAIN PROPERTY {Activity} Elevation
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Let x be the number of magazines a person reads every week. Based on a sample survey of adults, the following probability distribution table was prepared. Find the mean and standard deviation of x. 0...
-
Wong Company, a sole proprietorship owned by V. Wong, uses special journals and a general journal. The company uses a perpetual inventory system and had the following transactions: Sept. 2 Sold...
-
Show that these are homomorphisms. Are they inverse to each other? (a) d/dx: P3 P2 given by a0 + a1x + a2x2 + a3x3 maps to a1 + 2a2x + 3a3x2 (b) P2 P3 given by b0 + b1x + b2x2 maps to b0x +...
-
Difference and ratio estimation, mean-per-unit estimation, and probability proportional-to-size (PPS) sampling all express sampling results in dollars. How, though, does PPS sampling differ from the...
-
Presented below is information related to James Garfield Corp. July 1 James Garfield Corp. sold to Warren Harding Co. merchandise having a sales price of $8,000 with terms 2/10, net/60. Garfield...
-
Research scholarships that fit your personal profile and estimate your potential financial aid. Then you will analyze the results of your research and explain your plan for achieving all the aid you...
-
(a) For the cascade shown in Figure a, calculate the compositions of streams V4 and L1. Assume atmospheric pressure, saturated liquid and vapor feeds, and the vapor-liquid equilibrium data given...
-
Let f(z) 72-10z. We will find f'(z) using the definition f'(x) = =lim AO We break this down into four steps, as follows: STEP 1: Find f(x+h). f(x+h) = STEP 2: Find f(x+h) - f(z). f(x +h)-f(z) - STEP...
-
In a particle accelerator, a magnetic force keeps a lithium nucleus (mass 6.02 u) traveling in a circular path with a radius of 0.530 m. The lithium nucleus moves at a speed of 10.50% of the speed of...
-
A crate of eggs is located in the middle of the flat bed of a pickup truck as the truck negotiates a curve in the flat road. The curve may be regarded as an arc of a circle of radius 34.8 m. If the...
-
Find the derivative of the given function. Simplify the derivative. y =6x6 (5-8x)4 dy dx II
-
Using the Model of the Cultural Process , can you describe for me: 1. Exactly what cultural meanings do these smart speakers hold? 2. How did smart speakers gain their cultural meanings? Please be...
-
PLEASE PROVIDE WORKING C# Code with output if you answer. Design an archive system to store novels. A novel can have many pages. Within a page, there can be several columns and frames. A column can...
-
The power of an electric iron is 1000 W, if the resistance is 100. The current that passes is from?
-
The relationship described in question 7 does not always appear to hold. What factors, besides the number of firms in the market, might affect margins?
-
Why is increased efficiency an advantage in a distributed database?
-
In Example 1, why is the data type for the Postal Code field CHAR and not SMALLINT or INTEGER? Is the length of the field long enough? Why or why not?
-
Suppose in addition to the requirements specified in Question 7, you must store the number of the department in which the student is majoring. Indicate the changes this would cause in the design in...
-
Using the online code for the example in this chapter as a starting point and the solution from a previous exercise. 1. Implement (or modify your previous) Student: :DropCourse (). When a student...
-
What other examples can you imagine that might easily incorporate the Factory Method pattern?
-
Using the solution from a previous exercise, augment your code as follows: 1. Implement the Factory Method pattern to create various shapes. You will have already created an abstract base class of...
Study smarter with the SolutionInn App