Teradata基础教程中的数据库表：

整个试验数据库的名称是TERADATA_EDUCATION，其下分成以下三个数据库：
CUSTOMER_SERVICE数据库：包含所有的物理表
CS_VIEWS数据库：包含所有的视图
SQL用户：下面进一步分成SQL00至SQL20共21个数据库用户，供学员登录系统进行测试使用。每个用户登录的密码与其用户名相同，如用SQL01登录，其密码也为SQL01。

脚本文件有如下：

INTED00.sql
INTED01.sql
INTED02.sql
INTED03.sql

然后利用BTEQ或Queryman等工具来按秩序运行上面的脚本文件。以Windows BTEQ为例，假设上述脚本文件存放在\TNT_Sql目录下，则执行方法如下：

.run file=\TNT_Sql\INTED00.sql
.run file=\TNT_Sql\INTED01.sql
.run file=\TNT_Sql\INTED02.sql
.run file=\TNT_Sql\INTED03.sql

这样就创建了测试用的数据库，可以利用BTEQ或Queryman等前端工具来学习Teradata SQL，完成本书中所介绍的例子和练习。

讯享网

INTED00.sql

.LOGON DBC,DBC
/*/
/* Create a "super user" for Teradata Education */
/* Classroom Lab database/userid installation */
/*/
/* Note: This script must be run by a user who */
/* has Create Database/User authority and */
/* the right to grant or re-grant select */
/* on the dictionary tables.
/*/
/* Space limits and account codes may be */
/* modified by the user (RPK 3/97) */
/*/
CREATE USER Teradata_Education AS PASSWORD = educate
PERM = SPOOL =
ACCOUNT = ('$M_D2102');

GRANT ALL ON Teradata_Education TO Teradata_Education
WITH GRANT OPTION;

GRANT SELECT ON DBC TO Teradata_Education
WITH GRANT OPTION;
.LOGOFF

INSQL01.TXT

.SET SESSIONS 8
.SET QUIET 
    ON    
.LOGON Teradata_Education,educate
//
/* Creates Database Customer_Service, defines and */
/* populates nine (9) sample tables (RPK 3/97) */
//
SELECT    * 
FROM    DBC.Databases
WHERE    DatabaseName = 'Customer_Service';
.IF ACTIVITYCOUNT = 0 THEN .GOTO CreateCS
GRANT    DROP DATABASE 
    ON    Customer_Service TO Teradata_Education;
DELETE    DATABASE Customer_Service;
DROP    DATABASE Customer_Service;
.LABEL CreateCS
CREATE    DATABASE Customer_Service 
FROM    Teradata_Education AS
PERM= ACCOUNT = ('$M_P0623');

