HBO Facility Management

Laboratory notes from the Database Management Systems course covering keys and constraints in relational databases. The document details Primary Keys, Foreign Keys, UNIQUE and NOT NULL constraints, with practical exercises completed in MySQL Workbench including table creation, constraint implementation, and violation testing. Includes worked examples, constraint testing tables, and output-based Q&A that directly reflect the lab activities—useful for understanding data integrity concepts and pr...

Lab documentation for Introduction to the Relational Model in Database Management Systems at HBO Facility Management. Covers fundamental relational database concepts including tables, rows, columns, domains, and schemas, with practical MySQL Workbench exercises and SQL commands. Essential for understanding core DBMS theory and hands-on database table creation—ideal for completing lab assignments and exam preparation in the AI bachelor program.

Lab notes from the Database Management Systems course at HBO Facility Management covering introductory database concepts and MySQL fundamentals. Topics include understanding databases versus file systems, DBMS basics, MySQL Workbench interface, creating databases with SQL commands (CREATE DATABASE, USE, SHOW DATABASES), and understanding database structure with tables, rows, and columns. Includes practical exercises with deliverables, worked SQL commands, and Q&A section - ideal for students lea...

Lab notes for Database Management Systems covering SQL query fundamentals using MySQL. Topics include SELECT statements, WHERE clause filtering, comparison and logical operators (AND, OR, NOT), special operators (BETWEEN, IN, LIKE), and ORDER BY sorting with practical exercises. Ideal for mastering core SQL skills and preparing for DBMS assessments with step-by-step examples and hands-on query practice.

Lab manual for Database Management Systems covering SQL Data Manipulation Language (DML) at HBO Facility Management. This practical lab focuses on INSERT, UPDATE, and DELETE operations in MySQL, with hands-on activities using a university student database and MySQL Workbench. Essential for mastering data modification techniques and understanding best practices like using WHERE clauses safely before executing changes.

Lab notes for Database Management Systems (DBMS) covering SQL Data Definition Language (DDL) at HBO Facility Management. Topics include CREATE, ALTER, and DROP statements for managing databases and tables in MySQL, with practical exercises on creating databases, modifying table structures, adding/renaming columns, and verifying changes using MySQL Workbench. Includes step-by-step lab tasks and examples, making it ideal for understanding database structure fundamentals and preparing for DBMS cour...

Lab manual covering Entity-Relationship (ER) Model fundamentals for the Database Management Systems course at HBO Facility Management. Topics include identifying entities and attributes, understanding key attributes, mapping relationships between entities, determining cardinalities, and creating ER diagrams with practical examples from university and library databases. Includes output-based questions and answers showing how to analyze database requirements and convert them into ER models—essen...