Client / Server Databases
| Structure Type: | Study unit |
|---|---|
| Code: | TDA0108 |
| Type: | Compulsory / Basic Studies |
| Curriculum: | T-ITE 2009 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 2 (2010-2011) |
| Credits: | 3 cr |
| Responsible Teacher: | Harju, Börje |
| Language of Instruction: | Swedish |
Courses During the Academic Year 2010-2011
| Impl. | Study Time | Teacher(s) | Language | Enrolment |
|---|---|---|---|---|
| 5 | 2011-01-03 – 2011-04-29 | Börje Harju | Swedish | 2010-12-07 – 2011-01-09 |
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 workload of the course: 81 h
- of which scheduled studies: 40 h
- of which autonomous studies: 41 h
Prerequisites / Recommended Optional Courses
Basics of Databases
Contents
Relational database terminology. Design, implementation and administration of client/server solutions in Microsoft SQL Server environment. Multiuser database aspects.
Stored procedures. Triggers and alerts. Backup and restoring.
Recommended or Required Reading and Other Learning Resources/Tools
Beginning Microsoft SQL Server 2008 Programming (Ebrary)
Reading provided by the teacher.
Mode of Delivery / Planned Learning Activities and Teaching Methods
Lessons, tasks and self-studies.
Assessment Criteria
1 - The student has basic understanding of Client/Server Database Programming and is able to use his/hers knowledge fairly in practice.
2 - The student has good understanding of Client/Server Database Programming and is able to use his/hers knowledge in practice.
2 - The student has excellent understanding of Client/Server Database Programming and is able to use his/hers knowledge excellently in practice.
Assessment Methods
Test, submitted tasks. Numerical assessment (0-5)