Week 3

Which of the following is not an advantage of a Database Management System (DBMS)?

• Improved data sharing

• Reduced data redundancy

• Increased data inconsistency

• Program-data independence

Which type of relationship is characterized by each team having only one home stadium?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

What is the purpose of data normalization in database design?

• To make complex databases more efficient by breaking large tables into smaller ones.

• To increase data redundancy for faster access.

• To add extra fields to tables.

• To remove unique identifiers from tables.

Which of the following is an example of a relational model structure?

• Parent-Child Relationships

• Two-dimensional tables with rows and columns

• Web data linking structures

• Tree-like hierarchical structures

Which of the following database models allows for many-to-many relationships?

• Hierarchical Model

• Relational Model

• Single-Tier Model

• Sequential Model

Which recent development in databases involves integrating many large databases into one repository?

• Data Marts

• Data Warehouses

• Client-Server Computing

• Object-Oriented Databases

What is the main purpose of a Data Dictionary in a database management system?

• To describe each piece of information in the database, including key fields and data types.

• To store user login information.

• To manage transactions and concurrency.

• To create a backup of the database.

Which of the following is a technique used in data mining?

• Sequential Data Processing

• Online Transaction Processing (OLTP)

• Extracting patterns from large datasets

• Using a hierarchical model for data analysis

Which of the following is not a key database activity?

• Data entry using forms

• Retrieval using queries

• Manual data sorting

• Structured Query Language (SQL)

Which entity relationship model is best for representing data where each entity can have multiple parents and multiple children?

• Hierarchical Model

• Relational Model

• Network Model

• Star Schema