Part A: Draw the ER diagram

Identify the business situation $($a small$/$medium size business$),$ that you wish to design a

database for. The situation needs to be a real life one $($not an imaginary company for

example$)$ and ideally be something you are interested in or familiar with. Topics might

include hobbies $($cricket teams, online games$),$ associations $($hockey clubs, childcare centre$),$

work$-$related concerns $($fishing boats, student enrolments, art gallery$)$ or other interests

$($Star Wars$).$

Try to pick an application that is relatively substantial $($one that has too many customers and

interact with the environment such as government$/$suppliers$/$teachers$/$companies$/$etc$,$ but

not too enormous. If you decide to choose your own business situation $($i$,$ e if you want to

create a new business$)$ you will need to discuss with your lecturer if it is appropriate.

If you are unable to come up with your own you have the option of choosing from a list of

choices at the end of the document. No group can choose the same case, unless there is

sufficient difference in the case $($Remember it will need to be based on a real practical

situation$).$

For example, when expressed in the ER diagram, you might want your design to have a

range of entities $($more than $4),$ and a similar number of relationships.

You should certainly include different kinds of relationships $($many$-$one, many$-$many$)$ and

different kinds of data $($Alphanumeric$,$ Numbers, etc.$),$ as well as attribute types.

Please hand in the following: Part B: Map the ER diagram to $3$NF & Normalisation

$1-$Map the ER diagram to $3NF$

Translate your ER Diagram into a schema of normalised tables. These must be in at

least $3$rd Normal Form $($database schema$)$

$2-$Normalisation

Use a flat structure table include all attributes:

Determine functional dependencies

Use $3$ nf to develop the relations, show as

Text notation

List of choices

Fast food outlet $-$ food ordering

Gym trainer $-$ managing clients$-$exercise routines

Enrolment system

IT LOGIT system

Taxi system $-$ recording car and journey of a passenger

Childcare centre

Sport club$-$tracking teams

Investment $-$ tracking buy and selling shares and investments

Real estate

Hotel

Hospital management system database project

Health care organization database project

Restaurant management database project

Art gallery management database project

School behaviour management project

Construction project. can you please give me answer in figure and table