Double Degree in International Computer Engineering and Management of Business and Technology

Database Systems

Back to Syllabus

Description
Basic concepts in files, conceptualization and characterization of access to secondary memory structures are treated. Introduction to data base management systems: concepts and typology, historical evolution and their access languages and main functions. A prospective of data bases oriented to objects is introduced. Likewise, works on the model of corporate data and entity relationship model, from the conceptual model to its implementation are done. The main functions of DBMS and the file systems are treated from the point of view of an advanced user and the design and implementation of corporative data is done in one or more cases of study.
Type Subject
Tercer - Obligatoria
Semester
Annual
Course
2
Credits
5.00
Previous Knowledge

Basic Programming, Basic algorithm, Data Structures

Objectives

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.

Contents

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.

Methodology

The unit contains some theory lectures as well as some group work.

Evaluation

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.

Evaluation Criteria

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]

Basic Bibliography

[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.