| TDDI60 | Technical Databases, ECTS-points /TEKNISKA DATABASER/ Advancement level: B | |
| Aim: This course will give principles and practical solutions for storage and retrieval of information using a computer system, particularly for large quantities of data, and with an emphasis on technology and technical applications.Prerequisites: 1. Elementary knowledge about computers, and some experience with IDA's SUN system, corresponding to the course TDDA07 Introduction Computer Science and Computer Equipment. 2. Knowledge about programming, specifically in the language C, corresponding to the course TDDI 36 Programming in C. 3. Knowledge about data structures and algorithms, corresponding to the course TDDI40 Data structures and algorithms.Course content: This course covers the fundamentals of the database field. The subject of the database field is how to use computers to store and manage data, usually large quantities of data. If you are going to create a data base that models part of the real world, for example a company or some other organization, the first step is usually to make a description of the structure and function of that part of the real world, i. e. a conceptual data model . In this course we will learn, and use, a method called Entity-Relationship modeling. The conceptual model actually has nothing at all to do with computers, since it is just a description of the world, which could equally well be used e. g. by someone who needs to study the internal functioning of the company. If you want to create a data base in a computer you must first translate the conceptual data model to an implementation data model , which is then used to implement the data base. There are several different classes of implementation data models, and in this course we will study the hierarchical model, the network model, the relational model, and object-oriented models. The emphasis is on the relational model. A data base is a collection of data. It is usually managed by a special program or program system, called a data base management system , DBMS for short. During the course we will study how a DBMS is structured and how it functions, among other things how it stores its data internally, how it prevents unauthorized access to the data, and how it solves the problems that arise when several users simultaneously want to look at or change the data. Since we want to access the data base, i. e. ask questions about the data, change the data, or define which data that are to be stored, the data base management system provides several interfaces, for example different query languages. We will look at some of these interfaces, mostly for the relational model. The emphasis is on the query language SQL.Course literature: 1. Elmasri, Navathe: Fundamentals of Database Systems , 2nd Ed, Benjamin/Cummings, 1994. 2. Thomas Padron-McCarthy: Kurskompendium för kursen TDDI60 Tekniska Databaser, IDA, 1996. 3. Students who are not entirely familiar with the English language will need a (English-Swedish) dictionary. | ||
| LAB 1 | Labratory work | |
| TEN 1 | Written examination | |