Menú local
Syllabus 2014-15 - 13211002 - Data Bases (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 geomática y topográfica |
FACULTY: | SCHOOL OF ENGINEERING OF JAÉN |
ACADEMIC YEAR: | 2014-15 |
COURSE: | Data Bases |
NAME: Data Bases | |||||
CODE: 13211002 | ACADEMIC YEAR: 2014-15 | ||||
LANGUAGE: English | LEVEL: 1 | ||||
ECTS CREDITS: 6.0 | YEAR: 1 | 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: English | LEVEL: 1 |
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 model
Entity / Relationship
4.1
Fundamental 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 to
server.
1.2
Commands
CREATE TABLE
, ALTER
TABLE and
DELETE
TABLE.
1.3
Inserting
, modifying
and deleting
: Commands
INSERT
, UPDATE
and
DELETE
Integrity
Rules
1.4
Consultation of
information
I.
Basic uses
of the SELECT
1.7
Consultation of
information
II
.
Advanced uses
of the SELECT
1.8
Subqueries in
INSERT,
DELETE
and
UPDATE
1.9
Creation and
view
queries
:
CREATE VIEW
Command
2.
Database
Project
(integration of
concepts learned
on a
real case)
2.1
Preparation
of the requirements document
as
guidance document
2.2
.
Conceptual design
(
entity relationship
model
): Definition
of entities and
relationships,
Defining constraints
and
model
documentation
2.3
.
Relational
Logic Design
:
Conversion
NM
relationships
,
validation rules
and
default values,
model
documentation
.
2.4
.
Generating
DDL and
DML
for the
selected
DBMS
.
The activities will include theoretical lectures where
assumptions will be discussed and will resolve database from a
requirements document.
Hands-on activities include the implementation of a
relational database (Oracle DBMS) and the realization of queries to
the database and the data dictionary.
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
To pass the course
, you must obtain
a score
of 5.0
after adding
the notes
of
the following:
- 70
% of grade
theory
exam (A minimum of 5 out of 10 is required in this
exam)
-
25
% of the grade
of
the practical (No minimum required in this part)
-
5% of the
note of
harvesting and monitoring
the theoretical and
practical
The practical part of
the course consists
of
:
-
Scripts
practices
.
Continuous assessment
rated
PASS /
FAIL
.
If for any
valid reason
, the student
is unable to attend
continuously
to
those classes,
will
notify the
beginning of the semester
the teacher
responsible for the group
,
in
order
to
find a solution that
satisfies both parties
- Draft
Databases:
Note
number
0 .. 10
A call
shall be deemed
exhausted
when the
student
has
completed
all
the assessment procedures
provided for in
the Teaching Guide
, including
the final proof
, if any
During the
academic
semester
,
tests may be conducted
evaluation students
of
part of the syllabus
, in agreement with
the majority of
students.
- 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)