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 (updated for the 5th ed.)
- Reading instructions for the the book "Fundamentals of Database Systems", Elmasri - Navathe, 5th ed., 2003.
- 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. Read 2.5 on your own. |
| 3 | All. |
| 4 | All. Read 4.5 on your own. |
| 5 | All. |
| 6 | All, except relational calculus sections. |
| 7 | All except 7.2. |
| 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, except stored procedures section |
| 10 | All except 10.2.2, 10.2.3 and 10.2.4. |
| 11 | Omitted. |
| 12 | Omitted. |
| 13 | Read Ch. 13.1-13.3 if you need an introduction to disk storage. Read Ch. 13.3-13.8 to the extension that is required to understand the principles for file-organization and indexing techniques. Skip Ch. 13.9, 13.11. |
| 14 | Read to the extension that is required to understand the principles for file-organization and single-level indexing techniques. Skip Ch. 14.2-14.5. |
| 15 | Omitted. |
| 16 | Omitted. |
| 17 | Ch. 17.5 omitted. Note! However, you should know what is meant by the concepts serial, non-serial, and serializable transaction schedule. |
| 18 | Ch. 18.2, 18.3, 18.6, 18.7 omitted. |
| 19 | Ch. 19.5, 19.6 omitted. |
| 20 | Omitted. |
| 21 | Omitted. |
| 22 | Omitted. |
| 23 | Omitted. |
| 24 | Omitted. |
| 25 | Omitted. |
| 26 | Omitted. |
| 27 | Omitted. |
| 28 | Omitted. |
| 29 | Omitted. |
| 30 | 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. |