CIS154 — Database Modeling and Design
Top-down, systematic approach to defining a database design based on analysis of business information and requirements. Identifying and evaluating standard data model and design patterns. Developing an entity-relationship (ER) diagram that accurately reflects the business. Mapping the ER diagram to an initial database design and revising for complex entities, attributes, and relationships.