Database Design I - 1DL300
Contents
- News
- Literature
- Assignments
- Teachers
- Schedule
- Goal, content and prerequisite
- Organization and examination
- OH slides and compendium
- Reading instructions
- Miscellaneuos information
- F.A.Q.
Reading instructions for the course 1DL300
- Reading instructions for the the book "Fundamentals of Database Systems", Elmasri - Navathe, 6th ed., 2010.
- Note that supplementary material, such as overhead pictures and compendie, are also part of the course material.
| Chapter: | Note: |
| 1 | All. Read 1.4 and 1.5 on your own. |
| 2 | All. |
| 3 | All. |
| 4 | All. General knowledge about functionality in SQL is required. You shall be able to formulate a query given a database schema and be able to use constructs covered in lectures and labs. |
| 5 | All except 5.2. |
| 6 | 6.1,6.2,6.3 and 6.5. No relational calculus) |
| 7 | All. |
| 8 | All. |
| 9 | Omitted. |
| 10 | Omitted. |
| 11 | Omitted. |
| 12 | 12.3. |
| 13 | Omitted. |
| 14 | All. Read 14.6 and 14.7 to be informed about the meaning of 4th and 5th normal forms. |
| 15 | 15.1.1. |
| 16 | Read Ch. 16.1-16.3 if you need an introduction to disk storage. Read Ch. 16.3-16.9 to the extension that is required to understand the principles for file-organization techniques. Skip Ch. 16.10, 16.11. |
| 17 | Read 17.1 to the extension that is required to understand the principles of single-level indexing techniques. Skip Ch. 17.2-17.7. |
| 18 | Omitted. |
| 19 | Omitted. |
| 20 | All except 20.5.4, 20.5.5. |
| 21 | All except 21.2, 21.3, 21.6. |
| 22 | All except 22.5, 22.6. |
| 23 | Omitted. |
| 24 | Omitted. |
| 25 | Omitted. |
| 26 | Omitted. |
| 27 | Omitted. |
- Reading instructions for the the book "Databasteknik", Padron-McCarthy - Risch, Studentlitteratur 2005.
- Note that supplementary material, such as overhead pictures and compendie, are also part of the course material.
| Chapter: |
Note: |
| 1 |
All. |
| 2 |
All. |
| 3 |
All. |
| 4 |
All. |
| 5 |
All. |
| 6 |
All. |
| 7 |
All. |
| 8 |
All. General knowledge about functionality in SQL is required. You shall be able to formulate a query given a database schema and be able to use constructs covered in lectures and labs. |
| 9 |
All. |
| 10 |
All except 10.17,10.18,10.19,10.20. |
| 11 |
All. |
| 12 |
All except 12.12,12.13 |
| 13 |
Omitted. |
| 14 |
Omitted. |
| 15 |
Omitted. |
| 16 |
Omitted. |
| 17 |
Omitted. |
| 18 |
Omitted. |
| 19 |
Omitted. |
| 20 |
20.1,20.2 and 20.8. |
| 21 |
All. |
| 22 |
22.1-22.17. |
| 23 |
All. |
| 24 |
All, except 24.21-24.23. |
| 25 |
Omitted. |
| 26 |
Omitted. |
| 27 |
Omitted. |
| 28 |
Omitted. |
| 29 |
For the interested reader. |
| 30 |
For the interested reader. |