Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

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 assoc_name, and sales location. The primary key is salesassoc_id. The table has a relationship with the order table Provide SQL statement below.

3. Create a query to select all data from the tblcustomer data. Provide the SQL statement below:

4. Create a basic query that will extract the following information from the tblProduct table: ingproductid, strproductname, chkinstock, Ingunitsinstock, ingshippingid. Provide the SQL statement below:

5. You need to find all customer orders placed between January 2011 and June 2011. Provide the SQL statement below:

6. Create a new query to display all orders. Show the ingOrderid, ingCustomerid, strcustomerfirstname, strcustomerlastname and dtdateorderplaced, . Group data by IngOrderid. Provide the SQL statement below:

7. Delete all orders placed before January 2001. Provide the SQL statement below.

tblSuppliers IngSupplier ID strSupplierName strSupplier Address Street strSupplier AddressCity strSupplierAddessCountry strSupplier AddressPostCode strSupplierPhoneNo strSupplierFax No strPayment Terms tblProducts IngProductID strProductName chkinStock IngUnitsInStock curProductUnitPurchasePrice curProductUnitSale Price IngSupplierId 18 tblLink OrderProduct IngOrderId IngProductid intProductQuantity cur TotalProductSaleCost dteArrangedDeliveryDate tmeArrangedDelivery Time chkProduct Delivered dteActualDeliveryDate tmeActualDelivery Time tblCustomers IngCustomer ID strCustomerFirstName strCustomerLastName strCustomer AddressStreet strCustomer AddressCity strCustomerAddessCounty strCustomer AddressPostCode strCustomer ContactPhoneNo -J8L tblOrders IngOrder ID IngCustomer Id dteDateOrderPlaced tmeTimeOrderPlaced IngOrder TotalProduct No chkOrderCompleted dteDateOrder Completed memAnyAdditionalInfo http://www.databasedev.co.uk/customer_orders_data_model.html Use the data model shown above and create the following SQL statements:

Step by Step Solution

3.43 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

1 Create a new table that will be used to track the tblCustomer address and contact information The attributes associated with the table customerid ad... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
60997b3a6cfbe_29723.pdf

180 KBs PDF File

Word file Icon
60997b3a6cfbe_29723.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Charles I. Jones

3rd edition

978-0393123944, 393123944, 393923908, 978-0393923902

More Books

Students also viewed these Databases questions

Question

Describe how childhood experiences affect self-esteem.

Answered: 1 week ago

Question

What is the definition of the unemployment rate?

Answered: 1 week ago