SQL Queries used for the Phone project on MySQL
Home Task Requirements for SQL using MySQL
SUBJECT: Phone
Home Task #1
| Requirements | Implementation |
|---|---|
| Create a database schema using MySQL Workbench for the new hierarchy with at leas 12 tables and all relations |  |
The schema should satisfy the 3 Normal Forms
The following have been implemented in the database
Home Task #2
| Requirements | Implementation |
|---|---|
| 10 statements for Insertion | Added 2 SQL files into this repository: Insertion_staments and Insertion_statements_2 |
| 10 statements for Updating | Added 1 SQL files that contains Update_statements |
| 10 statements for Deletions | Added 1 SQL files that contains Delete_statements |
| 5 alter table. | Added 1 SQL files that contains alteration of tables Alter_Statements |
| 1 big statement to join all tables in the database | Added 1 SQL files that joins all tables from DB |
| 5 statements with left, right, inner, outer joins. | Added the Various_statement SQL file |
| 7 statements with aggregate functions and group by and without having | Added the 7_without_having SQL file |
| 7 statements with aggregate functions and group by and with having | Added the 7_with_having SQL file |