Datasheet

Figure 1-8
The steps in the following Try It Out assume that the physical database, ProjectTimeTracker, has been
created by you or your DBA and that you have the appropriate permissions to create objects, such as
tables and indexes, in that database.
Try It Out Creating the ProjectTimeTracker SQL Server Database
1.
Start Visual Studio 2005.
2. View the Server Explorer window and then click the Auto Hide icon on the title bar so that the
Server Explorer window stays visible.
3. Right-click the Data Connections node and choose Add Connection from the context menu.
Groups
GroupID
GroupName
GroupDescription
LastUpdateDate
Not Null
Not Null
Null
Not Null
UniqueIdentifier
VarChar(50)
Text
DateTime
Users
UserID
LoginName
Password
FirstName
LastName
Email
Phone
Status
GroupID
RoleID
ManagerID
LastUpdateDate
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Null
Not Null
UniqueIdentifier
VarChar(15)
VarChar(75)
VarChar(30)
VarChar(30)
VarChar(50)
VarChar(20)
Bit
UniqueIdentifier
UniqueIdentifier
UniqueIdentifier
DateTim
e
TimeSheets
TimeSheetID
UserID
WeekEndingDate
Submitted
ApprovalDate
ManagerID
LastUpdateDate
Not Null
Not Null
Not Null
Not Null
Null
Null
Not Null
UniqueIdentifier
UniqueIdentifier
DateTime
Bit
DateTime
UniqueIdentifier
DateTime
TimeSheetItems
TimeSheetItemID
TimeSheetID
ProjectID
Hours
TimeSheetDate
Not Null
Not Null
Not Null
Not Null
Not Null
UniqueIdentifier
UniqueIdentifier
UniqueIden
tifier
TinyInt
DateTime
GroupProjects
GroupProjectsID
GroupID
ProjectID
Not Null
Not Null
Not Null
UniqueIdentifier
UniqueIdentifier
UniqueIdentifier
Roles
RoleID
RoleName
RoleDescription
Ranking
LastUpdateDate
Not Null
Not Null
Null
Not Null
Not Null
UniqueIdentifier
VarChar(50)
Text
TinyInt
DateTime
Projects
ProjectID
ProjectName
ProjectDescriptio
n
SequenceNumber
LastUpdateDate
Not Null
Not Null
Null
Not Null
Not Null
UniqueIdentifier
VarChar(50)
Text
TinyInt
DateTime
21
Databases
04_58894x ch01.qxd 10/13/05 5:54 PM Page 21