Midterm 1

Which of the following is NOT an advantage of a database system?

• Data redundancy

• Data integrity

• Data security

• Data independence

Which database component is responsible for managing access, integrity, and security?

• Application developer

• Database administrator (DBA)

• End-user

• Data analyst

Which of the following best describes a DBMS?

• A hardware component

• A software system to manage databases

• A programming language

• A network protocol

The three-level database architecture includes which of the following levels?

• Physical, Logical, and Internal

• Conceptual, External, and Internal

• Conceptual, Physical, and Normalized

• External, Physical, and Logical

Which of the following is NOT a key characteristic of data quality?

• Accuracy

• Redundancy

• Consistency

• Timeliness

Which of the following is NOT a type of entity relationship?

• One-to-One

• One-to-Many

• Many-to-Many

• Self-to-Recursive

Which component in the ER model represents an attribute that can uniquely identify an entity?

• Composite attribute

• Primary key

• Foreign key

• Derived attribute

Which of the following is a valid notation for representing relationships in an ER diagram?

• Arrow notation

• Diamond notation

• Circle notation

• Box notation

Which of the following is an example of a weak entity?

• Employee

• Order

• Student

• Dependent

What is the main purpose of cardinality constraints in an ER model?

• To define the attributes of an entity

• To determine the number of relationships an entity can have

• To normalize the database

• To identify the primary key