Question: Consider the following ER diagram (primary keys are underlined): Create the relational database tables required to implement this ER diagram using SQL create table statements.

Consider the following ER diagram (primary keys are underlined):

Dorm DName varchar (30) numRooms numeric (3) address varchar(50) Belongs To Room

Create the relational database tables required to implement this ER diagram using SQL create table statements. Include primary key and foreign key constraints

Dorm DName varchar (30) numRooms numeric (3) address varchar(50) Belongs To Room with Room RoomNo bunk Beds shared Bathroom 0..1 0..1 numeric (3) boolean boolean 0..1 Resides in 0..2 Student Sid numeric (6) name varchar(25) phone varchar(12)

Step by Step Solution

★★★★★

3.31 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 create table studentsid int primary keyname varchar30phone v... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

What are some of the primary difference between basic partitioning and Logical Volume Manager (LVM) What are primary and extended partitions? Explain

Brand X copier advertises that its copiers run 23% longer between service calls than its competitor. If Brand X copiers run 65,000 copies between services, how many copies would the competitor run?...

A gas turbine system operates with air entering at a velocity of 115 m/s and a density of 1.25 kg/m. The gas turbine inlet area is 0.05 m. Air leaves the turbine at a velocity of 135 m/s and a...

Consider the relational database of Figure, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all...

Consider the relational database of Figure. Give a relational-algebra expression for each of the following queries: a. Find the company with the most employees. b. Find the company with the smallest...

Consider the relational database of Figure. Give an expression in the relational algebra for each request: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First...

Consider the employee database of Figure, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names of all employees who work for First...

Consider an employee database with two relations employee (employee-name, street, and city) works (employee-name, company-name, salary) where the primary keys are underlined. Write a query to find...

Marcia Wilson owns and operates Marcia's Dry Cleaning, which is an upscale dry cleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out from the competition by providing...

Consider the use of information technology to run thiscampaign. Using the four rows in Figure CE1-7, answer the following questions: a. Suppose that you attempt to use nothing other thanface-to-face...

A 765kV circuit has flat horizontal spacing of 10ft between phases, 4 conductors per bundle, and each bundle is arranged in a square of 1.0 ft on a side. The conductor has a diameter of 1.2 inches. a...

What is Bohrs effect in biology?

An indication of potential inventory fraud is that inventory levels are growing faster than sales. a . True b . False

COMMON AND PREFERRED CASH DIVIDENDS Wakui Company currently has 100,000 shares of $1 par common stock outstanding and 1,000 shares of $100 par preferred stock outstanding. On July 10, the board of...

RETAINED EARNINGS STATEMENT Womack Company had the following balances and results for the current calendar year: Retained earnings, January 1.....$80,000 Cash dividends declared.......15,000 Net...

Use the information for Cisco Systems in the last problem. In addition, the companys EBITDA was $6.834 billion and its share price was $22.36. Compute the firms price-earnings ratio and the...

Ayres Services acquired an asset for $80 million in 2011. The asset is depreciated for financial reporting purposes over four years on a straight-line basis (no residual value). For tax purposes the...

Athletic Universe began January with merchandise inventory of 65 crates of vitamins that cost a total of $3,835. During the month, Athletic Universe purchased and sold merchandise on account as...

Calculane the sork (is joules) reqpind to purp all liquid est of a fill tank.(Use scientific notalion. Give jowr anveer bo thoe sipoifican lipues.)

Maintenance has been presented as both the final stage of the SDLC (see Figure 14-1) and as a process similar to the SDLC (see Figure 14-3). Why does it make sense to talk about maintenance in both...

Jim Watanabe, project director for the No Customer Escapes customer loyalty system for Petrie Electronics, walked into the conference room. Sally Fukuyama, from marketing, and Sanjay Agarwal, from...

Consider the situation you addressed in Problem and Exercise 5-35. Create a sample Project Scope Statement following the structure shown in Figure 5-10. Problem and Exercise 5-35. Consider your use...

Prepare a HACCP analysis for burgers made in a fast-food restaurant such as McDonalds.

An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls during the previous week, as shown on the next page. Using the data, make a check sheet for...

Consider an auto assembly operation. What kinds of quality problems can arise during assembly? Name one or two. How can each be fixed? Prevented? You may view the Honda video segments on...