Client / Server Databases
| Structure Type: | Study unit |
|---|---|
| Code: | TTA0108 |
| Type: | Compulsory / Basic Studies |
| Curriculum: | T-TK 2006 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 2 (2007-2008) |
| Credits: | 3 cr |
| Responsible Teacher: | Tuomaala, Raija |
| Language of Instruction: | Finnish |
Courses During the Academic Year 2007-2008
| Impl. | Group(s) | Study Time | Teacher(s) | Language | Enrolment |
|---|---|---|---|---|---|
| 3 | T-TK-3DI | 2007-08-27 – 2007-12-21 | Raija Tuomaala | Finnish | 2007-08-17 – 2007-09-07 |
| 4 | 2007-08-27 – 2007-12-21 | Raija Tuomaala | Finnish | 2007-08-17 – 2007-09-07 |
Learning Outcomes
Students know the basic terminology and the management pracises of databases for multi-user environment. Students understand the importance of good database design. They can create a database and its objects and carry out the basic administration tasks.
Student's Workload
Total work load of the course: 81 h
- of which scheduled studies: 39 h
- of which autonomous studies: 42 h
Prerequisites / Recommended Optional Courses
Basics of Databases
Contents
The terminology of relational databases and advanced use of SQL. Client-server databases. Creating a multi user database. User management. Stored procedures. Triggers and alerts. Backups and restoring.
Planning, creating and managing SQL Server databases.
Recommended or Required Reading and Other Learning Resources/Tools
Material provided by the lecturer.
Hovi, Ari. 2004. SQL-opas. Docendo, Jyväskylä.
Mode of Delivery / Planned Learning Activities and Teaching Methods
Lectures, exercises, independent studies.
Assessment Criteria
5=The student creates independently a multifunctional database and its administrative tasks and the database is created according to best practices
3=The student creates independently and instructed a multifunctional database and its administrative tasks
3=The student creates independently and instructed a database that is compliant with the minimum requirements
Assessment Methods
Exercises and portfolio of the database project (in total 70 points).
Assignments, 20 p,
Portfolio, 40 p,
Working methods, 10 p.