Level:
First Cycle Level 1
Faculty:
School of Technology and Business Studies
This course can be included in the following main field(s) of study:
1. Information Systems
2. Microdata Analysis
Progression indicator within (each) main field of study:
1. G2F
2. G2F
Approved:
Approved by the Faculty School of Technology and Business Studies, 26 October 2010.
This syllabus is valid from 26 October 2010.
Revised:
Revised, 18 February 2013.
Revision is valid from 18 February 2013.
Learning Outcomes
After attending the course the student should be able to:
· give details about the history and development of different data storage systems, and of the need for data storage in companies and organizations.
· create new relational database components and use existing ones.
· describe the architecture/structure of relational databases.
· insert, update and remove data from relational database tables.
· give details about how integrity rules contribute to higher data quality and how integrity rules practically are implemented and maintained in a relational database.
· evaluate how database transactions affect the practical work of database programming.
· perform data modeling and normalization.
· describe how data modeling and normalization affect the scalability of information models in business environments or other organizations.
· perform data queries against separate tables.
· perform data queries against several logically linked tables.
· use variables, data structures, control structures and error-handling in procedural database languages.
· give details about how stored objects, such as procedures, functions and Triggers, can facilitate administration, enhance the performance and maintain companies’ or organizations’ business rules in a database.
· create and implement stored procedures, functions and triggers in a relational database
Course Content
The course presents and covers history and development from the simple
File-Based Systems of the 60’s to object-oriented relational databases and how
databases have become a central part of today’s IT-society, with its growing
demand for information.
Furthermore the course treats SQL DDL (Data Definition Language), Data Dictionary,
tables, users, sequences, architecture, physical and logical storage structure in Oracle,
SQL DML (Data Manipulation Language). The next stage of the course deals with how
integrity rules are maintained with the help of database constraints: primary key,
foreign key, unique, check and not null.
The course also covers the area related to database transactions, SQL-TCL
(Transaction Control Language), transaction control with locks, and conceptual models
based on operational descriptions and normalization of data models.
Furthermore, the course deals with how to retrieve data from tables using SQL select
statements (Data Retrivial Language). The course also addresses the handling of
NULL values, built-in functions, aggregate functions, sub queries, cartesian product
and join statements.
Finally, the course treats variables, control structures, loops, cursor handling and error
Handling, stored procedures, functions and database triggers, in the procedural database language Oracle PL/SQL
Assessment
Written examination (4,5 credits), written report on laboratory work (3 credits, U-G).
Forms of Study
Lectures, labs and independent work.
Grades
The Swedish grades U - VG
Grade level is determined through written examination, which also decides the final grade, provided that all laboratory work are accounted for.
Prerequisites 
- -----
- together with 90 credits of wich at least 7,5 credits is Basic Programming or equvivalent knowledge
Other Information
The course is equivalent to Database Systems 7,5 credits, and the first 7,5 credits in the course Databases and Information Systems 15 credits.
Literature
Laborationskompendium/Lab handouts (ca 35 s).