DATABASE Customer_Service;
CREATE    TABLE contact, FALLBACK
(contact_number INTEGER
,contact_name CHAR(30) NOT NULL
,area_code SMALLINT NOT NULL
,phone INTEGER NOT NULL
,extension INTEGER
,last_call_date DATE NOT NULL)
UNIQUE PRIMARY INDEX (contact_number);
CREATE    TABLE customer, FALLBACK
(customer_number INTEGER
,customer_name CHAR(30) NOT NULL
,parent_customer_number INTEGER
,sales_employee_number INTEGER
)
UNIQUE PRIMARY INDEX (customer_number);
CREATE    TABLE department, FALLBACK
(department_number SMALLINT
,department_name CHAR(30) NOT NULL
,budget_amount DECIMAL(10,2)
,manager_employee_number INTEGER
)
UNIQUE PRIMARY INDEX (department_number)
,UNIQUE INDEX (department_name);
CREATE    TABLE employee, FALLBACK
(employee_number INTEGER
,manager_employee_number INTEGER
,department_number INTEGER
,job_code INTEGER
,last_name CHAR(20) NOT NULL
,first_name VARCHAR(30) NOT NULL
,hire_date DATE NOT NULL
,birthdate DATE NOT NULL
,salary_amount DECIMAL(10,2) NOT NULL
)
UNIQUE PRIMARY INDEX (employee_number);
CREATE    TABLE employee_phone, FALLBACK
(employee_number INTEGER NOT NULL
,area_code SMALLINT NOT NULL
,phone INTEGER NOT NULL
,extension INTEGER
,comment_line CHAR(72)
)
PRIMARY INDEX (employee_number);
CREATE    TABLE job, FALLBACK
(job_code INTEGER
,description VARCHAR(40) NOT NULL
,hourly_billing_rate DECIMAL(6,2)
,hourly_cost_rate DECIMAL(6,2)
)
UNIQUE PRIMARY INDEX (job_code)
,UNIQUE INDEX (description);
CREATE    TABLE location, FALLBACK
(location_number INTEGER
,customer_number INTEGER NOT NULL
,first_address_line CHAR(30) NOT NULL
,city VARCHAR(30) NOT NULL
,state CHAR(15) NOT NULL
,zip_code INTEGER NOT NULL
,second_address_line CHAR(30)
,third_address_line CHAR(30)
)
PRIMARY INDEX (customer_number);
CREATE    TABLE location_employee, FALLBACK
(location_number INTEGER NOT NULL
,employee_number INTEGER NOT NULL
)
PRIMARY INDEX (employee_number);
CREATE    TABLE location_phone, FALLBACK
(location_number INTEGER
,area_code SMALLINT NOT NULL
,phone INTEGER NOT NULL
,extension INTEGER
,description VARCHAR(40) NOT NULL
,comment_line LONG VARCHAR
)
PRIMARY INDEX (location_number);
INSERT    INTO contact 
VALUES    
(8010,'Brayman, Connie',408,,112,);
INSERT    INTO contact 
VALUES    
(8001,'Leblanc, James',805,,221,);
INSERT    INTO contact 
VALUES    
(8005,'Hughes, Jack',212,,710,);
INSERT    INTO contact 
VALUES    
(8007,'Smith, Ginny',408,,333,);
INSERT    INTO contact 
VALUES    
(8008,'Torres, Alison',802,,444,);
INSERT    INTO contact 
VALUES    
(8009,'Dibble, Nancy',602,,652,);
INSERT    INTO customer 
VALUES    
(00,'Corporate Headquarters',NULL,NULL);
INSERT    INTO customer 
VALUES    
(01,'A to Z Communications, Inc.',NULL,1015);
INSERT    INTO customer 
VALUES    
(02,'Simple Instruments Co.',1,1015);
INSERT    INTO customer 
VALUES    
(03,'First American Bank',NULL,1023);
INSERT    INTO customer 
VALUES    
(04,'Sum Bank',3,1023);
INSERT    INTO customer 
VALUES    
(05,'Federal Bureau of Rules',NULL,1018);
INSERT    INTO customer 
VALUES    
(06,'Liberty Tours',NULL,1023);
INSERT    INTO customer 
VALUES    
(07,'Cream of the Crop',NULL,1018);
INSERT    INTO customer 
VALUES    
(08,'Colby Co.',NULL,1018);
INSERT    INTO customer 
VALUES    
(09,'More Data Enterprise',NULL,1023);
INSERT    INTO customer 
VALUES    
(10,'Graduates Job Service',NULL,1015);
INSERT    INTO customer 
VALUES    
(11,'Hotel California',NULL,1015);
INSERT    INTO customer 
VALUES    
(12,'Cheap Rentals',NULL,1018);
INSERT    INTO customer 
VALUES    
(13,'First American Bank',3,1023);
INSERT    INTO customer 
VALUES    
(14,'Metro Savings',NULL,1018);
INSERT    INTO customer 
VALUES    
(15,'Cates Modeling',NULL,1015);
INSERT    INTO customer 
VALUES    
(16,'VIP Investments',3,1023);
INSERT    INTO customer 
VALUES    
(17,'East Coast Dating Service',NULL,1023);
INSERT    INTO customer 
VALUES    
(18,'Wall Street Connection',NULL,1023);
INSERT    INTO customer 
VALUES    
(19,'More Data Enterprise',9,1015);
INSERT    INTO customer 
VALUES    
(20,'Metro Savings',14,1018);
INSERT    INTO department 
VALUES    
(401,'customer support',,1003);
INSERT    INTO department 
VALUES    
(201,'technical operations',,1025);
INSERT    INTO department 
VALUES    
(301,'research and development',,1019);
INSERT    INTO department 
VALUES    
(302,'product planning',,1016);
INSERT    INTO department 
VALUES    
(403,'education',,1005);
INSERT    INTO department 
VALUES    
(402,'software support',,1011);
INSERT    INTO department 
VALUES    
(501,'marketing sales',,1017);
INSERT    INTO department 
VALUES    
(100,'president',,0801);
INSERT    INTO department 
VALUES    
(600,'None',,1099);
INSERT    INTO employee 
VALUES    
(0801,0801,100,,'Trainer','I.B.',,,);
INSERT    INTO employee 
VALUES    
(1001,1003,401,,'Hoover','William',,,25525);
INSERT    INTO employee 
VALUES    
(1002,1003,401,,'Brown','Alan',,,43100);
INSERT    INTO employee 
VALUES    
(1003,0801,401,,'Trader','James',,,37850);
INSERT    INTO employee 
VALUES    
(1004,1003,401,,'Johnson','Darlene',,,36300);
INSERT    INTO employee 
VALUES    
(1005,0801,403,,'Ryan','Loretta',,,31200);
INSERT    INTO employee 
VALUES    
(1006,1019,301,,'Stein','John',,,29450);
INSERT    INTO employee 
VALUES    
(1007,1005,403,,'Villegas','Arnando',,,49700);
INSERT    INTO employee 
VALUES    
(1008,1019,301,,'Kanieski','Carol',,,29250);
INSERT    INTO employee 
VALUES    
(1009,1005,403,,'Lombardo','Domingus',,,31000);
INSERT    INTO employee 
VALUES    
(1010,1003,401,,'Rogers','Frank',,,46000);
INSERT    INTO employee 
VALUES    
(1011,0801,402,,'Daly','James',,,52500);
INSERT    INTO employee 
VALUES    
(1012,1005,403,,'Hopkins','Paulene',,,37900);
INSERT    INTO employee 
VALUES    
(1013,1003,401,,'Phillips','Charles',,,24500);
INSERT    INTO employee 
VALUES    
(1014,1011,402,,'Crane','Robert',,,24500);
INSERT    INTO employee 
VALUES    
(1015,1017,501,,'Wilson','Edward',,,53625);
INSERT    INTO employee 
VALUES    
(1016,0801,302,,'Rogers','Nora',,,56500);
INSERT    INTO employee 
VALUES    
(1017,0801,501,,'Runyon','Irene',,,66000);
INSERT    INTO employee 
VALUES    
(1018,1017,501,,'Ratzlaff','Larry',,,54000);
INSERT    INTO employee 
VALUES    
(1019,0801,301,,'Kubic','Ron',,,57700);
INSERT    INTO employee 
VALUES    
(1020,1005,403,,'Charles','John',,,39500);
INSERT    INTO employee 
VALUES    
(1021,1025,201,,'Morrissey','Jim',,,38750);
INSERT    INTO employee 
VALUES    
(1022,1003,401,,'Machado','Albert',,,32300);
INSERT    INTO employee 
VALUES    
(1023,1017,501,,'Rabbit','Peter',,,26500);
INSERT    INTO employee 
VALUES    
(1024,1005,403,,'Brown','Allen',,,43700);
INSERT    INTO employee 
VALUES    
(1025,0801,201,,'Short','Michael',,,34700);
INSERT    INTO employee_phone 
VALUES    
(0801,213,,101,'Corporate President');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'Graduates Job Service');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'Hotel California');
INSERT    INTO employee_phone 
VALUES    
(1001,213,,NULL,'Cates Modeling');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'More Data');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'A TO Z office');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'A TO Z System Manager');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'A TO Z Secretary');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'residence/office');
INSERT    INTO employee_phone 
VALUES    
(1001,415,,NULL,'Simple Instruments');
INSERT    INTO employee_phone 
VALUES    
(1002,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1002,213,,439,'office');
INSERT    INTO employee_phone 
VALUES    
(1003,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1003,213,,401,'office');
INSERT    INTO employee_phone 
VALUES    
(1004,212,,NULL,'First Am. Bank computer room');
INSERT    INTO employee_phone 
VALUES    
(1004,212,,NULL,'First Am. Bank system manager');
INSERT    INTO employee_phone 
VALUES    
(1004,609,,213,'Sum Bank system manager');
INSERT    INTO employee_phone 
VALUES    
(1004,609,,224,'Sum Bank computer room');
INSERT    INTO employee_phone 
VALUES    
(1004,609,,225,'Sum Bank secretary');
INSERT    INTO employee_phone 
VALUES    
(1004,609,,NULL,'residence/office');
INSERT    INTO employee_phone 
VALUES    
(1004,212,,NULL,'Liberty Tours main number');
INSERT    INTO employee_phone 
VALUES    
(1004,919,,NULL,'More Data System Manager');
INSERT    INTO employee_phone 
VALUES    
(1004,617,,NULL,'First Am. Bank Manager');
INSERT    INTO employee_phone 
VALUES    
(1004,212,,NULL,'VIP Investments');
INSERT    INTO employee_phone 
VALUES    
(1004,718,,NULL,'East Coast Dating');
INSERT    INTO employee_phone 
VALUES    
(1004,212,,NULL,'Wall Street Connection');
INSERT    INTO employee_phone 
VALUES    
(1005,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1005,213,,415,'office');
INSERT    INTO employee_phone 
VALUES    
(1006,213,,410,'office');
INSERT    INTO employee_phone 
VALUES    
(1006,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1007,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1007,213,,440,'office');
INSERT    INTO employee_phone 
VALUES    
(1008,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1008,213,,429,'office');
INSERT    INTO employee_phone 
VALUES    
(1009,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1009,213,,413,'office');
INSERT    INTO employee_phone 
VALUES    
(1010,202,,NULL,'Residence/office');
INSERT    INTO employee_phone 
VALUES    
(1010,213,,NULL,'office');
INSERT    INTO employee_phone 
VALUES    
(1010,202,,NULL,'Fed Bureau of Rules request name');
INSERT    INTO employee_phone 
VALUES    
(1010,804,,NULL,'Cream of the Crop');
INSERT    INTO employee_phone 
VALUES    
(1010,313,,NULL,'Colby Co');
INSERT    INTO employee_phone 
VALUES    
(1010,312,0,NULL,'Cheap Rentals');
INSERT    INTO employee_phone 
VALUES    
(1010,804,,370,'Metro Savings');
INSERT    INTO employee_phone 
VALUES    
(1010,804,,375,'Metro Savings');
INSERT    INTO employee_phone 
VALUES    
(1010,312,,NULL,'Metro Savings');
INSERT    INTO employee_phone 
VALUES    
(1011,213,,422,'office');
INSERT    INTO employee_phone 
VALUES    
(1011,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1012,213,,418,'office');
INSERT    INTO employee_phone 
VALUES    
(1012,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1013,213,,411,'office');
INSERT    INTO employee_phone 
VALUES    
(1013,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1014,213,,442,'office');
INSERT    INTO employee_phone 
VALUES    
(1014,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1015,213,,436,'office');
INSERT    INTO employee_phone 
VALUES    
(1015,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1015,415,,NULL,'A to Z system manager');
INSERT    INTO employee_phone 
VALUES    
(1015,415,,NULL,'Simple Instruments receptionist');
INSERT    INTO employee_phone 
VALUES    
(1016,213,,412,'office');
INSERT    INTO employee_phone 
VALUES    
(1016,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1017,213,,425,'office');
INSERT    INTO employee_phone 
VALUES    
(1017,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1018,202,,NULL,'Fed Bureau of Rules');
INSERT    INTO employee_phone 
VALUES    
(1018,804,,NULL,'residence/office');
INSERT    INTO employee_phone 
VALUES    
(1019,213,,418,'office');
INSERT    INTO employee_phone 
VALUES    
(1019,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1020,213,,433,'office');
INSERT    INTO employee_phone 
VALUES    
(1020,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1021,213,,428,'office');
INSERT    INTO employee_phone 
VALUES    
(1021,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1022,213,,416,'office');
INSERT    INTO employee_phone 
VALUES    
(1022,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1023,212,,NULL,'First Am. Bank system manager');
INSERT    INTO employee_phone 
VALUES    
(1023,212,,NULL,'residence/office');
INSERT    INTO employee_phone 
VALUES    
(1023,609,,213,'Sum Bank receptionist');
INSERT    INTO employee_phone 
VALUES    
(1024,213,,417,'office');
INSERT    INTO employee_phone 
VALUES    
(1024,213,,NULL,'residence');
INSERT    INTO employee_phone 
VALUES    
(1025,213,,429,'office');
INSERT    INTO employee_phone 
VALUES    
(1025,213,,NULL,'residence');
INSERT    INTO job 
VALUES    
(,'Corporate President',0,0);
INSERT    INTO job 
VALUES    
(,'Product Specialist',0,0);
INSERT    INTO job 
VALUES    
(,'System Support Analyst',0,0);
INSERT    INTO job 
VALUES    
(,'Dispatcher',0,0);
INSERT    INTO job 
VALUES    
(,'Field Engineer',0,0);
INSERT    INTO job 
VALUES    
(,'Sales Rep',0,0);
INSERT    INTO job 
VALUES    
(,'Software Engineer',0,0);
INSERT    INTO job 
VALUES    
(,'Hardware Engineer',0,0);
INSERT    INTO job 
VALUES    
(,'Planning Specialist',0,0);
INSERT    INTO job 
VALUES    
(,'Instructor',0,0);
INSERT    INTO job 
VALUES    
(,'System Analyst',0,0);
INSERT    INTO job 
VALUES    
(,'Software Analyst',0,0);
INSERT    INTO job 
VALUES    
(,'Electronic Assembler',0,0);
INSERT    INTO job 
VALUES    
(,'Mechanical Assembler',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Customer Support',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Software Support',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Education',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Product Planning',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Research and Development',0,0);
INSERT    INTO job 
VALUES    
(,'Manager - Marketing Sales',0,0);
INSERT    INTO location 
VALUES    
(0,0,'1294 Jefferson Blvd','Los Angeles','California',
,NULL,NULL);
INSERT    INTO location 
VALUES    
(0,1,'101 Middlefield Rd','Palo
Alto','California',,NULL,NULL);
INSERT    INTO location 
VALUES    
(0,2,'49 Fourth St','San Francisco','California',,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(,3,'10366 25th St','New York City','New
York',,NULL,NULL);
INSERT    INTO location 
VALUES    
(,4,'55 Madison Av','Trenton','New Jersey',,NULL,
        NULL);
INSERT    INTO location 
VALUES    
(0,5,'1 Lincoln Square','Washington','DC',,NULL,
        NULL);
INSERT    INTO location 
VALUES    
(,6,'10 River Rd','Schenectady','New York',,NULL,
        NULL);
INSERT    INTO location 
VALUES    
(,7,'4035 South 35th Av','Arlington','Virginia',,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(,8,'1100 State St','Detroit','MI',,NULL,NULL);
INSERT    INTO location 
VALUES    
(,9,'4400 Greenwood Rd','Wilmington','NC',,NULL,
        NULL);
INSERT    INTO location 
VALUES    
(0,10,'5171 El Camino Real','Palo Alto','California',94071,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(0,11,'770 Hotel Dr','Menlo Park','California',,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(,12,'510 Benton Av','Chicago','Illinois',,NULL,
        NULL);
INSERT    INTO location 
VALUES    
(,13,'1059 Kings Rd','Boston','Massachusetts',0,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(,14,'1690 Miller Av','Richmond','Virginia',,
        NULL,NULL);
INSERT    INTO location 
VALUES    
(0,15,'687 Culver Blvd','Culver
City','California',,NULL,NULL);
INSERT    INTO location 
VALUES    
(,16,'2255 16th Av','New York City','New
York',,NULL,NULL);
INSERT    INTO location 
VALUES    
(,17,'4001 Harbor Blvd','Brooklyn','New
York',,NULL,NULL);
INSERT    INTO location 
VALUES    
(,18,'105 Time Square','New York City','New
York',,NULL,NULL);
INSERT    INTO location 
VALUES    
(0,19,'567 El Camino Real','San
Mateo','California',,NULL,NULL)
;
INSERT    INTO location 
VALUES    
(,20,'876 Winston St','Chicago','Illinois',,NULL,
        NULL);
INSERT    INTO location_employee 
VALUES    
(0,1001);
INSERT    INTO location_employee 
VALUES    
(0,1001);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(0,1010);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1010);
INSERT    INTO location_employee 
VALUES    
(,1010);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(0,1001);
INSERT    INTO location_employee 
VALUES    
(0,1001);
INSERT    INTO location_employee 
VALUES    
(,1010);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1010);
INSERT    INTO location_employee 
VALUES    
(0,1001);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1004);
INSERT    INTO location_employee 
VALUES    
(,1001);
INSERT    INTO location_employee 
VALUES    
(,1010);
INSERT    INTO location_phone 
VALUES    
(0,213,,101,'Corporate Presidents office',NULL);
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'FEs office',NULL);
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'System Manager',NULL);
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'Secretary','available 9:00 to 5:00');
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'Receptionist','ask for page');
INSERT    INTO location_phone 
VALUES    
(,212,,NULL,'Computer Room',NULL);
INSERT    INTO location_phone 
VALUES    
(,212,,NULL,'System Manager',NULL);
INSERT    INTO location_phone 
VALUES    
(,609,,213,'Receptionist','leave message');
INSERT    INTO location_phone 
VALUES    
(,609,,224,'System Manager',NULL);
INSERT    INTO location_phone 
VALUES    
(,609,,225,'Computer Room',NULL);
INSERT    INTO location_phone 
VALUES    
(0,202,,NULL,'Switchboard',NULL);
INSERT    INTO location_phone 
VALUES    
(,212,,NULL,'Small office',NULL);
INSERT    INTO location_phone 
VALUES    
(,804,,NULL,'Switchboard',NULL);
INSERT    INTO location_phone 
VALUES    
(,313,,NULL,'Receptionist',NULL);
INSERT    INTO location_phone 
VALUES    
(,919,,NULL,'Receptionist',NULL);
INSERT    INTO location_phone 
VALUES    
(,919,,601,'John Moore','Vice President');
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'Alice Hamm','President');
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'J.R. Stern','Owner');
INSERT    INTO location_phone 
VALUES    
(,312,,NULL,'Tom Thumb','Owner');
INSERT    INTO location_phone 
VALUES    
(,617,,NULL,'Computer Room',NULL);
INSERT    INTO location_phone 
VALUES    
(,617,,NULL,'System Manager',NULL);
INSERT    INTO location_phone 
VALUES    
(,804,,370,'Alan Monday','System Manager');
INSERT    INTO location_phone 
VALUES    
(,804,,375,'Receptionist',NULL);
INSERT    INTO location_phone 
VALUES    
(0,213,,NULL,'Charles Cates','Owner');
INSERT    INTO location_phone 
VALUES    
(,212,,NULL,'Andy Moore',NULL);
INSERT    INTO location_phone 
VALUES    
(,718,,NULL,'various contacts',NULL);
INSERT    INTO location_phone 
VALUES    
(,212,,NULL,'Tom Sellers',NULL);
INSERT    INTO location_phone 
VALUES    
(0,415,,NULL,'Receptionist',NULL);
INSERT    INTO location_phone 
VALUES    
(,312,,NULL,'Receptionist',NULL);
INSERT    INTO location_phone 
VALUES    
(,312,,NULL,'System Manager',NULL);
.LOGOFF

INSQL02.sql

.LOGON Teradata_Education,educate
//
/* Creates Database CS_VIEWS and populates it with ten */
/* views of the Customer_Service tables. (RPK 3/97) */
/* */
/* Update by P. Derouin 8/19/97 */
//
SELECT    DatabaseName 
FROM    DBC.Databases
WHERE    DatabaseName = 'CS_VIEWS';
.IF ACTIVITYCOUNT = 0 THEN .GOTO CreateVM

GRANT    DROP DATABASE 
    ON    CS_VIEWS TO Teradata_Education;
    
DELETE    DATABASE CS_VIEWS;
DROP    DATABASE CS_VIEWS;

.LABEL CreateVM
CREATE    DATABASE CS_VIEWS 
FROM    Teradata_Education AS PERM = 0
ACCOUNT = ('$M_P0623');
GRANT    SELECT 
    ON    Customer_Service TO CS_VIEWS WITH 
GRANT    OPTION;
DATABASE CS_VIEWS;
CREATE    VIEW contact
(contact_number
,contact_name
,area_code
,phone
,extension
,last_call_date)
AS
SELECT    
contact_number
,contact_name
,area_code
,phone
,extension
,last_call_date
FROM    CUSTOMER_SERVICE.contact;
CREATE    VIEW customer
(customer_number
,customer_name
,parent_customer_number
,sales_employee_number)
AS
SELECT    
customer_number
,customer_name
,parent_customer_number
,sales_employee_number
FROM    CUSTOMER_SERVICE.customer;
CREATE    VIEW department
(department_number
,department_name
,budget_amount
,manager_employee_number)
AS
SELECT    
department_number
,department_name
,budget_amount
,manager_employee_number
FROM    CUSTOMER_SERVICE.department;
CREATE    VIEW employee
(employee_number
,manager_employee_number
,department_number
,job_code
,last_name
,first_name
,hire_date
,birthdate
,salary_amount)
AS
SELECT    
employee_number
,manager_employee_number
,department_number
,job_code
,last_name
,first_name
,hire_date
,birthdate
,salary_amount
FROM    CUSTOMER_SERVICE.employee;
CREATE    VIEW employee_phone
(employee_number
,area_code
,phone
,extension
,comment_line)
AS
SELECT    
employee_number
,area_code
,phone
,extension
,comment_line
FROM    CUSTOMER_SERVICE.employee_phone;
CREATE    VIEW job
(job_code
,description
,hourly_billing_rate
,hourly_cost_rate)
AS
SELECT    
job_code
,description
,hourly_billing_rate
,hourly_cost_rate
FROM    CUSTOMER_SERVICE.job;
CREATE    VIEW location
(location_number
,customer_number
,first_address_line
,city
,state
,zip_code
,second_address_line
,third_address_line)
AS
SELECT    
location_number
,customer_number
,first_address_line
,city
,state
,zip_code
,second_address_line
,third_address_line
FROM    CUSTOMER_SERVICE.location;
CREATE    VIEW location_employee
(location_number
,employee_number)
AS
SELECT    
location_number
,employee_number
FROM    CUSTOMER_SERVICE.location_employee;
CREATE    VIEW location_phone
(location_number
,area_code
,phone
,extension
,description
,comment_line)
AS
SELECT    
location_number
,area_code
,phone
,extension
,description
,comment_line
FROM    CUSTOMER_SERVICE.location_phone;

CREATE    VIEW emp
(emp
,mgr
,dept
,job
,last
,first1
,hire
,birth
,sal)
AS
SELECT    
employee_number
,manager_employee_number
,department_number
,job_code
,last_name
,first_name
,hire_date
,birthdate
,salary_amount
FROM    CUSTOMER_SERVICE.employee;
.LOGOFF

INSQL03.TXT

.LOGON Teradata_Education,educate
/*/
/* Create SQL Class Userids: SQL00 TO SQL20 */
/* from newly created userid SQL */
/*/
/* Note: This script will fail if these userids */
/* are already defined. To cleanup old SQL */
/* userids, run the script: rmsql01.txt */
/*/
/* Spool limit, account code values, and also */
/* access rights to the sample views and tables */
/* will be inherited from user SQL. (RPK 3/97) */
/* */
/* Updated by P.Derouin (8/19/97) */
/*/
CREATE    USER SQL99
FROM    Teradata_Education AS
PASSWORD = SQL99 PERM =
SPOOL = ACCOUNT = ('$M_P0623');
GRANT    SELECT 
    ON    Customer_Service TO ALL SQL99;
GRANT    SELECT 
    ON    CS_VIEWS TO ALL SQL99;
CREATE    USER SQL00 
FROM    SQL99 AS PASSWORD = SQL00
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL01 
FROM    SQL99 AS PASSWORD = SQL01
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL02 
FROM    SQL99 AS PASSWORD = SQL02
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL03 
FROM    SQL99 AS PASSWORD = SQL03
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL04 
FROM    SQL99 AS PASSWORD = SQL04
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL05 
FROM    SQL99 AS PASSWORD = SQL05
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL06 
FROM    SQL99 AS PASSWORD = SQL06
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL07 
FROM    SQL99 AS PASSWORD = SQL07
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL08 
FROM    SQL99 AS PASSWORD = SQL08
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL09 
FROM    SQL99 AS PASSWORD = SQL09
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL10 
FROM    SQL99 AS PASSWORD = SQL10
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL11 
FROM    SQL99 AS PASSWORD = SQL11
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL12 
FROM    SQL99 AS PASSWORD = SQL12
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL13 
FROM    SQL99 AS PASSWORD = SQL13
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL14 
FROM    SQL99 AS PASSWORD = SQL14
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL15 
FROM    SQL99 AS PASSWORD = SQL15
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL16 
FROM    SQL99 AS PASSWORD = SQL16
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL17 
FROM    SQL99 AS PASSWORD = SQL17
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL18 
FROM    SQL99 AS PASSWORD = SQL18
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL19 
FROM    SQL99 AS PASSWORD = SQL19
PERM = DEFAULT DATABASE = CS_VIEWS;
CREATE    USER SQL20 
FROM    SQL99 AS PASSWORD = SQL20
PERM = DEFAULT DATABASE = CS_VIEWS;
.LOGOFF