1. Engineering
  2. Computer Science
  3. 1 it is possible that a foreign key column of...

Question: 1 it is possible that a foreign key column of...

Question details

1. It is possible that a foreign key column of a table can be NULL.

A。True

B。False

2.From the list below, identify ALL the options to implement data integrity in the Database design.(option)

a.

Using the correct data types for the columns

b.

Identification of actors for Use Cases

c.

Foreign Keys

d.

CHECK Constraints

e.

NOT NULL constraints

3. Provide an example where foreign key column value of a table can be null.

4. In your own words, explain how Referential integrity can be enforced between two tables. You may use examples if it makes easy for you to explain.

5. The dataset below shows list of employees of an organization and the departments that the employees are working in. The EMPLOYEE_ID column of the dataset uniquely identifies an employee of the organization. The DEAPARTMENT_ID column of the dataset uniquely identifies a department of the organization. An employee of this organization can work only in one department of the organization.

Based on the information provided, please normalize the given dataset. Your response should clearly indicate resultant tables after the normalization along with their colums. Also please indicate all the primary keys and applicable foreign keys.

EMPLOYEE_ID EMPLOYEE_FIRST_NAME EMPLOYEE_LAST_NAME DEPARTMENT_ID DEPARTMENT_NAME
100 SCOTTY JORDAN 1 ACCOUNTING
110 MICHAEL PIPPEN 2 HR
113 KOBE NASH 3 IT
115 STEVE BRYANT 2 HR

Note: The first row of the above table indicates the names of the columns of the dataset.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution