Database Fundamentals 16959/1124/1415/1/16

Erasmushogeschool Brussel
Nijverheidskaai 170, B-1070 BRUSSEL
Tel. 02 523 37 37 - Fax 02 523 37 57
[email protected]
Database Fundamentals
Academic year:
16959/1124/1415/1/16
2014-15
In study programme: EIPBATI - Bachelor Applied Computer Science
Study load:
6 credits
Programme stage:1
This is a single unit of study.
6,00
Weight:
168,00 Hours
Total study time:
Possible deadlines for learning account:15.03.2015 ()
This unit of study is marked out of 20 (rounded to a whole number).
is possible.
Re-sit examination:
Info on exam board rules: not tolerable from a numerical score of less than 8.
Level:
Introductory
Nature:
General mandatory course
Contract restriction:
Co-ordinator:
Vanneuville Karine
Other teaching staff: Dejonckheere Ruben
Languages:
Dutch
PREREQUISITES
Description
Level
Final attainment level: secundary education
Introductory
COURSE OBJECTIVES
Acquired knowledge:
Functions and parts of a database
The different steps that one must undertake to make a database
The setting up of the conceptueel plan with the techniques of the Entity Relation Diagram (ERD).
Basic terms and concepts of the relational model.
The normalisation steps of Codd
The converting of ERD to tables.
The syntax of a SELECT statement
Knowledge of DML and DDL statements.
Acquired understandings:
Techniques control to come till the analysis of a data system.
The modeling of a data system.
Creating a data model.
Acquired skills:
Designs of a database.
Being able to go trough the different steps to create a database
EVALUATION
Evaluation(s) for first exam chance
Moment
Form
Final evaluation (exam period excluded)
Written evaluation
15,00
Exam period June
Written evaluation
40,00
Competence test
15,00
Competence test
30,00
Permanent evalutaion (exam period
excluded)
Exam period June
%
Remark
Evaluation(s) for re-sit examination
Moment
Form
%
Remark
Exam period August/September
Written evaluation
55,00
Exam period August/September
Competence test
45,00
COURSE CONTENT
First we start with an overview of the principles of databases. A profound discussion of information and data analyses is needed. The student will learn the techniques for
modeling data and designing a database. The ER model that leads to a data model that satisfies the needs of the information system. The normalisation steps of Codd play an
important role for implementing a structured database.
SQL, the standard query-language for relational databases, will be introduced. DDL, DML-statements and the SELECT statement are explored.
TYPE OF TEACHING
Lab (18,00 hours)
Lecture (30,00 hours)
Course preparation (120,00 hours)
COURSE MATERIAL(S)
guidebook
(Mandatory)
Author:
Kroenke
Publisher:
Pearson
Edition:
11
ISBN-nr:
978-90-430-1987-3
Medium:
Paper
For sale through sales service
Karine Vanneuville
For sale through sales service
Syllabus
(Mandatory)
Author:
COURSE SEQUENCE
There are no prerequisites for this course.

Download Report