PerfoSpace & SoundSpace: Conceptual/Logical ERD, SQL & PHP Project

This assignment is a comprehensive database project divided into two parts, focusing on the companies PerfoSpace and SoundSpace. Part A requires the creation of a Conceptual Entity-Relationship Diagram (ERD) for PerfoSpace, along with executive summaries explaining the identification of entities, relationships, multiplicities, attributes, and primary keys. Part B shifts to SoundSpace and involves mapping a conceptual ERD to a Logical ERD, accompanied by an executive report detailing the mapping process. Furthermore, it includes writing SQL code (DDL) to create a 'Studio' table in MySQL and developing PHP scripts to add and retrieve data, incorporating web-based forms and confirmation pages. The project emphasizes database design, relational modeling, and practical implementation using SQL and PHP.