Chapter 5: Data Modelling Flashcards
From Database Design book
Conceptual Model
The logical structure of the entire database
Conceptual Schema
Another term for logical schema
Data Independence
The immunity of user applications to changes made in the definition and organization of data.
Data Model
A collection of concepts or notations for describing data, data relationships, data semantics and data
constraints
Data Modelling
The first step in the process of database design
Database Logical Design
Defines a database in a data model of a specific database management system.
Database Physical Design
Defines the internal database storage structure, file organization or indexing techniques.
Entity Relationship Diagram (ERD)
A data model describing the database showing tables, attributes and relationships.
External Model
Represents the user’s view of the database.
External Schema
User view
Internal Model
A representation of the database as seen by the DBMS.
Logical Data Independence
The ability to change the logical schema without changing the external schema.
Logical Design
Where you create all the tables, constraints, keys, rules, etc.
Logical Schema
A conceptual design of the database done on paper or a whiteboard, much like architectural drawings for a house
Operating System (OS)
Manages the physical level of the physical model
