Servizi per la didattica
PORTALE DELLA DIDATTICA

Introduction to databases

01RKWLM, 01RKWOA

A.A. 2021/22

Course Language

Inglese

Course degree

1st degree and Bachelor-level of the Bologna process in Ingegneria Informatica (Computer Engineering) - Torino
1st degree and Bachelor-level of the Bologna process in Ingegneria Informatica - Torino

Course structure
Teaching Hours
Lezioni 36
Esercitazioni in aula 33,5
Esercitazioni in laboratorio 10,5
Tutoraggio 24
Teachers
Teacher Status SSD h.Les h.Ex h.Lab h.Tut Years teaching
Apiletti Daniele   Ricercatore a tempo det. L.240/10 art.24-B ING-INF/05 36 26 0 0 1
Teaching assistant
Espandi

Context
SSD CFU Activities Area context
ING-INF/05 8 B - Caratterizzanti Ingegneria informatica
2021/22
The course, compulsory for the Bachelor degree in Computer Engineering, is offered on the 2nd semester of the 2nd year. The course presents database management systems and introduces both database design methodologies and the development of applications for database querying and management. Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
The course, compulsory for the Bachelor degree in Computer Engineering, is offered on the 2nd semester of the 2nd year. The course presents database management systems and introduces both database design methodologies and the development of applications for database querying and management. Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
- Knowledge of the main characteristics of a database management system - Knowledge of the structure and properties of the relational model - Knowledge of query languages for a relational database: Relational algebra and SQL language - Ability to write queries in the relational algebra and SQL languages - Knowledge of the conceptual Entity-Relationship model for data representation and of the methodology for conceptual and logical design of a relational database - Ability to design a relational database - Knowledge of the SQL statements for view management, data access control, and transaction management - Knowledge of the interaction techniques between SQL statements and programming languages - Ability to design and develop an application accessing a database - Knowledge of active database systems and SQL statements for trigger definition. - Ability to write triggers in the SQL language.
- Knowledge of the main characteristics of a database management system - Knowledge of the structure and properties of the relational model - Knowledge of query languages for a relational database: Relational algebra and SQL language - Ability to write queries in the relational algebra and SQL languages - Knowledge of the conceptual Entity-Relationship model for data representation and of the methodology for conceptual and logical design of a relational database - Ability to design a relational database - Knowledge of the SQL statements for view management, data access control, and transaction management - Knowledge of the interaction techniques between SQL statements and programming languages - Ability to design and develop an application accessing a database - Knowledge of active database systems and SQL statements for trigger definition. - Ability to write triggers in the SQL language.
Basic programming skills.
Basic programming skills.
Class topics and their weight in credits: - Characteristics of a database management system (0.2 cr.) - Characteristics of the relational model (0.2 cr.) - Relational algebra (0.4 cr.): main operators and query definition - SQL language: statements for data definition and processing (1 cr.) - Conceptual data model (Entity-Relationship) and methodology for the conceptual and logical design of a relational database (0.8 cr.) - SQL language: statements for view management, data access control, and transaction management (0.4 cr.) - SQL for applications: client-server architectures, integration of SQL statements into a programming language, stored procedures, design of a client-server web-based architecture accessing a database (1.35 cr.) - Active database systems and SQL statements for trigger definition (0.4 cr.)
Course topics and their weight in credits (CFU): - Characteristics of a database management system (0.2) - Characteristics of the relational model (0.2) - Relational algebra (0.4): main operators and query definition - SQL language: statements for data definition and processing (1) - Conceptual data model (Entity-Relationship) and methodology for the conceptual and logical design of a relational database (0.8) - SQL language: statements for view management, data access control, and transaction management (0.4) - SQL for applications: client-server architectures, integration of SQL statements into a programming language, stored procedures, design of a client-server web-based architecture accessing a database (0.7) - Active database systems and SQL statements for trigger definition (1.05) - Practices on SQL language, relational algebra, conceptual and logical database design, and triggers (2.2) - Laboratory sessions on the SQL language, the design of an application accessing a database, and triggers (1.05).
The course includes lectures in the classroom, whose topics are described earlier, and practices on the lecture topics, and in particular SQL language, relational algebra, conceptual and logical database design, and triggers (2.2 cr.). Students will prepare an individual written report on the exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on the SQL language, the design of a client-server architecture accessing a database, and triggers (1.05 cr.). Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
The course includes lectures in the classroom, whose topics are described earlier, and practices on the lecture topics, and in particular SQL language, relational algebra, conceptual and logical database design, and triggers. Students will prepare an individual written report on the exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on the SQL language, the design of a client-server architecture accessing a database, and triggers. Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
The reference book, covering the majority of the course topics, is: Database Systems – Concepts, Languages and Architectures Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone McGraw-Hill [A free PDF file of the book is available at http://dbbook.dia.uniroma3.it/] The following book supports practices: Baralis, Belussi, Psaila, "Basi di dati: temi d’esame svolti", Esculapio, 2000. Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.
The reference book, covering the majority of the course topics, is: Database Systems – Concepts, Languages and Architectures Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone McGraw-Hill [A free PDF file of the book is available at http://dbbook.dia.uniroma3.it/] The following book supports practices: Baralis, Belussi, Psaila, "Basi di dati: temi d’esame svolti", Esculapio, 2000. Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.
Modalità di esame: Prova scritta (in aula); Elaborato scritto individuale;
Exam: Written test; Individual essay;
The exam includes a written part, which lasts 2 hours, an optional oral part, and the evaluation of the report on the individual practices assigned during the course. The written part consists of - 3 multiple-choice tests on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (connection to databases, HTML, PHP)) (max 3 points) - 3 exercises on writing queries to access data in a relational database (through relational algebra and SQL language) (max 13 points) - 1 exercise on conceptual and logical database design and on the definition of referential integrity constraints (max 10 points) - 1 exercise on trigger (max 5 points) Students can consult textbooks or notes during the exam. The delivery of individual practices’ reports during the course is optional (max 2.5 points). The optional oral part covers all the topics of the course. The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is 18 or above. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution.
Gli studenti e le studentesse con disabilità o con Disturbi Specifici di Apprendimento (DSA), oltre alla segnalazione tramite procedura informatizzata, sono invitati a comunicare anche direttamente al/la docente titolare dell'insegnamento, con un preavviso non inferiore ad una settimana dall'avvio della sessione d'esame, gli strumenti compensativi concordati con l'Unità Special Needs, al fine di permettere al/la docente la declinazione più idonea in riferimento alla specifica tipologia di esame.
Exam: Written test; Individual essay;
The exam includes a written part, which lasts 90 minutes, and the evaluation of the reports of the individual practices assigned during the course. The delivery of the individual practices’ reports is optional. Learning objectives assessment. The written part will assess: - the knowledge of the relational algebra operators, the capability to write queries in SQL, the key aspects to design relational databases, and active database systems. - the working knowledge of the SQL language and how to integrate SQL statements into a programming language, and the major relational database systems. The individual practices’ reports will assess: - the ability to design and develop a web application to access a database. - the ability to write queries in both relational algebra and SQL. - the ability to design relational databases and active database systems. Exam structure and grading criteria. The written part consists of closed-ended theoretical questions and a set of exercises that require to answer the open-ended questions and/or a closed-ended question. The points assigned to each exercise/question will be specified within the text of the exercise/question. Wrong answers to closed-ended questions may cause a penalty (negative points). Missing answers yield zero points (no penalty). The written part consists of: - 2-4 closed-ended questions on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (max 3 points) - 1-3 exercises on writing queries to access data in a relational database through relational algebra with open-ended questions and/or closed-ended questions. (max 4 points) - 2-3 exercises on writing queries to access data in a relational database through SQL language with open-ended questions and/or closed-ended questions. (max 10 points) - 1-2 exercises on triggers with open-ended questions and/or closed-ended questions (max 4 points) - 2-3 exercises on conceptual database design with open-ended questions and/or closed-ended questions (max 7 points) - 1-2 exercises on logical database design and on the definition of referential integrity constraints with open-ended questions and/or closed-ended questions (max 3 points) Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution. The teacher may request an integrative test to confirm the evaluation obtained in the written exam. Students are not allowed to use textbooks, notes, or additional electronic devices. The delivery of individual practices’ reports during the course is optional (max 2.5 points). The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is sufficient.
In addition to the message sent by the online system, students with disabilities or Specific Learning Disorders (SLD) are invited to directly inform the professor in charge of the course about the special arrangements for the exam that have been agreed with the Special Needs Unit. The professor has to be informed at least one week before the beginning of the examination session in order to provide students with the most suitable arrangements for each specific type of exam.
Modalità di esame: Elaborato scritto individuale; Prova scritta tramite PC con l'utilizzo della piattaforma di ateneo;
The exam includes a written part, which lasts 90 minutes, and the evaluation of the report on the individual practices assigned during the course. The written part consists of closed-ended theoretical questions and a set of exercises that require to answer open-ended question and/or a closed-ended question. The points assigned to each exercise/question will be specified within the text of the exercise/question. Wrong answers to closed-ended questions may cause a penalty (negative points). Missing answers yield zero points (no penalty). The written part consists of - 3 closed-ended questions on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (connection to databases, JDBC, HTML, PHP) (max 3 points) - 1-3 exercises on writing queries to access data in a relational database through relational algebra with open-ended questions and/or closed-ended questions. (max 4 points) - 2-3 exercises on writing queries to access data in a relational database through SQL language with open-ended questions and/or closed-ended questions. (max 11 points) - 1-2 exercises on triggers with open-ended questions and/or a closed-ended questions (max 3 points) - 2-3 exercises on conceptual database design with open-ended questions and/or a closed-ended questions (max 7 points) - 1-2 exercises on logical database design and on the definition of referential integrity constraints with open-ended questions and/or a closed-ended questions (max 3 points) Students are not allowed to use textbooks, notes, or additional electronic devices apart from the one used for the exam. The delivery of individual practices’ reports during the course is optional (max 2 points). The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is 18 or above. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution.
Exam: Individual essay; Computer-based written test using the PoliTo platform;
The exam includes a written part, which lasts 90 minutes, and the evaluation of the reports of the individual practices assigned during the course. The delivery of the individual practices’ reports is optional. Learning objectives assessment. The written part will assess: - the knowledge of the relational algebra operators, the capability to write queries in SQL, the key aspects to design relational databases, and active database systems. - the working knowledge of the SQL language and how to integrate SQL statements into a programming language, and the major relational database systems. The individual practices’ reports will assess: - the ability to design and develop a web application to access a database. - the ability to write queries in both relational algebra and SQL. - the ability to design relational databases and active database systems. Exam structure and grading criteria. The written part consists of closed-ended theoretical questions and a set of exercises that require to answer the open-ended questions and/or a closed-ended question. The points assigned to each exercise/question will be specified within the text of the exercise/question. Wrong answers to closed-ended questions may cause a penalty (negative points). Missing answers yield zero points (no penalty). The written part consists of: - 2-4 closed-ended questions on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (max 3 points) - 1-3 exercises on writing queries to access data in a relational database through relational algebra with open-ended questions and/or closed-ended questions. (max 4 points) - 2-3 exercises on writing queries to access data in a relational database through SQL language with open-ended questions and/or closed-ended questions. (max 10 points) - 1-2 exercises on triggers with open-ended questions and/or closed-ended questions (max 4 points) - 2-3 exercises on conceptual database design with open-ended questions and/or closed-ended questions (max 7 points) - 1-2 exercises on logical database design and on the definition of referential integrity constraints with open-ended questions and/or closed-ended questions (max 3 points) Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution. The teacher may request an integrative test to confirm the evaluation obtained in the written exam. Students are not allowed to use textbooks, notes, or additional electronic devices. The delivery of individual practices’ reports during the course is optional (max 2.5 points). The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is sufficient.
Modalità di esame: Test informatizzato in laboratorio; Prova scritta (in aula); Elaborato scritto individuale; Prova scritta tramite PC con l'utilizzo della piattaforma di ateneo;
The exam includes a written part, which lasts 90 minutes, and the evaluation of the report on the individual practices assigned during the course. The written part consists of closed-ended theoretical questions and a set of exercises that require to answer open-ended question and/or a closed-ended question. The points assigned to each exercise/question will be specified within the text of the exercise/question. Wrong answers to closed-ended questions may cause a penalty (negative points). Missing answers yield zero points (no penalty). The written part consists of - 3 closed-ended questions on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (connection to databases, JDBC, HTML, PHP) (max 3 points) - 1-3 exercises on writing queries to access data in a relational database through relational algebra with open-ended questions and/or closed-ended questions. (max 4 points) - 2-3 exercises on writing queries to access data in a relational database through SQL language with open-ended questions and/or closed-ended questions. (max 11 points) - 1-2 exercises on triggers with open-ended questions and/or a closed-ended questions (max 3 points) - 2-3 exercises on conceptual database design with open-ended questions and/or a closed-ended questions (max 7 points) - 1-2 exercises on logical database design and on the definition of referential integrity constraints with open-ended questions and/or a closed-ended questions (max 3 points) Students are not allowed to use textbooks, notes, or additional electronic devices apart from the one used for the exam. The delivery of individual practices’ reports during the course is optional (max 2 points). The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is 18 or above. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution.
Exam: Computer lab-based test; Written test; Individual essay; Computer-based written test using the PoliTo platform;
The exam includes a written part, which lasts 90 minutes, and the evaluation of the reports of the individual practices assigned during the course. The delivery of the individual practices’ reports is optional. Learning objectives assessment. The written part will assess: - the knowledge of the relational algebra operators, the capability to write queries in SQL, the key aspects to design relational databases, and active database systems. - the working knowledge of the SQL language and how to integrate SQL statements into a programming language, and the major relational database systems. The individual practices’ reports will assess: - the ability to design and develop a web application to access a database. - the ability to write queries in both relational algebra and SQL. - the ability to design relational databases and active database systems. Exam structure and grading criteria. The written part consists of closed-ended theoretical questions and a set of exercises that require to answer the open-ended questions and/or a closed-ended question. The points assigned to each exercise/question will be specified within the text of the exercise/question. Wrong answers to closed-ended questions may cause a penalty (negative points). Missing answers yield zero points (no penalty). The written part consists of: - 2-4 closed-ended questions on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (max 3 points) - 1-3 exercises on writing queries to access data in a relational database through relational algebra with open-ended questions and/or closed-ended questions. (max 4 points) - 2-3 exercises on writing queries to access data in a relational database through SQL language with open-ended questions and/or closed-ended questions. (max 10 points) - 1-2 exercises on triggers with open-ended questions and/or closed-ended questions (max 4 points) - 2-3 exercises on conceptual database design with open-ended questions and/or closed-ended questions (max 7 points) - 1-2 exercises on logical database design and on the definition of referential integrity constraints with open-ended questions and/or closed-ended questions (max 3 points) Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution. The teacher may request an integrative test to confirm the evaluation obtained in the written exam. Students are not allowed to use textbooks, notes, or additional electronic devices. The delivery of individual practices’ reports during the course is optional (max 2.5 points). The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is sufficient. Online and onsite exams will share the same structure and similar difficulty.
Esporta Word


© Politecnico di Torino
Corso Duca degli Abruzzi, 24 - 10129 Torino, ITALY
Contatti