Academic management

University of Oviedo

Uniovi.es | Home | Search | Site Map

| |

Bachelor´s Degree in Computer Science - Software Engineering
GIISOF01-2-008
Databases
General description and schedule Teaching Guide

Coordinator/s:

Darío Álvarez Gutiérrez
darioauniovi.es

Faculty:

Darío Álvarez Gutiérrez
darioauniovi.es
(English Group)
Beatriz Remeseiro Lopez
bremeseirouniovi.es
(English Group)
Pablo García Marcos
garciamarpablouniovi.es
(English Group)
Ana Belen Martinez Prieto
belenmpuniovi.es
Rodolfo Benito Arango
benitorodolfouniovi.es
Xiomarah María Guzmán Guzmán
guzmanxiomarahuniovi.es

Contextualization:

This course belongs to the Persistence area within the common Computing Module. It is directly related with the next course in this area: Information Repositories and Web Information Systems (elective).

It is a 6 ECTS credits, second year, second semester course with 150 hours work: 60 in-class hours and 90 personal study hours. In-class hours per week are as follows: 2 hour lecture sessions (up to 21 hours in total), 1 hour seminars (up to 7 hours), 2 hour lab sessions (up to 28 hours), and

Main topics:

Database Management Systems. Data models and the database development life cycle. Conceptual design of databases. Relational languages. Logical design using the relational model. Other models and database systems.

The main competences related to this course are:

  • Com.12 Knowledge and application of the characteristics, functionality and structure of databases allowing their appropriate use, and designing, analysing and implementing applications based on them.
  • Com.13 Knowledge and application of the tools required for storing, processing and access to information systems, including web-based systems.

Requirements:

First year and first semester of the second year taken (with an emphasis in Introduction to Programming, Programming Methodology, and Automatons and Discrete Mathematics), and specially Data Structures. It is also a bonus to be enrolled in the Operating Systems course.

Competences and learning results:

1- General competences

·       CG1  Competence for the design of solutions for complex human problems.

·       CG3  Abstraction capability.

·       CG5  Competence for the analysis, selection, and usage of basic and support computing tools.

·       CG7 Ability in written expression.

·       CG21 Professional ethics.

·       CG25 Critical thinking.

2- Specific competences

  • Bas.4 Basic knowledge on computer use and programming, operating systems, data bases and computer programs applied in engineering.
  • Com.1 Capacity to design, develop, select and evaluate computer applications and computer systems, ensuring their reliability, safety and quality according to the ethical principles and the legislation and norms in force.
  • Com.5 Knowledge, administration and maintenance of computer systems, services and applications.
  • Com.8 Capacity to analyse, design, construct and maintain efficient and safe robust applications, choosing the most appropriate programming paradigm and languages.
  • Com.12 Knowledge and application of the characteristics, functionality and structure of databases allowing their appropriate use, and designing, analysing and implementing applications based on them.
  • Com.13 Knowledge and application of the tools required for storing, processing and access to information systems, including web-based systems.

 Learning results

The student will be able to:

  • RA.SIP-1. Identify reasons why a Database Management System (DBMS) is needed in a computing system.
  • RA-SIP-3. Know the architecture and implementation of a DBMS.
  • RA-SIP-4. Use a commercial DMBS with SQL and other languages.
  • RA.SIP-5. Perform the full design of a relational database system, including the documentation and the implementation with a commercial DBMS.
  • RA.SIP-6. Know and comprehend the fundamental features of information repositories.
  • RA.SIP-8. Know and use different languages, patterns, and standards to manage information.
  • RA.SIP-9. Evaluate, configure, and administer different persistent systems.
  • RA.SIP-13. Perform the conceptual modeling of an information repository.
  • RA.SIP-14. Analyse and develop solutions based on information repositories.
  • RA.SIP-15. Use and develop tools for information retrieval and processing.

 

 

Contents:

  1. Introduction and structure of Database Management Systems (DBMS)

·         Fundamental concepts in databases

·         Advantages of DMBS

·         DMBS structure

·         Introduction to data models

·         Database lifecycle

  1. Conceptual design using the Entity-Relationship (ER) model

·         Main elements of the ER model

·         Integrity constraints in the ER model: cardinality, superkeys, primary keys, candidate keys

·         Additional elements of the extended ER model

  1. Relational model

·         Main elements of the relational model

·         Primary and foreign keys

