Educational guide
IDENTIFYING DATA							2023_24
Subject	Databases					Code	00810010
Study programme	0810 - G.ING.EN GEOMÁTICA Y TOPOGRAFÍA (PONFERRADA)
Descriptors	Credit.	Type	Year	Period
	6	Basic Training	First	Second
Language	Castellano
Prerequisites
Department	ING.ELECTR.DE SIST. Y AUTOMATI
Coordinador	RIESCO PELÁEZ , FÉLIX				E-mail	friep@unileon.es mapram@unileon.es
Lecturers	PRADA MEDRANO , MIGUEL ANGEL RIESCO PELÁEZ , FÉLIX
Web	http://www.unileon.es/estudiantes/oferta-academica/grados/grado-en-geomatica-y-topografia/plan-estudios?id=0810010&cursoa=2020
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	Tribunal titular Cargo Departamento Profesor Presidente ING.ELECTR.DE SIST. Y AUTOMATI ALEGRE GUTIERREZ , ENRIQUE Secretario ING.ELECTR.DE SIST. Y AUTOMATI ALAIZ RODRIGUEZ , ROCIO Vocal ING.ELECTR.DE SIST. Y AUTOMATI DIEZ DIEZ , ANGELA Tribunal suplente Cargo Departamento Profesor Presidente ING.ELECTR.DE SIST. Y AUTOMATI BLAZQUEZ QUINTANA , LUIS FELIPE Secretario ING.ELECTR.DE SIST. Y AUTOMATI RODRIGUEZ SEDANO , FRANCISCO JESUS Vocal ING.ELECTR.DE SIST. Y AUTOMATI BENAVIDES CUELLAR , MARIA DEL CARMEN

Competencias

Code
A3073
A3208
A3209
A3212
A3225
A3226
A3232
A3244
A3245
B385
C5	CMECES5 That students have developed those learning skills necessary to undertake further studies with a high degree of autonomy

Learning aims

	Competences
	A3232
	A3073
	A3073 A3209
			C5
	A3208	B385
	A3212
	A3226
	A3244
	A3245
	A3225

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

Methodologies   ::  

	Description
Practicals using information and communication technologies (ICTs) in computer rooms
Seminars
Tutorship of group
Lecture

Personalized attention

Practicals using information and communication technologies (ICTs) in computer rooms Tutorship of group

Description

Assessment

	Description	Qualification
		30%
Extended-answer tests		40%
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 Martin Kleppmann, Diseño de aplicaciones mediante el uso intensivo de datos, Marcombo, España 2022 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 Sébastien Chazallet, Python 3. Los fundamentos del lenguaje, Ediciones ENI, Barcelona 2016 Óscar Ramírez Jiménez, Python a fondo, Marcombo S.L., Madrid 2021 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 María Teresa Jimeno García, María Ángeles Caballero Velasco et al., La Biblia del Hacker, Anaya Multimedia, Madrid 2012 Ellie Quigley, Marko Gargenta, PHP y MySQL práctico para diseñadores y programadores Web, Anaya Multimedia, Madrid 2008 Álvaro Corredor Lanas, WordPress Profesional Edition 2017, Ra-Ma, Madrid 2017

Recommendations

Subjects that it is recommended to have taken before

Introduction to Computer Science / 00810004