oan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database: (Table 1) Employee Information: Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information: Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?
Joan Yancey has been asked to create a
(Table 1) Employee Information:
Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number
(Table 2) Project Information:
Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date
What data type should Joan Yancey use for the Actual Completion Date field and why?
(Table 1) Employee Information:
Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number
(Table 2) Project Information:
Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date
following data type should Joan Yancey use for the Actual Completion Date field is given below:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
