Before choosing course
This course has been discontinued.
Last planned examination: Autumn 2017
Decision to discontinue this course: No information inserted
A basic course in computer science that covers the fundamentals of database technology and information systems.
Course offering missing
Course offering missing for current semester as well as for previous and coming semestersContent and learning outcomes
Course contents
Definition of the relation model. Information structuring according to the "Entity Relationship"-model.
Simple rules for good database design. Query languages and a little about the mathematics behind them. Transaction management.
Assertion of security and integrity.
Laboratory assignments using experimental and commercial systems.
Intended learning outcomes
The students will, upon completion of the course, be able to model and implement a simple database. Further on, the students will be able to formulate queries, using SQL, to search information in such databases. Finally, the students will have basic knowledge in the use of decision support systems (data warehouses).
This implies that the students should be able to:
* understand the functions and architecture of a database system,
* be able to model and structure data according to actual constraints
* be able to use a query language to formulate queries
* use a simple decision support system.
Course Disposition
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.
Literature and preparations
Specific prerequisites
No information inserted
Recommended prerequisites
No information inserted
Equipment
No information inserted
Literature
To be announced at least 4 weeks before course start at course web page.
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
- LAB1 - Computer Assignment, 2,5 hp, betygsskala: P, F
- SEM1 - Seminar, 2,0 hp, betygsskala: P, 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
Examination by seminar tasks, laboratory assignments and one written examination.
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 DD1370Offered by
Main field of study
Technology
Education cycle
First cycle
Add-on studies
DD1334, DD2469, DD2471, DD2472 and DD2483.
Contact
Petter Ögren, e-post: petter@kth.se