-
Presentation
Presentation
This curricular unit aims to present the importance of Data Management within a company, to guarantee both the daily operation of the business, as well as the support to the strategic decision.
This unit will reinforce the framework for structuring and methodologies for creating databases.
-
Class from course
Class from course
-
Degree | Semesters | ECTS
Degree | Semesters | ECTS
Bachelor | Semestral | 6
-
Year | Nature | Language
Year | Nature | Language
2 | Mandatory | Português
-
Code
Code
ULHT6634-1792
-
Prerequisites and corequisites
Prerequisites and corequisites
Not applicable
-
Professional Internship
Professional Internship
Não
-
Syllabus
Syllabus
The syllabus of the curricular unit is:
A) Theorical component- Introduction
- Entity-Relationship Model
- The Relational Model
- Schema refinement: Normalisation and Transactions concept
- Architecture of DBMS and some Advanced SQL
B) Lab component
- Introduction to SQL language;
- Instructions: DDL, DML (DQL) and DCL
- Operations: WHERE, ORDER BY, GROUP BY;
- Advanced concept in SQL: Error control
- Relational Operators: Union, Intersection, and Subtraction
- Cartesian Product (external)
- Complex queries (filter with aggregated values) and sub-queries
- Set DDL; CREATE statement; Data types; Nullity; ALTER and DROP statements
- INDICES and VIEWS
- Error control: TRY structure ... CATCH
- Procedures (SP) and Triggers
- Tables: Cursors
-
Objectives
Objectives
The objectives are to provide students with the theoretical and practical knowledge required to design, construct and analyze relational databases: namely, to obtain the following skills and competences:
1. Understand the reasons for implementing relational databases in the business world
2. Transpose from a requirements analysis to an entity-association model to design databases;
3. Apply the concepts of the relational database model, transforming the entity-association model into a physical data model;
4. Apply the techniques of normalization of tables;
5. Understand architecture and main components of Database Management Systems;
6. Use the base and advanced SQL language for creating, querying, and modification of databases;
-
Teaching methodologies and assessment
Teaching methodologies and assessment
Use of interactive class game dynamics through platforms like Kahoot.
-
References
References
Books
- Campbell, L., & Majors, C. (2017). Database Reliability Engineering: Designing and Operating Resilient Database Systems (1 edition). Beijing Boston Farnham Sebastopol Tokyo: O¿Reilly Media.
- Date, C. J. (2003). An Introduction to Database Systems (8 edition). Boston: Pearson.
- Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7 edition). Hoboken, NJ: Pearson.
- Teorey, T. J., Lightstone, S. S., Nadeau, T., & Jagadish, H. V. (2011). Database Modeling and Design: Logical Design (5 edition). Amsterdam: Morgan Kaufmann.
-
Office Hours
Office Hours
-
Mobility
Mobility
No
