Error message
User error : Failed to connect to memcache server: druportbe01:11211 in dmemcache_object() (line 415 of /production/drupal/dim_prod/drupal/d7cl4/prod/unich/releases/7/web/sites/all/modules/contrib/memcache/dmemcache.inc ).
Course Sheet Academic Year of enrolment:
Professor and Collaborators:
Hours of classroom activity:
Objectives
Contents The fundamental concepts necessary for designing, using, and implementing database systems and database applications.
Laboratory lessons with MySqL language
Extended Syllabus - The basic introductory concepts necessary for a good understanding of database models, systems, and languages.
- Databases, typical users, and DBMS concepts, terminology, and architecture.
- The conceptual database design and the concepts of the Entity-Relationship (ER) model and ER diagrams,
- The relational data model,
- The operations of the relational algebra
- The SQL standard
- Some of the basic parts of the SQL standard for relational databases, including data definition, data modification
operations, and simple SQL queries.
- More complex SQL queries, views, and schema modification.
- MySQL
Recommended Bibliography P.ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, Basi di dati. Modelli e linguaggi di interrogazione. McGraw-Hill.
Slides provided by the teacher and supplementary useful material.
Slides provided by the teacher and supplementary useful material will be
made available for the students on the platform
https://fad.unich.it/
Teaching Methods Front lectures and exercises in classroom using blackboard, projector and
computer; practical activities (guided exercises) at the Laboratory of
Computer Science.
Although recommended, course attendance is not mandatory.
Evaluation methods Verification of learning:
Written exam, project (mandatory) and its oral discussion (mandatory). The final evaluation, expressed in thirtieths, takes into account both the project and its discussion.
Contacts/More Information Tutorship of students:
- 2 hours per week with dates and times communicated at the beginning of the course;
- on request by reservation via e-mail.
E-mail: cmeo@unich.it