Assessment 2: Database Normalization for MIS201 Students

This assignment presents a solution for a database normalization project, as required for the MIS201 Database Fundamentals course. The task involves normalizing a given database table through the first, second, and third normal forms (1NF, 2NF, and 3NF). The solution demonstrates the transformation of the initial table structure, addressing data redundancy and improving data integrity by breaking it down into related tables. The assignment showcases the application of normalization principles to create a well-structured database design. The solution provides the ERD and references to support the work.

Database Fundamentals

TASK 1

Normalise table in First normal form
School_phoneNo STU_Subject
9054 1321 Accounting Principles,
9054 1321 Business Law,
9054 1321 Quantitative Method
9067 1835 Introduction to Programming,
9067 1835 Database Fundamentals
9067 1835 Introduction to Programming,
9067 1835 Introduction to Information Systems
9054 1321 Introduction to Microeconomics,
9054 1321 Principles of Finance
SUBJECT
CODE
SUBJECT
CREDITPOI
NT
STU
SUBJECTMAR
K
STU
AVERAGEMAR
K
STU
SUBJECTGRA
DE
ACCT1001 6 60 70 P
BLAW100
2
6 70 C
QUAN100
3
6 80 D
BIT1001 12 50 55 P
BIT100 6 60 P
BIT1001, 12 70 75 C
STU_nam
e
STU_ph
oneNo
STU_DO
B
STU_hom
eCountry
STU_conti
net
STU_gend
er
STU_Schoo
l
STU_majo
r
John 1231 12/3/199
5
Australia Oceania Male Business Accounting
Nick 3213 1/2/2000 India Asia Female IT &
engineering
Software
developme
nt
William 9748 3/5/2015 India Asia Male IT &
engineering
Informatio
n
Systems
Kim 6383 12/2/199
0
China Asia Female Business Finance

Normalise table in second normal form
SUBJECT_CODE STU_SUBJECTMARK STU_name STU_School
ACCT1001 60 John Business
BLAW1002 70 Nick IT & engineering
QUAN1003 80 William IT & engineering
BIT1001 50 Kim Business
BIT100 60 - -
BIT1001, 70 - -
BIT1003 80 - -
FINC1001, 70 - -
FINC1002 70 - -

Cont.
SUBJECT_CODE STU_SUBJECTMA
RK
ACCT1001 60
BLAW1002 70
QUAN1003 80
BIT1001 50
BIT100 60
BIT1001, 70
BIT1003 80
FINC1001, 70
FINC1002 70
STU_name STU_School
John Business
Nick IT & engineering
William IT & engineering
Kim Business
- -
- -
- -
- -
- -

Normalise table in Third normal form
SUBJECT_CODE STU_SUBJECTMA
RK
ACCT1001 60
BLAW1002 70
QUAN1003 80
BIT1001 50
BIT100 60
BIT1001, 70
BIT1003 80
FINC1001, 70
FINC1002 70
SUBJECT_CODE STU_name STU_School
ACCT1001 John Business
BLAW1002 Nick IT & engineering
QUAN1003 William IT & engineering
BIT1001 Kim Business
BIT100 - -
BIT1001, - -
BIT1003 - -
FINC1001, - -
FINC1002 - -

ERD

REFERENCES
• Köhler, H. and Link, S., 2018. SQL schema design: foundations, normal forms, and
normalization. Information Systems, 76, pp.88-113.
• Wu, Y. and He, K., 2018. Group normalization. In Proceedings of the European conference on computer
vision (ECCV) (pp. 3-19).

THANK YOU