Program
Search
Print
Sistemi Informativi e Basi di Dati
Information Systems and Databases Claudia Diamantini
Seat
Ingegneria
A.A.
2015/2016
Credits
9
Hours
72
Period
I
Language
ENG
Prerequisites
None
Learning outcomes
The course aims to introduce concepts, methods and languages for the management of information within enterprises. At the end of the course the student will be able to design medium size databases and create, populate and query databases.
Program
- introduction to enterprise information systems: definitions of organization, information and computer systems. Enterprise processes. Characteristics of processes, information and data.
Introduction to databases and database management systems: basic definitions, database schemes and instances, abstraction levels, abstraction and independence. Languages for database management, Database users.
- relational model: definition of relation, relations and tables, null values, integrity constraints.
- relational algebra and calculus.
- SQL.
- database design: general methodologies, conceptual design and the Entity/Relationship model. logical design.
- Theory of normalization.
- Advanced laboratory of database design
Development of the examination
LEARNING EVALUATION METHODS
Evaulation is based on three tests:
- development of a report describing the design of a database;
- written examination composed by open-ended and closed-ended questions on course topics;
- oral examination with the discussione of one or more course topics, possibly starting from learning gaps that emerged in the previous tests
Projects can be developed in groups of three students at most. A positive outcome of the project gives access to the written test, either in the same exam session or in subsequent exam sessions. In order to access the oral examination the student has to obtain a positive outcome in the written examination. Oral examination must be taken in the same exam session as the written examination. In case of failure of the oral examination, the student must also repeat the written test.
LEARNING EVALUATION CRITERIA
To successfully pass the assessment of learning, the student must demonstrate, through the tests described above, a good understanding of the concepts related to models and languages for data management presented in the course, and must demonstrate a clear understanding of and be able to correctly apply the methodologies for database design.
LEARNING MEASUREMENT CRITERIA
A score between zero and 30 is assigned to each of the three tests indicated above. The overall grade is between zero and 30, calculated as the average of the marks obtained in the three tests.
FINAL MARK ALLOCATION CRITERIA
In order for the overall outcome grade to be positive, the student must achieve at least a pass, amounting to eighteen points in each of the three tests.
The highest rating is achieved by demonstrating a thorough understanding of the course content in the tests. The praise is reserved for students who have demonstrated a particular brilliance in the oral and in the preparation of written assignments.
Recommended reading
- P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di dati: modelli e linguaggi di interrogazione, 3° ed., McGraw-Hill, Italia
- Further material given by the teacher
Courses
- Ingegneria Informatica e dell'Automazione (Corso di Laurea Triennale (DM 270/04))
- Ingegneria Informatica e dell'Automazione (Corso di Laurea Magistrale (DM 270/04))