Instructions

$1.$ Students will be divided into groups with max members of $4$ people.

$2.[$Identification of performance problem$]$ Your group is free to choose the case that will be used to solve the problem.

$3.[$Identification of performance problem$]$ The case must be related to one of these industry sectors:

a$.$ Health

b$.$ Energy

c$.$ Communication

d$.$ Insurance

e$.$ Tourism

$4.[$Preparation for the sample data$]$ Determine the sample data that you will use to apply to the application to be built.

$5.[$Preparation for the sample data$]$ Each group should not use the same case $($especially about your sample data$).$

$6.[$Preparation for the sample data$]$ The collected sample data must be in Un$-$normal form.

$7.[$Overcoming and recognizing data anomalies and functional dependencies$]$ After collecting the sample data, it is necessary to check for anomalies and functional dependencies in the sample data.

$8.[$Implementing normal form techniques$]$ The system that you build must apply the stages in the design of normalization techniques, from unnormal until $3$NF$.$

$9.[$Implementing normal form techniques$]$ After the sample data is applied to $3$NF$,$ consider is it necessary to apply BCNF on the current $3$NF sample data and explain the reason for your decision.

$10.[$Refining an ER Diagram$]$ After the sample data is applied to $3$NF$/$ BCNF$,$ it must be refined into an ERD $($Crow$`$s foot or Chen method$)$

$11.$ For submissions, each group must submit a report and presentation.

The report contains:

a$.[$Identification of performance problem$]$ Chapter $1$ The description of the case used

b$.[$Identification of performance problem$]$ Chapter $2$ The problem you identified $($this chapter should describe why the case needs a database$).$

c$.[$Overcoming and recognizing data anomalies and functional dependencies$]$ Chapter $3$ The sample data description and list of anomalies may occur.

d$.[$Implementing normal form techniques$]$ Chapter $4$ Implementation of normalization $($detail step by step of normalization from un$-$normal form$).$

e$.[$Implementing normal form techniques$]$ Chapter $5$ Conclusions.

$12.$ For the presentation, each group only takes $5-10$ minutes.

Note: yes this group project and no my team doesnt aswear any my call so i doit alone and i know it need to make a report but i dont know what kind of repor is it report where i just type the world or i add something, if can give example or if you can answear it tahnks