Database Design

Textbook References

Digital Book: Chapter 2: Unit 2.1 - 2.3
Red Textbook: Module 4.1

Multiple Choice

Why is it important to transform unorganized data into a structured database system?

• To improve data security and accessibility

• To make the data look more visually appealing

• To reduce the number of files stored

• To increase the speed of internet connection

Open Ended

How do data integrity and data independence contribute to the effectiveness of a database system?

Multiple Choice

Which of the following is an example of a non-physical measure for protecting data security?

• Biometric security

• Security companies

• Data encryption

• Off-site cloud servers

Open Ended

Explain why storing multiple entities in a single table can lead to data redundancy and errors. Use the example shown in the image.

Multiple Select

Which of the following are anomalies that can occur in a flat file database?

• Insert anomaly

• Delete anomaly

• Update anomaly

• Primary key anomaly

Open Ended

Describe the first step in normalization and explain its importance in database design.

Multiple Select

Which of the following actions help achieve atomicity and remove redundancy in database tables?

• Splitting multi-value fields

• Removing calculated fields

• Repeating client details in every order

• Combining all data into one table

Multiple Choice

Why is it important to allocate a Primary Key (PK) to each table in a database?

• To ensure every record is uniquely identifiable

• To allow duplicate records in the table

• To store additional information about each record

• To make the table look organized

Multiple Choice

How does the use of foreign keys help in creating relationships between tables?

• By linking records in one table to records in another table

• By duplicating data across tables

• By deleting unrelated records automatically

• By increasing the number of tables in the database

​

Open Ended

Explain how referential integrity prevents orphaned records in a relational database.

Multiple Choice

Which of the following fields in the tblCompanies table is considered redundant and why?

• Age, because it can be calculated from the Founded date

• Company, because it is the same for all apps

• Employees, because it is a large number

• Founded, because it is not needed

Multiple Choice

In the final ERD architecture, what type of relationship exists between tblCompanies and tblApps?

• One-to-Many

• Many-to-Many

• One-to-One

• Self-Referencing

Multiple Choice

Which of the following is NOT a characteristic of a good database?

• Data Integrity

• Data Independence

• Physical Independence

• Data Redundancy

Open Ended

Summarize the main characteristics that make a database good, and explain why these characteristics are important for organizations.

Multiple Choice

What are the key benefits of a normalized database as described in the image?

• It ensures integrity, independence, and security, turning raw data into a reliable asset.

• It increases the amount of raw data stored without organization.

• It makes software applications less efficient.

• It focuses only on data visualization, not structure.