|
Learning outcomes |
This course introduces the theme of information systems (SI) and databases (BD), focusing on their design and implementation. Its main objective is, therefore, to prepare students to understand, design and develop information systems. At the databases level, the C.U. focuses on the relational model, mainly, conceptual model, normalization, SQL language and database management.
With the completion of the teaching-learning process, the student must be able to:
- Identify SI’ architectures and topologies.
- Understand the Management of Information Systems (planning, development, and exploration).
- Given a real or fictitious situation, develop a data model that represents it.
- Normalize and "de-normalize" relations.
- Choose a database management system according to the IS to be developed.
- Produce the physical model of BD.
- Query the database (via SQL).
- Develop client/server applications.
|
|
Main Bibliography |
1. Thomas Connolly, Carolyn Begg. “Database Systems, A Practical Approach to Design, Implementation and Management”, 6th Edition, 2015. Pearson, ISBN: 978-1-292-06118-4.
2. Feliz Gouveia. “Fundamentos de Bases de Dados”, FCA, 2014, ISBN: 978-972-722-799-0.
3. Luís Damas, “SQL”, 14ª Edição, FCA, 2017, ISBN 978-972-722-829-4.
4. Kenneth Laudon, Jane Laudon. "Management Information Systems, Managing the Digital Firm", 15th Edition, 2018, Pearson Education, ISBN: 978-1-292-21175-6.
5. Ralph Stair, George Reynolds. "Principles of Information Systems", 13th Edition, 2018, Cengage Learning, ISBN: 978-1-305-97177-6.
6. Patricia Wallace. "Introduction to Information Systems", 4th Edition, 2021, Pearson, ISBN: 978-0-13-582984-4.
|