IT 330 FINAL EXAM REVIEW;
QUESTIONS WITH DETAILED VERIFIED
ANSWERS; ALREADY GRADED A; 2026
Q1- Describe 1NF, 2NF and 3NF? Give examples. -
correct answer- 1NF
• Every Table will contain primary key
• Every column will be single valued - Name column
should be broken as FirstName, MiddleName and Last
Name
• There should not duplicate columns in any table - like
we should not have columns like address1,address2
2NF
• Every non-key column in dependent on primary key and
DB is in 1NF.
Ex: In customer table ( CustomerId, CustomerName,
CustomerAge, CustomerCity) CustomerCity is not
dependent on CustomerId so it should be removed from
Customer Table and should be put somewhere else.
,3NF:
• When every non-key column is independent of every
other non-key column
EX: Customer Table ( CustomerId, CustomerName,
CustomerAge,CustomerDateOfBirth) CustomerAge and
CustomerDateOfBirth are dependent on each other so
one should be removed.
Q1- Explain the different types of join operations. What
are they and how do they work? - correct answer-
Inner join: only returns rows meeting criteria
Cross join: Performs relational product of two tables
Natural join: Returns all rows with matching values in the
matching columns. Eliminates duplicate columns. Used
when tables share one or more common attributes with
common names
Join USING: Returns only rows with matching values in the
column indicated in the USING clause
, Join ON: Used when tables have no common attributes
Outer Join: Returns rows with unmatched attribute values
for tables to be joined
Left & Right: designate order in which tables are
processed
Left: Returns rows matching the join condition. Returns
rows in left side table with unmatched values
Right: Returns rows matching join condition. Returns rows
in right side table with unmatched values
Full: Returns rows matching join condition. Returns all
rows with unmatched values in either side table
Q1- List and briefly describe the three types of system
maintenance activities. - correct answer- i)
QUESTIONS WITH DETAILED VERIFIED
ANSWERS; ALREADY GRADED A; 2026
Q1- Describe 1NF, 2NF and 3NF? Give examples. -
correct answer- 1NF
• Every Table will contain primary key
• Every column will be single valued - Name column
should be broken as FirstName, MiddleName and Last
Name
• There should not duplicate columns in any table - like
we should not have columns like address1,address2
2NF
• Every non-key column in dependent on primary key and
DB is in 1NF.
Ex: In customer table ( CustomerId, CustomerName,
CustomerAge, CustomerCity) CustomerCity is not
dependent on CustomerId so it should be removed from
Customer Table and should be put somewhere else.
,3NF:
• When every non-key column is independent of every
other non-key column
EX: Customer Table ( CustomerId, CustomerName,
CustomerAge,CustomerDateOfBirth) CustomerAge and
CustomerDateOfBirth are dependent on each other so
one should be removed.
Q1- Explain the different types of join operations. What
are they and how do they work? - correct answer-
Inner join: only returns rows meeting criteria
Cross join: Performs relational product of two tables
Natural join: Returns all rows with matching values in the
matching columns. Eliminates duplicate columns. Used
when tables share one or more common attributes with
common names
Join USING: Returns only rows with matching values in the
column indicated in the USING clause
, Join ON: Used when tables have no common attributes
Outer Join: Returns rows with unmatched attribute values
for tables to be joined
Left & Right: designate order in which tables are
processed
Left: Returns rows matching the join condition. Returns
rows in left side table with unmatched values
Right: Returns rows matching join condition. Returns rows
in right side table with unmatched values
Full: Returns rows matching join condition. Returns all
rows with unmatched values in either side table
Q1- List and briefly describe the three types of system
maintenance activities. - correct answer- i)
