ITSS 4300 Exam #1 (Quiz Questions)
The only way to access data in a database is through the DBMS. T/F - ✔✔True
_____ is the result of revealing the meaning of raw facts. - ✔✔Information
The term _____ refers to an org
...
ITSS 4300 Exam #1 (Quiz Questions)
The only way to access data in a database is through the DBMS. T/F - ✔✔True
_____ is the result of revealing the meaning of raw facts. - ✔✔Information
The term _____ refers to an organization of components that define and regulate the collection,
storage, management and use of data within a database environment. - ✔✔Database System
A disadvantage of the relational database management system (RDBMS) is its inability to hide
the complexities of the relational model from the user. - ✔✔False
A(n) _____'s main function is to help one understand the complexities of the real-world
environment. - ✔✔Model
Which of the following is true of NoSQL databases? - ✔✔They are not based on the relational
model.
The one-to-many (1:M) relationship is easily implemented in the relational model by putting the
foreign key of the "1" side in the table of the "many" side as a primary key. - ✔✔False
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column
has no null entries, and all entries are unique. This is an example of _____ integrity. - ✔✔Entity
A _____ contains at least all of the attribute names and characteristics for each table in the
system. - ✔✔Data dictionary
Referential _____ dictates that the foreign key must contain values that match the primary key in
the related table, or must contain null. - ✔✔Integrity
Each table in a relational database must have a primary key. - ✔✔True
The SELECT operator yields a vertical subset of a table. - ✔✔False
A _____ is the primary key of one table that has been placed into another table to create a
common attribute. - ✔✔Foreign Key
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column
has no null entries, and all entries are unique. This is an example of _____ integrity. - ✔✔Entity
A(n) _____ join links tables by selecting only the rows with common values in their common
attribute(s). - ✔✔Natural
_____ relationships can be implemented by creating a new entity in 1:M relationships with the
original entities. - ✔✔M:N
An entity in the entity relationship model corresponds to a table in the relational environment. -
✔✔True
Connectivities and cardinalities are established by concise statements known as business rules. -
✔✔True
In implementation terms, an entity is existence-dependent if it has a mandatory primary key. -
✔✔False
A weak relationship exists if the primary key of the related entity contains at least one primary
key component of the parent entity. - ✔✔False
Relationships between entities always operate in one direction. - ✔✔False
The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.
- ✔✔Conceptual
The decision to store _____ attributes in database tables depends on the processing requirements
and the constraints placed on a particular application. - ✔✔Derived
If Tiny College has some departments that are classified as "research only" and do not offer
courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.
- ✔✔Optional to
Database design is a(n) _____ process based on repetition. - ✔✔Iterative
The entity supertype contains common characteristics, and the entity subtypes each contain their
own unique characteristics. - ✔✔True
Within a specialization hierarchy, a supertype can exist only within the context of a subtype. -
✔✔False
A subtype contains attributes that are common to all of its supertypes. - ✔✔True
Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set. -
✔✔False
Implementing overlapping subtypes requires the use of one discriminator attribute for each
subtype. - ✔✔True
Normalization is a process that is used for changing attributes to entities - ✔✔False
Denormalization produces a lower normal form. - ✔✔True
3NF takes care of which type of dependency - ✔✔Transitive Dependency
2NF takes care of which type of dependency - ✔✔Partial Dependency
Since a partial dependency can exist only if a table's primary key is composed of several
attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in
2NF. - ✔✔True
[Show More]