·         Formal query languages

  1. The SQL relational language and applications development

·         Main elements of the SQL as a data management language

·         Advanced queries in SQL

·         SQL as a data definition language

·         Applications development in SQL (PL/SQL, and using libraries).

·         Integrity constraints in SQL (assertions and triggers)

  1. Integrity constraints

·         Using integrity constraints

·         Domains, keys, and referential integrity

·         Functional dependencies

  1. Logical design using the relational model

·         Fundamentals of relational normalization theory

·         Normal forms and normalization algorithms

  1. Introduction to other data models

·         Object-oriented, object-relational, XML, logical, and NoSQL models.

Methodology and work plan:

Interactive lectures, activities favoring active learning and for the out-of-class work (such as assignments, and evaluation activities needing previous work).

 

Summary:

 

 

Hours

%

Total

In-class

Lectures

21

14

58 hours

(39 %)

Seminars

7

5

Lab sessions

28

19

-

0

0

 Tutoring

2

1

-

0

0

-

0

0

Personal study

Group work

26

17

92 hours

(61 %)

Individual work

66

44

 

Total

150

 

 

Extraordinarily, if required for sanitary conditions, non-presential teaching methods can be included. In that case, students will be informed about the changes.

Assessment of students learning:

There are two types of evaluation:

Continuous assessment (ordinary call) (“May/June”)

There are two global aspects: theory and lab.

Grade = 0.5 * gradeTheory + 0.5 * gradeLab. Course is passed with Grade >= 50% (5 points out of 10).

Theory: Written tests: essay, and/or multiple choice, and/or exercises. Other assignments optionally to be delivered along the semester. Exercises 62.5%, concepts tests (e.g. multiple choice) 37.5%. 30% compulsory in each of the evaluated elements.

Lab: Several live development laboratory tests taken along the semester (50% of the final grade). 40% required in each test.

40% coverage of theory and lab is mandatory.

80% attendance is mandatory.

Extraordinary call assessment (“July”), Extraordinary ahead assessment (“January”) and differentiated assessment

Theory: Test (theory part of the final exam), with contents, structure, and requirements equivalent to the ordinary continuous assessment (may/june).

Lab: Live development test (lab part of the final exam). The lab test will have several parts. Each part could have a minimum grade.

Grade = 0,5 * gradeTheory + 0,5 * gradeLab. Course is passed with Grade >= 50% (5 points out of 10).

40% coverage of theory and lab is mandatory.

Absent and Fail (calculation of the grade)

Students that do not take evaluation activities which amount to 50% of the grade will get and “Absent”. If the student takes the evaluation activities which amount to at least 50% of the grade, and some minimum requirements for theory and/or lab are not met, then the student will get “Fail”. In this case, the final numeric grade will be calculated with the specified weights, with an upper limit of 4.

Extraordinarily, if required for sanitary conditions, non-presential evaluation methods can be included. In that case, students will be informed about the changes.
 

Resources, bibliography and documentation:

Basic resources

  • Theory
    • (CAS) Fundamentos de Diseño de Bases de Datos. Quinta Edición. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 2006 (libro de texto)
    • (CAS) Fundamentos de Bases de Datos. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 4ª, 5ª, 6ª edición, 2006-2014 (libro de texto, versión ampliada)
    • (ENG) Database System Concepts. 4th, 5th, 6th, or 7th edition. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 2001-2019 (textbook)
    • (ENG) Fundamentals of database systems. 5th or 6th edition. R. Elmasri, S.B. Navathe. Addison-Wesley, 2006-2010 (alternative textbook)
    • (CAS) Fundamentos de Sistemas de Bases de Datos. Quinta Edición. R. Elmasri, S.B. Navathe. Addison-Wesley, 2007 (libro de texto alternativo)
    • (CAS) Tecnología y diseño de bases de datos. M. Piattini, E. Marcos, C. Calero, B. Vela. Rama,  2006. (libro de texto alternativo)
  • SQL
    • (CAS/ENG) The Practical SQL Handbook. Using SQL Variants.J.S. Bowman, S.L. Emerson, M. Darnovsky.Addison-Wesley, 2001
    • (CAS/ENG) A Guide to the SQL Standard (Fourth Edition). C.J. Date, H. Darwen. Addison-Wesley, 1997
  • Oracle
    • (CAS/ENG) Online Oracle documentation at http://www.oracle.com/technetwork/es/documentation/index.html