INF-21306 Data Management
Vak
Studiepunten 6.00
| Onderwijstype | Contacturen |
| Lectures | 12 |
| Practical intensively supervised | 32 |
| Project learning | 15 |
| Tutorial | 6 |
| Self-study |
| Course coordinator(s) | prof.dr. ir. GJ Hofstede |
| Lecturer(s) | prof.dr. ir. GJ Hofstede |
| Examiner(s) | prof.dr. ir. GJ Hofstede |
Language of instruction:
English
Assumed knowledge on:
Fluency in English, at ease with computers, basic mathematics
Continuation courses:
Thesis work, INF-31306 Information Systems
Contents:
This is a first but thorough course in data management. Includes extensive practical work in the design, construction and use of databases in the students' field of study. Practical work involves SQL and Microsoft Access, possibly other database software such as Oracle. The main focus is on research data.
Aims:
To become competent as a manager of data and a worker with data models and data bases.
At the end of the course the student will:
- have a managerial perspective on data as an organization's memory;
- be able to design not too complex databases in the area of their study;
- be able to use relational, object-oriented and possibly other state-of-the-art modelling techniques;
- be able to construct a database, including integrity constraints;
- be able to use SQL for complex queries;
- be a competent user of a database software package.
Activities:
- take a tutorial in a database package (MS Access) ;
- do realistic database design exercises;
- do advanced database querying exercises;
- study the course book "Data Management";
- perform a database development project in a team about a topic in the students' field of study, write a report on it, present the results.
Examination:
There will be two marks, both counting for 50% of the final grade:
- evaluation of practical work done during the course;
- individual written examination.
Literature:
The schedule can be found at the group's Website http://www.informatics.wur.nl. During the course Blackboard is used for which a student will receive an account. Blackboard offers all support material: study guide, explanatory texts, self tests, sample exam questions and sample project results of prior teams. The book for the course is: Richard T. Watson (2004) Data Management, Databases and Organizations. Fourth edition. New York: John Wiley ISBN0-471-4-45225-4. Available through any bookshop, e.g. Kniphorst.