The course is included in these curricula and study modules
- Automation (el 2004) - Professional studies
- Telecommunication (el 2004) - Professional studies
- Manufacturing automation 2001 - 2004 - Information technology
- Polymer tecnology 2001 - 2004 - Information technology
Level/category
Teaching language
Swedish
Type of course
Compulsory
Recommended year of study
3
Total number of ECTS
3 cr
Learning outcomes
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.
Course contents
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.
Prerequisites and co-requisites
Personal Computers
Recommended or required reading
Föreläsningsmaterial
Thomas Connolly: Database Systems
Referenslitteratur
Handböcker om MS Access
Study activities
- Lectures - 0 hours
- Exercise based learning - 0 hours
- - 0 hours
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
- Exams
- Reports and productions
Examiner
Karlsson Hanne
Home page of the course
Group size
No limit
Course completion date
Date for course completion will be announced later
Assignments valid until
Until further notice
Assessment methods
- Date of examination will be announced later - Exams
- Date will be announced later - Reports and productions