In this lecture, some exercises about ER diagrams are shown, moreover an introduction to SQL is given.
In this lecture, the following items are reported: Introduction to SQL, Tables and Relationships in SQL, Main Operations, and Queries.
In this lecture, the following items are reported: ER Diagram Elements, Cardinality of the Relationships, Type of Relatioships, Examples of Relationships, and Examples of ER diagrams.
In this lecture, the following main topics are shown: Functional Dependency, Keys, Normalization of a Database, and Normal Forms.
In this lecture, main principles of the DBMS, Entity-Relational Model, Set Theory, and Tuples are introduced.
In this lecture, some principles about Databases, Data/Information, Information Systems, and Information Technology are introduced.