Database Development

2022/2023

Prerequisite/Recommended prerequisite for participation in the module

Recommended professional prerequisite: Basic knowledge of programming

Content, progress and pedagogy of the module

Disclaimer.
This is an English translation of the module. In case of discrepancy between the translation and the Danish version, the Danish version of the module is valid.

Learning objectives

Knowledge

  • the relational data model and its concepts
  • data modeling (ERD / UML)
  • transactions concept
  • integrity restrictions including primary keys, promotion keys, checks and not null
  • The SQL language for defining databases, basic and advanced extraction of data as well as modifying data
  • Extracting information from a DBMS from a programming language such as PHP, Java or C #
  • "Best practice" for good design and use of DBNS and SQL

Skills

  • be able to construct a database design and a database schema
  • demonstrate understanding of the relational data model
  • construct and evaluate complex queries in SQL and other relevant queries
  • construct transactions that meet relevant technical and business criteria

Competences

  • use a database management system (DBMS) to store and retrieve information
  • use SQL from a conventional programming language

Type of instruction

The teaching is organized in accordance with the general teaching methods for the education, cf. section 17.

Extent and expected workload

The student is expected to spend 27.5 hours per ECTS, which for this activity means 137.5 hours.

Exam

Exams

Name of examDatabase Development
Type of exam
Written or oral exam
ECTS5
Assessment7-point grading scale
Type of gradingInternal examination
Criteria of assessmentThe criteria of assessment are stated in the Examination Policies and Procedures

Additional information

Contact: Study Board for Computer Science via cs-sn@cs.aau.dk or 9940 8854

Facts about the module

Danish titleDatabaseudvikling
Module codeDSNBAITFB402
Module typeCourse
Duration1 semester
SemesterSpring
ECTS5
Language of instructionEnglish
Empty-place SchemeYes
Location of the lectureCampus Aalborg
Responsible for the module

Organisation

Study BoardStudy Board of Computer Science
DepartmentDepartment of Computer Science
FacultyTechnical Faculty of IT and Design