DATABASE PROCESSING FUNDAMENTALS
DESIGN AND IMPLEMENTATION
COMPREHENSIVE EXAM SCRIPT VERIFIED
QUESTIONS AND SOLUTIONS GRADED
APLUS
●● Surrogate Key
Answer: an attribute that is added onto the table to the primary key.
●● Foreign Key
Answer: an attribute that serves as a primary key in another table to be
joined as a relationship between two tables
●● Primary Key
Answer: is a unique identifier by it
the values of these keys are used to create the relationships between
tables
●● Candidate Key
Answer: an attribute that's selected as a primary key but hasn't been
selected as the primary key
,●● Database Administrator
Answer: Those who designs, constructs and manages the database itself
●● Database Management System (DBMS)
Answer: a computer program used to create, process, and administer the
database and its applications
●● Structured Query Language (SQL)
Answer: the universal query language of structure and processing of a
relational database by all commercial DBMS
●● Metadata
Answer: data about data
●● Integrated Tables
Answer: tables that store both data and the relationships among the data
●● Normalization / Normal Form
Answer: a set of principles, collectively
●● Attribute
Answer: a property in an entity. A column of a relation. Entities that
describe their characteristics
, ●● Entity
Answer: something that users want to track. Is stored in one row of a
table. Some identifiable thing
●● Relation
Answer: a two-dimensional array containing single value entries and no
duplicate rows.
The rows must store data about an entity and columns must store data
about the characteristics about those entities
●● Entity Class
Answer: Entities of a given type are grouped by
●● Entity Instance
Answer: the occurence of a particular entity. Described by values of its
attributes.
●● Attributes EXAMPLES
Answer: EmployeeNumber, EmployeeName, Phone and Email
●● Entity Class EXAMPLES
Answer: Employee is the collection of all Employee entities
DESIGN AND IMPLEMENTATION
COMPREHENSIVE EXAM SCRIPT VERIFIED
QUESTIONS AND SOLUTIONS GRADED
APLUS
●● Surrogate Key
Answer: an attribute that is added onto the table to the primary key.
●● Foreign Key
Answer: an attribute that serves as a primary key in another table to be
joined as a relationship between two tables
●● Primary Key
Answer: is a unique identifier by it
the values of these keys are used to create the relationships between
tables
●● Candidate Key
Answer: an attribute that's selected as a primary key but hasn't been
selected as the primary key
,●● Database Administrator
Answer: Those who designs, constructs and manages the database itself
●● Database Management System (DBMS)
Answer: a computer program used to create, process, and administer the
database and its applications
●● Structured Query Language (SQL)
Answer: the universal query language of structure and processing of a
relational database by all commercial DBMS
●● Metadata
Answer: data about data
●● Integrated Tables
Answer: tables that store both data and the relationships among the data
●● Normalization / Normal Form
Answer: a set of principles, collectively
●● Attribute
Answer: a property in an entity. A column of a relation. Entities that
describe their characteristics
, ●● Entity
Answer: something that users want to track. Is stored in one row of a
table. Some identifiable thing
●● Relation
Answer: a two-dimensional array containing single value entries and no
duplicate rows.
The rows must store data about an entity and columns must store data
about the characteristics about those entities
●● Entity Class
Answer: Entities of a given type are grouped by
●● Entity Instance
Answer: the occurence of a particular entity. Described by values of its
attributes.
●● Attributes EXAMPLES
Answer: EmployeeNumber, EmployeeName, Phone and Email
●● Entity Class EXAMPLES
Answer: Employee is the collection of all Employee entities
