Computer Engineering BA (B), Databases - Modelling and Implementing, 6 Credits

Syllabus:

Computer Engineering BA (B), Databases - Modelling and Implementing, 6 Credits

General data

  • Code: DT139G
  • Subject/Main field: Computer Engineering
  • Cycle: First cycle
  • Progression: (B)
  • Credits: 6
  • Progressive specialization: G1F - First cycle, has less than 60 credits in first-cycle course/s as entry requirements
  • Answerable department: Information Systems and Technology
  • Answerable faculty: Faculty of Science, Technology and Media
  • Established: 3/15/2007
  • Date of change: 6/1/2020
  • Version valid from: 7/1/2020

Aim

The course aims to provide basic knowledge of database system concepts and the ability to design and create them. Focus in this course is to create stable and expandable databases. Important topics are conceptual modelling, implementation and normalization of existing databases. This course is essential for those who will work as database administrator.

Course objectives

Upon completion of this course, you will have
- gained theoretical knowledge of database system concepts and the knowledge essentional for working with databaseadministrator(DBA)
- be able to create a conceptual database model (with ER, EER or UML) based on given textual description or problem
- be able to use, work up or improve a existing database by applying SQL and alternative metods
- be able to use ODBC or JDBC to connect and work with a database in an existing platform
- be able to analyse and stabilize instable databases to avoid conflict states

Content

Introduction
- motive and alternatives for database system
- basic concepts
- Three Schema architecture
Database models and language
- relational database model, relational algebra
- orientation in object-oriented and object-relational model
- SQL, both simple and advanced
- design of relational and simple object-oriented database with SQL
Conceptual modeling and database schema
- Entity-Relationship model (ER)
- Extended Entity-Relationship (EER)
- Unified Modelling Language (UML)
- Functional Dependencies and Normalization
- Mapping conceptual model to relational databas schema
ODBC
- introduction
- databases in Client/Server platforms
- mapping existing database from one platform to another
- simple database programming
Other
- Security

Entry requirements

Computer Engineering BA (A), including the course Basic Computer Science, 6 Credits, and one course in an object-oriented programming language, 6 Credits.

Selection rules and procedures

The selection process is in accordance with the Higher Education Ordinance and the local order of admission.

Teaching form

The course is given as approximately 16% lectures, 10% laboratory work, and 4% seminars or exercises. Approximately 70% of the course is devoted to self studies of the course literature, preparation for laboratory work, and preparation for examination. If the available resources are changed, the distribution of the time might also change.

Examination form

L103: Laboratory, 1.5 Credits
Grade scale: Fail (U) or Pass (G)

T103: Exam, 4.5 Credits
Grade scale: Seven-grade scale, A, B, C, D, E, Fx and F. Fx and F represent fail levels.

Grading criteria for the subject can be found at www.miun.se/en/Student/Services/Grading-Criteria.

The examiner has the right to offer alternative examination arrangements to students who have been granted the right to special support by Mid Sweden University’s disabilities adviser.

If examination on campus cannot be conducted according to decision by the vice-chancellor, or whom he delegated the right to, the following applies: Exam T103, will be replaced with two parts, online examination and follow-up. Within three weeks of the online examination, a selection of students will be contacted and asked questions regarding the examination. The follow-up consists of questions concerning the execution of the on-line exam and the answers that the student have submitted.

Grading system

Seven-grade scale, A, B, C, D, E, Fx and F. Fx and F represent fail levels.

Other information

This course and the courses with code DTAB83 and DT076G can not be included in the same degree.

Course reading

Required literature

  • Author: Thomas Padron-McCarthy och Tore Risch
  • Title: Databasteknik
  • Edition: 2
  • Publisher: Studentlitteratur
  • Comment: Obligatorisk litteratur endast vid undervisning på svenska
  • Author: Elmasri R., Navathe S. B
  • Title: Fundamentals of Database Systems
  • Edition: 5
  • Publisher: Addison Wesley
  • Comment: Obligatorisk litteratur endast vid undervisning på engelska

The page was updated 9/2/2014