Coursework $-$ Assessment $2$: Individual

WORKSHOP $-$ ONLINE SUBMISSION REQUIRED $(20\%)$

DATABASE DESIGN & MODELLING : Logical data base design, Normalization and establishing Relationship.

Due date: $3^{rd}$ Feb $2024,11$:$00$ PM SGT

Note: Read ALL the instruction before you begin, it may save you lots of time.

In this workshop, you will gain solid understanding of the relational data model including the

general properties of relations and the characteristics of well$-$structured relations. You will also

fill with a firm grasp on the principles of functional dependencies and related concepts of

normalization.

CASE STUDY:

$,$

Having reviewed your logical models, Relationships and Normalization with the appropriate entities,

you are now ready to move to the project $-$ logical design and normalization. Your deliverable is the

creation of a normalized dataset, tables, relationship and keys identification.

Deliverables:

Do Normalization by Applying UNF, $1$NF$,2$NF and $3$ NF and List Dataset

Find Tables and Set PK$,$ FKs and Composite Keys. Establish a relationship between tables

Note: you can use Access S$/$w or a Power point s$/$w to complete the task.

Print screen the same and attach in word document

TASKS

Normalize for inventory management system, identify dataset by applying UNF, $1$NF$,2$NF

and $3NF$

Analyze and document the Tables and functional dependencies between the table by identifying

PKs$,$ FKs and composite Keys. Establish a relationship between the table$($ER Diagram$)$

$(10$ marks$)$

Include both your normalized relational dataset as well as finalized tables with relationship into

a word document. Attach a cover page with Student Name, Student ID$,$ Lecturer Name and

Submission Date and Time to Blackboard submission link for grading.

Submission: Submit as word file$($studentname$-$Workshop.docx$)$ to Blackboard workshop submission Link.