AIS EXAM 2 EXAM SCRIPT 2026
COMPREHENSIVE QUESTIONS AND
VERIFIED SOLUTIONS
◉ Normalization involved identifying and removing structural
dependencies from tables being modeled.
Answer: True
◉ The E in REA stands for
Answer: events
◉ At least two REA agents participate in each economic event.
Answer: Ture
◉ An excel file can be a database.
Answer: False
◉ An REA diagram must link every event to at least one _____ and
two _____
Answer: Resource; Agents
,◉ Identify the attribute below that would not make a good primary
key.
A) A unique number automatically generated by the system
B)Postal Code
C) Cell Phone Number
D) Social Security Number
Answer: B) Postal Code
◉ What is the first step to implementing and REA diagram in a
relational database?
A) Identify Carnalities
B) Create Table for each distinct entity and each M:M relationship
C)Assign attributes to appropriate tables
D) Use foreign keys to implement 1:1 and 1:M relationships
Answer: B) Create Table for each distinct entity and each M:M
relationship
◉ A primary key does not have to be unique for each record.
Answer: False
,◉ A fully normalized database is called
A) fourth normal form (4NF)
B) Second normal form (2NF)
C)First normal form (1NF)
D) Third normal form (3NF)
Answer: D) Third normal form (3NF)
◉ A table is in the first normal form when it is
A) Free of partial dependencies
B) Free of repeating group data
C) Free of transitive dependencies
D) Free of update anomalies
Answer: B) Free of repeating group data
◉ Which of the following elements link rows in one table to rows in
another table?
A) Foreign keys
B) Semantic Keys
, C) Link Keys
D) Primary keys
Answer: A) Foreign keys
◉ The formal name for a row in a database table is
A) Schema
B) Tuple
C) Link
D) Attribute
Answer: B) Tuple
◉ Which acts as an interface between the database and the various
application programs?
A) Database Administrator
B) Data Warehouse
C) Database System
D) Database Management System
Answer: D) Database Management System
COMPREHENSIVE QUESTIONS AND
VERIFIED SOLUTIONS
◉ Normalization involved identifying and removing structural
dependencies from tables being modeled.
Answer: True
◉ The E in REA stands for
Answer: events
◉ At least two REA agents participate in each economic event.
Answer: Ture
◉ An excel file can be a database.
Answer: False
◉ An REA diagram must link every event to at least one _____ and
two _____
Answer: Resource; Agents
,◉ Identify the attribute below that would not make a good primary
key.
A) A unique number automatically generated by the system
B)Postal Code
C) Cell Phone Number
D) Social Security Number
Answer: B) Postal Code
◉ What is the first step to implementing and REA diagram in a
relational database?
A) Identify Carnalities
B) Create Table for each distinct entity and each M:M relationship
C)Assign attributes to appropriate tables
D) Use foreign keys to implement 1:1 and 1:M relationships
Answer: B) Create Table for each distinct entity and each M:M
relationship
◉ A primary key does not have to be unique for each record.
Answer: False
,◉ A fully normalized database is called
A) fourth normal form (4NF)
B) Second normal form (2NF)
C)First normal form (1NF)
D) Third normal form (3NF)
Answer: D) Third normal form (3NF)
◉ A table is in the first normal form when it is
A) Free of partial dependencies
B) Free of repeating group data
C) Free of transitive dependencies
D) Free of update anomalies
Answer: B) Free of repeating group data
◉ Which of the following elements link rows in one table to rows in
another table?
A) Foreign keys
B) Semantic Keys
, C) Link Keys
D) Primary keys
Answer: A) Foreign keys
◉ The formal name for a row in a database table is
A) Schema
B) Tuple
C) Link
D) Attribute
Answer: B) Tuple
◉ Which acts as an interface between the database and the various
application programs?
A) Database Administrator
B) Data Warehouse
C) Database System
D) Database Management System
Answer: D) Database Management System
