Database Design - PowerPoint PPT Presentation

yeary
database design n.
Skip this Video
Loading SlideShow in 5 Seconds..
Database Design PowerPoint Presentation
Download Presentation
Database Design

play fullscreen
1 / 9
Download Presentation
0 Views
Download Presentation

Database Design

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Database Design Beginning

  2. Sylabus • Overview of Database Design • Analyzing and Modeling Business Requirements • Designing the Database • Life After Design

  3. Overview of Database Design • Understanding Database Fundamentals • Exploration of Database Models • Database Design Planning • The Database Design Life Cycle

  4. 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

  5. Designing the Database • Designing Tables • Integrating Business Rules and Data Integrity • Designing Views • Applying Database Design Concepts


  6. Life After Design • Implementing Database Security • Change Control • Analyzing Legacy Databases for Redesign

  7. 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.

  8. Database Design Review Basis Data

  9. Any Question ?