OpenCourseWare UA

Saltar menú

Saltar contenido
### Fundamentos de las bases de datos (2011)

## ARMANDO SUÁREZ CUETO

PATRICIO MARTÍNEZ SHIP

EVA GÓMEZ BALLESTER

ESTELA SAQUETE BORÓ

PALOMA MOREDA POZO

** Area of knowledge **

Engineering and Architecture

** **

Department

Languages and Computer Systems

** **

Studies in which it gives

Degree in Computer Engineering

Degree in Multimedia engineering

#### Description

#### Aims

#### Methodology and Evaluation

#### Contents

#### Plan of learning with links of download of the materials

#### Bibliography

PATRICIO MARTÍNEZ SHIP

EVA GÓMEZ BALLESTER

ESTELA SAQUETE BORÓ

PALOMA MOREDA POZO

Engineering and Architecture

Department

Languages and Computer Systems

Studies in which it gives

Degree in Computer Engineering

Degree in Multimedia engineering

** **

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.

## Materials published |
||||||||||||||||

Archives | Educational resources | Resources web | ||||||||||||||

doc | html | ppt | avi/mpeg/swf | Mp3 | Subjects | Practices | Exercises | Examinations | Articles | Site | docuwiki | Blog | moodle | Others |

- Know and know apply technicians of persistent storage.
- Know and know apply the basic concepts of design of a database that reflect a system of information.
- Know develop and keep systems of basic relational databases.

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)

BDtolER.Pdf | FBD bdTOL Diagram entity-relation | ||||||

BDtolERdetalle.Pdf | FBD bdTOL Detail and explanations | ||||||

BDtolMR.Pdf | FBD bdTOL Relational diagram | ||||||

fbdSQLejer.Pdf | Exercises SQL | ||||||

Hour1 | Hour2 | Practice | Video | ||||

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 |

- Silberschatz, Abraham,
### History and files: arrival of the technicians of BD

Silberschatz, Abraham,### History

Software crisis Wikipedia In what consists and how arose the term. History of the computing Sonia Lurueña Jiménez Curious exhibition of the evolution of the computing. History of the databases History of the Computing Brief and easy to read, evolution of the technicians of storage and processing of data from a lot before the apparition of the computers, tied precisely to the technological state of each moment. The way to the Relational Databases Macluskey Curious approximation with a lot of interesting data to the historical route of the computing until arriving to the databases, that includes also to the file.### Files

Organisations of files and structures of access (1) .

Organisations of files and structures of access (2) .

Questions and answers . Mercedes Marquis In format### Models of data

It dates model Wikipedia Extensive entrance in the wikipedia, interests us extract the most notable data: what are and for what serve, which types there is and which models can stand out . Databases: models of data Antonio Moreno This publication has chosen by his shortness and concisión, is practically a summary of the commented in class. Concept of model of data (presentation pdf) Group Kybele Another punto with a lot of coincidences with the aims of this subject in the asignatura.### Entity relation

Entity-relationship model Wikipedia### Relational model

The relational model Carlos To. García Chavez### Algebra and relational calculations

The relational algebra Blog FBD Of why it is so important this subject inside the asignatura. Relational calculation: ¿but which need have I%u2026? Blog FBD Origin, details and justification of his inclusion in the temario, of form excessively brief, of these languages. Relational algebra Wikipedia To see that the relational algebra has more operators or versions of operators that approach it more to the core of SQL (rather, the other way around). To stand out the aim on his utilisation in optimisation of queries. Also a pair of links to implementations of the language that can download and test. Relational calculation Francisco Ruiz González The definition of the language in all his extension. The logical perspective of the relational model Eva Gómez, Patricio Martínez, Paloma Moreda, Armando Suárez, Andrés Montoyo, Estela Saquete Of own production, with aims resembled i604, does more upsetting in the idea of "another form" to see a database.### Normalisation

Normalise, that not "formalising" Blog FBD An introductory text, for what serves to normalise. Here it goes, the 4FN and the 5FN Blog FBD A reflection on these normal forms.### Systems of databases

Comparison of database tools Wikipedia More than at all, for showing that systems of databases there are many, but more, still, tools of access, design, etc. Model-ANSI-X3-SPARC Edu Mendez Source used in the presentation of the subject. Councils to optimise databases MySQL Pablo Javier Suárez Compilation of links on optimisation in MySQL. Panoramic on optimisation MySQL Documentation Chapter of the manual MySQL that serves of entrance to the most specific details related with the performance of the engine of database. Query optimization in DBMS Koolcampus Slideshow that shows diverse appearances of the performance of a query and his optimisation. EXPLAIN MySQL or how optimise SQL Sergi Quiñonero On the commando EXPLAIN in MySQL. The commando EXPLAIN MySQL Documentation EXPLAIN In the manual MySQL. Query optimization Yannis And. Ioannidis On the optimisation of queries. Optimisation of the clauses WHERE by part of MySQL MySQL Documentation How "help" to MySQL when we write conditions in*the where*. Optimisation of Queries SQL splits II World Business Intelligence More on how write consult SQL. Optimise subconsultas MySQL Documentation Another on how help to MySQL. This and the previous are more headed to the practice in SQL that to the theory, but help to give account that MySQL (or any DBMS) does not do it everything.

Saltar pie

OpenCourseWare UA

Last update 10-Jun-2013 13:04:11

Saltar dirección
POSTAL ADDRESS

Universidad de Alicante

Carretera de San Vicente del Raspeig s/n

03690 San Vicente del Raspeig

Alicante (Spain)

Tel: (+34) 96 590 3400

Fax: (+34) 96 590 3464