Page 1 of 1
Question 2 Refer to Table 1 and answer the following questions. EmployeeID FirstName: LastName Davolio Fuller Leverling
Posted: Fri Jul 01, 2022 5:37 am
by answerhappygod
- Question 2 Refer To Table 1 And Answer The Following Questions Employeeid Firstname Lastname Davolio Fuller Leverling 1 (85.24 KiB) Viewed 43 times
Question 2 Refer to Table 1 and answer the following
questions. EmployeeID FirstName: LastName Davolio Fuller Leverling Peacock Buchanan Suyama King Callahan Dodsworth 1 2 3 4 5 6 7 8 9 Table 1 Nancy Andrew Janet Margaret Steven Michael Robert Laura Anne HireDate 1/5/1992 12:00:00 AM 14/8/1992 12:00:00 AM 1/4/1992 12:00:00 AM 3/5/1993 12:00:00 AM 17/10/1993 12:00:00 AM 17/10/1993 12:00:00 AM 2/1/1994 12:00:00 AM 5/3/1994 12:00:00 AM 15/11/1994 12:00:00 AM City Seattle Tacoma Kirkland Redmond London London London Seattle London a) Each field in a table must have a unique name. State TWO (2) field names. [4 Marks] b) Indicate which field(s) that make up the primary key, which is the unique identifier. State the primary key for the above table. [2 marks] c) Each field has a data type. This indicates the type of data that can be stored in the field. Identify the appropriate data types for the above table. [4 Marks] [Total : 10 Marks]