
A continaution in computer science that covers the fundamentals of database technology.
Choose semester and course offering
Choose semester and course offering to see information from the correct course syllabus and course offering.
Content and learning outcomes
Course contents
Definition of the relation model. Information structuring according to the “Entity Relationship”-model.
Functional dependencies and what they mean for good database design. Normalization. Query languages and the mathematics behind them.Transaction handling. Assertion of security and integrity. Overview of different models for data representation. Laboratory assignments using experimental and commercial systems.
Intended learning outcomes
The student will understand:
- schema and queries in the relational database model using SQL;
- the operation of constraints and triggers during modifications of a SQL database;
- how to avoid anomalies, preserve information and dependencies in the design of a relational databases;
- the use of ER diagrams and design principles in relational database design .
- the XML database model, XML-schema DTD, and XQuery.
Course Disposition
The course consists of a series of lectures each with a prerequist reading assignment, recitations in which homework assignments are explained, labs, a group assignment, and an exam.
Literature and preparations
Specific prerequisites
For single course students: completed upper secondary education including documented proficiency in Swedish corresponding to Swedish B, English corresponding to English A. Furthermore: 7,5 hp in mathematics and 6 hp in computer science or programming technics.
Recommended prerequisites
One of the courses 2D1320/DD1320 Applied Computer Science, 2D1343/DD1343 Computer Science, 2D1344/DD1344 Fundamentals of Computer Science or the equivalent.
Equipment
No information inserted
Literature
H. Garcia-Molina, J. Ullman and J. Widom, Database Systems: The Complete Book, Pearson Prentice Hall, 2009.
Examination and completion
If the course is discontinued, students may request to be examined during the following two academic years.
Grading scale
A, B, C, D, E, FX, F
Examination
- LABA - Laboratory Assignments, 3,0 hp, betygsskala: A, B, C, D, E, FX, F
- TEN1 - Examination, 3,0 hp, betygsskala: 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.
In this course all the regulations of the code of honor at the School of Computer science and Communication apply, see: http://www.kth.se/csc/student/hederskodex/1.17237?l=en_UK.
Other requirements for final grade
The students participating in the course are expected to take part in all activities on the course with a particular emphasis on the exercises and laboratories.
In addition the course focuses on training:
acquiring knowledge.
training oral and written presentation.
Examination by one examination (TEN1; 3 university credits), laboratory assignments (LAB1; 3 university credits), seminar and training tasks.
Opportunity to complete the requirements via supplementary examination
No information inserted
Opportunity to raise an approved grade via renewed examination
No information inserted
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 web
Further information about the course can be found on the Course web at the link below. Information on the Course web will later be moved to this site.
Course web DD1334Offered by
Main field of study
Information Technology, Technology
Education cycle
First cycle
Add-on studies
DD2471 Modern Database Systems and Their Application, DD2483 Development of Web Applications with Enterprise Java.
Contact
Florian Pokorny (fpokorny@kth.se)
Supplementary information
The course cannot be counted towards the degree if the student also has taken 2I1100 or 2I1033.
In this course, the EECS code of honor applies, see:
http://www.kth.se/en/eecs/utbildning/hederskodex