Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATA, DATABASES, AND DATA SCIENCE, Database design course (Introduction,…
DATA, DATABASES, AND DATA SCIENCE
Database design course
-
-
- What is a relational database
-
-
-
-
-
-
-
-
-
-
- One-to-Many relationships
- Many-to-Many relationships
- Designing one-to-one relationships
- Designing one-to-many relatioships
- Parent tables and child tables
- Designing many-to-many relatioships
-
-
-
-
- superkey and candidate key
- Primary key and alternate key
- surrogate key and natural key
- should i use a surrogate keys or natural keys?
-
-
-
- simple key, composite key, compound key
- review and key points.... Ha GET IT? KEY points!
- introduction to entity relationship modeling
-
-
- Introduction to database normalization
- 1NF (first normal form of database normalization)
- 2NF (second normal form of database normalization)
- 3NF (third normal form of database normalization)
- Indexes (clusters, nonclustered, composite index)
-
-
-
-
- inner join of 3 tables (example)
- introduction to outer joins
-
- JOIN with NOT NULL columns
- Outer join across 3 tables
-
-
-