Question: CUSTOMER_01 (EmailAddress, LastName, FirstName) Write and run an SQL CREATE TABLE statement to create the CUSTOMER_01 table. EmailAddress is a text column containing an email

CUSTOMER_01 (EmailAddress, LastName, FirstName)

Write and run an SQL CREATE TABLE statement to create the CUSTOMER_01 table.

EmailAddress is a text column containing an email address, and is therefore not a surrogate key. CustomerID is a surrogate key that starts at 1 and increments by 1. SaleID is a surrogate key that starts at 20150001 and increases by 1.

The CH07_RQ_TABLES database has the following referential integrity constraints:

EmailAddress in SALE_01 must exist in EmailAddress in CUSTOMER_01

CustomerID in SALE_02 must exist in CustomerID in CUSTOMER_04

The relationship from SALE_01 to CUSTOMER_01 is N:1, O-M.

The relationship from SALE_02 to CUSTOMER_04 is N:1, O-M.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write and run an SQL CREATE TABLE statement to create the SALE_01 table. Note that the foreign key is EmailAddress, which references CUSTOMER_01. EmailAddress. In this database, CUSTOMER_01 and...

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

A. Write SQL CREATE TABLE statements for each of these tables. Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading deletions and...

Objectives: Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. Alter the definition of an existing table using the Alter Table statement. Create...

Web Applications with Databases (20 pts) Background: You will create .php web pages that query information from the Heather Sweeny Designs (HSD) database. Instructions: Download the attached zip file...

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

--************************************************************************************************************************ --*...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Define critical angle. Explain total internal reflection using a neat diagram.

2010 Wall Street Reform and Consumer Protection Act and post your comments relative to its impact on financial intermediaries and consumers. Please indicate some of the positive and negative outcomes...

ABC Ltd paid R 1 0 0 0 0 in wages and salaries for the month. How will this transaction be recorded in the accounting equation?

1 2 8 .

What are the Variable columns settings available in the Mining Models Tab?

What does the Mining Content Viewer in Visual Studio show in terms of Probabilities?

How are continuous variables normally handled in Decision Tree Algorithms?