Question: 1. (20 pts) Write the create table statements for the following ERD. Make sure to have the primary key and foreign key constraints. ssn

1. (20 pts) Write the create table statements for the following ERD. Make sure to have the primary key and

1. (20 pts) Write the create table statements for the following ERD. Make sure to have the primary key and foreign key constraints. ssn Employees name lot Worksin since did Departments dname a. List all the unique product vendors. b. List all the customer names in the state of California. 2. (10 pts) Insert 5 records into each table of question 1. 3. Download the sample database from http://www.mysqltutorial.org/mysql-sample-database.aspx. An ER diagram is available on this page as well. Load the data into MySQL and write queries for the following questions. 4. (20 pts) Simple Queries: Write the SQL queries on one table budget c. Calculate the average credit limit for all the customer in California. d. For each customer, list the total number of orders in 2005. e. List all the product name who quantityInStock is less than 200.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Create Table Statements sql CREATE TABLE Employees ssn INT PRIMARY KEY name VARCHAR255 NOT NULL CR... 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!

A bond issued 10 years ago had a face value of $2,000; a coupon rate of 5%; and a yield of 6% when it was sold last month in the secondary bond market. At what price did the bond sell in the...

Project 1 provides experience with creating ERDs and writing CREATE TABLE statements for the Expense Reporting database at XCorp, a fast-growing web consulting company. You will design an ER Diagram...

a) Find the set of solutions of each of the linear congruence: i. 8x = 12 (mod 28). ii. 7x = 1 (mod 9). b) Hashing Function is used to assign a memory location for the records in the computer (For...

I just wanted to compare answers to see if I did it right. (20 pts) Write the create table statements for the following ERD. Make sure to have the primary key and foreign key constraints. (10 pts)...

Write the create table statements for the following ERD. Make sure to have the primary key and foreign key constraints. Each table needs to start with your initials underscore table name. Add an...

Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid 1 2 3 4 LastName Jason Smith Wagner Blake Jones Lynn Walters Poplar Robb Henlon FirstName Rita Jackson James Susan...

Answer the following questions based on the CLIENT and ORDER tables: CLIENT ClientId LastName FirstName Suburb Phone City 1 Jason Rita Bella Boulevard 3432422 Sydney 2 Smith Jackson High Park 5535333...

Questions: 1. Write CREATE and INSERT statements for the above tables and identify constraints. Make sure that primary key, foreign key, not null and other constraints are included in the table...

Answer the following questions based on the CLIENT and ORDER tables: CLIENT ClientId LastName FirstName Suburb Phone City Jason Rita Bella Boulevard 3432422 Sydney 12 Smith Jackson High Park 5535333...

please answer ASAP. Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid 1 2 3 LastName Jason Smith Wagner Blake Jones 4 5 6 FirstName Rita Jackson James Susan Tania...

A) Describe any 4 types of chemical reactions. Write one example for each type. (B) Calculate the mass of 941 molecules of Cd(NO2)2. (C) Balance the following chemical equations. (a) Pb(OH)2 + HNO3 ...

A statistics practitioner wants to estimate the mean age of children in his city. Unfortunately, he does not have a complete list of households. Describe a sampling plan that would be suitable for...

The volume of a tube ( see the figure ) is V ( r , h , t ) = h t ( 2 r - t ) Tubes are produced with maximum error - 0 . 0 5 c m in the radius and height and maximum error - 0 . 0 0 0 5 c m in...

In terms of Le Chateliers Principle, explain why steam reforming is done at low pressures while methanol synthesis is performed at moderate to high pressures. Explain why reforming is done at high...

Using a handheld bicycle pump to generate an air jet, a soda can as the water reservoir, and a straw as the tube, design and build an atomizer. Study the effects of various parameters such as the...

It is proposed to place a 3 m 3 m foundation at 2 m depth in a sandy soil, where the average N 60 is 25 and the unit weight is 18 kN/m 3 . Using Meyerhofs expressions presented in Section 9.6,...

A property interest that allows a person who owns real property to dispose of it either during lib lifetime or on his death is a(n)?????? property interest. affemative easement flee simple400024 Me...

On July 1, 2012, Ted, age 73 and single, sells his personal residence of the last 30 years for $365,000. Ted's basis in his residence is $35,000. The expenses associated with the sale of his home...

Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...

During 2012, Palo Fiero purchases the following property for use in his manufacturing business: Palo uses the accelerated depreciation method under MACRS, if available, and does not make the election...

How much interest will be earned on $5000 in five months if the interest rate is 5.5%?

During its 50-50 Sale, Marpole Furniture will sell its merchandise for 50% down, with the balance payable in six months. No interest is charged for the first six months. What 100% cash price should...

At what rate can money be invested if $2370.00 is equivalent to $2508.79 paid 190 days later?