Database Development

2019/2020

Prerequisite/Recommended prerequisite for participation in the module

Basic knowledge of programming.

Content, progress and pedagogy of the module

Learning objectives

Knowledge

  • the relational data model and its concepts
  • data modelling (ERD / UML)
  • concept of operations
  • integrity constraints including primary keys, promoting keys, checks and not null
  • SQL language for defining databases, basic and advanced data extraction and modification of 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
  • Understand and use the advanced queries using more than two tables, e.g., for inner join, outer join, and the set operators

Skills

  • be able to construct and evaluate a database design and database scheme
  • demonstrate understanding of the relational data model and how to evaluate the model
  • construct and evaluate complex queries in SQL and other relevant query languages
  • constructing transactions that comply with relevant technical and commercial criteria
  • Informally argue for the goodness/quality of the database design using knowledge on unnecessary repetition of information plus first and third normal form

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 according to the general teaching methods for the education, cf. chapter 3

Extent and expected workload

It is expected that the student uses 30 hours per ECTS, which for this activity means 150 hours

Exam

Exams

Name of examDatabase Development
Type of exam
Written or oral exam
ECTS5
AssessmentPassed/Not Passed
Type of gradingInternal examination
Criteria of assessmentThe criteria of assessment are stated in the Examination Policies and Procedures

Additional information

Contact: The Study board for Computer Science at cs-sn@cs.aau.dk or 9940 8854

Facts about the module

Danish titleDatabaseudvikling
Module codeDSNIDAK204
Module typeCourse
Duration1 semester
SemesterSpring
ECTS5
Language of instructionDanish and English
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