90 likes | 138 Views
Database Design. Beginning. Sylabus. Overview of Database Design Analyzing and Modeling Business Requirements Designing the Database Life After Design. Overview of Database Design. Understanding Database Fundamentals Exploration of Database Models Database Design Planning
E N D
Database Design Beginning
Sylabus • Overview of Database Design • Analyzing and Modeling Business Requirements • Designing the Database • Life After Design
Overview of Database Design • Understanding Database Fundamentals • Exploration of Database Models • Database Design Planning • The Database Design Life Cycle
Analyzing and Modeling Business Requirements • Gathering Business and System Requirements • Establishing a Business Model • Understanding Entities and Relationships • Normalization: Eliminating Redundant Data • Entity Relationship Modeling • Modeling Business Processes
Designing the Database • Designing Tables • Integrating Business Rules and Data Integrity • Designing Views • Applying Database Design Concepts
Life After Design • Implementing Database Security • Change Control • Analyzing Legacy Databases for Redesign
Bahan Ajar Referensi : • Toby Teorey . . . [et al.]. 2011. DATABASE MODELING AND DESIGN Logical Design Fifth Edition, New Jersey: Elsevier. • Rebecca M. Riordan, Designing Effective Database Systems, Addison Wesley Professional, 2005 • Gavin Powell, Beginning Database Design, Wiley Publishing, 2006 • Lecture’s Slide.
Database Design Review Basis Data