Hair Salon Database Specification: Using MySQL create Hair Salon database: 1. A minimum of 6 relational tables such as (Stylist, service, appointment, customers, suppliers, products….) 2. Appropriate...

The specification is attached to the file


Hair Salon Database Specification: Using MySQL create Hair Salon database: 1. A minimum of 6 relational tables such as (Stylist, service, appointment, customers, suppliers, products….) 2. Appropriate implicit constraints (including primary & foreign keys) 3. Explicit (semantic) constraints such as table constraints and triggers (you need not to implement assertions) 4. At least one view should also be defined within database 5. A minimum of 5 tuples per table A brief report with an appendix section containing the contents of the relational tables, create, insert, update, one join(for 2 tables), one view creation (for 2 tables) and one trigger command used in the project. The report should include: 1. Brief description of the Hair salon database (max one page) 2. An entity Relational Diagram for database and a mapping to an outline Relational Schema 3. Afunctional dependency diagram for the database and list of normalised relations, identifying the primary and foreign keys 4. A brief explanation for any semantic defined for the database 5. Example of Database Security commands for access and brief explanation of security policy intended Submit a Zip file contains the report as PDF and an export of the database from MySQL.