GT-2-006

• Automation (el 2004) - Professional studies
• Telecommunication (el 2004) - Professional studies
• Manufacturing automation 2001 - 2004 - Information technology
• Polymer tecnology 2001 - 2004 - Information technology

Swedish

Compulsory

3

3 cr

This subject will give the students the expertise needed to use database management software in order to model, design, implement and manage simple relational databases. To achieve this goal a real database system environment will be introduced in the PC-laboratory. The student will also establish a general understanding of the theory behind relational databases.

Database theory:
- definitions, concepts and terminology
- relational database model
- data base management systems and query language
- data integrity
Working with databases in PC environment using MSAccess or SQL:
- select queries, data manipulation (DML)
- creation of tables and other database objects (DDL)
- forms, reports
- introduction to database applications
Multi-user databases: client-server environment, file sharing and locking principles, security aspects.

Personal Computers

Föreläsningsmaterial
Thomas Connolly: Database Systems
Referenslitteratur
Handböcker om MS Access

• Lectures - 0 hours
• Exercise based learning - 0 hours
• - 0 hours

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

Participation in tuition

• Exams
• Reports and productions

Karlsson Hanne

http://www.sit.fi/~karlssoh/databaser/et/ External link

No limit

Date for course completion will be announced later

Until further notice

• Date of examination will be announced later - Exams
• Date will be announced later - Reports and productions