Part I: Entity Relationship Diagram

$[$

$1$

$0$

Marks

$]$

Create any type of real or hypothetical business case for which a database is

needed for storing data. In this business case, create your own business

rules according to which the business operates, and that the database must

conform to

$.$

Using this business case and your business rules, create an

entity relationship diagram

$($

ERD

$)$

that is part of the design for the required

database. For ease of submission and marking, please use MS Word for this

task, although it is not the ideal tool for it

$.$

$1$

$.$

Here are some considerations for your ERD:

$1$

$.$

$1$

$.$

There must be a minimum of two entities, and not more than four

entities.

$1$

$.$

$2$

$.$

Include as many attributes as you need, but no more than

necessary. Listing many attributes does not result in an allocation of

more marks.

$1$

$.$

$3$

$.$

Use the Crow

s Foot notation to resolve the relationship

$($

s

$)$

between

your entities.

$1$

$.$

$4$

$.$

Clearly indicate all primary key and foreign key attribute