COURSE SYLLABUS

Basic Course in Database Systems 7.5 Credits

Databaser, en introduktion
First cycle, L0003B
Version
Course syllabus valid: Autumn 2011 Sp 1 - Present
The version indicates the term and period for which this course syllabus is valid. The most recent version of the course syllabus is shown first.

Syllabus established
by Department of Civil and Environmental Engineering 31 Jan 2007

Last revised
by Department of Civil, Environmental and Natural resources engineering 17 Aug 2011

Education level
First cycle
Grade scale
U G#
Subject
Geographic Information Technology
Subject group (SCB)
Geographic Informations Technology and Surveying

Entry requirements

In order to meet the general entry reguirements for first cycle studies you must have successfully completed upper secondary education and documented skills in English language. and Basic Course in Programming, for example ABL005 or analogous knowledge acquired through other courses or proved practical work.


More information about English language requirements


Selection

Selection B



Course Aim
The aim of the course is to give the students ability to explain and describe basic concepts within database theory and relational database theory in particular. Students shall be able to construct databases (data modeling) from a depicted reality. Students shall also master basics in the SQL language and be able to construct simple applications that use some database manager. They shall also learn how to use some mapping tool with belonging database and be able to describe how a geographical component is used to manage spatial data in applications. Further more students shall develop skills in documenting their work according to established methodology.

Contents
• Database management systems
• Relational databases
• SQL, datadefinition and data manipulation
• Database design, object and data modeling
• Embedded database management and SQL in some host language
• Transactions and concurrency
• Map management

Realization
Lectures, laboratory work. No compulsory lectures.

Examination
Assignment reports.

Remarks
Courses followed through Internet demands access to some sort of broadband.

Examiner
Folke Stridsman

Transition terms
The course L0003B is equal to ABL006

Literature. Valid from Autumn 2011 Sp 1 (May change until 10 weeks before course start)
M, Segerlund & F, Stridsman,Databaser och SQL, SQL Introduktion, Pontes, 91 86536 44 X
T. Connolly & C. Begg: Database Systems – A Practical Approach to Design, Implementation and Management, Addison Wesley, senaste upplaga.

Course offered by
Department of Civil, Environmental and Natural Resources Engineering

Items/credits
NumberTypeCreditsGrade
0001Assignment7.5U G#

Study guidance
Study guidance for the course is to be found in our learning platform Canvas before the course starts. Students applying for single subject courses get more information in the Welcome letter. You will find the learning platform via My LTU.