Question: request 1: MAKE SQL CODE FOR THE TABLES AND WRITE SQL QUERIES THAT ARE ASKED. 1. Create three tables based on the ER model provided

all the three tables using primary key to foreign key 3. Insert 3 records for each table. 4. Use join and connect customer and sales table. 5. Write a query which displays customerid, customername,item_id itemname,salesid- to request 1: MAKE SQL CODE FOR THE TABLES AND WRITE SQL QUERIES THAT ARE ASKED.

1. Create three tables based on the ER model provided 2. Connect all the three tables using primary key to foreign key 3. Insert 3 records for each table. 4. Use join and connect customer and sales table. 5. Write a query which displays customerid, customername,item_id itemname,salesid- to perform this query you need to alter the table to add the fields Scripts for Q1: create database Test use test

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

-Various forms of price discrimination. -Examples of Price Discrimination where consumers are likely to either clearly lose or clearly gain as a group (why?)

For the conceptual schemata of the database, establish an environment for the execution of simple and advanced queries in Oracle. The global schemata is as below EMP (ENUM, NAME, SAL, TAX, MGR, DNUM)...

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...

(a) Explain what is meant by component depreciation and its status under inter national accounting standards. (b) Trin, a limited liability company, owns its business premises. It has just installed...

Match each of the following statements with the corresponding document term. Statement 1. Incoming shipments of raw materials are counted and recorded on this document, a(n) _______________, which...

Morrison Company had credit sales of $2,500,000 during the year, its first year of business. Morrison has estimated that $50,000 of these sales on account will ultimately be uncollectible. In...

A specimen of medium-carbon steel having an initial diameter of 0.503 in was tested in tension using a gauge length of 2 in. The following data were obtained for the elastic and plastic states: Note...

A firm maintains a separate account for cash disbursements. Total disbursements are $100,000 per month, spread evenly over the month. Administrative and transaction costs of transferring cash to the...

Single-rate versus dual-rate methods, support department. The Chicago power plant that services all manufacturing departments of MidWest Engineering has a budget for the coming year. This budget been...

Assume the same facts as in P8-11, except that the FMVs for the inventory and fixed assets of Rachel are not as precisely specified. That is, appraisers have indicated that the FMV of the inventory...

Chec Troy Engines, Ltd. manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An...

What are Rare Earth Elements (REE)? 2) What products use REE? 3) What country produces the most REE? 4) Discuss the geo-political impacts of the current situation regarding REE. 5) Do you have any...

Employee ( EmpID , FName, LName, Address, DOB, Sex, SSN , DriverLisNo) EmpInf (EmpID, DivisionID, Position, HireDate, TerminationDate) EmpSal (EmpID, Position, Salary) Inventory (ProductNo, ProdName,...

Short Answer 5 Questions 15 marks Calculate the answers to the questions, make sure you input values for each textbox. Each input can have multiple entries, don't forget to include units where...

Assume that an investment provides the following cash inflows over a three-year period: Year 1 Year 2 $ 5,000 Year 3 Total 5,000 7,000 $ 17,000 Click here to view Exhibit 14B-1 and Exhibit 14B-2, to...

The function f(x) is graphed below. It has domain (-, -3) U (-3, ). 10 y -10 -5 5 5 10 x 5 10 Find the absolute maximum and absolute minimum y-values of f(x) on the given intervals, if they exist....

assume boeing sold 767 aircraft to American airlines on January 1, 2016. the sales agreement required American airlines to pay $10million immediately and $10million on December 31, of each year for...

Consider model (9.18). What is the effect on the model parameter estimates, their standard errors, and the goodness-of-fit statistics when (a) The times at risk are doubled, but the numbers of deaths...

Use the graph of y = f(x) to determine if f is one-to-one. Does f have an inverse? -3 3 y = f(x) 3

Graph y = f(x) by first plotting points to determine the shape of the graph. f(x) = x - 1

State the slope of the graph of f. - X = (x)/

An eight-year note for $3800 with interest at 11% compounded semiannually was sold after three years and three months to yield the buyer 14% compounded quarterly. What price did the buyer pay?

The contract for a $4000 loan at 9% compounded quarterly requires two payments. The first payment of $2000 is required two years after the date of the loan. (It is applied to the balance owed after...

Sun Life Financial offers a five-year compound-interest GIC earning rates of 2.5%, 3%, 3.5%, 4.25%, and 5% in successive years. Manulife offers a similar GIC paying rates of 2.75%, 3.25%, 3.5%, 4%,...