Sql Homework – 7 questions

All guidelines are attached – please check the screen shot

Let me know if you have any questions

Week 6-SOL Exercises
Week 6-SOL Exercises
Student Name:
loo
CO
3. Create a query to select all data from the tblcustomer data. Provide the SQL
statement below:
tblSuppliers
Ingsupplier ID
str Supplier Name
str Supplier Address Street
str Supplier Address City
str SupplierAddessCountry
str Supplier AddressPostcode
str SupplierPhoneNo
strSupplierFaxNo
strPayment Terms
tblLink_Order Product
IngOrderId
IngProductId
intProductQuantity
curTotalProductSaleCost
dteArranged DeliveryDate
tmeArranged Delivery Time
chkProductDelivered
dteActualDeliveryDate
tmeActualDelivery Time
1811
tblProducts
IngProductID
strProductName
chkInStock
IngUnitsInStock
cur ProductUnitPurchase Price
cur ProductUnitSale Price
IngSupplierId
tblOrders
IngOrderID
IngCustomerid
dteDateOrderplaced
tmeTimeOrder Placed
IngOrder TotalProductNo
chkorder Completed
dteDateOrderCompleted
memAnyAdditionalInfo
4. Create a basic query that will extract the following information from the
tblProduct table: ingproductid. stiproductname, chkinstask. Ingunitsinstask.
ingshippingid. Provide the SQL statement below:
tblCustomers
ing Customer ID
strCustomer FirstName
strCustomerLastName
strCustomer Address
Street
strCustomer AddressCity
strCustomerAddessCounty
strCustomer AddressPostcode
strCustomer ContactPhoneNo
5. You need to find all customer orders placed between January 2011 and June 2011.
Provide the SQL statement below:
http://www.databasedev.co.uk/customer_orders_data_model.html
Use the data model shown above and create the following SQL statements:
SQL Exercises
1. Create a new table that will be used to track the tblCustomer address and contact
information. The attributes associated with the table: customer_id, address_type
street address, city, state, zipcode, phone number, customer name and e-mail
address. Create a new table the attributes listed above. The primary key is
customer_id, and address_type. It has a relationship with the customer table.
Provide SQL statement below.
6. Create a new query to display all orders. Show the ingOrderid. ing Customerid.
strcustomerfirstname sticustomerlastname and dtdateorderplaced Group data by
IngOrderid. Provide the SQL statement below:
7. Delete all orders placed before January 2001. Provide the SQL statement below.
2. Create new table it will be used to identify the Sales associate gets the credit for
the customer order. This attributes associated with table: Salesassoc id sales
assos. name, and sales location. The primary key is salesassoc_id. The table has a
relationship with the order table Provide SQL statement below.
1 Page
2 Page