Some knowledge of database design terminology and techniques is required, and while this course does delve into the details of the six$-$step relational database design technique, you will learn, from examples, how this technique can be used to create a sturdy, reliable, and accurate relational database model. The extensive supplemental resources $($handouts$)$ that compliment the video tutorials allow you to fully understand how the six$-$step relational database design technique works.

You will learn what the six steps of Six$-$Step Relational Database Design are, and how they work to transform a problem statement into a Crow's Foot relational database model using three examples.

Case Studies in Six$-$Step Relational Database Design $/$ Udemy

Important note $-$ Questions that require coding, drawing tables or diagrams must be answered using a Word document and submitted as a 'File upload' on MANCOSA Connect. Please ensure that all work is clearly labelled.

QUESTION $1$

$(20$ Marks$)$

Crows's Foot notation is one of Entity relationship diagrams $($ERD$)$ used by database designers to depict the relationship among various entities. This is part of the Data Modelling concept in database management systems.

$1\mathrm{.}1$ Present traditional data models.

$(10$ Marks$)$

$1\mathrm{.}2$ Formulate Crows Foot Notation relationships two indicators?

$(10$ Marks$)$