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.
DD1368 Database Technology 6.0 credits
A continuation course in computer science that covers the fundamentals of database technology.
About course offering
For course offering
Autumn 2024 dbtd24 programme students
Target group
CDATE, CTMAT and CLGYM.
Part of programme
Degree Programme in Computer Science and Engineering, åk 2, Mandatory
Degree Programme in Engineering Mathematics, åk 3, Optional
Master of Science in Engineering and in Education, åk 3, TEDA, Mandatory
Periods
P2 (6.0 hp)Duration
Pace of study
33%
Form of study
Normal Daytime
Language of instruction
Swedish
Course location
KTH Campus
Number of places
Places are not limited
Planned modular schedule
Course memo
Course memo is not publishedSchedule
Link to scheduleApplication
For course offering
Autumn 2024 dbtd24 programme students
Application code
51196
Contact
For course offering
Autumn 2024 dbtd24 programme students
Contact
Dena Hussain denah@kth.se
Examiner
No information insertedCourse coordinator
No information insertedTeachers
No information insertedContent and learning outcomes
Course contents
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.
Literature and preparations
Specific prerequisites
Knowledge and skills in programming, 6 higher education credits, equivalent to completed course DD1337/DD1310/DD1311/DD1312/DD1314/DD1315/DD1316/DD1318/DD1321/DD1331/DD100N/ID1018.
Knowledge in basic computer science, 6 higher education credits, equivalent to completed course DD1338/DD1320/DD1321/DD1325/DD1327/DD2325/ID1020/ID1021.
Active participation in a course offering where the final examination is not yet reported in LADOK is considered equivalent to completion of the course. Registering for a course is counted as active participation. The term 'final examination' encompasses both the regular examination and the first re-examination.
Recommended prerequisites
Equipment
Literature
Examination and completion
If the course is discontinued, students may request to be examined during the following two academic years.
Grading scale
Examination
- HEM1 - Home assignments, 3.0 credits, grading scale: A, B, C, D, E, FX, F
- LAB2 - 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.
Opportunity to complete the requirements via supplementary examination
Opportunity to raise an approved grade via renewed examination
Examiner
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
Course room in Canvas
Offered by
Main field of study
Education cycle
Add-on studies
DD2447, DD2471 and DD2476.
Contact
Transitional regulations
The earlier component TEN1 is replaced by HEM1.
Supplementary information
In this course, the EECS code of honor applies, see:
http://www.kth.se/en/eecs/utbildning/hederskodex