Question: create table Orders ( Order _ id int primary key not null, Customer _ id int Foreign key References Customer ( Customer _ id )

create table Orders(
Order_id int primary key not null,
Customer_id int Foreign key References Customer(Customer_id),
EmployeeID int Foreign key References Employee(EmployeeID),
ShipName VARCHAR(255),
ShipAddress VARCHAR(255),
ShipCity VARCHAR(50),
ShipRegion VARCHAR(50),
ShipPostalCode VARCHAR(15),
ShipCountry VARCHAR(50),
ShipVia INT,
OrderDate DATE,
RequiredDate DATE,
ShippedDate DATE,
Freight DECIMAL(10,2))i need a correction please

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!

Q:

Create a database. You may name it Broadcast. Use the following DDL queries to create tables on your new database. Create one at a time, ensuring it is successfully added to the database. Hint, if...

Q:

Modify Table Lab Create the following tables in SQL Server (code is supplied CREATE TABLE Customer (cust id INT PRIMARY KEY company_name VARCHAR (30), company age INT c address VARCHAR (30). c_city...

Q:

In SQL I am trying to Create an inline table function. I will give you my script first then the instructions. CREATE DATABASE Computer_Inventory_System CREATE TABLE Brands ( BrandKey int...

Q:

2) In SQL I am trying to Create a view. I will give you my script first then the instructions. CREATE DATABASE Computer_Inventory_System CREATE TABLE Brands ( BrandKey int IDENTITY(1,1) PRIMARY KEY...

Q:

MY SQL QUERY REQUIRED Create a procedure SuburbBestCustomer() to list the best customer for each suburb. The best customer is the customer who spent the largest amount in the restaurant. The list...

Q:

for the visit table im getting this error please tell me whay im doing wrong 3 Request edit access ] =) Proj... File Edit View Tools Help Visit Column Name VisitID Patient ID DoctorID Dateof Visit...

Q:

PHP/MYSQL Question Assume you have ordersDB database stored in MySQL server that contains the following 2 tables as follows: Table 1: Orders Table 2: OrderItems order ID int, Primary Key, Auto itemID...

Q:

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

Q:

In T-SQL Please. I would really appreciate it! Please fulfill the requirements stated below with the following database: /*use master; GO Alter database Project3 set single_user with rollback...

Q:

SQL-Assignment 4: The following questions are based on all tables of the SQL-Example 03. Please execute each of following query in MS SQL server management studio. Once you get the successful result,...

Q:

1. Let 3 215 B = 0 4 -1 1 A C- 304 Compute the following if defined: (a) 3A - B (b) 2B" +C (c) AB (d) AC

Q:

Comment on the difficulties associated with evaluating the financial position of an entity whose primary assets are intangible.

Q:

can you do the questions for me so i can understand and practice please

Q:

Management can be viewed as: Assembling the resources to achieve a mutually agreed upon objective Getting things done through other people Authoritative control over the affairs of others All of the...

Q:

(Appendices) ENDING INVENTORY, COST OF GOODS SOLD, AND GROSS MARGIN. Wilson Company sells a single product. At the beginning of the year, Wilson had 120 units in stock at a cost of $8 each. During...

Q:

(Appendices) SALES RETURNS. Swan and Bloom, Inc., is a wholesaler of novelty items to small stores. All sales are on credit with no discount offered. During March, Swan and Bloom accepted the...

Q:

(Appendices) INTERNAL CONTROL FOR SALES. Alcoa Building Products distributes aluminum siding and related building products to building contractors, all of whom purchase on credit. LO6 REQUIRED: List...