1 / 9

Comprehensive Database Design Guidebook: From Modeling to Implementation

Dive into the world of database design with this comprehensive guidebook covering the overview, requirements analysis, database modeling, and post-design implementation. Understand database fundamentals, entity relationships, normalization, and business processes to create efficient database systems. Explore topics like database security, change control, and legacy database analysis for redesign. This resource-based syllabus offers practical insights and hands-on techniques to master the art of designing robust databases.

yeary
Download Presentation

Comprehensive Database Design Guidebook: From Modeling to Implementation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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 ?

More Related