Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave

ADDRESSTYPE table

You are required to perform the followings tasks: 1.

Task 1: Create a text file named Create_.sql (for example, Create_s3087654.sql) that will contain SQL statementsto: I. Create a database named BigM_. II. Create all of the tables for the database according to the Database schema given with this document (separately attached).

2. Task 2: Create a text file named Insert_.sql that will contain SQL statements to: I. Insert at least five records in each of the tables. The test data inserted into the table must ensure that each of the queries, specified in Task 3, outputs at least one record. 3.

Task 3: Create a text file named Query_.sql that will contain all the queries to display the following I. List of names and complete postal address of all employees sorted by their salary. II. The date on which the most recent customer order has been made. The customer name and date of the order will be sufficient. III. List of all the store names and their addresses, sorted in dictionary order of the store name. IV.

A list of all customers that have not placed an order yet. Displaying customer number and name will be sufficient. V. A list containing the name of employees, which work as accountant. VI. A list containing the total quantity on hand for each product (product number and description) regardless of stores. VII. A list showing each product sold (picked) on or before May 20, 2018. Show product number, name and quantity sold, sorted by product number and then quantity sold. VIII. A list of products(show product number, description and price) whose price is less than or equal to the average product price. IX.

Increase each employee’s salary by 7.5% and show the updated salary of all employees (name and salary). X. Show the pay information (employee name, hours paid, amount paid) of all employees in the most recent pay date. 1804ICT & 7003ICT - Assignment Part 2 Page 3 of 4 Additional queries for 7003ICT students only: XI. Make a list of all products of brand “Armani” and their price in ascending order of price. Show the product description and price. XII. A list of supervisors (employee id, name) and all of their subordinates (employee id, name).

4. Task 4: Create a text file named Update_.sql that will perform the followings. Insert additional data in the tables appropriately if needed. A customer named Daniel Ortega, from 11 Fuller Road, Marsden QLD 4132 and having a mobile number 0431xxx668, orders two shirts ofsize “XL” of brand “Prada” on 6 Sep 2018. The full order is ready on 8 Sep 2018 for pickup, but the customer picks up on 10 Sep 2018. You should insert data into appropriate tablesfor the above order and make sure you update the data in the relevant tables after the order is picked up. 

ADDRESSTYPE table

