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