This is a project content: Part A - Design a relational database schema Design a database about vehicle information management The requirements are as follows: 1. Describe this subjects Entity, Relationship and Attributes. (5 marks) 2. Draw this subject's ERA diagram (E-R model). (10 marks) 3. Conversion from ERA diagram (E-R model) into relational database schema at least five tables in Third Normal Form(3NF). (10 marks) 4. For each table, assert some functional dependencies(FDs) and identify the keys. (5 marks) Part B Implement a MySQL -compatible relational database schema 1. Create file schema.sql which 2. Create file queries.sql which contains: contains: (1) Five SQL queries for your database. The (i) a CREATE TABLE statement for queries should use a join, subquery and/or each table defined in part A; include group by and having; (15 marks) definitions of primary keys, any (ii) A definition of one view that might be foreign keys and any unique attributes; useful either for the queries you have written or specify any default values of for other queries; (5 marks) attributes; (10 marks) (ii) INSERT INTO statements that 3. Create file trigger.sql which contains insert some example data into the one trigger for your database. (5 marks) tables (at least five data rows per table), Use UPDATE SET statements to modify some data and use DELETE 4. Create file procedure.sql which contains FROM statements to delete some data. one stored procedure/ function for your (10 marks) database