Data Modeling and a Framework for Database System Design

Click CS403-Courtney-Paradice-Database-Systems-for-Management-CCBY-chapters3-4.pdf link to view the file.

Read chapters 3 and 4. In chapter 3, the three ANSI/SPARC schemas are presented as phases of database development: the requirements phase, the high-level design phase, the detailed design phase, and the implementation phase. These correspond to the external model, the internal model, and the physical model, respectively. This chapter also describes entity-relationship modeling as a means of representing a conceptual model. Chapter 4 discusses conceptual modeling for hierarchical, network, and relational databases.