Introduction to Databases and Programming

Theoretical classes: Exposition of the subjects followed by problem solving
Theoretical-Practical classes: Problem solving
Practical classes: Problem solving and discussion of the practical assignment.
Students have at their disposal textbooks, bibliography, report models, and exercise sheets in the Moodle
platform.
Each professor posts 6 office hours.
Students can also contact teachers by email.

• Identify and use relational database concepts.
• Use normalization techniques for relational databases.
• Define the conceptual and physical model of a normalized relational database.
• Propose solutions at the database projects level.
• Develop and test relational database models.
• Evaluate database models with a critical attitude.
• Query a relational database using SQL.
• Develop documentation to support the specification and analysis of relational databases
• Clearly present and explain the developed projects.
• Develop innovative projects, with a high autonomy degree, not limited to the concepts learned in classes.
• Develop a basic client server application using an ObjectOriented Language.

Introduction to relational database management systems
Entity-relationship model
• Entities, relationships, and attributes
• Logical Database Design
• Physical Database Design
SQL language
• Joins
• Functions
• Group by
• Subqueries
• Creating and populating tables
• Constrainsts on tables
Introduction to Object Oriented Programming
• Variables, types, and expressions
• Vectors and matrices
• Control instructions
• Classes
• Class Inheritance

NAO