Datasheet

Try It Out Creating the ProjectTimeTracker Oracle Database
1.
Start SQL Plus or your favorite third-party tool for running SQL scripts against an Oracle
database.
2. Enter and execute the following script to create your tables:
---------------------------------------------------------------------
-- Tables
---------------------------------------------------------------------
CREATE TABLE Projects
(
ProjectID char(36) NOT NULL,
ProjectName varchar2(50) NOT NULL,
ProjectDescription clob NULL,
SequenceNumber number(3) NOT NULL,
LastUpdateDate date NOT NULL
);
CREATE TABLE Groups
(
GroupID char(36) NOT NULL,
GroupName varchar2(50) NOT NULL,
GroupDescription clob NULL,
LastUpdateDate date NOT NULL
);
CREATE TABLE GroupProjects
(
GroupProjectID char(36) NOT NULL,
GroupID char(36) NOT NULL,
ProjectID char(36) NOT NULL
);
CREATE TABLE Users
(
UserID char(36) NOT NULL,
LoginName varchar2(15) NOT NULL,
Password varchar2(75) NOT NULL,
FirstName varchar2(30) NOT NULL,
LastName varchar2(30) NOT NULL,
Email varchar2(50) NOT NULL,
Phone varchar2(20) NOT NULL,
Status number(1) NOT NULL,
GroupID char(36) NOT NULL,
RoleID char(36) NOT NULL,
ManagerID char(36) NULL,
LastUpdateDate date NOT NULL
);
CREATE TABLE Roles
(
RoleID char(36) NOT NULL,
RoleName varchar2(50) NOT NULL,
RoleDescription clob NULL,
27
Databases
04_58894x ch01.qxd 10/13/05 5:54 PM Page 27