6.7 - Mapping an ER Model to a Logical Schema

Lecture 2 - BZAN 6356 Fall 2024

Lecture 1 - BZAN 6356 Fall 2024

10.2 - Multiple Table DDL

10.1 - Single Table DDL

SQL Project DDL Instructions

Tutorial - Importing data into PostgreSQL

Learn SQL - CRUD in SQL (Part 2)

Learn SQL - Stored Procedures and Triggers (Part 4)

Learn SQL - Creating SQL Views (Part 5)

Learn SQL - ACID and Transactions (Part 3)

Learn SQL - Creating and ERD and DDL (Part 1)

Write awesome SQL DDL using Excel

Candidate Keys and Normalization - Mighty Good University

DB 1 Assignment 4 Walkthrough

DB1 Assignment 1 Walkthrough

DB1 Assignment 2 Walkththrough

DB1 Assignment 3 Walkthrough

3.2 - Bearcat Incorporated Part 2

3.1 - Bearcat Incorporated Part 1

6.7 - Mapping an ER Model to a Logical Schema

1.3 - Limitations of File Systems

2.4 – Relationships

3.3 - Modeling Errors

2.6 - Deletion Constraints