Question: Cerate the following tables using SQL and make a relation between tables. Employee: (Employee_ID, Name, Hire Date, Salary, Job_title, costumer_ID) Costumer :(costumer_ID. Firstname, Lastname,

Cerate the following tables using SQL and make a relation between tables. Employee: (Employee_ID, Name, Hire

Cerate the following tables using SQL and make a relation between tables. Employee: (Employee_ID, Name, Hire Date, Salary, Job_title, costumer_ID) Costumer :(costumer_ID. Firstname, Lastname, Purchase_product.product_ID) Product: (product_ID, Name, Availability, Price, Sales_ID) Sales: (Sales_ID, Fname, product_name, price, quantity, data_purchase, payment_ID) Payment: (payment ID, customer_name, total_payment, date) B. Insert 5 records for each tables using SQL code.

Step by Step Solution

★★★★★

3.52 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SQL queries to create the given tables Employee Costumer Product Sales Payment along with the relati... 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!

8-Assume that k corresponds to register $s0, n corresponds to register $s2 and the base of the array v is in $s1. What is the MIPS assembly code corresponding to this C segment? while (k

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

There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...

can anyone do it please which is about advanced database . This assignment focuses on skills associated with the following topic of your course: Data Models Business Rules The Relational Database...

Please solve it using SQL Developer: Part A: Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the...

Q:Question:Create the following tables using SQL 1- Show the SQL statements which been used to create these tables 2- Show the SQL statement which you can use to insert your name as one of sales...

After watching the videos about budgets, what are your key takeaways? Do you think you will take any of this advice and use it? In your experience, what makes budgets difficult? Do you have any other...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Suppose the slit openings in a Youngs double-slit experiment have different sizes so that the electric fields and intensities from each slit are different. With E1 = E01 sin (wt) and E 2 = E02 sin...

Important role of nurses in the workplace & in healthcare is the article. Categories (Scope) conducted a self- contained summary of the case with the main point. Stated the problems and...

What human resources (HR) strategy can help align employee personal goals with the company's strategic objectives? Employee wellness programs Flexible work arrangements Aligning HR strategy with core...

The repayment plan for a loan with an interest rate of 5.0% totaling 20,500 now is to fully pay off the loan in 11 years using end of year payments beginning at 1300 and increasing by the same amount...

What difference will you want to make in Ghana during the next 7 years.

Your parents plan to give you $200 a month for four years while you are in college. At a discount rate of 6 percent, compounded monthly, what are these payments worth to you when you first start...

What are the various forms of business organization? What are the advantages and disadvantages of each?

Analyze the primary ways in which auditors would use the information from downgrades to assess business risk or evaluate the likelihood that the downgrades would impact the auditor's assessment of...

Identify two ways in which adults guide the next generation:

What distinguishes master data management from other forms of data integration?

Why is HTML5 beneficial for developing mobile applications?

Identify opportunities for using triggers in your database and write the appropriate DDL queries for them.

Mr. Palmer wants to retire in 20 years and purchase a 25-year annuity that will make end-of-quarter payments. The payment size is to be the amount which, 20 years from now, has the purchasing power...

Patrick contributes $1000 at the beginning of every quarter to his RRSP. In addition, he contributes another $2000 to the RRSP each year from his year-end bonus. If the RRSP earns 9.5% compounded...

Sheila already has $67,000 in her RRSP. How much longer must she contribute $4000 at the end of every six months to accumulate a total of $500,000 if the RRSP earns 9% compounded quarterly? (Round...