# Module quiz: Database design
1. **A logical database schema introduces a blueprint of how the data is organized and related in tables.**
* False
* True
2. **Which column is the primary key in the following Patients table?**
* Date of Birth
* Email
* Patient name
3. **A foreign key is used to connect tables in a database.**
* True
* False
4. **The normalization process aims to reduce the negative effects of the different types of data anomalies.**
* False
* True
5. **Identify the issue with the following table of data in accordance with the rules of first normal form criteria**
Department ID | Department Name | Director | Course ID | Course Name | Tutor ID | Tutor |
D1 | Computing | Dr Karl | C1 | Database | T1 | Mark |
D1 | Computing | Dr Karl | C2 | Python | T1 | Mark |
D1 | Computing | Dr Karl | C3 | Web | T2 | Jack |
D1 | Computing | Dr Karl | C4 | Java | T2 | Jack |
D2 | Math | Dr Mosa | C5 | Math | T3 | Rose |
* Duplication of data.
* Atomicity problem.
6. **To normalize the following table of data, you must decompose it into how many tables?**
Department ID | Department Name | Director | Course ID | Course Name | Tutor ID | Tutor |
D1 | Computing | Dr Karl | C1 | Database | T1 | Mark |
D1 | Computing | Dr Karl | C2 | Python | T1 | Mark |
D1 | Computing | Dr Karl | C3 | Web | T2 | Jack |
D1 | Computing | Dr Karl | C4 | Java | T2 | Jack |
D2 | Math | Dr Mosa | C5 | Math | T3 | Rose |
* Two tables (departments and courses).
* Four tables (departments, directors, courses, and tutors).
* Three tables (departments, courses, and tutors).
7. **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
8. **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?**
![Players and Games table connected by foreign key](https://d3c33hcgiwev3.cloudfront.net/imageAssetProxy.v1/9156f5f2-345f-43c4-9a34-028b1bc74fe7image1.png?expiry=1731283200000&hmac=NO7gVoHhud9WntunMpZu_hUq_3MwnX_rHWKnhCXRPlQ align="left")
* 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));
9. **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
10. **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
---
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731151492495/82ba296f-1569-4a76-a644-918e22ba3b49.png align="center")