Chapter 12. Relational Model, SQL Schema
Prev
Part I. Webprogramming I 1st Semester
Next
Chapter 12. Relational Model, SQL Schema
Table of Contents
12.1. References for this Lesson
12.2. Most Recent Lesson's Assignments
12.3. The Relational Model
12.3.1. Structure
12.3.2. Rules / Constraints
12.3.3. Operationer
12.3.4. Relational Algebra
12.4. SQL
12.4.1. SQL - Structured Query Language
12.4.2. Focal Araes from the SQL Standard
12.5. SQL Schema
12.5.1. SQL Standard Data Types, grouped
12.5.2. Create table
12.6. ER2RM, Entity Relationship Model to Relational Model, Mapping
12.6.1. Intro and Overview
12.6.2. Step 1 - Regular (strong) Entities
12.6.3. Step 2 - Weak Entities
12.6.4. Step 3a - 1:1 Relationships
12.6.5. Step 3b - 1:1 Relationships
12.6.6. Step 4a - 1:N Relationships
12.6.7. Step 4b - 1:N Relationships
12.6.8. Step 5 - N:M
12.6.9. Step 6 - Multivalued attributes
12.6.10. Step 7 - N-ary relationships
12.6.11. Step 8 - Generalizations/Specializations
12.6.12. Step 9 - Aggregations
12.6.13. What If?
12.7. SQL Data, Create, Update, Delete
12.7.1. SQL Data, Create Data
12.7.2. SQL Data, Update Data
12.7.3. SQL Data, Delete Data
12.8. Assignments Relational Schema
12.8.1. Assignment DB.3.0
12.1. References for this Lesson
[
NMLdkexit
] This chapter.
[
Sum07
]