DATABASE MANAGEMENT
 
Lectured in 1st year Bachelor in business studies - Main Subject: Financing and Insurance
Theory [A] 0.0
Exercises [B] 25.0
Training and projects [C] 0.0
Studytime [D] 75
Studypoints [E] 3
Level introductory
Language of instruction Dutch
Lecturer Nadine Tasseff
Reference RCBMGF01A00001
 
Key words
Applied Information Technology, Database Management, Data Banks, P175-Informatics

Objectives
  • This course aims at making students familiar with databases. With the assistance of a database programme (part of an Office-package) they have to be able to produce and work with a database in a professional manner.
    Students have to know the most important possibilities of database programs and should be able to expand their knowledge through program documentation (help function). Students must be able to carry out assignments independently and efficiently, within a given time. Students must be able to think in a problem solving manner and work accurately. This course is used as a link to the office-packages Word and Excel.
  • Introduction to a management package for insurance brokers.


Topics
Database program:
  • Basic terminology concerning database programmes
  • Making up tables, relations
  • Entering data, links to Word and Excel
  • Designing queries: selection queries (including parameter queries and join-queries) and action queries
  • Handling forms and reports Exercises
Management package for insurance brokers:
  • Demonstration of a management package for insurance brokers


Prerequisites
Being able to make an efficient use of the possibilities of the operating system most in demand and having basic keyboard skills.

Final Objectives
Knowledge:
Job-related (general):
  • Database management
Job-related (specific):
  • Knowledge of data processing and adjusting data
Skills:
General:
  • Knowledge of data processing and adjusting data
  • Thinking and reasoning power
  • Working independently
Job-related (general):
  • Handling data
  • Operating the PC efficiently, with an eye on output
  • Having an understanding of job-related software packages
  • Being creative
  • Thinking logically
  • Having insight in complex situations
  • Ability to think in an analytical and problem-solving way
Job-related (specific):
  • Knowledge of processing and adjusting data
  • Applying the right IT-solutions for prospecting and management of customer data
  • Processing, storing and using relevant information
  • Being able to work up professional and corporate computer software
  • Retrieving data through queries
  • Entering data by means of forms
  • Reporting
  • Ability to make up a data bank
  • Thinking logically
  • Having insight in complex situations
Attitudes
General:
  • Precision and accuracy
Job-related (general):
  • Being critical


Materials used
Syllabus drawn up by lecturer, available at the course service
.Exercises on the network and/or electronic teaching environment Dokeos Disk; CD-RWPC with Office software, students who have no PC of their own may operate computers after the lessons

Study costs
Syllabus: unit price determined under Hogeschool rules
Around 250 pages.
Handbook: about 13 euro

Study guidance
  • Monitoring and coaching students during guided self-study.
  • Lecturers are available for questions through their e-mail address.


Teaching Methods
  • Through question-and-answer method, guided and individual exercises with the computer students learn the software
  • The lecturer will coach you during guided self-study when solving exercises you have prepared at home.


Assessment
  • First exam session: written exam 100% with practical application on the computer.
  • Second exam session: written exam 100% with practical application on the computer.
Students only enrolled for taking the exams:
  • First exam session: written exam 100% with practical application on the computer
  • Second exam session: written exam 100% with practical application on the computer
Students have to make the examination assignments within the given time.

Lecturer(s)