
Menú local
Syllabus 2020-21 - 13312013 - Database Foundations (Fundamentos de bases de datos)
- Level 1: Tutorial support sessions, materials and exams in this language
- Level 2: Tutorial support sessions, materials, exams and seminars in this language
- Level 3: Tutorial support sessions, materials, exams, seminars and regular lectures in this language
DEGREE: | Grado en Ingeniería informática |
FACULTY: | SCHOOL OF ENGINEERING OF JAÉN |
ACADEMIC YEAR: | 2020-21 |
COURSE: | Database Foundations |
NAME: Database Foundations | |||||
CODE: 13312013 | ACADEMIC YEAR: 2020-21 | ||||
LANGUAGE: English | LEVEL: 3 | ||||
ECTS CREDITS: 6.0 | YEAR: 2 | SEMESTER: SC |
NAME: MOLINA AGUILAR, ANDRÉS | ||
DEPARTMENT: U118 - INFORMÁTICA | ||
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS | ||
OFFICE NO.: A3 - 135 | E-MAIL: molina@ujaen.es | P: 953212889 |
WEBSITE: - | ||
ORCID: https://orcid.org/0000-0002-7823-8348 | ||
LANGUAGE: - | LEVEL: 3 | |
NAME: MARTÍNEZ CRUZ, CARMEN JOSEFA | ||
DEPARTMENT: U118 - INFORMÁTICA | ||
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS | ||
OFFICE NO.: A3 - 118 | E-MAIL: cmcruz@ujaen.es | P: 953212411 |
WEBSITE: https://www.ujaen.es/departamentos/dinformatica/contactos/martinez-cruz-carmen | ||
ORCID: https://orcid.org/0000-0002-8117-0647 | ||
LANGUAGE: - | LEVEL: 3 |
THEORY PROGRAM
Introduction to Databases
1.1 Fundamental Concepts
1.2 Levels information
1.3 Functional description of the DBMS
The relational database approach
2.1 Relational data structure
2.2 Relational Algebra
The SQL language
3.1 Data Definition Language ( DDL )
3.2 Data Manipulation Language (DML )
The Entity / Relationship Model
4.1 Basic Concepts
4.2 Reduction to hierarchical relationships
4.3 Transformation of ternary relationships
4.4 Conversion strong weak entities
4.5 Application of relational database logical approach
toconceptual schemes
4.6 Normalization tables
PRACTICAL PROGRAM:
SQL Programming
1.1. Work environment Oracle SQL * Plus. Connecting toserver.
1.2 Commands CREATE TABLE , ALTER TABLE and DROP TABLE.
1.3 Inserting , modifying and deleting : Commands INSERT
,UPDATEand DELETE. Integrity Rules
1.4 Basic use of the SELECT command
1.7 Advanced use of the SELECT command
1.8 Subqueries in INSERT, DELETE and UPDATE
1.9 Managing views in SQL: CREATE VIEW Command
Database Project (integration of learned
concepts on a real case)
2.1. Preparation of the document requirements as
guidancedocument
2.2. Conceptual design (entity relationship model):
Definitionof entities and relationships, Defining constraints
anddocumentation
2.3. Relational Logic Design: Conversion N-M
relationships,validation rules and default values, documentation.
2.4.Generating DDL and DMLfor the selected DBMS.
The activities will include theoretical lectures where
database exercises will be discussed and resolved from a
requirements document.
Practical activities will include the implementation of
arelational database (Oracle DBMS) and the design and
implementationof queries over the database.
The tutorial classes include debate about the key concepts
ofthe subject and the resolution of advanced exercises.
The group and individual tutorials as established by the regulations are NOT PRESENTIAL. Therefore, the students themselves have to dedicate these hours to the resolution of problems and doubts.
Students with special educational needs should contact the Student Attention Service (Servicio de Atención y Ayudas al Estudiante) in order to receive the appropriate academic support
According to the provisions of Article 13 of the Regulations on
the Academic and
Evaluation Regime of the students of the University of
Jaén, the evaluation of the
subject will be global.
In order to pass the course, it will be necessary to obtain a
score of 5.0 points (of a
maximum of 10) after adding up the marks with the weights of
each one of the
following concepts:
- (S1) 5 % of the course grade requires the realization of a
set of exercises and
assumptions during the classes period.
- (S2) 30 % of the course grade requires the accomplishment
of a theory exam. A
minimum score required in this part.
- (S3) 30% of the course grade requires the development of a
work case or an class
exercise. There is not a minimum score required in this part.
- (S4) 35 % of the course grade is corresponded to the
practical part of the course.
There is not a minimum score required in this part.
In order to get this marks, the students must accomplish the
following rules for each
concept:
The theoretical part of the course is composed:
- Theory exam (S2): It corresponds to 30% of the overall
grade of the course in the S2
concept. It is required to pass this exam with a minimum of
15% of the overall grade (a
5 out of 10 on the exam) to be able to pass the course. If
this minimum is not obtained
the student will get only the mark of the exam and the other
parts of the course will
not be added. The exam will be held at all official
convocations, both ordinary and
extraordinary. The examination mark will not be kept from one
convocation to
another.
- Evaluation exercises (S3). It corresponds to 30% of the
overall mark of the course, in
the concept S3. These exercises must be delivered in the
required time and form. The
non-delivery of these exercises within the specified date
will result in a mark of 0.0 on
the exercises. These exercises can be delivered only during
the class period, and there
will be no deliveries in extraordinary calls.
The practical part of the course (S4) consists of:
- Practical scripts: 80% of the practical classes of the
course must be attended and all
the scripts must be solved and uploaded in time during the
class period. If for some
justified reason, the student is unable to attend to the
practical classes, you will have
to communicate this at the beginning of the term to the
teacher responsible for the
group, in order to find a solution that satisfies both
parties. The qualification will be
SUITABLE - NOT SUITABLE in this part of the course.
- Database Project. The mark of the practical part (S4) will
be that of the Database
Project if the practice scripts are qualified as SUITABLE. If
the scripts are NOT
SUITABLE, the grade in the practical part S4 will be 0.0
Other considerations:
- All the marks got by the student during the class period, that
is, marks related
with concepts S1, S3 and S4, will be maintained for the
ordinary and
extraordinary call of the same course.
- The copy/plagiarism in exams, written tests, works or
projects will carry the
mark of 0.0 in the course.
- During the class period, several mid-term exams could be
proposed.
- The tests and activities of both the theoretical and
practical part allow the
evaluation of all the competences and result learning
objectives included in
sections 6 and 7 of this course guide .
- Objects that will NOT be needed for the test (books, mobile
phones, etc.) will
be will be deposited in the place indicated by the teachers.
- The use or possession of electronic devices, mobile phones
(switched on or off)
will not be allowed, books, notes, particular instruments or
other objects other
than those specified by the teachers.
- Database design for mere mortals [Recurso electrónico] : a hands-on guide to relational database des. Edition: 3rd ed. Author: Hernandez, Michael J. (Michael James), 1955-. Publisher: Upper Saddle River, NJ : Addison-Wesley, c2013 (Library)
1)TEACHING METHODOLOGY AND TRAINING ACTIVITIES.
The activities that cannot be carried out in a
face-to-face mode will be developed in a
semi-attendance format with rotational assistance as
established in the document of
Academic Criteria for the adaptation of teaching during the
2021 academic year in
relation to the pandemic caused by the COVID-19, approved in
the GC nº17 of 2 July
2020 of the University of Jaén. These activities will
be carried out using
videoconference systems, provided that the capacity and
infrastructure of the space
assigned for teaching the course allow it.
The degree of attendance in this scenario will depend on the
classroom
Large group exhibition lectures:
* Modality: Face-to-face 50% rotation (*)
* Teaching methodology: Lectures are taught in the schedule
and classroom assigned
to a part of the group of students and broadcasted by
videoconference to the rest,
with periodic rotation of students, as determined by the
Center.
Small group lectures:
* Format: Face-to-face 50% rotation (*)
* Teaching methodology: Lectures are taught in the schedule
and classroom assigned
to a part of the group of students and broadcasted by
videoconference to the rest,
with periodic rotation of the students, as determined by the
Center.
2) EVALUATION SYSTEM
The evaluation system and instruments will be the same as for
the face-to-face mode,
replacing the face-to-face exams and activities by similar
exams and activities
developed through the use of the online teaching platform or
others that the
University of Jaén allows, as long as the identity of
the student is guaranteed.
3) RESOURCES.
All the video conference systems available in the spaces of the
University of Jaen, will
be used to do the lectures, as well as the
University's teaching platform. The activities
that cannot be carried out in a face-to-face modality, will
be performed by
synchronous and/or asynchronous activities through the
virtual teaching platform or
any other on-line tool that the University enables.
In any case, it is expressly forbidden to record and/or
broadcast any lecture or
activity of this course in a synchronous or asynchronous
without explicit permission
from the teacher.
1) TEACHING METHODOLOGY AND TRAINING ACTIVITIES.
The methodology followed in this modality will consist of the
realization of all teaching
activities in a synchronous and/or asynchronous way through
the virtual teaching
platform and the mechanisms that University of Jaen allows or
enables.
2) EVALUATION SYSTEM.
The evaluation system and instruments will be the same as for
the face-to-face
modality, replacing the face-to-face tests by similar tests
developed through the use of
the online teaching platform or others that the University of
Jaén allows or enables, as
long as the identity of the student is guaranteed.
3) RESOURCES.
The activities in this modality will be carried out through
synchronous and/or
asynchronous activities through the virtual teaching platform
or any other online
platform enabled by the University of Jaén.
In any case, it is expressly forbidden to record and/or
broadcast any lecture or
activity of this course in a synchronous or asynchronous
without explicit permission
from the teacher.
Institution in charge of data processing: Universidad de Jaén, Campus Las Lagunillas, s/n, 23071 Jaén
Data Protection Delegate: dpo@ujaen.es
Purpose: In accordance with the Universities Law and other national and regional regulations in force, carrying out exams and assessment tests corresponding to the courses students are registered in. In order to avoid frauds while sitting the exam, the exam will be answered using a videoconference system, being able the academic staff of the University of Jaén to compare and contrast the image of the person who is answering the exam with the student's photographic files. Likewise, in order to provide the exam with evidential content for revisions or claims, in accordance with current regulation frameworks, the exam will be recorded and stored.
Legitimacy: compliance with legal obligations (Universities Law) and other national and regional regulations currently in force.
Addressees: service providers who are the owners of the platforms where the exams are carried out and with whom the University of Jaén has signed the corresponding data access contracts.
Storage periods: those established in current in force regulations. In the specific case of exam videoconference recordings, not before the examination records and transcripts are closed or the exam can still be reviewed or challenged.
Rights: you can exercise your right of access, amendment, cancellation, opposition, suppression, limitation and portability by sending a letter to the postal or electronic address indicated above. In the event that you consider that your rights have been violated, you may submit a complaint to the Andalusian Council for Transparency and Data Protection www.ctpdandalucia.es
Person in charge: Universidad de Jaén, Paraje Las Lagunillas, s/n; Tel.953 212121; www.ujaen.es
Data protection delegate (DPO): TELEFÓNICA, S.A.U. ; Email: dpo@ujaen.es
Procedure aim: To manage proper recordings of teaching sessions with the aim of facilitating learning process under a multimodal and/or online teaching
Period for record storage: Images will be kept during legal term according to regulations in force
Legitimacy: Data will be managed according to legal regulations (Organic Law 6/2001, December 21, on Universities) and given consent provided by selecting corresponding box in legal admission documents
Data recipients (transfers or assignments): Any person allowed to get access to every teaching modality
Rights: You may exercise your rights of access, rectification, cancellation, portability, limitation of processing, deletion or, where appropriate, opposition. To exercise these rights, you must submit a written request to the Information, Registration and Electronic Administration Service of the University of Jaen at the address above, or by e-mail to the address above. You must specify which of these rights you are requesting to be satisfied and, at the same time, you must attach a photocopy of your ID card or equivalent identification document. In case you act through a representative, legal or voluntary, you must also provide a document that proves this representation and identification. Likewise, if you consider that your right to personal data protection has been violated, you may file a complaint with the Andalusian Data Protection and Transparency Council www.ctpdandalucia.es