Level/category
Teaching language
English
Type of course
Compulsory
Recommended year of study
2
Total number of ECTS
3 cr
Competency aims
This subject will give the students the expertise needed to model, design, implement and manage a relational database. Hands-on computer training is mixed with in-class theory. Database programs MySQL and/or MS SQL Server will be used to demonstrate all database concepts. The student will also establish a general understanding of the theory behind relational databases. Fundamentals of SQL language and multi-user databases are also introduced. Upon completion of this course the student will realize the importance of databases and the basic skills necessary to complete primary database tasks.
Learning outcomes
Upon completeion of this course the student has the necessary skills to:
- correctly use common terminology used in database environment
- outline and describe components in a client-server database environment
- understand the basics of relational algebra and how this relates to theory of relational databases
the relational data model
- knows basics of SQL (Data manipulation and Data Definition)
- understands the concepts of data base design methodology, which inludes conceptual design (ER modeling), logic design (normalization) and physical design (how a data base is implemented in a computer environment)
Course contents
Database theory
- definitions, concepts and terminology
- relational database model
- introduction to data base management systems and query language
- data integrity
Working with databases in a client-server environment using SQL:
- select queries
- creation of tables and other database objects
- file sharing and locking principles, security aspects.
Introduction to database design methodology.
Recommended or required reading
Course textbook
Thomas Connolly etc. : Database Systems, Third Edition
Study activities
- Lectures
- Assignments
- Project work
- Written report
- Exercises
- Individual work
Workload
- Total workload of the course: 0 hours
- Of which autonomous studies: 0 hours
- Of which scheduled studies: 0 hours
Mode of Delivery
Participation in tuition
Assessment methods
Written tests
Examiner
Karlsson Hanne
Home page of the course
Group size
No limit
Assignments valid until
The end of the academic year