Module quiz: Database design

A logical database schema introduces a blueprint of how the data is organized and related in tables.

• False

• True

Which column is the primary key in the following Patients table?

• Date of Birth

• Email

• Patient name

A foreign key is used to connect tables in a database.

• True

• False

The normalization process aims to reduce the negative effects of the different types of data anomalies.

• False

• True

Identify the issue with the following table of data in accordance with the rules of first normal form criteria

• Duplication of data.

• Atomicity problem.

To normalize the following table of data, you must decompose it into how many tables?

• Two tables (departments and courses).

• Four tables (departments, directors, courses, and tutors).

• Three tables (departments, courses, and tutors).

The table below contains a composite primary key made up of the columns "Tutor ID" and "Subject". What kind of normalization problem does this composite key create?

| Tutor ID | Subject | Credits | | --- | --- | --- | | T1 | Java | 20 | | T1 | Web | 15 | | T2 | Math | 15 | | T2 | History | 20 |

• Second normal form partial dependency

• First normal form data redundancy

Which of the following statements is the correct syntax to define a foreign key that links the "Players" and "Games" table in an ER diagram?

• CREATE TABLE Games( gameID int NOT NULL, playerID int, PRIMARY KEY (gameID), FOREIGN KEY (playerID) REFERENCES players(playerID));

• CREATE TABLE Games( gameID int NOT NULL, playerID int, PRIMARY KEY (gameID), FOREIGN KEY (gameID) REFERENCES players(gameID));

A database relation is in second normal form if it is in first normal form and every non key attribute is __________ functionally dependent on the primary key.

• Fully

• Partially

Database normalization is a progressive process, which means that the database relation cannot be in the third normal form if it is not already applying the rules of the first and the second normal forms.

• True

• False