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

• ER Diagram (ERD) - Definition & Overview | Lucidchartlucidchart.com
• Everything I know about good system designseangoedecke.com
• NoSQL - Database Systemscs186berkeley.net
• Notes on Data Modeling | 6.1040 Fall 202261040-fa22.github.io
• Build Your Own Databasenan.fyi
• GitHub - donnemartin/system-design-primer: Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.github.com
• GitHub - karanpratapsingh/system-design: Learn how to design systems at scale and prepare for system design interviewsgithub.com
• Iterators and Joins - Database Systemscs186berkeley.net
• DBMS Normalization: 1NF, 2NF, 3NF Database Exampleguru99.com
• The Beginner's Guide to Databasestechnically.substack.com
• Recovery - Database Systemscs186berkeley.net
• Database Fundamentalstontinton.com