Describe the two phases in designing databases that arise from the development of new information systems.
The two phases of development of databases for a new information system are:
- Create a data model: point out the complexities that are might be possessed in the database design (the second phase). These complexities could be the relation of the different data sets to each other. The dependencies of different data tables on each other and so on.
- Database Design: This is the phase where the data model is transformed into a database design. The main features of database design like foreign keys and intersection tables are added in this phase.