Database Technologies

Code:

M.EIC028

Acronym:

TBD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2024/2025 - 2S

Active?	Yes
Web Page:	https://moodle2425.up.pt/mod/assign/view.php?id=36048
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Master in Informatics and Computing Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
M.EIC	19	Syllabus	1	-	6	39	162

Teaching language

Suitable for English-speaking students

Objectives

The students should be able to design and manage large relational databases through object relational modelling and the optimization of the physical schema and the SQL queries. Students will also be able to deal with concurrency in database transactions

Learning outcomes and competences

The student will have the skills to (1) Refine the DB's physical schema, (2) Optimise SQL queries, (3) Model object-relational DBs, (4) Know how to manage concurrency situations, (5) Recover and replicate data.

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Students should be acquainted with object programming, relational algebra, relational databases, normalisation theory, relational algebra and SQL.

Program

1. Physical schema and database tuning. Storing and indexing data. Query execution and optimisation.


2. Modelling in object-relational databases.


3. Recover and replication.


4. Concurrency.

Mandatory literature

Ullman, Jeffrey D.; A First Course in Database Systems. ISBN: 0-13-861337-0
Garcia-Molina, Hector; Database system implementation. ISBN: 0-13-040264-8

Complementary Bibliography

Date, C. J.; An introduction to database systems. ISBN: 0-201-68419-5
Date, C. J.; A Guide to the SQL Standard. ISBN: 0-201-55822-X
Ramakrishnan, Raghu; Database Management Systems. ISBN: 0-07-115508-2

Teaching methods and learning activities

Classes are used to formally expound the subject, accompanied by presenting examples and the respective laboratory analyses. To orientate the experimental side of learning, a set of laboratory application exercises is proposed, the resolution of which is followed through to the production of reports.

Software

Oracle Server 21c
Oracle SQL Developer

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Exame	50,00
Trabalho laboratorial	50,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	60,00
Frequência das aulas	42,00
Trabalho laboratorial	60,00
Total:	162,00

Eligibility for exams

Compulsory attendance at 75% of classes. Approval according to the calculation rule (see formula).

Calculation formula of final grade

The assessment consists of:

    2 group projects (groups of 2):

        PROJ1: Query optimisation - minimum mark 8.
        PROJ2: OR data model - minimum mark 8.

    Exam (EXAM): covers the whole syllabus and is taken at exam time (minimum mark 7.5).

Regular and special assessment students
Final Grade = 25% * PROJ1 + 25% * PROJ2 + 50% * EXAM.

Special assessment (TE, DA, ...)

Students attending under regimes other than the ordinary one fulfil the course unit assessment requirements at the established times.

Classification improvement

The exam component can be improved in the same edition, in the appeal exam. The Project components (PROJ1 and PROJ2) cannot be improved in the same academic year but can be improved in the next edition of the course.

Observations

1. Given the project-based nature of the subject, it is compulsory and essential to complete all the work set out within the deadlines or dates set and to hand it in on the dates set. All students are covered by this regulation (working students, students with special needs, students doing an internship, etc.).


2. Failure to complete / hand in an assignment or handing it in after the deadline set by the teacher will result in the loss of the total percentage of the grade corresponding to that assignment.


3. All practical work must be monitored regularly (1 or 2 weeks); otherwise, it will not be considered for assessment. It is the student's responsibility to ensure this.


4. Enrolment in the course after the second lesson is not accepted.


5. No work may be handed in/assessed after the last day of the semester (relative to the academic year).


6. This curricular unit does not allow the freezing of total/partial marks between different assessment periods or academic years.


7. The possibility of claiming/requesting a review of any classification ceases once fifteen days have elapsed since the publication of the classification (partial/final).


8. Students must have access to their UP email account (SIGARRA). They should check this email regularly as it is the preferred means of communication used by lecturers.


9. In case of doubt, the teacher reserves the right to request an oral defence of a test/work. As a result of this extraordinary assessment moment, the grade can be maintained, raised or lowered. This right can be applied at any time during the assessment and until the grades are finalised (sent to the Registrar's Office).


10. The Portuguese text takes precedence over the English translation.