NSC Information Technology Data validation: Consider the entity relationship

Question

Consider the entity relationship diagram (ERD) below and answer the questions that follow.

4.1.1 What is the purpose of an ERD? (2)

4.1.2 Choose the most suitable term from the list below for the part of the ERD above that is indicated by (a) to (d).

NOTE: You are allowed to choose an option from the list ONLY ONCE.

Write down the letter ((a) to (d)) from the diagram and the selected term from the list below next to the question number (4.1.2).
- Entity
- Relationship
- Attribute
- Many
- One
- Mandatory
- Optional

4.1.3 A primary key needs to be unique when used in a normalised database.

Name ONE other requirement of a primary key. (1)

4.1.4 The design of the tblPlaylist table below is an attempt to compile a list of songs for the different genres, with sample data.

| Genre | Number of songs | Song 1 | Song 2 | Song 3 | Song 4 |
|-------|-----------------|--------|--------|--------|--------|
| Pop   | 3               | Go West| Shaggy | DoBeDo |        |
| R and B | 2             | Move On|        |        |        |
| Country | 3             | Let’s Dance | Jolene | Hey Jude |        |
| Classical | 2          | Sunset | Phantom |        |        |

a) Critically analyse the design of the tblPlaylist table by explaining why the table does not adhere to the rules of normalisation. (2)

b) Give a reason why it is more suitable to save the playlist information in a database rather than in a text file. (1)

Consider the entity relationship diagram (ERD) below and answer the questions that follow - NSC Information Technology - Question 4 - 2023 - Paper 2

Worked Solution & Example Answer:Consider the entity relationship diagram (ERD) below and answer the questions that follow - NSC Information Technology - Question 4 - 2023 - Paper 2

What is the purpose of an ERD?

Choose the most suitable term for (a) to (d)

Name ONE other requirement of a primary key.

Critically analyse the design of the tblPlaylist table by explaining why the table does not adhere to the rules of normalisation.

Give a reason why it is more suitable to save the playlist information in a database rather than in a text file.

Join the NSC students using SimpleStudy...