Question? Call Us  +1 (817) 546-4770

1804ICT Data Management

Academic Anxiety?

Get an original paper within hours and nail the task

156 experts online

Free Samples

1804ICT Data Management

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

1804ICT Data Management

0 Download13 Pages / 3,185 Words

Course Code: 1804ICT
University: Griffith University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Question:
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. 
Answer:

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—————————–
—————————————————————————*/
 
/*———————–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′,’bigm.redbank@bigm.com.au’,1,1),
(‘BigM1 Underwood’,’0989098782′,’2565456765′,’bigm1.redbank@bigm.com.au’,2,2),
(‘BigM2 Underwood’,’0989098783′,’3565456765′,’bigm2.redbank@bigm.com.au’,3,3),
(‘BigM3 Underwood’,’0989098784′,’4565456765′,’bigm3.redbank@bigm.com.au’,4,4),
(‘BigM4 Underwood’,’0989098785′,’5565456765′,’bigm4.redbank@bigm.com.au’,5,5);
/*——————–7. STOREDEPARTMENT TABLE——————————–*/
insert into STOREDEPARTMENT(StrDept_Phone, StrDept_Email, Str_Num, Dept_ID) VALUES
(‘9861686178′,’Store1Depatment1@bigm.com.au’,1,1),
(‘9862686278′,’Store2Depatment1@bigm.com.au’,2,2),
(‘9863686378′,’Store3Depatment1@bigm.com.au’,3,3),
(‘9864686478′,’Store4Depatment1@bigm.com.au’,4,4),
(‘9865686578′,’Store5Depatment1@bigm.com.au’,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.*/
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); Bibliography 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. Free Membership to World's Largest Sample Bank To View this & another 50000+ free samples. Please put your valid email id. E-mail Yes, alert me for offers and important updates Submit  Download Sample Now Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days. UploadUnique Document DocumentUnder Evaluation Get Moneyinto Your Wallet Total 13 pages PAY 8 USD TO DOWNLOAD *The content must not be available online or in our existing Database to qualify as unique. Cite This Work To export a reference to this article please select a referencing stye below: APA MLA Harvard OSCOLA Vancouver My Assignment Help. (2021). Data Management. Retrieved from https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html. "Data Management." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html. My Assignment Help (2021) Data Management [Online]. Available from: https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html[Accessed 18 December 2021]. My Assignment Help. 'Data Management' (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Data Management [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/1804ict-data-management/will-contain.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

MyAssignmenthelp.com is one of the noted service providers that deliver essay help. We provide tailored essay assistance to make sure that student gets online essay help exactly in the way they want it to be written. We at MyAssigemnthelp.com have built teams of consultants, who readily attend every query related to help me writing my essay. We provide essay writing help in forms of tips and steps in order o assist students with tough essay assignments.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Need an essay written specifically to meet your requirements?

Choose skilled experts on your subject and get an original paper within your deadline

156 experts online

Your time is important. Let us write you an essay from scratch

Tips and Tricks from our Blog

PROJ6016 Employer Based Project

Free Samples PROJ6016 Employer Based Project .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} PROJ6016 Employer

Read More »

PPMP20009 Marking Rubric

Free Samples PPMP20009 Marking Rubric .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} PPMP20009 Marking Rubric

Read More »