Center
|
Faculty of Geography and History |
Departament
|
Computer Science |
Lecturers in charge
|
H8007 - ARIADNA FUERTES SEDER |
Met. Docent
|
During the lessons, the theorical concepts are teached and theoretical-practices questions and problems are developped. All concepts are also implemented on the computer during the sessions of practices. |
Met. Avaluació
|
Continuos evaluation - - |
Bibliografia
|
Fundamentos de Bases de Datos Henry F. Korth. Abraham Silberschatz.. McGraw Hill, 1999 () Introducción a las bases de datos Jefrey D. Ullman . Prentice Hall, 1999 () Introducción a las bases de datos relacionales. A. Mendelzon & Juan Ale. Ed: Prentice Hall 2000 Sistemas de Bases de Datos. Conceptos fundamentales. Ramez Elmasri, Shamkant B. Navathe. Ed: Addison-Wesley. 2001. SQL para usuarios y programadores. J. Benavides, J.M. Olaizola y E. Rivero. Ed: Paraninfo. 1992. |
Continguts
|
The goal of this course is to provide students with the foundations of databases using the relational DBMS model, as well as to develop basic skills in using the database language, interactive SQL. In the subjet, a consistent methodology of design of relational databases is presented, covering from the conceptual design to the physical design, that will allow the student to analyze and to design its own relational databases, and also to recover information by means of queries in SQL. The theoretical part is complemented with the practical module in which it is learned to handle to the BD tool Access in order that the student is able to implement the relational DB designs and to carry out SQL queries on them. Summarizing, the contents are: Introduction to Databases. Basic concepts of relational Data Bases and Principles of design for relational DB. Conceptual design of relational DB: Entity-Relationship diagrams. Logical design of relational DB: Relational model and Relational algebra. SQL Query Language. Theory of the Normalization. |
Objetius
|
|
URL de Fitxa
|
http://aulavirtual.uv.es |