{"id":28,"date":"2023-11-28T22:43:28","date_gmt":"2023-11-28T22:43:28","guid":{"rendered":"http:\/\/vargas-solar.com\/db-fundaments\/?page_id=28"},"modified":"2023-12-13T15:27:13","modified_gmt":"2023-12-13T15:27:13","slug":"activity-1-designing-and-implementing-a-relational-database-29-12-2023","status":"publish","type":"page","link":"http:\/\/vargas-solar.com\/db-fundaments\/activity-1-designing-and-implementing-a-relational-database-29-12-2023\/","title":{"rendered":"Activity 1: Designing and implementing a relational database 29\/12\/2023"},"content":{"rendered":"\n

Material<\/strong>
– SQL Data Definition Language [SQL languages cheat sheet<\/a>]
– MERISE – Relational Model Transformation Rules [PDF<\/strong><\/a>]<\/p>\n\n\n\n

=========================================================
– Ch 17: Conception des BD<\/a> (in French, all book chapters<\/a> available for free)
Lire les sections 1 and 3 for the UML\/R transformation rules<\/strong>
– Ch 06: Mod\u00e8le Relationnel<\/a>
– R\u00e8gles passage MCD\/R<\/a>
Material from a BTS program
– Video: Relational Model Explained<\/a>
=========================================================<\/p>\n\n\n\n

Objective<\/em><\/strong>: The research question is how to design a relational database (relations and constraints) that represents the mini-world described in the section Context.<\/p>\n\n\n\n

Theory background<\/em><\/strong> [PDF<\/a><\/strong>]<\/p>\n\n\n\n