MrsSimpson

This lecture goes through the basic Relational Data Model (for RDBMS). We cover entities and attributes, keys (both primary and foreign) and how to join data (natural joins, left joins, right joins, etc). We also cover relationship types (1:1, 1:M, M:M) and introduce the concept of Normalization.

This chapter goes more in depth with Entity Relationship (ER) modeling (diagrams). Understanding the different types of relationships, weak and strong relationships, degrees and associative (composite) entities (which are used to join two M:N entities).

In this video, we start to build our data models. (Entity Relationship Diagram - ERD) The most important step is to build your business rules to understand how the existing system works and to ensure that you and the client are on the same page. Do you understand the problem? Solving the wrong problem isn't going to help you!

In this video, we cover different database systems, why you need a DBMS and some basic introduction topics. What is the importance of database design and how has it evolved over the years. The textbook we are using is Coronel and Morris Database Systems (13th Edition). This lecture is designed for an Introduction to Databases college level course. I teach at Great Falls College, Montana State University in the Computer Technology Department