Class Project - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Class Project

Author

Topic

durbano
Starting Member

1 Post

Posted - 2011-05-19 : 23:39:00

I am trying to create a database for a lass project and not having much luck. Any help would be appreciate. I am having a bunch on syntax errors.

Here is what I have so far--

CREATE DATABASE Example

CREATE TABLE Product (
ProductID INT NOT NULL,
Price MONEY NOT NULL,
Author$Email VARCHAR(100) NOT NULL,
Type CHAR(15) NOT NULL,
FilePath VARCHAR(125) NOT NULL,
DocPath VARCHAR(125) NOT NULL,
RevDate DATETIME NULL,
VerNum VARCHAR(25) NULL,
Royalty MONEY NOT NULL,
CONSTRAINT Product_PK PRIMARY KEY (ProductID),
CONSTRAINT Author_FK FOREIGN KEY(Author$Email) REFERENCES Author(Email)
);

CREATE TABLE Author (

Email VARCHAR(100) NOT NULL,
Fname CHAR(20) NOT NULL,
Lname CHAR(20) NOT NULL,
Address CHAR(30) NOT NULL,
Phone CHAR(12) NOT NULL,
ZIP CHAR(5) NOT NULL,
City CHAR(20) NOT NULL,
State CHAR(2) NOT NULL,
CONSTRAINT AUTHOR_PK PRIMARY KEY(EMAIL)
);

CREATE TABLE Customer (
CustomerID INT NOT NULL,
Email VARCHAR(100) NOT NULL,
Fname CHAR(20) NOT NULL,
Lname CHAR(20) NOT NULL,
Address CHAR(30) NOT NULL,
Phone CHAR(12) NOT NULL,
ZIP CHAR(5) NOT NULL,
City CHAR(20) NOT NULL,
State CHAR(2) NOT NULL,
CONSTRAINT CUSTOMER_PK PRIMARY KEY(CustomerID)
);

CREATE TABLE Orders (
OrderID INT NOT NULL,
Total MONEY NOT NULL,
Customer$CustomerID INT NOT NULL,
PayMethod CHAR(6) NOT NULL,
OrderDate DATETIME NOT NULL,
CONSTRAINT Order_PK PRIMARY KEY(OrderID),
CONSTRAINT Order_FK FOREIGN KEY(Customer$CustomerID)
REFERENCES Customer(CustomerID)
);

CREATE TABLE LineItem (
Order$OrderID INT NOT NULL,
Product$ProductID INT NOT NULL,
CONSTRAINT LineItem_PK PRIMARY KEY(Order$OrderID, Product$ProductID),
CONSTRAINT LineItem_Order_FK FOREIGN KEY(Order$OrderID)
REFERENCES Orders(OrderID),
CONSTRAINT LineItem_Product_FK FOREIGN KEY(Product$ProductID)
REFERENCES Product(ProductID)
);

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-05-19 : 23:50:14

Don't try to live your life in one day

Execute the CREATE TABLE statement one by one. Look at the error message and fix it one by one.

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources