4 Text Files for the Tutorial

4.1 createmoviedbtables.txt

CREATE TABLE MovieStar (
    name CHAR(30),
    address VARCHAR(255),
    gender CHAR(1),
    birthdate INTEGER
)

CREATE TABLE Movie (
    title VARCHAR(255),
    year INTEGER,
    length INTEGER,
    inColor CHAR(1),
    studioName CHAR(50),
    producerCNo INTEGER
)

CREATE TABLE StarsIn (
    movieTitle VARCHAR(255),
    movieYear INTEGER,
    starName CHAR(30)
)

CREATE TABLE MovieExec (
    name CHAR(30),
    address VARCHAR(255),
    certNo INTEGER,
    netWorth INTEGER
)

CREATE TABLE Studio (
    name CHAR(50),
    address VARCHAR(255),
    presCNo INTEGER
)

4.2 deletemoviedbtables.txt

DROP TABLE MovieStar

DROP TABLE Movie

DROP TABLE StarsIn

DROP TABLE MovieExec

DROP TABLE Studio

4.3 populatemoviedbtables.txt

INSERT INTO Movie VALUES ('Star Wars', 1990, 120, 'y', 'Disney', 1)

INSERT INTO Movie VALUES ('Pretty Woman', 1990, 119, 'y', 'Disney',999)

INSERT INTO Studio VALUES ('Disney', 'Drive Rd.', 1)

INSERT INTO Studio VALUES ('Paramount', 'Drive Way', 2)

INSERT INTO MovieExec VALUES ('Marius', 'Home', 1, 3000000)

INSERT INTO MovieExec VALUES ('Lucas', 'Home', 2, 2000000)

The BetaDBC Library - Reference Manual and Tutorial

[Modified: Friday September 7^th 2001 at 12:45]