SQL - Phone Database

Description

Project consists of using MySQL Workbench to design a SQL database related to Samsung S24 and IPhone 15 models. The database schema's design has 15 tables, 105 instances, and 19 SQL queries. Furthermore, an ER-diagram was developed on draw.io with 8 entities and later refined into a relational diagram. A 2,100 word Latex report was made to communicate findings to technical and non-technical stakeholders.

Languages and Utilities Used

• MySQL Workbench
• Draw.io
• Latex

Program walk-through:

Make an E-R Diagram:


Make a Relational Model:


Make the tables, their variables, and their variable types:


Insert values for the variables:


Create questions to analyze your data:


Share your findings in a Latex Report: