Introduction to Database Design
The data is an important corporate resource of an organisation and the database is a fundamental component of an information system. Therefore, management and control of the corporate data and the corporate database is very important. Database design is a process of arranging the corporate data fields into an organised structure needed by one or more applications in the organisation. The organised structure must foster the required relationships among the fields while confirming to the physical constraints of the particular database management system in use. This structure must result into the advantages as explained in Chapter 1, Section 1.8.5, such as:
- Data redundancy.
- Data independence. ...