How many ship-to-addresses does each customer have

Assignment Help Database Management System

Reference no: EM131740328

Assignment

Directions: Write the answer to an exam question on this document immediately following the question. Do not provideSQL commands on this document. Submit SQL script files separately. Write the result of a queryafter the labelThe result is.

The instructor or TA will execute all the scripts submitted by each student to verify correctness and completeness ... all scripts must execute correctly without error for consideration for credit.

Question 1:

A data model of a shopping application allows a customer to have only one billing address and at least one ship-to-addresses.

a. Describe how you would implement the customer billing and shipping addresses as an Oracle relational database. Be sure to describe how the database uniquely identifies the billing addresses for each customer.

b. Describe how you would implement the customer billing and shipping addresses as an Oracle object-relational database. Be sure to identify the data type or structure that allows more for than one value for the billing address.

c. Describe how you would implement the customer billing and shipping addresses as an Oracle relational database that allows for hierarchical queries. Be sure to identify the data type or structure that allows more for than one value for the billing address.

d. Create an SQL script that contains

i. The DDL to create each database

ii. The DML to add data to each database

iii. SQL commands to query each database:

1. How many ship-to-addresses does each customer have?

2. How many customers have just one ship-to-address?

3. How many customers have a ship-to-address that is the same as the billing address?

iv. Documentation that describes the purpose and motivation behind the SQL command

· Submit a copy of the Oracle script as a separate file with the name Q1_Final.SQL to the assignment folder for the final exam.

Reference no: EM131740328

Questions Cloud

Discuss a cost-benefit and cost-effective analysis : Using the story about Robin Hood, discuss a cost-benefit and cost-effective analysis of the proposed assessment and contingency plan.

What concerns should you have regarding the conversations : You and a former classmate started a computer software company five years ago. Originally, the two of you were the owners and only employees.

What is your vision for your successful business : What is your vision for your successful business? What would you do go gain buy-in from your entire service team?

Revise prior probabilities in light of friends track record : What is the posterior probability of a good market given that his friend has provided an unfavourable market prediction

How many ship-to-addresses does each customer have : Create an SQL script that contains. How many ship-to-addresses does each customer have? How many customers have just one ship-to-address?

Requirements of the sarbanes-oxley act : You and two partners operate a graphics design and printing company. The success of this business relates to the high-quality service and products you provide.

Majority of organizations today recognize : The majority of organizations today recognize that their long-term survival depends on their ability to adapt to changes in their environment.

Assign employees more difficult work : A manager seems to assign employees more difficult work tasks based on a belief that these particular employees are trying to organize workers.

What is the holding of the trial court : Volvo Trucks North America, Inc., sells its heavy-duty trucks through franchised dealers who compete in a competitive bidding process typically with dealers.

User Account

All Pages