• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. What Every Developer Needs to... > Practical Examples: Designing the Ta...

Practical Examples: Designing the Tables Needed for a Computer Consulting Firm's Time and Billing Application

Create a new database and try designing a few of the tables needed by a computer consulting firm's time and billing application. You will build tblClients and tblProjects tables. The main table for the application, tblClients, will be used to track the key information about each client. The second table, tblProjects, will hold all the key information users need to store on the projects they're working on for each client. Table 2.4 shows the field names, data types, and sizes for each field in tblClients. You should include indexes for all fields except Notes. Table 2.5 shows the properties that need to be set for these fields. Table 2.6 shows the fields, data types, and sizes for the fields in tblProjects, and Table 2.7 shows the properties that need to be set for these fields. You should include indexes for all fields except ProjectDescription.

Table 2.4. Field Names, Data Types, and Sizes for the Fields in tblClients
Field NameData TypeSize
ClientIDAutoNumberLong Integer (Stored as 4)
CompanyNameText50
ContactFirstNameText30
ContactLastNameText50
ContactTitleText50
ContactTypeIDNumberLong Integer (Stored as 4)
ReferredByText30
AssociatedWithText30
IntroDateDate/TimeStored as 8
DefaultRateCurrencyStored as 8
NotesMemo-
MilesNumberLong Integer (Stored as 4)
TermTypeIDNumberLong Integer (Stored as 4)
HomePageHyperlink-



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint