Key words
SQL, relational database, RDBMS, relational model, normalisation, normal form
Objectives
To gain insight in the architecture and administration of a database management system to be able to learn and use every DBMS available today.
To develop knowledge and experience in the design, administration and querying of relational databases. The querying is done by learning and styding the SQL language in depth.
Designing a relational correct database scheme – without losing eye for economic reality and financial cost – and the implementation in an existing DBMS, both individually and in group while learning to discuss and rapport the whole in a critical and professional manner (conforming the design rules).
In a multidiscipline group project attention is focused on the technical aspects of database design, keeping an eye on the software development process that inevitably follows.
Topics
Introduction to relational databases: architecture, design, administration and user aspects.
Relational databases: the relational model and the normalization process.
SQL: implementation of the database design (DDL), manipulation of the data in a database (DML) and transactional operations (COMMIT, ROLLBACK) and dynamic and ‘embedded’ SQL. All of this in an Oracle environment with PL/SQL. Also practical exercises on ‘query-by-example’ (QBE) in Microsoft Access.
Prerequisites
General basic definitions in computerscience, such as : processor, file and disk management, memory, ...
Knowledge of the capabilities and shortcomings of a modern programming language and software development.
Final Objectives
SC1
SC2
SC3
SC7
Materials used
Syllabus (electronically available)
Additional references
Study costs
Cost: 0.0 EUR
none
Study guidance
Academic staff are available before, during and after the lab sessions and by appointment otherwise. Continuously availability through email.
Teaching Methods
Ex cathedra colleges with slides
Exercises in a computer lab
Assessment
Theory : An oral exam tests knowledge in the subject and the ability to assimilate it as well as the competence to communicate this not only written but also in a verbally efficient way. (47%)
Exercises : Computer exercises (daily work) , a written test (permanent evaluation) and a group project in which a realistic database is designed and implemented. (53%)
However, if a student gains a score of 7 or less on 20 on one of the different courses (parts of training items), he proves that his skill for certain subcompetencies is insufficient. Consequently, one can turn from the arithmetical calculation of the final assignment of quotas of a training item and the new marks can be awarded on consensus. Of course the examiners can judge that the arithmetic regulations mentioned in the study index card can also be used for 7 or less. For each deviation a detailed motivation ought to be drawn up. In that case one should point out that the skill for this subcompetency is proven to be insufficient, if the student didn’t pass the partim that is considered to be important for certain subcompetencies.
Lecturer(s)
Dirk VANDYCKE
|
|
