Database Questions 1 You are designing a table for employee

Database Questions

1) You are designing a table for employee data of a company. You have a requirement to identify if an employee is a United States citizen or not. You have designed a table called EMPLOYEE to store information related to each employee and you have a column called US CITIZEN INDICATOR to store if an employee is a US citizen or not. You only want to store values \"Y\" or \"N\" in this column. From the following options, what is the best way to accomplish this in your database design? A) Define a check constraint on the primary key column of the table to accept only \"Y\" and \"N\" as the values B Define a check constraint on the column US CITIZEN INDICATOR to accept only \"Y\" and \"N\" as the values C) Define a check constraint on all the columns of the table to accept only Y\" and \"N\" as the values D) Design a process that deletes the rows that do not contain valid values for the column US CITIZEN INDICATOR E) None of the above

Solution

Answers:

1:B)Define a check constraint on the column US_CITIZEN_INDICATOR to accept \"Y\" and \"N\" as the values.

3:C)Every unique key is always a primary key

4:C) A and B

5:D)Candidate set for the field probability_of_rain

Note:Please do ask in case of any doubt,thanks.