Syllabus for Databases 1

Databaser 1

Syllabus

  • 7.5 credits
  • Course code: 2IS222
  • 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:

    First cycle

    • 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

    Second cycle

    • 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: 2016-03-03
  • Established by:
  • Revised: 2021-04-08
  • Revised by: The Department Board
  • Applies from: Autumn 2022
  • Entry requirements: General entry requirements and Mathematics 3b or 3c/Mathematics C, Social Studies 1b or 1a1+1a2, English 6
  • Responsible department: Department of Informatics and Media

Decisions and guidelines

The course is included in the following degree programme:

  • Bachelor's Programme in Information Systems, specialisation software engineering 180 credits
  • Bachelor's Programme in Digital Business Development 180 credits

Learning outcomes

Regarding knowledge and understanding the student is expected to be able to on completion of the course:

  • account for basic database concepts,
  • explain concepts, structure and safety in relational databases,
  • account for technologies and models for design of a database,
  • describe laws and regulations regarding data storage and personal integrity.

Regarding competence and skills the student is expected to be able to on completion of the course:

  • design data models based on business needs,
  • analyse a conceptual data model and based on that implement a relational database,
  • design a relational database and also insert, change and search data from the database,
  • improve database design by applying normalisation.

Regarding judgement and approach the student should, on completion of the course, be able to:

  • evaluate the quality of data models given different criteria.

Content

The course gives an introduction to databases with a focus on design of relational databases. The course includes conceptual data modelling based on ER-diagram and design of databases and work with storing and fetching of data in relational databases with the Structured Query Language (SQL). The course also deals with how the database manager provides services as well as maintains data integrity. Further, the course deals with safety and the risks with data storage based on both relevant sections of the law and ethical aspects.

Instruction

The course is given in the form of lectures, laboratory work, and seminars.

Assessment

The course is examined through laboratory work, assignments, and written exam.

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.

Reading list

Reading list

Applies from: Autumn 2022

Some titles may be available electronically through the University library.

  • Padron-McCarthy, Thomas; Risch, Tore Databasteknik

    Andra upplagan: Lund: Studentlitteratur, [2018]

    Find in the library

    Mandatory

  • Bergman, Marina Att studera på högskolan : studieteknik och motivation på vägen

    Tredje upplagan: Lund: Studentlitteratur, [2022]

    Find in the library

    Mandatory