|
* Note: Do not populate the Customer2
table. This table will be populated in lesson eight.
* Note: In some cases you may
have to set your primary key in the Create Table scripts
using the following method: CustomerID INTEGER NOT NULL CONSTRAINT
PriKey Primary Key,
* Note: In Microsoft Access, when you do
not state NOT NULL when creating a column the column is automatically
set to NULL. In some DBMS's however, if you want to set a column
to NULL you must explicitly state NULL.
Note: In some versions of Microsoft Access you may have to set your primary key in the Create Table script using the following method: CustomerID INTEGER NOT NULL CONSTRAINT PriKey Primary Key, |
CUSTOMER2 CREATE
TABLE SCRIPT
CREATE TABLE Customer2
(
CustomerID INTEGER Primary Key NOT NULL,
FirstName CHAR(50) NOT NULL,
LastName CHAR(50) NOT NULL,
HomePhone CHAR(20),
Address CHAR(50),
State CHAR(02),
City CHAR(30),
PostalCode INTEGER
);
ServicePlans
Table
Orders Table
Customer Table
|