I need a data base implementation in mysql

Job ID: 31861476

Budget: $30 – $250 AUD

design a very simple relational database in sqlite3 database with the following requirements
1)An entity-relationship diagram

2)A database schema that implements:
i)Key columns and uniqueness constraints
ii)Referential integrity
iii)Data entry validation

3)A trigger to improve data consistency

4)A view to improve usability

YOU MUST SUBMIT 4 FILES specified in the in the document below See the attached file for the data base specification..