8.1 Overview of Database Design

Figure 8-1: Database Design Activities in the System Design Phase

8.1 Overview of Database Design

Database is where all the information system's data are kept as records and will be accessed again for the system's used. Database is a main component in any system where we keep records. Figure 8-1 shows that database design is one of the activity involved during the system design. Data are a core of a system element. In the previous lesson, we have learned how Data Flow Diagram and Entity-Relationship Diagram have been used to depict the data requirements of a system. When designing a database, we should define data in a fundamental form called normalized data. The main purpose of database design is to structure the data in a stable structure so that it's easy to manage data and less redundancy.