Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
SQL queries to create the given tables Employee Costumer Product Sales Payment along with the relati...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
12th edition
133544613, 978-0133544619
