This work publishes with a licence BY-NC-SA Creative Commons License
Introduction to the basic technicians of databases, fundamental for the effective and efficient development of the software of gestión and of many other areas that benefit of his power and versatilidad.
|Archives||Educational resources||Resources web|
Classes of theory divided in 2 parts of 50 minutes each one; practices in computer.
CONTINUOUS EVALUATION (25%) Intermediate of theory:
Basically of type test, together with some exercise of direct application of the theory. They will realise 2 during the course, of 1 hour each one
CONTINUOUS EVALUATION (50%) SQL
Minicontroles At the end of the session of practices related with the seen in them. 10 controls of 10 min.
FINAL EXAMINATION (25%) theoretical Examination-practical
Examination written in the official date of the UA, basically of exercises of application of the theory, in first announcement (June) and recovery (July). No more than 3 hours.
Subject 1: Organisation
General aims of the asignatura. Contents. System of evaluation, description of activities to realise.
Subject 2: Files and technical of database
Historical justification of the technicians of BD. Main types and organisations of files, advantages and disadvantages. I mark of application and relation with the company of the databases. Legal questions associated to the gestión of big volumes of data.
Subject 3: The model of data Entity-Relation
Basic concepts of the model and function of the same in the technicians of BD.
Subject 4: The model of Relational data
Field of application. Mathematical foundations and his implementation: concepts of relation, command and attribute.
Keys of identification, extraneous keys, invalid value.
Integrity of key, referential integrity.
Representation of systems of information, design of diagrams of relational database.
Languages of definition and manipulation of data: algebra and relational calculations and SQL; relational languages and computationally complete.
Normalisation: concept of functional dependency. Normal forms.
Subject 5: Systems of gestión of databases
Basic concepts of the DBMS: architecture, functions, components, transactions, optimisation and performance, security. Databases distributed. Other models of data
Material (complete listing)
|Presentation of Foundations of the Databases (course 2011-2012)|
|Foundations of the Databases. Exercises hour1 (course 2012-2013)|
|Foundations of the Databases. Conceptual maps (course 2012-2013)|
|Foundations of the Databases. 2011-12 Results of the evaluation (course 2012-2013)|
|Foundations of the Databases. 2012C2 Examination (course 2012-2013)|
|Foundations of the Databases. 2011C1 final Examinations (course 2012-2013)|
|Foundations of the Databases. 2011C2 final Examinations (course 2012-2013)|
|Foundations of the Databases. Theory2 concepts and exercises (course 2012-2013)|
|Foundations of the Databases. 2012C1 final Examination (course 2012-2013)|
|Foundations of the Databases. Presentations Theory1 (course 2012-2013)|
|Relation "One to Many" with restriction of existence 1-N RE|
|Relation "Many to A lot of" N-N|
|Relation "One to A lot of" 1-N|
|Foundations of the Databases. SQL lessons|
|Foundations of the Databases. Diagrams of database TiendaOnLine|
|Foundations of the Databases. SQL exercises|
|User MySQL and HeidiSQL|
|SQL a simple query|
|SQL users and places in the BD of practice|
|BDtolER.Pdf||FBD bdTOL Diagram entity-relation|
|BDtolERdetalle.Pdf||FBD bdTOL Detail and explanations|
|BDtolMR.Pdf||FBD bdTOL Relational diagram|
|S1||T1To history.Pdf||History of the computing.||SB Maps.Pdf||Links to conceptual maps on some appearances of the theory to develop.||T01_concept_BD_and_relacion.Pdf||FBD T01 Concept of BD and relation|
|T1B files.Pdf||Files, access and organisation.|
|S2||T2To models data.Pdf||Models of data.||SB02 exercises.Pdf||Exercises SB02.||T02_Queries.Pdf||T02 Queries (part 1)||Key candidate|
|S3||T2B-1 entity-relation.Pdf||Model entity-relation.||SB03 exercises.Pdf||Exercises SB03.||T02B_Queries.Pdf||T02 Queries (part 2)||SQL a simple query|
|S4||T2B-2 ER2MR.Pdf||Transformation ER-relational model (supports in the contents of THEORY2).||SB04 Correspondence classes.Pdf||Correspondence between classes, relations and cardinalidad.||T03_Expressions_of_seleccion_of_rows.Pdf||T03 Expressions of selection of rows||Relation "One to A lot of" 1-N|
|SB04 exercises.Pdf||Exercises SB04.||Relation "One to Many" with restriction of existence 1-N RE|
|Relation "Many to A lot of" N-N|
|S5||T2B-3 ERnotación.Pdf||Notations used in the model, graphic variants.||SB05 exercises.Pdf||Exercises SB05.||T04_Dates_and_time.Pdf||T04 Dates and time||SQL users and places in the BD of practice|
|S6||T3 relational model.Pdf||Mathematical base of the relational model.||SB06 referential integrity.Pdf||Referential integrity.||T05_reunion-join.Pdf||T05 Meeting (join)|
|SB06 exercises.Pdf||Exercises SB06.|
|S7||T4To relational algebra.Pdf||Relational algebra, all the operators less the division.||SB07 exercises.Pdf||Exercises SB07.||T06_Definicion_and_manipulacion_of_data.Pdf||T06 Definition and manipulation of data|
|S8||T4B relational algebra.Pdf||Relational algebra, division.||SB08 exercises.Pdf||Exercises SB08.||T07_Options_of_referential_integrity.Pdf||T07 Options of referential integrity|
|S9||T4B relational calculation.Pdf||Relational calculation.||T08_Aritmetica_of_column.Pdf||T08 Arithmetic of column|
|S10||T5To normalisation.Pdf||Normalisation, first, second and third normal forms.||SB10 exercises.Pdf||Exercises SB10. (The ítem SB09 does not exist, this session uses for possible delays).||T09_Agregacion.Pdf||T09 Aggregation|
|S11||T5B normalisation.Pdf||Normalisation, fourth and fifth normal forms.||SB11 examination.Pdf||Preparation for the FINAL examination.||T11_Groups.Pdf||T11 Groups|
|S12||T6 systems of gestión of bd.Pdf||Systems of gestión of databases (DBMS).||SB12 examination.Pdf||Preparation for the FINAL examination.||T12_Seen_and_temporary_tables.Pdf||T12 Seen and temporary tables|
|Txx Exercises.Pdf||Billed of the exercises of THEORY1 (hour 1 of the sessions of theory)|
|Txx Exercises SOLU.Pdf||Solutions to the exercises||SBxx Solutions.Pdf||Solutions to the exercises.||fbdSQLejersolu.Pdf||Solutions to the exercises SQL|
Universidad de Alicante
Carretera de San Vicente del Raspeig s/n
03690 San Vicente del Raspeig
Tel: (+34) 96 590 3400Fax: (+34) 96 590 3464