Universidad de Jaén

THEORY PROGRAM

1. Introduction to Databases
1.1 Fundamental Concepts
1.2 Levels information
1.3 Functional description of the DBMS
2. The relational database approach
2.1 Relational data structure
2.2 Relational Algebra
3. The SQL language
3.1 Data Definition Language ( DDL )
3.2 Data Manipulation Language (DML )
4. 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 to conceptual schemes
4.6 Normalization tables

PRACTICAL PROGRAM:

1. 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.5 Advanced use of the SELECT command
1.6 Subqueries in INSERT, DELETE and UPDATE
1.7 Managing views in SQL: CREATE VIEW Command
2. 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.

In theory the competences CB2R, CB3R, CB5R, CC12R and CT6 will be worked on. In practicals the competences CC12R and CT6 and in group tutorials the competences CC12R and CT6.

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

In accordance with the provisions of art. 13 of the Regulations of Academic Regime and Evaluation of the students of the University of Jaén, the evaluation of the subject will be global.

In order to pass the subject, it will be necessary to obtain a score of 5.0 after adding the marks of the following concepts:

- (S1) 5 % of the mark for the completion of exercises and assumptions.

- (S2) 60 % of the mark for the theory exam (Minimum mark required for this part).

- (S4) 35 % of the mark for the practical part (No minimum mark is required for this part).

The theory part of the course consists of:

Theory exam (S2): This corresponds to 60% of the overall grade of the subject in the S2 concept. Passing this exam is required (a 5 out of 10 in the exam). If this minimum is not obtained, the final grade will be the grade obtained in the exam, without considering the rest of the grades obtained in S1 and S4. The exam will be taken in all official exams, both ordinary and extraordinary. The exam mark will not be saved from one exam session to another. The competences CB2R, CB3R, CB5R, CC12R and CT6 will be assessed.

The practical part of the course (S4) consists of:

- Practical scripts: 80% of the practical classes of the subject must be attended and all the scripts must be completed. If, for any justified reason, the student cannot attend the practical classes continuously, he/she must inform the teacher responsible for the group at the beginning of the term, in order to find a solution that satisfies both parties. The grade will be PASS - FAIL
- Database Project: Numerical grade 0..10

The final grade for the practical part (S4) will be the grade for the Database Project if the practical scripts are graded PASS. If the scripts are NOT PASSED, the grade in the practical part S4 will be 0.0. Both the project and the scripts will assess the competences CC12R and CT6.

The grade obtained by the student during the teaching period (concepts S1 and S4) will be maintained for the official exams of the same course.

The exercises/projects/assignments/cases/scripts/ for the evaluation of aspects S1 and S4, must be delivered in due time and form, with no extraordinary deliveries.

Copying/plagiarism in exams, written tests, assignments or projects will lead to a grade of 0.0 in the subject.

During the academic term, evaluative tests of part of the syllabus may be carried out.

The tests and activities of both the theoretical and practical parts allow the evaluation of all the competences and learning outcomes included in sections 6 and 7 of this Teaching Guide.

Objects that are NOT going to be used for the exam (books, mobile phones, etc.) will be deposited in the place indicated by the teachers.

The use or possession of electronic devices, mobile phones (switched on or off), books, notes, private instruments or objects other than those specified by the teachers will not be permitted.

1)TEACHING METHODOLOGY AND TRAINING ACTIVITIES.

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 (presential exam).
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