create table ADDRESSTYPE(

AddType_ID CHAR(1) Primary Key,

Add_Type VARCHAR(15)

/*------------------------2. ADDRESS TABLE--------------------------------*/

create table ADDRESS

Address_ID INT AUTO_INCREMENT,

Address_St VARCHAR(50),

Address_City VARCHAR(30),

Address_State VARCHAR (3),

Address_Postcode CHAR(4),

Add_TypeID CHAR(1),

primary key (Address_ID),

FOREIGN KEY (Add_TypeID) references ADDRESSTYPE(AddType_ID)

/*--------------------3. CUSTOMER TABLE--------------------------------*/

create table CUSTOMER

(

Cust_Number INT AUTO_INCREMENT Primary Key,

Cust_FName VARCHAR(30),

Cust_LName VARCHAR(30),

Cust_Phone CHAR(10),

Address_ID INT,

FOREIGN KEY (Address_ID) references ADDRESS (Address_ID)

/*-----------------------4. JOBTYPE TABLE--------------------------------*/

CREATE TABLE JOBTYPE(

JobType_ID INT AUTO_INCREMENT Primary Key,

JobType_Name VARCHAR(30)

/*-----------------------5. DEPARTMENT TABLE--------------------------------*/

CREATE TABLE DEPARTMENT(

Dept_ID INT AUTO_INCREMENT Primary Key,

Dept_Name VARCHAR(40)

/*---------------------6. STORE TABLE--------------------------------*/

CREATE TABLE STORE

Str_Num INT AUTO_INCREMENT Primary Key,

Str_Name VARCHAR(50),

Str_Phone CHAR(10),

Str_Fax CHAR(10),

Str_Email VARCHAR(40),

StoreManagerID INT,

SupStore_Num INT,

Address_ID INT,

Foreign key(SupStore_Num) references STORE(Str_Num),

Foreign key(Address_ID) references ADDRESS (Address_ID)

/*--------------------7. STOREDEPARTMENT TABLE--------------------------------*/

create table STOREDEPARTMENT

StrDept_ID INT AUTO_INCREMENT Primary Key,

StrDept_Phone CHAR(10),

StrDept_Email VARCHAR(40),

DeptSupervisorID INT,

Str_Num INT,

Dept_ID INT,

Foreign key(Str_Num) references STORE(Str_Num),

Foreign key(Dept_ID) references DEPARTMENT (Dept_ID)

/*--------------------8. EMPLOYEE TABLE--------------------------------*/

CREATE TABLE EMPLOYEE

Emp_ID INT AUTO_INCREMENT Primary Key,

Emp_FName VARCHAR(30),

Emp_LName VARCHAR(30),

Emp_Phone CHAR(10),

Emp_DoB DATE,

Emp_StartDate DATE,

Emp_TaxFNum CHAR(12),

Emp_HourlySalary DOUBLE(10,2),

StrDept_ID INT,

SupvisorID INT,

Address_ID_Postal INT,

Address_ID_Resident INT,

Emp_JobTypeID INT,

Foreign key(StrDept_ID) references STOREDEPARTMENT (StrDept_ID),

Foreign key(SupvisorID) references EMPLOYEE(Emp_ID),

Foreign key(Address_ID_Postal) references ADDRESS (Address_ID),

Foreign key (Address_ID_Resident) references ADDRESS (Address_ID),

Foreign key (Emp_JobTypeID) references JOBTYPE (JobType_ID)

/*------------------ALTER TABLE STORE AND STOREDEPARTMENT --------------------------------*/

ALTER TABLE STORE ADD CONSTRAINT STOREFK

Foreign key(StoreManagerID) references EMPLOYEE(Emp_ID);

ALTER TABLE STOREDEPARTMENT ADD CONSTRAINT SD_FK

Foreign key(DeptSupervisorID) references EMPLOYEE(Emp_ID);

/*---------------------9. BRAND TABLE--------------------------------*/

CREATE TABLE BRAND(

Brand_ID INT AUTO_INCREMENT Primary Key,

Brand_Name VARCHAR(30)

/*------------------10.PAYSLIP TABLE--------------------------------*/

CREATE TABLE PAYSLIP(

Pay_ID INT AUTO_INCREMENT Primary Key,

Pay_date DATE,

Pay_num_of_hours DOUBLE(4,2),

Pay_amount_gross DOUBLE(6,2),

Emp_ID INT,

Str_Num INT,

Foreign key(Emp_ID ) references EMPLOYEE(Emp_ID),

Foreign key(Str_Num) references STORE(Str_Num)

/*----------------11. PRODUCT TABLE--------------------------------*/

CREATE TABLE PRODUCT(

Prod_Num INT AUTO_INCREMENT Primary Key,

Prod_Desc VARCHAR(50),

Prod_Size VARCHAR(10),

Prod_Price DOUBLE(4,2),

Prod_BrandID INT,

Foreign key(Prod_BrandID) references BRAND (Brand_ID)

/*-----------------12. INVENTORY TABLE--------------------------------*/

CREATE TABLE INVENTORY

ProductNum INT,

Str_Num INT,

Inv_QntyOnHand INT,

Inv_QtyOrdered INT,

primary key (ProductNum, Str_Num),

Foreign key(ProductNum) references PRODUCT (Prod_Num),

Foreign key(Str_Num) references STORE (Str_Num)

/*--------------13. CUSTOMERORDER TABLE--------------------------------*/

CREATE TABLE CUSTOMERORDER(

CustOrd_ID INT AUTO_INCREMENT Primary Key,

CustOrd_Date DATE,

Cust_Number INT,

Str_Num INT,

Foreign key(Cust_Number) references CUSTOMER (Cust_Number),

Foreign key(Str_Num) references STORE (Str_Num)

/*------------------14. ORDERLINE TABLE--------------------------------*/

CREATE TABLE ORDERLINE

CustOrd_ID INT,

Prod_Num INT,

OrdLn_DateArrived DATE,

OrdLn_DatePicked DATE,

OrdLn_Qnty INT,

primary key (CustOrd_ID, Prod_Num),

Foreign key(CustOrd_ID) references CUSTOMERORDER(CustOrd_ID),

Foreign key(Prod_Num) references PRODUCT (Prod_Num)

Task 2: -

/*-------------------------------------------------------------------------

-----------------------INSERT DATA INTO TABLES-----------------------------

ADDRESS table

---------------------------------------------------------------------------*/

/*-----------------------1. ADDRESSTYPE table------------------------*/

insert into ADDRESSTYPE VALUES ('R','Residential'),

('P','Postal'),

('B','Both');

/*------------------------2. ADDRESS TABLE--------------------------------*/

insert into ADDRESS(Address_St, Address_City, Address_State, Address_Postcode, Add_TypeID) VALUES

('152 Temple St','Redbank','VIC','3350','R'),

('153 Temple St','Redbank','NSW','2001','P'),

('154 Temple St','Redbank','NSW','2001','B'),

('155 Temple St','Redbank','QLD','4132','R'),

('156 Temple St','Redbank','QLD','4132','P');

/*--------------------3. CUSTOMER TABLE--------------------------------*/

INSERT INTO CUSTOMER(Cust_FName, Cust_LName, Cust_Phone, Address_ID) VALUES

('mikaya','Caan','1236567456',5),

('Mohammad','Awrangjeb','5676567876',1),

('John,','Smith','5676565676',2),

('Robin','Caan','5676561234',3),

('Mika','Smith','9876567876',4),

('Veena','Caan','1236567876',5);

/*-----------------------4. JOBTYPE TABLE--------------------------------*/

insert into JOBTYPE(JobType_Name) VALUES

('Accountant'),

('CA'),

('Manger'),

('Admin'),

('Programmer');

/*-----------------------5. DEPARTMENT TABLE--------------------------------*/

insert into DEPARTMENT(Dept_Name) VALUES

('Sales'),

('Training'),

('Payroll'),

('Customer Service'),

('Billing');

/*---------------------6. STORE TABLE--------------------------------*/

insert into STORE (Str_Name, Str_Phone, Str_Fax,Str_Email, SupStore_Num,Address_ID) Values

('BigM Underwood','0989098781','1565456765','[email protected]',1,1),

('BigM1 Underwood','0989098782','2565456765','[email protected]',2,2),

('BigM2 Underwood','0989098783','3565456765','[email protected]',3,3),

('BigM3 Underwood','0989098784','4565456765','[email protected]',4,4),

('BigM4 Underwood','0989098785','5565456765','[email protected]',5,5);

/*--------------------7. STOREDEPARTMENT TABLE--------------------------------*/

insert into STOREDEPARTMENT(StrDept_Phone, StrDept_Email, Str_Num, Dept_ID) VALUES

('9861686178','[email protected]',1,1),

('9862686278','[email protected]',2,2),

('9863686378','[email protected]',3,3),

('9864686478','[email protected]',4,4),

('9865686578','[email protected]',5,5);

/*--------------------8. EMPLOYEE TABLE--------------------------------*/

INSERT INTO EMPLOYEE(Emp_FName,Emp_LName, Emp_Phone, Emp_DoB, Emp_StartDate, Emp_TaxFNum, Emp_HourlySalary,StrDept_ID, SupvisorID, Address_ID_Postal, Address_ID_Resident, Emp_JobTypeID) VALUES

('Gaani','Caan','0987656781','1994-01-01','2016-01-01','098789878912',23.09,1,1,1,1,1),

('Yanni','Raan','0987656782','1994-02-01','2016-02-01','098789878913',23.09,2,2,2,2,2),

('Cabin','Raan','0987656783','1994-03-01','2016-03-01','098789878914',23.09,3,3,3,3,3),

('Roon','Caan','0987656784','1994-04-01','2016-04-01','098789878915',23.09,4,4,4,4,4),

('John','Raan','0987656785','1994-05-01','2016-05-01','098789878916',23.09,5,5,5,5,5);

/*------------------UPDATE STORE TABLE AND STOREDEPARTMENT --------------------------------*/

update STORE set StoreManagerID=(1) where Str_Num=(1);

update STORE set StoreManagerID=(2) where Str_Num=(2);

update STORE set StoreManagerID=(3) where Str_Num=(3);

update STORE set StoreManagerID=(4) where Str_Num=(4);

update STORE set StoreManagerID=(5) where Str_Num=(5);

/*------------------UPDATE STOREDEPARTMENT TABLE--------------------------------*/

UPDATE STOREDEPARTMENT SET DeptSupervisorID =(1) WHERE StrDept_ID=(1);

UPDATE STOREDEPARTMENT SET DeptSupervisorID =(2) WHERE StrDept_ID=(2);

UPDATE STOREDEPARTMENT SET DeptSupervisorID =(3) WHERE StrDept_ID=(3);

UPDATE STOREDEPARTMENT SET DeptSupervisorID =(4) WHERE StrDept_ID=(4);

UPDATE STOREDEPARTMENT SET DeptSupervisorID =(5) WHERE StrDept_ID=(5);

/*---------------------9. BRAND TABLE--------------------------------*/

INSERT INTO BRAND(Brand_Name) VALUES

('Century'),

('Armani'),

('lakme'),

('abc'),

('xyz');

/*------------------10.PAYSLIP TABLE--------------------------------*/

INSERT INTO PAYSLIP(Pay_date,Pay_num_of_hours,Pay_amount_gross, Emp_ID, Str_Num) VALUES

('2017-01-01',2.4,34.09,1,1),

('2017-02-01',3.4,44.09,2,2),

('2017-03-01',4.4,54.09,3,3),

('2017-04-01',5.4,64.09,4,4),

('2017-05-01',6.4,74.09,5,5);

/*----------------11. PRODUCT TABLE--------------------------------*/

INSERT INTO PRODUCT(Prod_Desc,Prod_Size,Prod_Price,Prod_BrandID) VALUES

('Pant for man','Large',67.09,1),

('Pant for man','XL',17.09,2),

('skirt for girl','Large',27.09,3),

('skirt for girl','Medium',37.09,4),

('Pant for man,','Medium',47.09,5);

/*-----------------12. INVENTORY TABLE--------------------------------*/

insert into INVENTORY VALUES

(1,2,500,5),

(1,1,100,5),

(2,2,200,10),

(3,3,300,15),

(4,4,400,20),

(5,5,500,25);

/*--------------13. CUSTOMERORDER TABLE--------------------------------*/

INSERT INTO CUSTOMERORDER(CustOrd_Date, Cust_Number,Str_Num) VALUES

('2018-01-01',1,1),

('2018-02-01',2,2),

('2018-03-01',3,3),

('2018-04-01',4,4),

('2018-05-01',5,5);

/*------------------14. ORDERLINE TABLE--------------------------------*/

INSERT INTO ORDERLINE VALUES

(1,2,'2018-02-01','2018-05-20',8),

(1,3,'2018-02-01','2018-05-20',8),

(1,1,'2018-02-01','2018-02-02',8),

(2,2,'2018-03-02','2018-03-04',8),

(3,3,'2018-04-03','2018-04-05',8),

(4,4,'2018-05-04','2018-05-06',8),

(5,5,'2018-06-05','2018-06-07',8);

Task 3: -

/*I. List of names and complete postal address of all employees sorted by their salary.*/

Select concat(Employee.Emp_FName,' ' ,Employee.Emp_LName) as 'Employee Name',

Concat(Address.Address_ST,' ', Address.Address_City,' ',

Address.Address_State,' ', Address.Address_Postcode) as 'Postal Address',

concat('$',Employee.Emp_HourlySalary) as 'Salary'

from Employee, Address

where Employee.Address_ID_Postal=Address.Address_ID

order by Employee.Emp_HourlySalary;

+---------------+--------------------------------+--------+

| Employee Name | Postal Address                 | Salary |

+---------------+--------------------------------+--------+

| Gaani Caan    | 152 Temple St Redbank VIC 3350 | $26.68 |

| Yanni Raan    | 153 Temple St Redbank NSW 2001 | $26.68 |

| Cabin Raan    | 154 Temple St Redbank NSW 2001 | $26.68 |

| Roon Caan     | 155 Temple St Redbank QLD 4132 | $26.68 |

| John Raan     | 156 Temple St Redbank QLD 4132 | $26.68 |

+---------------+--------------------------------+--------+

II. The date on which the most recent customer order has been made. The customer name and date of the order will be sufficient.*/

select concat(Customer.Cust_FName,' ', Customer.Cust_LName) as 'Customer Name',

Customerorder.CustOrd_Date as 'Order Date'

from customer, customerorder

where Customer.Cust_Number=CustomerOrder.Cust_Number

Order By CustOrd_Date DESC

LIMIT 1;

+---------------+------------+

| Customer Name | Order Date |

+---------------+------------+

| Veena Caan    | 2018-05-01 |

+---------------+------------+

III. List of all the store names and their addresses, sorted in dictionary order of the store name.*/

CUSTOMER table

SELECT Store.Str_Name as 'Store Name',

Concat(Address.Address_ST,' ', Address.Address_City,' ',

Address.Address_State,' ', Address.Address_Postcode) as 'Address'

from store, address

where store.Address_ID= Address.Address_ID

Order By Store.Str_Name;

+-----------------+--------------------------------+

| Store Name      | Address                        |

+-----------------+--------------------------------+

| BigM Underwood  | 152 Temple St Redbank VIC 3350 |

| BigM1 Underwood | 153 Temple St Redbank NSW 2001 |

| BigM2 Underwood | 154 Temple St Redbank NSW 2001 |

| BigM3 Underwood | 155 Temple St Redbank QLD 4132 |

| BigM4 Underwood | 156 Temple St Redbank QLD 4132 |

+-----------------+--------------------------------+

IV. A list of all customers that have not placed an order yet. Displaying customer number and name will be sufficient.*/

select Customer.Cust_Number as 'Customer Number',

Concat(Customer.Cust_FName,' ', Customer.Cust_LName) as 'Name'

from Customer where Customer.Cust_Number not in (select Cust_Number from Customerorder);

+-----------------+-------------+

| Customer Number | Name        |

+-----------------+-------------+

|               6 | mikaya Caan |

+-----------------+-------------+

V. A list containing the name of employees, which work as accountant.*/

SELECT concat(Employee.Emp_FName,' ', Employee.Emp_LName) as 'Employee Name',

JobType.jobtype_Name as 'Work'

from Employee, JobType

where Employee.Emp_JobTypeID=JobType.JobType_ID

and JobType.jobtype_Name='Accountant';

+---------------+------------+

| Employee Name | Work       |

+---------------+------------+

| Gaani Caan    | Accountant |

+---------------+------------+

VI. A list containing the total quantity on hand for each product (product number and description) regardless of stores.*/

select Product.Prod_Num as 'Product Number',

Product.Prod_Desc as 'Description' ,

concat('$',Cast((Sum(Inventory.Inv_Qntyonhand))As char)) as 'Total Quantity on hand'

from Product, inventory

where Product.Prod_Num=Inventory.ProductNum

group by Product.Prod_Num, Product.Prod_Desc;

+----------------+----------------+------------------------+

| Product Number | Description    | Total Quantity on hand |

+----------------+----------------+------------------------+

|              1 | Pant for man   | $600                   |

|              2 | Pant for man   | $200                   |

|              3 | skirt for girl | $300                   |

|              4 | skirt for girl | $400                   |

|              5 | Pant for man,  | $500                   |

+----------------+----------------+------------------------+

VII. A list showing each product sold (picked) on or before May 20, 2018. Show product number, name and quantity sold, sorted by product number and then quantity sold.*/

select Product.Prod_Num as 'Product Number',

Product.Prod_Desc as 'Description' ,

concat('$',Cast((Sum(Inventory.Inv_Qntyonhand))As char))as 'Total Quantity on hand'

from Product, inventory, orderline

where Product.Prod_Num=Inventory.ProductNum

and orderline.Prod_Num=Product.Prod_Num

and Orderline.OrdLn_DatePicked='2018-05-20'

group by Product.Prod_Num, Product.Prod_Desc

order by Product.Prod_Num, Inventory.Inv_Qntyonhand ;

+----------------+----------------+------------------------+

| Product Number | Description    | Total Quantity on hand |

+----------------+----------------+------------------------+

|              2 | Pant for man   | $200                   |

|              3 | skirt for girl | $300                   |

+----------------+----------------+------------------------+

III. A list of products (show product number, description and price) whose price is less than or equal to the average product price.*/

select Prod_Num as 'Product number', Prod_Desc as 'Product Description',

concat('$',Prod_Price) As 'Price'

from Product

where Prod_Price<=(select avg(Prod_Price) from product);

+----------------+---------------------+--------+

| Product number | Product Description | Price  |

+----------------+---------------------+--------+

|              2 | Pant for man        | $17.09 |

|              3 | skirt for girl      | $27.09 |

|              4 | skirt for girl      | $37.09 |

+----------------+---------------------+--------+

IX. Increase each employee’s salary by 7.5% and show the updated salary of all employees (name and salary)*/

update employee set Emp_HourlySalary=Emp_HourlySalary+Emp_HourlySalary*0.075;

select Concat(Employee.Emp_FName,' ', Employee.Emp_LName) as 'Employee Name',

concat('$',Employee.Emp_HourlySalary) as 'Salary'

from Employee;

+---------------+--------+

| Employee Name | Salary |

+---------------+--------+

| Gaani Caan    | $28.68 |

| Yanni Raan    | $28.68 |

| Cabin Raan    | $28.68 |

| Roon Caan     | $28.68 |

| John Raan     | $28.68 |

+---------------+--------+

X. Show the pay information (employee name, hours paid, amount paid) of all employees in the most recent pay date.*/

select Concat(Employee.Emp_FName,' ', Employee.Emp_LName) as 'Employee Name',

concat('$',Employee.Emp_HourlySalary) as 'Hours Paid',

concat('$',Payslip.Pay_Amount_Gross) as 'Amount Paid'

from Employee, Payslip

where Employee.Emp_ID=Payslip.Emp_ID

order by Payslip.Pay_date DESC

LIMIT 1;

+---------------+------------+-------------+

| Employee Name | Hours Paid | Amount Paid |

+---------------+------------+-------------+

| John Raan     | $28.68     | $74.09      |

+---------------+------------+-------------+

XI. Make a list of all products of brand “Armani” and their price in ascending order of price. Show the product description and price.*/

select Product.Prod_Desc as ' Product Description',

concat('$',Product.Prod_Price) as 'Price'

from Product

where Prod_BrandID=( select Brand_ID from brand

 where Brand.Brand_Name='Armani')

order by Product.Prod_Price;

+---------------------+--------+

| Product Description | Price  |

+---------------------+--------+

| Pant for man        | $17.09 |

+---------------------+--------+

II. A list of supervisors (employee id, name) and all of their subordinates (employee id, name).*/

SELECT S.SupvisorID as 'Supvisor ID',

Concat(S.Emp_FName,' ',S.Emp_LName) as 'Supvisor Name',

SO.Emp_ID as 'subordinate ID',

Concat(SO.Emp_FName,' ',SO.Emp_LName) as 'subordinate Name'

FROM EMPLOYEE S, EMPLOYEE SO

WHERE SO.Emp_ID= S.SupvisorID;

+-------------+---------------+----------------+------------------+

| Supvisor ID | Supvisor Name | subordinate ID | subordinate Name |

+-------------+---------------+----------------+------------------+

|           1 | Gaani Caan    |              1 | Gaani Caan       |

|           2 | Yanni Raan    |              2 | Yanni Raan       |

|           3 | Cabin Raan    |              3 | Cabin Raan       |

|           4 | Roon Caan     |              4 | Roon Caan        |

|           5 | John Raan     |              5 | John Raan        |

+-------------+---------------+----------------+------------------+

Task 4: -

/*A customer named Daniel Ortega, from 11 Fuller Road, Marsden QLD

4132 and having a mobile number 0431xxx668, orders two shirts of size

“XL” of brand “Prada” on 6 Sep 2018. The full order is ready on 8 Sep

2018 for pickup, but the customer picks up on 10 Sep 2018*/

insert into ADDRESS(Address_St, Address_City, Address_State, Address_Postcode, Add_TypeID) VALUES

('11 Fuller Road', 'Marsden', 'QLD','4132','R');

INSERT INTO CUSTOMER(Cust_FName, Cust_LName, Cust_Phone, Address_ID) VALUES

('Daniel', 'Ortega', '0431xxx668',6);

INSERT INTO BRAND(Brand_Name) VALUES

('Prada');

INSERT INTO PRODUCT(Prod_Desc,Prod_Size,Prod_Price,Prod_BrandID) VALUES

('shirts','XL',78.09,6);

INSERT INTO CUSTOMERORDER(CustOrd_Date, Cust_Number,Str_Num) VALUES

('2018-09-06',7,1);

INSERT INTO ORDERLINE VALUES

(7,6,'2018-09-08','2018-09-10',2);

Awad, E., & Gotterer, M. (1992). Database management. Danvers, Mass.: Boyd & Fraser Pub. Co.

Cram, C. (2012). Microsoft Word 2010. Australia: Course Technology/Cengage Learning.

Date, C., & White, C. (1993). A guide to DB2. Reading: Addison-Wesley.

DuBois, P. (2013). MySQL. Upper Saddle River, NJ: Addison-Wesley.

DuBois, P., & Go?mez Pastor, J. (2005). MySQL. Madrid: Anaya Multimedia.

Duffy, J. (2011). Microsoft Word 2010. Boston, MA: Course Technology.

Eliot, G. (2016). The mill on the Floss. New York: Open Road Integrated Media.

Huddleston, T., & Miller, M. (2011). Using Microsoft Word 2010. Indianapolis, Ind.: Que.

Johnson, S., & Johnson, S. (2011). Brilliant Microsoft Word 2010. Harlow: Prentice Hall.

Kofler, M., & Kramer, D. (2001). MySQL. Berkeley: Apress.

Obermair, W. (1995). Extending the object-oriented database management system VODAK with active capabilities. Sankt Augustin: GMD.

Pachev, S. (2012). MySQL. Helion.

PATHAK, N. (2011). DATABASE MANAGEMENT SYSTEM. [S.l.]: HIMALAYA PUBLISHING HOUSE.

Ramarkrishnan, R. (1997). Database management system. London: McGraw-Hill Pub. Co. (ISE Editions).

Rigollet, P. (2010). Microsoft Word 2010. St Herblain: E?ditions ENI.

Rutkosky, N., & Roggenkamp, A. (2011). Microsoft Word 2010. St. Paul, MN: Paradigm Pub.

Schneller, D., & Schwedt, U. (2010). MySQL admin cookbook. Birmingham, U.K.: Packt Pub.

Schwartz, B., Zaitsev, P., & Tkachenko, V. (2012). High performance MySQL. Beijing: O'Reilly Media.

Silberschatz, A., Korth, H., & Sudarshan, S. (2009). Database system concepts. Boston: McGraw-Hill.

Tahaghoghi, S., & Williams, H. (2007). Learning MySQL. Sebastopol, Calif.: O'Reilly.

Ullman, L. (2006). MySQL. Berkeley, CA: Peachpit.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Sample Database Tables And Data Created With SQL Essay. (70 Characters). Retrieved from https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html.

"Sample Database Tables And Data Created With SQL Essay. (70 Characters)." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html.

My Assignment Help (2021) Sample Database Tables And Data Created With SQL Essay. (70 Characters) [Online]. Available from: https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html
[Accessed 21 June 2024].

My Assignment Help. 'Sample Database Tables And Data Created With SQL Essay. (70 Characters)' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html> accessed 21 June 2024.

My Assignment Help. Sample Database Tables And Data Created With SQL Essay. (70 Characters) [Internet]. My Assignment Help. 2021 [cited 21 June 2024]. Available from: https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close