Design a mailing list database

Assignment Help Computer Engineering

Reference no: EM133423575

Oracle SQL

Mailing List Case

You are asked to design a mailing list database. Your boss said, "All we need is just keep listing our 10 million+ clients' names and addresses. We use it to create mailing labels. Give me the SQL script file after lunch." "Sure, that's so easy. I'll be back in 10 minutes with the script file," you replied. Write it quickly, please.

PizzaDotCom Case

We start with the script we came up with in the last session. First, download the script (PizzaDotCom Script Session 7). Then, go through the below steps by using the downloaded script.
1) Draw a physical schema.
2) Modify the current designs so that we have Customers-<>-Pizza_Orders-<>-LineItem-<>-Pizzas.
- Clear the existing order.
- Remove the foreign key constraint in Pizza_Orders.
- Remove the column, Pizza.
- do a new table, LineItems.
? What should be its columns?
-Set up the table relationships among Pizza_Orders-<>-LineItem-<>-Pizzas3) Add OrderDate to the table, PIZZA_ORDERS.
4) Enter a sample record to PIZZA_ORDERS.
o 1001, 'John Smith', 31-NOV-22
5) Enter the data to LineItems.
-John orders two Small Cheese and one Large Pepperoni.
- Jan orders three Large Cheese and four Small Pepperoni.
6) Check all the tables and their contents.
7) do a "clean" script file that creates the four tables from scratch and enters data. - Use auto-generated numbers for OrderNumbers.

Reference no: EM133423575

Questions Cloud

Predisposing factors for development of diverticulitis : Identify the common predisposing factors for the development of diverticulitis. Identify common clinical manifestations of a patient with diverticulitis.

What the author means by long-term implications : Summarize what the author means by "long-term implications" and "short-term effects" of gene duplication. What is a paralagous gene? What is the goal

Explain the idea of bag-of-words model : Explain the idea of bag-of-words model. What are the two methods to treat the meaningless frequently occurring words

Significant or sentinel moments of development : One piece of evidence based on significant or sentinel moments of development while nursing a aspirations pneumonia patient in medical ward.

Design a mailing list database : design a mailing list database. Your boss said, "All we need is just keep listing our 10 million+ clients' names and addresses. We use it to create mailing

Determine the effectiveness of your change : In order to evaluate an evidence-based practice project, it is important to be able to determine the effectiveness of your change.

What is the clinical significance of this to the patient : Calculate the INR for the following data set. Answer to the nearest tenth of a decimal point. Show all your work & circle your final answer.

How many different genotypes could be produced from : how many different genotypes could be produced from a single mating event? 291 How swer to 20 explain diversity we see in humans, even between siblings?

Draw a project-level er diagram for situation : CS 600 Open University Malaysia track of each time a customer uses a parking spot, including the number of the license plate, start and end parking times

User Account

All Pages