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

Case Example

This chapter discussed many of the issues connected with creating tables, but you never actually got around to creating one from start to finish. This case example attempts to remedy that shortcoming. The Nifty Lions database currently has no Employees table. In the following exercise, you create the table using these columns and business rules:

  • EmployeeID (primary key)

  • Social Security Number

  • Employee Last Name

  • Employee First Name

  • Street Address

  • City

  • State

  • ZIP

  • Biography

  • Photo

  • Date Hired

  • Employee Website

  • Hourly Wage

  • Overtime (i.e., whether the employee is willing to work overtime.)

  • Allowed Vacation Days (Must not exceed 10)

  • Allowed Sick Days (Must not exceed 10)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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