Achieve Scheme Database Analysis and Design

COVER PAGE

Contents
Introduction.................................................................................................................................................3
Entity relationship Model............................................................................................................................3
Database Normalization..............................................................................................................................5
Database schema....................................................................................................................................6
Research report...........................................................................................................................................7
Reflection Summary....................................................................................................................................7
References...................................................................................................................................................8

Introduction
This report discusses the database analysis and design of the proposed Achieve Scheme database
management system. An entity relationship diagram is used to show the top down design of the
document and each entity in the entity relationship model is validated to make sure it’s in Boyce-Codd
Normal Form (BCNF). A research of a possible database visualization tool is proposed with justifications
as to why it’s the best tool suited for the proposed database.
Entity relationship Model
The diagram below shows the ERD of the proposed database.