In this lesson we talk about how to map our conceptual schema to relational database tables in the optimal normal form.
Month: September 2019
In this lesson we talk about some other constraints you can include in your CS diagram.
In this lesson we talk about how to add unique constraints (many to one, one to many, many to many, one to one)
In this tutorial we talk about how to combine surplus entities and state derived entities in our CS diagrams.
Now that you’re okay with drawing CS diagrams with binary relationships, let’s put in some ternary/nested relationships.
In this lesson we start drawing conceptual diagrams – step 2 in information analysis for database design.
In this lesson we talk about what ORM is, and the steps required to use ORM to design a relational database, starting with step 1 – writing elementary sentences.
In this table we talk about the benefits of a relational database as opposed to a flat file database.
In this video we talk about what flat file databases are, and why they are not good databases for storing large amounts of data.
Before I could explain what ORM is, I felt like we needed to talk about what a database is.