1. Draw appropriate Entity-Relationship (E-R) diagram that satisfies the above facts. Indicate the multiplicity of relationships and the key or keys for the entity sets and relationships, and weak and subclass entity sets, whenever exist. Translate the E-R diagram into relational database schema. Indicate the key or keys for each relation. Give appropriate SQL statements to create the database tables and provide the outputs for the following queries: 2. 3. The number of students, and the highest and lowest salaries, for each employer; a. b. he names of students and their best friends, and their respective salaries; c. The names of students whose best friends receive a higher salary than theirs. Show the outputs ordered in ascending order by the student name. Data: STUDENTS: StudentId Name Nurul Amin Candice Baptiste-Sexton Alexis Cruz Tama Dey Jorge Gottman Ariel Martinez Vernon Mckenzie Abiola Olabode Nana Yaw Oppong-Quayson 8 Data for the exercise is entirely arbitrary. You may change the data in any way you wish