Syllabus for Information Systems A: Databases
Informationssystem A: Databaser
A revised version of the syllabus is available.
- 7.5 credits
- Course code: 2IS007
- Education cycle: First cycle
Main field(s) of study and in-depth level:
Information Systems G1N
Explanation of codes
The code indicates the education cycle and in-depth level of the course in relation to other courses within the same main field of study according to the requirements for general degrees:
- G1N: has only upper-secondary level entry requirements
- G1F: has less than 60 credits in first-cycle course/s as entry requirements
- G1E: contains specially designed degree project for Higher Education Diploma
- G2F: has at least 60 credits in first-cycle course/s as entry requirements
- G2E: has at least 60 credits in first-cycle course/s as entry requirements, contains degree project for Bachelor of Arts/Bachelor of Science
- GXX: in-depth level of the course cannot be classified
- A1N: has only first-cycle course/s as entry requirements
- A1F: has second-cycle course/s as entry requirements
- A1E: contains degree project for Master of Arts/Master of Science (60 credits)
- A2E: contains degree project for Master of Arts/Master of Science (120 credits)
- AXX: in-depth level of the course cannot be classified
- Grading system: Fail (U), Pass (G), Pass with distinction (VG)
- Established: 2010-08-26
- Established by:
- Revised: 2019-11-11
- Revised by: The Department Board
- Applies from: Autumn 2019
- Entry requirements: General entry requirements and English 6, Mathematics 3b/3c, Social Studies 1b/1a1+1a2 or English B, Mathematics C, Civics A
- Responsible department: Department of Informatics and Media
Decisions and guidelines
This course belongs to the minor subject Database Technology.
Regarding knowledge and understanding, the student should be able to
- Explain basic database concepts,
- Describe the relational model,
- Explain ER-diagrams, relational schemas, and the role of normalisation in information modeling,
- Explain relational algebra, and how it relates to the query language SQL,
- Describe the fundamental principles of transaction processing,
- Explain the importance of database management and relational database management systems (RDBMS).
Regarding competence and skills, students should be able to
- Use ER diagrams to perform information modeling,
- Use normalisation to transform and simplify an information model,
- Use relational algebra as a basis for querying,
- Implement and utilise a relational database using the query language SQL,
- Apply the fundamental principles of transaction management.
Regarding judgement and approach the student should be able to
- Discuss the implications of different database designs.
The course introduces database systems with a focus on the relational database model. The course begins with conceptual information modelling based upon ER diagrams. The information model is then refined into a collection of normalised tables that remove duplicated and redundant information. Relational algebra is taught in order to show how information can be extracted and modified in a relational database. Subsequently, the Structured Query Language (SQL) is shown as an industrial variant for practical database querying and transformation. Finally, fundamental principles for transaction management, and the role of database management and database management systems, are discussed.
Lectures, lessons, and laboratory exercises.
If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the University's disability coordinator or a decision by the department's working group for study matters.
- Latest syllabus (applies from Autumn 2022)
- Previous syllabus (applies from Autumn 2019, version 4)
- Previous syllabus (applies from Autumn 2019, version 3)
- Previous syllabus (applies from Autumn 2019, version 2)
- Previous syllabus (applies from Autumn 2019, version 1)
- Previous syllabus (applies from Autumn 2010)
Applies from: Autumn 2019
Some titles may be available electronically through the University library.
Fundamentals of database systems
seventh edition, Global edition: Harlow: Pearson, 2017