Proposed database system is developed through four phases:
Analysing and documenting requirements based on the data requirements, transaction requirements and business rules.
Drawing an EER model based on the identified requirements.
Mapping the EER model to the relational model and normalize the relational schema.
Inputting the final normalize relational schema into SQL.
