IM-2-006

English

Compulsory

2

3 cr

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.

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)

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.

Course textbook
Thomas Connolly etc. : Database Systems, Third Edition

• Lectures
• Assignments
• Project work
• Written report
• Exercises
• Individual work

• Total workload of the course: 0 hours
• Of which autonomous studies: 0 hours
• Of which scheduled studies: 0 hours

Participation in tuition

Written tests

Karlsson Hanne

http://people.arcada.fi/~hanne/databases/ External link

No limit

The end of the academic year