Part $1$: Database Description and Design$\mathrm{.}1-$ Write an introduction about a database of your choice. The database is pet adoption

The database must include at least five entities. Do not select any database which were studied in the lab$/$lecture$.(1$ Mark$)2-$ Design an entity$-$relationship $($ER$)$ diagram based on your scenario requirements. Ensure that cardinalities, relationships, and primary keys are clearly represented. State any assumptions that may affect the ER diagram. $(2$ Marks$)3-$ Convert the ER diagram to a class diagram. $(1$ Mark$)$ Part $2$: Create and Populate Relations$1-$ Map the ER diagram to a relational model and create the relations in MySQL$.(1$ Mark$)2-$ Enter at least $15$ tuples for each relation. Your solution should include thescreenshots of your relations with data. $(1$ Mark$)$ Part $3$: Indexes, Queries and Fragmentation$1-$ Write any retrieval query that includes a selection condition. Illustrate how MySQL internally performed this query $($e$.$g$.,$ such as parsing and optimization$)(1$ Mark$)2-$ Create an index for the same column used in the previous selection condition. $(1$ Mark$)3-$ Select any relation $($table$)$ from your database and perform vertical fragmentation on it$.$ Show the table before and after fragmentation. Additionally, discuss the benefits of using such fragmentation. $(1$ Mark$)4-$ Write any retrieval query that includes at least one join condition and one selection condition. Show the results of the query. $(1$ Mark$)5-$ Show the query statistics and execution plan for the above query. $(1$ Mark$)$Part $4$: Roles, Privileges and Triggers$1-$ Create $3$ roles and assign the following privileges to the roles: $(1$ Mark$)-$ Give all privileges to the first role.$-$ Give select and update privileges to the second role, which canfurther assign the same privileges to others.$-$ Give only insert privileges to the third role$\mathrm{.}2-$ Create three accounts and assign the above roles to the created accounts $($each account with a different role$).(1$ Mark$)3-$ Create SQL trigger that must check condition in a relation. $(1$ Mark