https://wiki.bzz.ch/ 2026-04-23T08:09:47+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-02T13:15:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/theorie/a_concept?rev=1727874910&do=diff LU04a - Concept of a RDB Learning Objectives * I can explain in my own words, what a relations database is and why it is widely used in all kinds of web applications. * I can name and explain the key components of a relational database. A Relational Database (RDB) is a structured method for storing and organizing data. The core idea is to represent data as related tables. text/html 2024-10-02T13:15:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/theorie/b_datatypes?rev=1727874903&do=diff LU04b - Data-types In chapter LU03b we want to talk about data-types, why we are in need of them, and how they are used in the database world in order to specify the content of tables. Most common MySQL data-types MySQL provides us with a variety of data types to fulfil the most diverse data requirements. Let's take a look at the most important categories: text/html 2024-10-02T13:14:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/theorie/c_erm_erd?rev=1727874896&do=diff LU04c - ERM and ERD Entity-Relationship Model = ERM The Entity-Relationship Model (ERM) is a conceptual data-model used in database design to represent relationships between data entities in a system. An entity is a real-world object or concept, such as customer or product, and each entity has specific attributes that describe it. text/html 2024-10-02T13:14:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/theorie/d_crowfeet?rev=1727874887&do=diff LU04d - The Crow's Feet Notation The Basics of Crow’s Foot Notation In database design, an entity represents a real-world object or concept, such as a person, place, event, or thing, that needs to be stored in the database. Each entity typically becomes a table in the relational database.