QUIZ 3 - Data Design and Database Management

What is the primary purpose of a database management system (DBMS)?

• To store data in a file-oriented system

• To manage and analyze data efficiently

• To create physical storage devices

• To eliminate the need for data security

Which of the following best describes normalization?

• The technique for coding data in binary

• The method of storing data in physical media

• The process of organizing data to reduce redundancy

• The process of creating redundant data

What does a primary key do in a database?

• Stores multiple values in a single field

• Uniquely identifies a record in a table

• Links two tables together

• Represents a common field in multiple tables

In an entity-relationship diagram, what does cardinality represent?

• The relationship between two entities

• The number of fields in a table

• The type of data stored in a field

• The physical storage location of data

Which of the following is NOT a type of relationship in an entity-relationship diagram?

• One-to-many

• Many-to-many

• Many-to-few

• One-to-one

What is a foreign key?

• A field that contains repeating values

• A field that links two tables together

• A field that cannot be null

• A unique identifier for a record

Which coding scheme is commonly used on personal computers?

• Unicode

• Binary

• ASCII

• EBCDIC

What is the main advantage of using a DBMS over a file-oriented system?

• Simpler data access methods

• Better data security and integrity

• Increased data redundancy

• Lower cost of implementation

What does referential integrity ensure in a relational database?

• Data can be duplicated across tables

• Foreign key values must match primary key values

• All data is stored in one table

• All fields must be unique

Which of the following is a characteristic of data warehousing?

• It stores data in a single file

• It is used for real-time transaction processing

• It integrates data from multiple sources

• It only contains structured data