Basic Programming, Basic algorithm, Data Structures
The students acquire their own knowledge on the matters and develop the following skills:
1. General basic knowledge of file systems and data base management systems.
2. Ability to apply this knowledge to practical situations.
3. Capacity to search for information from different sources and to understand the explanations of non-expert people.
4. Basic skills in the use of computer resources in design and helping corporate data base models.
5. Develop research abilities
6. Develop oral and written communication abilities in their own language and others.
1. Introduction to database systems.
2. The relational model.
3. Calculus and Relational algebra.
4. The SQL language.
5. Transaction management.
6. Concurrency control.
7. Administration and tools.
8. Query optimization.
9. Laws on data protection.
The unit contains some theory lectures as well as some group work.
1) In order to pass the course, the student has to pass the first and the second semester.
- The student has to pass the theory with a grade greater or equal than 5.
- There is also an extra exam in July.
- The grades of one course are not maintained for subsequent courses.
The continuous assessment can help the student to pass the subject theory.
- The Continuous Assessment will consist of problem resolution to be delivered into the virtual campus.
The course can be followed in the form of continuous assessment through the completion and delivery of the proposed work in the virtual campus. In this case the final grade of the theory is the greatest of: The final theory exam or (70% of the final tehory exam + 30% of the continuous assessment), if the final exam grade of the theory is greater or equal than 3.5. Otherwise, the final grade of the theory is the grade of the theory exam.
1. General basic knowledge of file systems and data base management systems. [A][J][D]
2. Ability to apply this knowledge to practical situations. [G][L][K]
3. Capacity to search for information from different sources and to understand the explanations of non-expert people. [G][E]
4. Basic skills in the use of computer resources in design and helping corporate data base models. [A][G][K]
5. Develop research abilities [D]
6. Develop oral and written communication abilities in their own language and others. [D][K][J]
[1] R.Groff, P.N.Weinberg and A.J.Oppel, SQL: The Complete Reference, 3rd Edition, McGraw-Hill, ISBN: 978-0071592550, 2009.
[2] J.D.Ullman and J.Widom, A First Course in Database Systems, 3rd Edition, Prentice Hall, ISBN: 978-0136006374, 2007.
[3] Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom, Database Systems: The Complete Book, 2nd Edition, Prentice Hall, 2008.
[4] Garcia-Molina, Hector; Ullman, Jeffrey D.; Widom, Jennifer, Database System Implementation, Prentice-Hall, 2000.
[5] Özsu M.Tamer and Patrick Valduriez, Principles of Distributed Database Systems, Third Edition, Springer, 2011.