A 3.2.4 Constructing Tables Worksheet Answers
Part 1: Table Analysis Instructions: Analyze the following table designs and identify potential problems. For each table, explain what issues might arise and how the design could be improved. Table 1: Employees EmployeeID (INT) Name (VARCHAR) Department (VARCHAR) Salary (FLOAT) Address (VARCHAR) Phone (VARCHAR) Example records: | 123 | John Smith | Sales | 60000 | 123 Main St, Anytown | 555-1212 | | 456 | Jane Doe |...