AI Features
Log In
0% completed
All Lessons
Free Lessons (5)
Introduction
What to Expect
Before the Advent of Databases
Disadvantages of File-Based System
Fundamental Concepts
What is a Database?
Database management systems (DBMS)
An Example of a Database
Characteristics of the Database Approach
Benefits of the Database Approach
Quiz!
Data Modeling
Introduction to Data Models
Schemas and Instances
The Three-Schema Architecture
Data Independence
Classification of Database Management Systems
Quiz!
Entity-Relationship Data Model
Intro to Entity-Relationship Model
Entities, Entity Sets and Entity Types
Attributes
Keys
Relationships, Relationship Sets and Relationship Types
Degrees of Relationship Types
Binary Relationship Type Constraints
Attributes of Relationship Types
Weak Entity Types
Exercise 1
Solution to Exercise 1
Exercise 2
Solution to Exercise 2
The Relational Data Model
Relational Model Concepts
Properties of a Table
Introduction to Database Keys
Integrity Rules and Constraints
Relational Database Schemas
Common Relational Database Operations
Quiz!
Functional Dependencies
Intro to Functional Dependencies
Rules of Functional Dependencies
Dependency Diagrams
Quiz!
Normalization
What Is Normalization?
First Normal Form
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
Exercise 1
Solution to Exercise 1
Exercise 2
Solution to Exercise 2
Quiz!
Structured Query Language
Structured Query Language (SQL)
SQL Data Types and Operators
SQL Constraints
CREATE, DROP, and USE Databases
CREATE, DROP, and INSERT Table
The SELECT Clause
The WHERE Clause
The AND & OR Clauses
Aggregate Functions in SQL
ORDER BY & GROUP BY
The HAVING Clause
Alias Syntax
SQL Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
Exercise 1
Solution to Exercise 1
Exercise 2
Solution to Exercise 2
Exercise 3
Solution to Exercise 3
Exercise 4
Solution to Exercise 4
Conclusion
Where to Go from Here
Home
Courses
Database Design Fundamentals for Software Engineers
Solution to Exercise 2
Solution to exercise 2.
We'll cover the following...
Solution
Explanation
Solution
The ER diagram derived from our requirements is
...