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
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)
Total allowed vacation days and total allowed sick days cannot exceed 20.
Here are the ...