Database Development and Applications in Biology
Objectives
Introduce the fundamental concepts inherent to the development of relational databases aiming to support the implementation of transactional systems. This curricular unit places great emphasis on a theoretical structuring of knowledge combined with the provision of extensive practical experience based on the use of Relational Database Management Systems (RDBMS). In practical cases, particular emphasis will be placed on data modeling, information extraction, and business rulemaking in functional contexts within Bioinformatics. This course should provide students with the skills of structuring information as well as using the SQL language for querying databases and programming business rules.
General characterization
Code
12505
Credits
3.0
Responsible teacher
Jorge Nelson Gouveia Sousa Neves
Hours
Weekly - 2
Total - Available soon
Teaching language
Português
Prerequisites
Information Systems.
Bibliography
- Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts - 7th ed., McGraw-hill, 2021
- Thomas M. Connolly and Carolyn E. Begg, Database Systems: a Practical Approach to Design, Implementation, and Management, Addison-Wesley, Pearce Education Limited, 2010
Teaching method
Available soon
Evaluation method
Available soon
Subject matter
Introduction - Databases and database management systems - Database design. - SQL. Database Design - The Relational model Normalization - Normal Forms (1, 2 and 3) SQL Fundamentals - SQL syntax and basic commands - Retrieving data from a database using SELECT statements - Using aggregate functions Intermediate SQL - Joining tables - Using subqueries - Manipulating data with INSERT, UPDATE, and DELETE statements Advanced SQL - Creating and using views - Transactions - Indices
Programs
Programs where the course is taught: