Database Design.pptVIP

Database Design Models A data model is a collection of objects that can be used to represent a set of data and operations to manipulate the data Conceptual models are tools for representing reality at a very high-level of abstraction Logical models are data descriptions that can be processed by computers Conceptual model: Entity-Relationship Diagrams Entities represent classes of real-world objects. Person, Students, Projects, Courses are entities of a University database Relationships represent interactions between two or more entities Example: Every employee works in at least one project