Databases (5cr)
Course unit code: G-04233
General information
- Credits
- 5 cr
Objectives
The students are able to design and implement a relational database and to make SQL queries to the database.
Content
The course focuses on the terminology of databases, design of relational databases ER modelling and SQL language. During the course the students do an assignment modelling and implementing a database which fulfils a set criteria. In addition, the students use PHP to program small web based database applications.
Further information
Literature: Fundamentals of Database Systems (Elmasri & Navathe 2000), SQL-ohjelmointi, Pro Training (Hovi, 1999). MySQL (Heinisuo Rami 2001), PHP and MySQL Web Development (Welling & Thomson, 2003) Lectures, exercises and independent work Prerequisites: G-02018, G-02019, G-02029. Language of instruction: Finnish Contact person: Director of degree programme .