[Solved]Task Week Write Sql Statements Create Tables Relational Schema Also Write Sql Statements I Q37206231
Below are the supporting images to help complete the above
Your task this week is to write the SQL statements to create the tables from your relational schema. You will also write the SQL statements to insert a minimum of 3 rows of data into each table. Include all of SQL statements in a single SQL script file. The script should execute as a single script. Attach the script file to the group discussion forum. You will be graded on the following: Script file is formatted in a way that all SQL statements are clear You included comments in your script file. You have properly added primary and foreign key constraints. . Good use of naming conventions (table names and column names) * The script executes with no errors. so points) Emloyee Lname Emloyee Fname Takes Order ORDER CUSTOMER Makes Oeder Amount Charged Payment Type DateTime FK Employee ID Last Name Fest Name have ITEMS DETAIL ITEMS Has Item Descpoon SalePrice Cos Price Relational Database Schema: ORDER(Order ID, Customer ID, Employee ID. Bill ID) EMPLOYEE(Employec ID, Employee Lname, Employee Fname) CUSTOMER Customer ID. Last Name, First Name) BILL Bill ID, Amount Charged, Payment Type, DateTime) ITEMS(tem ID, Order IDItemDetail ID,Quantity) ITEMS DETAILtemDetail ID, Item Description, SalePrice, CostPrice) Emloyre lLrane Emloyec Fname SLL Make Order Amount Charges Payment Type Last Name ITEMS DETAI llem Descpion Orde D- Quanny Show transcribed image text Your task this week is to write the SQL statements to create the tables from your relational schema. You will also write the SQL statements to insert a minimum of 3 rows of data into each table. Include all of SQL statements in a single SQL script file. The script should execute as a single script. Attach the script file to the group discussion forum. You will be graded on the following: Script file is formatted in a way that all SQL statements are clear You included comments in your script file. You have properly added primary and foreign key constraints. . Good use of naming conventions (table names and column names) * The script executes with no errors. so points)
Emloyee Lname Emloyee Fname Takes Order ORDER CUSTOMER Makes Oeder Amount Charged Payment Type DateTime FK Employee ID Last Name Fest Name have ITEMS DETAIL ITEMS Has Item Descpoon SalePrice Cos Price
Relational Database Schema: ORDER(Order ID, Customer ID, Employee ID. Bill ID) EMPLOYEE(Employec ID, Employee Lname, Employee Fname) CUSTOMER Customer ID. Last Name, First Name) BILL Bill ID, Amount Charged, Payment Type, DateTime) ITEMS(tem ID, Order IDItemDetail ID,Quantity) ITEMS DETAILtemDetail ID, Item Description, SalePrice, CostPrice) Emloyre lLrane Emloyec Fname SLL Make Order Amount Charges Payment Type Last Name ITEMS DETAI llem Descpion Orde D- Quanny
Expert Answer
Answer to Your task this week is to write the SQL statements to create the tables from your relational schema. You will also write… . . .
OR
