DB Design | Database Systems

Online textbook for CS186, Berkeley’s Database Systems course.

DB Design - Database Systems DB Design | Database Systems Search Menu Expand Document Database Systems Save this note as PDF Introduction So far, we’ve learned how to use already built databases: SQL queries! We also learned the internals of a database management system which includes many abstraction levels. But what happens if we are given a high-level description of what data we want to store with our database? How do we design a database to fit out needs? We will discuss these question in this module! Entity-Relationship Models When designing a database, we often use Entity-Relationship Mo

related reading

• DBMS Normalization: 1NF, 2NF, 3NF Database Exampleguru99.com
• ER Diagram (ERD) - Definition & Overview | Lucidchartlucidchart.com
• NYSRGnotes.ekzhang.com
• GitHub - donnemartin/system-design-primer: Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.github.com
• Notionnanransohoff.com
• Notes on Data Modeling | 6.1040 Fall 202261040-fa22.github.io
• The Beginner's Guide to Databasestechnically.substack.com
• Readings in Database Systems, 5th Editionredbook.io
• Analysis of Open Government Datasets From a Data Design and Integration Perspectiveopenproceedings.org
• Outerbase | The interface for your databaseouterbase.com
• Database Cryptography Fur the Rest of Us - Dhole Momentssoatok.blog
• A More Human Approach To Databasesccorcos.github.io