Universidad de Jaén

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.

Competences CB2R, CB3R, CB5R, CC12R will be evaluated through aspects S1, S2 and S4. Competence CT6 will be assessed through aspect S1.

The learning outcomes through aspects S1, S2 and S4.

It is required to pass the course 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) 60 % of the course grade requires the accomplishment of a theory exam. 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.

 Every one of these concepts is described below.

The theoretical part of the course (S2) is composed:

• Theory exam (S2): It corresponds to 60% of the overall grade of the course in the S2 concept. It is required to pass this exam with a minimum of 30% 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.

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 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.

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 (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