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: 2018/19/1
 
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 and in management without IT specific pre-requisites.
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. Building a demo data model I., identifying and referencing
2. Building a demo data model II., one-to-many relationships
3. Building a demo data model III., importance of clear definitions
4. How it works in practical life: SQL I., basic queries
5. How it works in practical life: SQL II., multiple table queries, relational databases
6. How it works in practical life: SQL III., inserting, modifying and deleting
7. Software crisis, Modelling and models
8. Data models, optimal data model, Elements of data models
9. Redundancy, semantic normalization
10. Levels of planning, Modelling techniques, Typical particular models
11. Database management functions, Security basics
12. Test
13. Projekt presentations
14. Projekt presentations
 
Type of evaluation,
repetition, calculation
of grade, etc.
Grade is the mean of the project work,
its presentation and the test.

Suggested literature: Molina – Ullman – Widom: Database systems: The Complete Book. Perason – Prentice Hall. ISBN-13: 978-0131873254 ISBN-10: 0131873253 or a newer edition
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