Match the following options to the correct statement based on the sample table,

Question

Match the following options to the correct statement based on the sample table, Employee. Not all options will be used. Assume the current year is 2017 and employee information is added on the start date EmpLName EmpDependents EmpStartDate EmpNo Meyer Smith ones Smith 2 9/1/1990 140 9/1/1990 487 2 1/1/2020 655 0 11/30/1987 342 All of the data about Meyer is called a(n). EmpDependents is a n). A. primary key B. data type C. attribute D. record E. validation rule F. default value G. foreign key Jones' start date suggests the data dictionary needs an).. EmpLName has )..of text For this table, EmpNo is the...

Explanation / Answer

Solution :

1. All data about mayer is called D. Record.

2. EmpDependents is an C. Attribute.

3. jones' start date suggests the data dictionary needs a E. Validation rule.
Here date 1/1/2020 is a future date which is invalid as current year is 2017.

4. EmpLName has a B. DataType of text.

5. For this table EmpNo is the A. Primary key

if you have any doubts then you can ask in comment section. If you find the solution helpful then upvote the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.