|
* Note: Do not run the INSERT
Statements more than once or it may generate errors.
* Note: In some DBMS's you may
need to substitute a DECIMAL (8,2), or CURRENCY datatype
for the MONEY datatype in the Create Table script.
* Note: DB2 users must
use the NUMERIC (5,2) datatype in place of the MONEY
datatype in the Create Table script.
* Note: MySQL users must
use the DECIMAL (8,2) or NUMERIC (5,2) datatype in place of the MONEY
datatype in the Create Table script.
* Note: Oracle users must
use the NUMBER (8,2) datatype in place of the MONEY
datatype in the Create Table script.
* Note: Microsoft Access users: In some versions of the software you may have to set your primary key in the Create Table script using the following method: PlanID CHAR(10) NOT NULL CONSTRAINT PriKey Primary Key, |
SERVICEPLANS CREATE
TABLE SCRIPT
CREATE TABLE ServicePlans
(
PlanID CHAR(10) PRIMARY KEY NOT NULL,
PlanName CHAR(50) NOT NULL,
PlanDescription CHAR(50) NOT NULL,
PlanPrice MONEY NOT NULL,
DiscountedPrice MONEY
);
SERVICEPLANS TABLE INSERT
STATEMENTS
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('D1002', 'Digital Cable', 'Digital cable plan', 40.00, 35.00);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('D1003', 'Digital Phone', 'Cell phone', 40.00, 35.00);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('D1101', 'Data IP Services A', 'Plan A Data/IP services', 100.00,
85.00);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('D2202', 'Data IP Services B', 'Plan B Data/IP services', 150.00,
125.00);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('I1001', 'Internet', 'Internet/email', 19.99, 16.99);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('L2001', 'Local Phone', 'In state calling', 39.00, 29.99);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('L2002', 'Long Distance A', 'Plan A Out of state per/min', 0.12,
0.11);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('L2003', 'Long Distance B', 'Plan B Out of state per/min', 0.09,
0.08);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('L2004', 'Long Distance C', 'Plan C Out of state per/min', 0.10,
0.09);
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('W1001', 'Web Hosting', 'hosting, site creation', 19.99, 16.99);
NOTE: The ServicePlans
table in lesson 7 and 8 contains 1 extra record. Below you will find the
extra record. You can add the record now or you can add it when you get
to lessons 7 and 8. Adding the record now is not a problem as long as
you remember that you added the record since you may see the record in
some of your results.
INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice,
DiscountedPrice)
VALUES ('E1001', 'Email', 'Premium e-mail', 9.99, 6.99);
Customer Table
Orders Table
Customer2 Table
|