. "Other Data Management (rather Than Geospatial Data Architecture And Management) Kas"@en . . . . . . . . . . . . . . . "Databases"@en . . "6.0" . "Prerequisites\nEssencial: Fundamentos da Programação. Recommended: Lógica para Programação, Introdução aos Algoritmos e Estruturas de Dados, Introdução à Arquitectura de Computadores, Programação com Objectos, Sistemas Operativos, Interfaces Pessoa-Máquina\n\nObjectives\nThe course introduces students to database design and analysis. The focus is on the relational model, covering the logical design of databases (schema design) and implementation, and transaction processing systems. Aspects of unstructured and semi-structured data management, decision support and data mining systems will also be covered. The objective of this course is to expose the student to the basic concepts involved in designing and building an information system, and to practical information systems applications design through a team-based project.\n\nProgram\nIntroduction to database management systems Main characteristics of database management systems. The advantages of the database approach. When not to use a database management system. Database systems models. The relational model. Database management systems architecture. Database systems market. The database systems development process. Data modeling The entity-relationship model. Entity sets and association sets. Weak entities. Generalizations. Aggregations. Introduction to the Relational Model. Conversion of Entity-Relationship models into relational models. Database query languages Relational algebra. Relational calculus (may be omitted) Database manipulation language. SQL. Views in SQL. Integrity constraints Entity integrity. Domain integrity. Referential integrity. Integrity in SQL. Main characteristics of database management systems. Database management systems architecture. The database systems development process. Information modelling. The entity-relationship model. The Relational Model. Conversion of Entity-Relationship models into relational models. Database query languages. Relational algebra and calculus. SQL. Integrity constraints. Referential integrity. User constraints. Triggers. Architecture and programming of database applications. Stored procedures. Data normalization. Dependency theory. Normal forms. Relational schema decomposition and normalisation. Indexing structures. B-trees. Hash and Bitmap indexes. Transaction processing. Transaction recovery. Transactions in SQL. Security and Access control of databases. Complex and XML data management. Decision Support Systems. Data warehousing. OLAP. Data mining. Text search and indexing models. Information retrieval systems evaluation.\n\nEvaluation Methodology\n40% Class Project (P) with two parts (P1, P2) + 60% Final Exam (E) ; Final Grade: 0.2xP1 + 0.2xP2 + 0.6xE Minimum Grade: 9,5 on (P) and 9,5 on (E) Working-Students (must be formally recognised as such): must complete the project but may develop it individually.\n\nCross-Competence Component\nSoft skills to be acquired while developing the class project in groups of 3. All aspects of Collaboration and Communication Skills (competências interpessoais) will be developed, while Productivity and Stress Management Skills (competências intrapessoais) will also be required. Global Citizenship (cidadania global) issues related to the ethics of handling mission critical and personal data, and protecting privacy will also be discussed while presenting the syllabus topics. The soft skills will be assessed while monitoring students in the lab and grading the two Project reports (one for each part). About 10% of the overall learning effort will be dedicated to the development of Soft Skills.\n\nLaboratorial Component\nStudents develop in the Class Project the conceptual model of an information system and an interactive application, while following lab guides with practical examples. Students work in groups of three in designing their solution to the class project.\n\nProgramming and Computing Component\nNo curso onde esta UC é oferecida estão asseguradas as componentes de Computação e Programação de acordo com o MEPP 2122.\n\n\nMore information at: https://fenix.tecnico.ulisboa.pt/cursos/lerc/disciplina-curricular/845953938490015" . . "Presential"@en . "TRUE" . . "Bachelor in Telecommunications and Informatics Engineering"@en . . "https://tecnico.ulisboa.pt/en/education/courses/undergraduate-programmes/telecommunications-and-informatics-engineering/ " . "180"^^ . "Presential"@en . "Programme Overview\nTelecommunications and Informatics Engineering is dedicated to “Internet Engineering”, namely the so-called “internet of things”, which allows us to interact with various objects, such as refrigerators, heating our homes or products for sale in a supermarket. As such, a Telecommunications and Informatics Engineer works with complex, fixed or mobile communication networks and related infrastructures. It also develops services or applications, knowing the related security aspects.\n\nEntry Requirements - National Admission to Higher education\n\n* National Admission Exams: Mathematics A + Physics and Chemistry (Minimum grade point: 100 points (out of 200))\n* Application Grade: MS x 50% + PI x 50% (Minimum grade point: 120 points (out of 200))\n - MS: high school final arithmetic average grade | PI: Average of national admission exams’ grades.\n\nhttps://tecnico.ulisboa.pt/en/education/study-at-tecnico/applications/national-admission-for-higher-education/ \n\nAdmissions can also be done through one of the following ways:\n\n* Course Change and Transfer\n* Holders of Middle Level/Higher Education degrees\n* Applicants over the age of 23\n* Special Admission Regime for International Students\n\nMore information about admissions to Técnico (national and international candidates) is available at: https://tecnico.ulisboa.pt/en/education/study-at-tecnico/applications/"@en . . . "3"@en . "FALSE" . . . "Bachelor"@en . "Thesis" . "697.00" . "Euro"@en . "7000.00" . "None" . "Fields:\n\n* Telecommunications companies\n* Information technology companies\n* Government agencies\n* Research and development organizations\n* Consulting firms\n* Start-ups\n\nThe average salary for a telecommunications engineer in Portugal is €35,000 per year. The average salary for an informatics engineer in Portugal is €30,000 per year.\n\nSome of the possible positions:\n\n* Telecommunications engineer\n* Network engineer\n* Systems engineer\n* Software engineer\n* Data scientist\n* Cyber security engineer"@en . "1"^^ . "TRUE" . "Midstream"@en . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .