A continaution in computer science that covers the fundamentals of database technology.
Course memo Autumn 2023
Course presentation
Headings denoted with an asterisk ( * ) is retrieved from the course syllabus version Autumn 2023
Content and learning outcomes
Course contents
Definition of the relational data model. Information structuring according to the Entity-Relationship model.
Functional dependencies and their importance for good database design. Normalization. Query languages and their underlying mathematics.
Transaction management. Overview of different models for data representation.
Laboratory assignments using experimental and commercial systems.
Intended learning outcomes
After passing the course, the student should be able to:
- explain the functions and structure of a database management system
- discuss the advantages and disadvantages of different database models
- model and structure data according to actual constraints
- explain the implications of different constraints on the database structure
- use a query language to formulate queries and describe the mathematical foundation for query languages
- write embedded SQL statements in a third generation programming language
- present independently acquired necessary knowledge orally and in writing.
Detailed plan
All course information has been moved to Canvas. Please see Canvas for detailed information about e.g. learning activities, pedagogical info, etc.
Preparations before course start
Recommended prerequisites
DD2477 Search Engines and Information Retrieval Systems.
Literature
No information insertedSupport for students with disabilities
Students at KTH with a permanent disability can get support during studies from Funka:
Examination and completion
Grading scale
A, B, C, D, E, FX, F
Examination
- HEM1 - Home assignments, 3.0 credits, Grading scale: A, B, C, D, E, FX, F
- LABA - Laboratory Assignments, 3.0 credits, Grading scale: A, B, C, D, E, FX, F
Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.
The examiner may apply another examination format when re-examining individual students.
Ethical approach
- All members of a group are responsible for the group's work.
- In any assessment, every student shall honestly disclose any help received and sources used.
- In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.
Further information
No information inserted
Contacts
Round Facts
Start date
Missing mandatory information
Course offering
- dbtech23 Autumn 2023-51868
Language Of Instruction
English