Datasheet

Ranking number(3) NOT NULL,
LastUpdateDate date NOT NULL
);
CREATE TABLE TimeSheets
(
TimeSheetID char(36) NOT NULL,
UserID char(36) NOT NULL,
WeekEndingDate date NOT NULL,
Submitted number(1) NOT NULL,
ApprovalDate date NULL,
ManagerID char(36) NULL,
LastUpdateDate date NOT NULL
);
CREATE TABLE TimeSheetItems
(
TimeSheetItemID char(36) NOT NULL,
TimeSheetID char(36) NOT NULL,
ProjectID char(36) NOT NULL,
Hours number(3) NOT NULL,
TimeSheetDate date NOT NULL
);
3. Enter and execute the following script to create the primary keys in the tables you just created:
---------------------------------------------------------------------
-- Primary Keys
---------------------------------------------------------------------
ALTER TABLE Projects ADD
(
CONSTRAINT PK_Projects PRIMARY KEY (ProjectID)
);
ALTER TABLE Groups ADD
(
CONSTRAINT PK_Groups PRIMARY KEY (GroupID)
);
ALTER TABLE GroupProjects ADD
(
CONSTRAINT PK_GroupProjects PRIMARY KEY (GroupProjectID)
);
ALTER TABLE Users ADD
(
CONSTRAINT PK_Users PRIMARY KEY (UserID)
);
ALTER TABLE Roles ADD
(
CONSTRAINT PK_Roles PRIMARY KEY (RoleID)
);
ALTER TABLE TimeSheets ADD
28
Chapter 1
04_58894x ch01.qxd 10/13/05 5:54 PM Page 28