createstmt

sql

School

University of the Fraser Valley *

*We aren’t endorsed by this school

Course

Subject

Information Systems

Date

Oct 30, 2023

Type

sql

Pages

Uploaded by kakger18

CREATE TABLE countries( CountryID INTEGER NOT NULL, CountryName VARCHAR(50), CountryCode VARCHAR(2), PRIMARY KEY (CountryID) ); CREATE TABLE cities( CityID INTEGER NOT NULL, CityName VARCHAR(50), Zipcode INTEGER, CountryID INTEGER NOT NULL, PRIMARY KEY (CityID), FOREIGN KEY (CountryID) REFERENCES countries(CountryID) ); CREATE TABLE customers( CustomerID INTEGER NOT NULL, FirstName VARCHAR(50), MiddleInitial VARCHAR(4), LastName VARCHAR(50), CityID INTEGER NOT NULL, Address VARCHAR(255), PRIMARY KEY (CustomerID), FOREIGN KEY (CityID) REFERENCES cities(CityID) ); CREATE TABLE categories( CategoryID INTEGER NOT NULL, CategoryName VARCHAR(50), PRIMARY KEY (CategoryID) ); CREATE TABLE products( ProductID INTEGER NOT NULL, ProductName VARCHAR(255), Price INTEGER, "Temp" INTEGER, CategoryID INTEGER NOT NULL, "Class" VARCHAR(50), ModifyDate TIMESTAMP, Resistant VARCHAR(20), IsAllergic VARCHAR(10), VitalityDays VARCHAR(4), PRIMARY KEY (ProductID), FOREIGN KEY (CategoryID) REFERENCES categories(CategoryID) ); CREATE TABLE employes( EmployeeID INTEGER NOT NULL, FirstName VARCHAR(50), MiddleInitial VARCHAR(1), LastName VARCHAR(50), BirthDate TIMESTAMP, Gender VARCHAR(1), CityID INTEGER NOT NULL, HireDate TIMESTAMP, PRIMARY KEY (EmployeeID), FOREIGN KEY (CityID) REFERENCES cities(CityID)

); CREATE TABLE sales( SalesID INTEGER NOT NULL, SalesPersonID INTEGER NOT NULL, CustomerID INTEGER NOT NULL, ProductID INTEGER NOT NULL, Quantity INTEGER, Discount REAL, <<<<<<< HEAD TotalPrice INTEGER, "Temp" INTEGER, ======= TotalPrice REAL, >>>>>>> 548eb0662149b4117d4825401ade842accec3af1 SalesDate TIMESTAMP, TransactionNumber VARCHAR(20), PRIMARY KEY (SalesID), FOREIGN KEY (SalesPersonID) REFERENCES employes(EmployeeID), FOREIGN KEY (CustomerID) REFERENCES customers(CustomerID), FOREIGN KEY (ProductID) REFERENCES products(ProductID) ); <<<<<<< HEAD --drop temp and totalprice ======= >>>>>>> 548eb0662149b4117d4825401ade842accec3af1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version