Question: Is this correct. Do i need a primary key for the Items Table? using SQL server create table Customer ( CustomerId int not null, FirstName

Is this correct. Do i need a primary key for the Items Table? using SQL server

create table Customer ( CustomerId int not null, FirstName varchar(25) null, LastName varchar(25) null, City varchar(25) null, States varchar(25) null, constraint Customer-pk1 primary key (CustomerID) );

create table Items ( CustomerId int not null, OrderDate date null, Item varchar(25) null, Quanity int null, Price money null,

constraint Items-fk1 foreign key (CustomerID) references Customer (CustomerId) );

Is this correct. Do i need a primary key for the Items

Customers table customerid firstname lastname 10101 10298 10339 10410 city state John Leroy Anthony Sanchez Winslow Mary Ann Howel Gray Lynden Pinetop Washington Arizona Arizona South Brown Charleston Carolina North Carolina Colorado Arizona 10429 Sarah Kevin Isabela Moore Graham reensboro 10438 Smith Durango Yuma 10449 items ordered table customerid order date 10101 10339 10449 10449 10438 10449 10101 10438 10449 10101 10298 itemquantity price 30-Jun-1999 Raft 27-Jul-1999 Umbrella 14-Aug-1999 Ski Poles 18-Dec-1999 Tent 02-Dec-1999 Pillow 22-Dec-1999 Canoe 02-Jan-2000 Lantern 18-Jan-2000 Tent 29-Feb-2000 Flashlight 1 08-Mar-2000 Sleeping Bag 2 01-Apr-2000 Ear Muffs 1 1 1 2 1 1 1 1 1 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50 Customers table customerid firstname lastname 10101 10298 10339 10410 city state John Leroy Anthony Sanchez Winslow Mary Ann Howel Gray Lynden Pinetop Washington Arizona Arizona South Brown Charleston Carolina North Carolina Colorado Arizona 10429 Sarah Kevin Isabela Moore Graham reensboro 10438 Smith Durango Yuma 10449 items ordered table customerid order date 10101 10339 10449 10449 10438 10449 10101 10438 10449 10101 10298 itemquantity price 30-Jun-1999 Raft 27-Jul-1999 Umbrella 14-Aug-1999 Ski Poles 18-Dec-1999 Tent 02-Dec-1999 Pillow 22-Dec-1999 Canoe 02-Jan-2000 Lantern 18-Jan-2000 Tent 29-Feb-2000 Flashlight 1 08-Mar-2000 Sleeping Bag 2 01-Apr-2000 Ear Muffs 1 1 1 2 1 1 1 1 1 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50

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!

Am trying to insert data into a column but the 2 methods I've tried haven't worked. Here are the tables: Create Table Customer ( Customer_id int NOT NULL AUTO_INCREMENT, FirstName VARCHAR(50),...

HI there, so the project is complete. But could you please provide diagrams for this project, also include screenshots. Project Title: E - Commerce Database for Online Retail Store Project Overview:...

>>> Hello! I have the following sql code to create a new procedure called InsertCustomerWithTransaction. DELIMITER // CREATE PROCEDURE InsertCustomerWithTransaction (IN newCustomerLastName Char(25),...

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

This question is from The Queen Anne Curiosity Case questions from Database Processing: Fundamentals, Design, and Implementation, 16th edition textbook. We have executed the following SQL CREATE...

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

if db_id('TestPremierProducts') is not null begin use master alter database TestPremierProducts set SINGLE_USER with rollback immediate drop database TestPremierProducts end create database...

USE GYM; CREATE TABLE Customer ( CustomerID INT PRIMARY KEY NOT NULL, Phone_number VARCHAR(10) UNIQUE NOT NULL, FirstName VARCHAR(225) NOT NULL, LastName VARCHAR(255) NOT NULL, Sex VARCHAR(10) NOT...

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...

Your firm needs to raise $100 million in funds. You can borrow short term at a spread of 1% over LIBOR. Alternatively, you can issue 10-year, fixed-rate bonds at a spread of 2.50% over 10-year...

Shown below are comparative balance sheets for Sheffield Company. Assets Cash Accounts receivable Inventory Land Sheffield Company Comparative Balance Sheets December 31 Equipment Accumulated...

2 . Define what a cost schedule is in financial modeling and explain how a depreciation schedule is created using the straight - line method

Table 5: Mass of liquid delivered by buret Table view List View Table 5. Mass of liquid delivered by buret Trial 1 Trial 2 Trial 3 Mass of clean, dry Erlenmeyer flask (9) 34.39 34 44 34:45 2.24 2.22...

How do Dimensional Database Models differ from Relational Models?

What type of processing do Relational Databases support?

Describe several aggregation operators.