A beginner-friendly introduction to database system design covering core concepts and practical implementation. Topics include the components of a database system, types of databases (relational, NoSQL, cloud, etc.), the four stages of database design (requirements analysis, conceptual, logical, physical), and normalization through the first three normal forms. A hands-on section walks through designing a library database using PostgreSQL and pgAdmin 4, with SQL examples for creating tables with primary/foreign keys, inserting data, and querying with SELECT, WHERE, and JOIN.
Table of contents
Prerequisites and SetupWhat is a Database?Types of Database SystemsCharacteristics of a Good DatabaseStages of Database DesignThe Role of Normalisation in Database DesignPractical: Designing a Library SystemConclusionSort: