Question: As a summer intern, you have been asked to create a database record layout for storing employee information. The record will contain the following fields:

As a summer intern, you have been asked to create a database record layout for storing employee information. The record will contain the following fields:
The employee's full name (first, middle, and last)
Street address (allow two lines)
City
State
Zip code
Home area code
Home phone number
Cell phone area code
Cell phone number
Employee birthdate (mm/dd/yyyy)
Age, calculated using the birthdate and system current date (updated nightly)
Gender
Start date at the organization (mm/dd/yyyy)
Number of years employed, calculated using the start date and system current date (updated nightly)
The employee's last four Social Security number digits
Which two database fields will be represented as string literals?
Question 19 options:
a)
social security number and age
b)
number of years employed and zip code
c)
zip code and area code of cell phone
d)
age and area code of home phone

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!