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

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

SQL queries to create the given tables Employee Costumer Product Sales Payment along with the relati... View the full answer