QUESTION 2

Which of the following are correct statements about Primary Key of a table?

	A.	Primary Key uniquely identifies a row in the table
	B.	The value of a column which is constituent of the primary key cannot be null
	C.	Primary key columns can accept only numeric values
	D.	It is possible that the primary key can be combination of multiple columns

QUESTION 3

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

-- Font family --

-- Font size --

-- Format --HeadingSub Heading 1Sub Heading 2ParagraphFormatted Code

-- Font family --Andale MonoArialArial BlackBook AntiquaComic Sans MSCourier NewGeorgiaHelveticaImpactSymbolTahomaTerminalTimes New RomanTrebuchet MSVerdanaWebdingsWingdings

-- Font size --1 (8pt)2 (10pt)3 (12pt)4 (14pt)5 (18pt)6 (24pt)7 (36pt)

QUESTION 4

Study the data in the table below. The first row of the table contains the column names.

Table: LOANS

LOAN_ID	PRINCIPAL_AMOUNT	TERM_YEARS	YEARLY_RATE	SIMPLE_INTEREST
1	1000	2	10	200
2	10000	5	5	2500
3	5000	5	2	500
4	1000	1	10	100

In the above table, the SIMPLE_INTEREST column is computed using the values in the columns PRINCIPAL_AMOUNT, TERM_YEARS and YEARLY_RATE.

Is the table Normalized?

Yes No

QUESTION 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.

QUESTION 6

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

		Foreign Keys
		NOT NULL constraints
		Identification of actors for Use Cases
		CHECK Constraints
		Using the correct data types for the columns

QUESTION 7

Please study the data in the table below, and based on the data in the table, identify the column that can NOT be the primary key. Please note that the first row of the table contains names for the columns of the table.

TEST_TABLE

REFERNCE_ID	REASON_ID	ATTEMPT_ID	SUCCESS_NUMBER
100	A	2	10
110	B	16	8
111	C	24	8
125	D	27	10

	A.	REASON_ID
	B.	SUCCESS_NUMBER
	C.	REFERENCE_ID
	D.	ATTEMPT_ID

QUESTION 8

Explain how Referential integrity can be enforced between two tables. You may use examples if it makes easy for you to explain.

QUESTION 9

Study the data in the tables named EMPLOYEE and EVALUATION below. The first row of each of these tables contains the names for the columns of the table.

EMPLOYEE

EMP_ID	LAST NAME	FIRST_NAME
1	JORDAN	RONALD
2	MURPHY	MARY
3	DUNKIN	WILLIAM

EVALUATION

ID	EMP_ID	GRDAE
5	1	A
1	3	B
6	8	A

Based on the data in these tables, the column EMPLOYEE_ID from EVALUATION table can be a foreign key referencing EMPLOYEE_ID in EMPLOYEE table.

True

False