Print Course syllabus
Course syllabus - Databases
Scope
7.5 credits
Course code
DVA214
Valid from
Autumn semester 2013
Education level
First cycle
Progressive Specialisation
G1F (First cycle, has less than 60 credits in first-cycle course/s as entry requirements).
Main area(s)
Computer Science
School
School of Innovation, Design and Engineering
Ratified
2013-01-29
Status
This syllabus is not current and will not be given any more
Literature lists
Course literature is preliminary up to 8 weeks before course start. Course literature can be valid over several semesters.
-
Books
Databasteknik
Lund : Studentlitteratur, 2005 - [2], xii, 646 s.
ISBN: 91-44-04449-6 (inb.) LIBRIS-ID: 9930141
Fundamentals of database systems
Sixth edition. : Harlow, Essex : Pearson, [2014] - iv, 1081 pages
ISBN: 1292025603 LIBRIS-ID: 16248867
Other materials
OBS! Endast en av ovanstående titlar behöver användas.
Akademin för innovation, design och teknik,
-
Books
Fundamentals of database systems
5. ed. : Boston, Mass : Pearson/Addison-Wesley, cop. 2007 - xxviii, 1123 s.
ISBN: 0-321-36957-2 LIBRIS-ID: 10074587
An introduction to database systems
7. ed. : Reading, Mass. : Addison-Wesley, cop. 2000 - xxii, 938 s.
ISBN: 0-201-38590-2 LIBRIS-ID: 4703818
Databasteknik
Lund : Studentlitteratur, 2005 - [2], xii, 646 s.
ISBN: 91-44-04449-6 (inb.) LIBRIS-ID: 9930141
Other materials
Dessa tre böcker är alternativ, endast en behövs.
Akademin för innovation, design och teknik,
Objectives
The course aims to provide a basic theoretical and practical knowledge of databases and their ability to provide robust, efficient and standardized management of data in software. The course provides sufficient knowledge in order to work with databases professionally as well as providing a solid foundation for advanced studies on e.g. object-oriented and object-relational databases, distributed and component-based software development.
Learning outcomes
After completing this course the student will be able to:
- describe how a database can be used to store and manage information in a standardized, structured and efficient manner
- design conceptual data models with the help of Entity-Relationship and UML-diagrams
- based on conceptual models implement a database
- use SQL to perform CRUD operations (Create, Read, Update and Delete)
- describe the relational model and relational principles and how they are applied in the implementation of relational databases
- develop software that uses databases with the help of standard interfaces such as ADO.NET, JDBC, ODBC, SQL / CLI, LINQ , etc
- describe how transactions are used and managed by a DBMS
- analyse different algorithms/methods for indexing and index searching
Course content
Databases in general.
Relational databases, hierarchical databases, network databases, object-oriented databases and object-relational databases.
Construction and design of relational databases.
Modelling with E/R, EE/R and UML diagrams.
Introduction to SQL.
The relational model and relational algebra.
Functional dependencies and normal forms.
Transaction Management.
Recovery from system- and media-faults.
Physical database implementation and indexing.
Programming towards databases.
Tuition
Lectures, assignments and laborations.
Specific requirements
Programming in C# 7,5 ECTS credits, Data structures, algorithms and program development 7,5 ECTS credits or corresponding.
Examination
Exercise (INL1), 1.5 credits, marks Pass (G)
Exercise, laboratory work (LAB1), 3 credits, marks Pass (G)
Examination TEN1), 3 credits, marks 3, 4 or 5
A student who has a certificate from MDU regarding a disability has the opportunity to submit a request for supportive measures during written examinations or other forms of examination, in accordance with the Rules and Regulations for Examinations at First-cycle and Second-cycle Level at Mälardalen University (2020/1655). It is the examiner who takes decisions on any supportive measures, based on what kind of certificate is issued, and in that case which measures are to be applied.
Suspicions of attempting to deceive in examinations (cheating) are reported to the Vice-Chancellor, in accordance with the Higher Education Ordinance, and are examined by the University’s Disciplinary Board. If the Disciplinary Board considers the student to be guilty of a disciplinary offence, the Board will take a decision on disciplinary action, which will be a warning or suspension.
Grade
Pass with distinction, Pass with credit, Pass, Fail
Interim Regulations and Other Regulations
The course completely overlaps with the courses CD5430 Databases, CDT208 Databases, CDT223 Development of Web Applications with .NET and DVA213 Development of Web Applications with :NET.