Base Knowledge
N/A
Teaching Methodologies
The curricular unit will be lectured through a mix regime of theoretical and practical classes, although a distinction between them is made.
The evaluation by periodical assessment is achieved by means of a written test (50%) and two practical assignments (50% – 10% for the first and 40% for the second).
The practical assignments can be made both individually or in groups of two, and, when and if needed, they may be defended. These assignments will be evaluated against their completion and quality.
A final exam evaluation is also available, with theoretical and practical elements with identical percentages to those of periodical assessment.
Learning Results
In this curricular unit it is expected the students to acquire sensibility to the issues of database creation and application, with special focus on the following items:
* recognize and distinguish data and information;
* know the different types of databases, especially the relational model;
* know relational database management systems;
* conceive entity-relationship diagrams;
* insure data coherence and normalization;
* create databases based on data models and E-R diagrams;
* insert, access, modify and delete data from tables using SQL;
* integrate databases in applications, specifically on the web.
Program
The curricular unit addresses the following items:
* data and information concepts;
* basic aspects of set theory;
* introduction to databases;
* E-R diagrams;
* relational model;
* relation normalization;
* tables and data types;
* introduction to SQL (Structured Query Language), focusing both DDL (Data Definition Language) and DML (Data Manipulation Language), using MySQL;
* introduction to the development of web applications using databases through the use of Node.js.
Grading Methods
- - Individual and/or Group Work - 50.0%
- - Frequency - 50.0%
- - Exam - 100.0%
Internship(s)
NAO
Bibliography
BAGUI, S. & EARP, R. (2011). Database Design Using Entity-Relationship Diagrams, Second Edition (Foundations of Database Design). Auerbach Publications. ISBN 978-1439861769
GRIPPA, V. & KUZMICHEV, S. (2021). Learning MySQL: Get a Handle on Your Data, 2nd ed. O’Reilly Media, Inc, USA. ISBN: 978-1492085928
HERNANDEZ, M.J. (2013). Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition). Addison-Wesley Professional. ISBN 978-0321884497
TEOREY, T., LIGHTSTONE, S., NADEAU, T. & JAGADISH, H.V (2011). Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems). Morgan Kaufmann. ISBN 978-0123820204
YOUNG, Alex; MECK, Bradley, CANTELON, Mike. (2017) Node.js in Action, 2nd ed. Manning Publications. ISBN: 978-1617292576