Study Guide@lith   Link to LiU Homepage
 

Linköping Institute of Technology

Link to LiU Homepage
 
Valid for year : 2010
 
TNM055 Database Technology, 6 ECTS credits.
/Databaser/

For:   BI   KTS   MT  

 

Prel. scheduled hours: 68
Rec. self-study hours: 92

  Area of Education: Technology

Main field of studies: Media Technology

  Advancement level (G1, G2, A): G2

Aim:
The course gives an introduction to databases, with particular emphasis on data modeling and query languages for relational databases. The course also gives an introduction to database applications in Java. After this course the student should be able to:
  • create a conceptual model of a database from a given requirements specification and document this as an ER-diagram.
  • explain various concepts used in the ER-model, such as entity type, attribute, key and relationship type.
  • transform the conceptual model to a logical model and document this as a collection of relational schemas.
  • explain various concepts used in the relational model, such as relation, attribute, primary key and foreign key.
  • explain the concepts integrity rule and business rule.
  • create a database from the logical model.
  • formulate and execute queries in SQL in order to retrieve data and update the database.
  • explain the concept functional dependency and define the most common normal forms.
  • decide whether a database is in a certain normal form, and transform the database to a higher normal form.
  • write database applications in PHP.


Prerequisites: (valid for students admitted to programmes within which the course is offered)
Java programming

Note: Admission requirements for non-programme students usually also include admission requirements for the programme and threshhold requirements for progression within the programme, or corresponding.

Organisation:
Lectures, lessons, and laboratory work.
The course runs over the entire autumn semester.


Course contents:
Relational databases. Conceptual design and the ER model. Logical design and the relational model. Database operations and the query language SQL. Normal forms and normalization. Transaction management. Database applications in PHP.

Course literature:


Examination:
Written examination
Laboratory work
3 ECTS
3 ECTS
 



Course language is English.
Department offering the course: ITN.
Director of Studies: Kenneth Bjerner
Examiner: Pierangelo Dell’Acqua
Link to the course homepage at the department



Linköping Institute of Technology

Link to top of pagep


Contact: TFK , val@tfk.liu.se
Last updated: 04/28/2010