Database Modeling and Design


In this course, you will achieve expertise in two topics, database modeling and database design. Databases are the fundamental technology adopted in all information systems worldwide, since they allow organizing, storing and retrieving digital data that are useful for both personal activities and decisions, and for core activities of enterprises and public administrations. Digital data managed in databases are at the basis of a huge amount of digital services and apps we use every day.

Referring to the modeling capability, the course introduces two models widely adopted to represent databases, the Relational model and the Entity relationship model. The Relational model is used by the majority of software systems that manage databases, while the Entity relationship model, that is provided of an user friendly diagrammatic representation, is adopted in the early stage of the database design process.

Referring to the design capability, the database design process starts usually with a natural language or pictorial description of user requirements; it is worthwhile to represent initially such description using the Entity Relationship model, that is understandable by users, and provides a rich set of semantic characteristics of data. The result of the design activity at this stage is a database schema. After that, the design can proceed translating the Entity Relationship schema into a logical schema in the relational model. Such translation has to be performed using several practical rules that have the goal to optimize the relational schema w.r.t. queries and transactions performed by users. Once obtained the logical schema, one can add to relations (last step) data that represent, in our case, the students, courses and exams.

The course assumes you are familiar with basic mathematical concepts such as set, subset, table, function, and domain of a function.


Frequenza e Attestati

Frequenza
GRATUITO!
Attestato di Partecipazione
GRATUITO!

Categoria

Informatica, Gestione e Analisi dei Dati

Ore di Formazione

23

Livello

Intermedio

Modalità Corso

Tutoraggio

Lingua

English

Durata

5 Settimane

Tipologia

Online

Stato del Corso

Tutoraggio

Avvio Iscrizioni

11 Lug 2018

Apertura Corso

27 Ago 2018

Inizo Tutoraggio

27 Ago 2018

Fine Tutoraggio

15 Ott 2019

Tutoraggio Soft da

16 Ott 2019

Chiusura Corso

Non impostato

By the end of this course, you will be able to:

  1. Model a piece of the real world around you, expressed usually by a text in natural language, in terms of the Relational model and the Entity Relationship model. This ability can be used when your aim is to use a database, and also when you want to understand a complex reality around you.
  2. Design a reasonably complex database, that represents a piece of real world, by means of the two steps procedure shown above.
Basic knowledge of set theory, basic knowledge of mathematical functions and relations.
  1. Carlo Batini - Transcription of video lessons of the Eduopen Course - This text is a transcription of the video lessons. It can be useful for those of you that, after watching at the video, need for a moment of further in depth analysis of the concepts presented. It is also useful for those of you that do not possess entirely spoken English language, and need for a written version of lessons to be examined comfortably. It can also be used independently form the video version.
  2. Carlo Batini, Stefano Ceri, Sham B. Navathe - Conceptual Database Design: an Entity Relationship Approach - ISBN-10: 0805302441 • ISBN-13: 9780805302448 ©1992, Addison-Wesley, 470 pp, available in the e-market.
  3. Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone - Database Systems Concepts, Languages and Architectures - McGraw-Hill Book Company 1999, ISBN 0-07-709500-6 Freely available at http://dbbook.dia.uniroma3.it/
The course consists of five Sections. Each Section consists of 4 to 9 video-lectures. Each video-lecture consists of a methodology video, during which several exercises are proposed. When an exercise is proposed, you can pause the video, and once you have conceived a solution, you can watch the video and compare the solution with the one provided. If you want, you can also use the booklet, that is an accurate transcription of the video lessons. When an exercise is proposed, you can conceive a solution, and then you turn the page and compare the solution in the booklet with your solution. The whole set of concepts that are discussed in the course can be divided into three blocks: 1) Basic concepts, 2) Models and 3) Design methods. Let us go in more depth for specific parts. Part 1 - Introduction to Databases: in this section you will learn the basic concepts on database modeling and design, with specific reference to the two models dealt with in the course, the Relational model and the Entity relationship model, and the two phases of database design, Conceptual design and Logical design; Part 2 – Entity Relationship model: in this section you will learn the basic constructs of the Entity relationship model such as entity, relationship, attribute, is-a relation and generalization. You will also learn the diagrammatic representations of constructs, and you will start to design simple schemas and related diagrams. 
You can have the Attendance Certificate after watching all video lectures and scoring at least 7 out of 10 of each one of the three tests correctly (you can retry each answer twice).