Database Fundamentals
What is a broad definition of data? - ANS-Raw facts that are captured on printed or
digital media
What are data? - ANS-Facts that are collected and stored in a database system.
What is a determining characteristic of unstructured data? - ANS-It does not follow a
data model.
What is true about flat files? - ANS-They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - ANS-Flat files.
How were data retrieved before database management systems? - ANS-Sequentially
from simple files.
What is the uniquely identifiable element about which data can be categorized in an
entity-relationship diagram? - ANS-Entity Types
Which data classification is an entity? - ANS-Event
A sales person is authorized to sell 12 products; a product can be sold by 10
salesperson. Which kind of binary relationship is described? - ANS-Many to many
Which three kinds of rules for referential integrity are provided by modern relational
database management systems? - ANS-Delete Update Insert
What is an important aspect of referential integrity? - ANS-Reference to data in one
relation is based on values in another relation.
Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find salesperson with a
commission percentage of 15? - ANS-WHERE COMMPERCT=15
What is a broad definition of data? - ANS-Raw facts that are captured on printed or
digital media
What are data? - ANS-Facts that are collected and stored in a database system.
What is a determining characteristic of unstructured data? - ANS-It does not follow a
data model.
What is true about flat files? - ANS-They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - ANS-Flat files.
How were data retrieved before database management systems? - ANS-Sequentially
from simple files.
What is the uniquely identifiable element about which data can be categorized in an
entity-relationship diagram? - ANS-Entity Types
Which data classification is an entity? - ANS-Event
A sales person is authorized to sell 12 products; a product can be sold by 10
salesperson. Which kind of binary relationship is described? - ANS-Many to many
Which three kinds of rules for referential integrity are provided by modern relational
database management systems? - ANS-Delete Update Insert
What is an important aspect of referential integrity? - ANS-Reference to data in one
relation is based on values in another relation.
Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find salesperson with a
commission percentage of 15? - ANS-WHERE COMMPERCT=15
