Educational guide | ||||||||||||||||||||||
IDENTIFYING DATA | 2023_24 | |||||||||||||||||||||
Subject | DATABASES | Code | 00810050 | |||||||||||||||||||
Study programme | ||||||||||||||||||||||
Descriptors | Credit. | Type | Year | Period | ||||||||||||||||||
6 | Compulsory | CA | ||||||||||||||||||||
Language |
|
|||||||||||||||||||||
Prerequisites | ||||||||||||||||||||||
Department | ||||||||||||||||||||||
Coordinador | ||||||||||||||||||||||
Lecturers | |
|||||||||||||||||||||
Web | http://www.unileon.es/estudiantes/estudiantes-grado/oferta-de-estudios/planes?id=0810010&curso=2015 | |||||||||||||||||||||
General description | General concepts of Databases: Tables, registers and attributes Models and schemes: Entity-Relationship (ER), Extended Entity Relationship (EER) The language SQL: Examples of Databases resolved in MySQL. The Relational model: Translation of models Spatial extensions and functions in MySQL Database Administration: users and permissions | |||||||||||||||||||||
Tribunales de Revisión |
|
|||||||||||||||||||||
Competencias |
Code | |
C5 | CMECES5 That students have developed those learning skills necessary to undertake further studies with a high degree of autonomy |
Learning aims |
Competences | |||
B390 |
|||
B390 |
|||
B390 |
|||
C5 |
|||
B389 |
|||
B391 |
|||
B403 |
|||
B392 |
|||
B397 |
|||
B398 B402 B403 |
Contents |
Topic | Sub-topic |
Planning |
Methodologies :: Tests | |||||||||
Class hours | Hours outside the classroom | Total hours | |||||||
Practicals using information and communication technologies (ICTs) in computer rooms | 30 | 45 | 75 | ||||||
Seminars | 5 | 15 | 20 | ||||||
Tutorship of group | 2 | 0 | 2 | ||||||
Lecture | 20 | 30 | 50 | ||||||
1 | 0 | 1 | |||||||
Extended-answer tests | 2 | 0 | 2 | ||||||
(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students. |
Methodologies |
Description | |
Practicals using information and communication technologies (ICTs) in computer rooms | |
Seminars | |
Tutorship of group | |
Lecture |
Personalized attention |
|
|
Assessment |
Description | Qualification | ||
25.0% a 35.0 % | |||
Extended-answer tests | 35.0% a 45.0% | ||
Other comments and second call | |||
Sources of information |
Access to Recommended Bibliography in the Catalog ULE |
Basic |
Fracisco Charte Ojeda, Access 2010, Anaya Multimedia, Madrid 2010 Michael R. Groh, Access 2010, Anaya Multimedia, Madrid 2010 M. Pérez, Access 2010 en profundidad, RC Libros, Madrid 2010 Alan Beaulieu, Aprende SQL, Anaya Multimedia, Madrid 2009 Carlos Coronel, Steven Morris, Bases de Datos. Diseño, implementación y administración, Cengage Learning, México 2011 Dolores Cuadra, Elena Castro, Desarrollo de Bases de Datos, RA-MA, Paracuellos del Jarama, Madrid 2013 Ramez A. Elmasri Shamkant B. Navathe, Fundamentos de Sistemas de Bases de Datos, Addison Wesley, Madrid 2002 Paul DuBois, MySQL. Edición revisada y actualizada 2009, Anaya Multimedia, Madrid 2009 Paul Beynon-Davies, Sistemas de Bases de Datos, Reverté, Barcelona 2014 Fracisco Charte Ojeda, SQL, Anaya Multimedia, Madrid 2010 |
Complementary |
Luis Joyanes Aguilar, Big Data, Marcombo, Mexico 2013 Scott Mc Cracken, Curso de Programación Web, INFORBOOK'S SL, Barcelona 2011 Lewis T. G. Smith M. Z., Estructuras de Datos, Paraninfo, Madrid 1985 Ellie Quigley, Marko Gargenta, PHP y MySQL práctico para diseñadores y programadores Web, Anaya Multimedia, Madrid 2008 |
Recommendations |
Subjects that it is recommended to have taken before | ||
|