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

Patients

Patient Name

Date Of Birth

Email

Karl

19/03/2000

karl.k@luckyshrub.com

Mark

20/05/1999

mark.f@luckyshrub.com

Peter

10/03/2001

peter.g@luckyshrub.com

Peter

19/03/2000

peter.s@luckyshrub.com

Practice More Questions From: Module quiz: Database design

Q:

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

Q:

Which column is the primary key in the following Patients table? Patients Patient Name Date Of Birth Email Karl 19/03/2000 karl.k@luckyshrub.com Mark 20/05/1999 mark.f@luckyshrub.com Peter 10/03/2001 peter.g@luckyshrub.com Peter 19/03/2000 peter.s@luckyshrub.com

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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?

Q:

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.

Q:

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.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments