Institute: Szervezési és Vezetési Intézet (1081 Budapest, Népszínház u. 8.) Credit: 2
Type of classes: Nappali Language: angol Semester: 2015/16/2
 
Level: ERASMUS; Kritérium tárgy;
 
Responsible Teacher: Dr. Keszthelyi András Teacher(s): Dr. Keszthelyi András;
 
Pre requirements: Angol nyelvi elõkövetelmény
Consultations (total/week): Heti Lectures: 0 Practice lectures: 0 Labs: 2 Consultations: 0
 
Type of Exam: félévközi jegy
 
Aim of the subject: To become prepared for taking part in planning-developing, in management, in usage of databases.
Requirements during the semester
(homeworks, essays,
excercises, teamworks,
presentations,
part and final
oral/written exam etc.):
Students are to develop and present a project work in small teams of 2
or 3 and write a formal test at the end of the semester.

 
Week of
semester
Topics of lectures/practices
1. Historical overview, Software crisis
2. Modelling and models
3. Data models, optimal data model
4. Elements of data models
5. Building a demo data model
6. Redundancy, semantic normalization
7. Modelling techniques
8. SQL
9. Typical particular models
10. Relational databases
11. Database management functions
12. Data security, ISO 27000, CC, Cobit
13. Legal data protection (in Hungary)
14. Project presentations
 
Type of evaluation,
repetition, calculation
of grade, etc.
Grade is the mean of the project work,
its presentation and the test.

 
Compulsory literature: Molina – Ullman – Widom: Database systems: The Complete Book. Perason – Prentice Hall. ISBN-13: 978-0131873254 ISBN-10: 0131873253 or a newer edition
Suggested literature: Codd, Edgar Frank: The Relational Model for Database Management (Version 2 ed.). Addison Wesley Publishing Company. ISBN 0-201-14192-2.
Methods of
quality assurance
of the subject :
TÜV CERT EN ISO 9001:2000