Hello I need someone to Convert the following ER diagram into a relational database schema. and answer the following questions, 1.Find names of all students who take at least two courses taught by Peterson but take only one course from Davidson. 2. Find S_IDs of the students who take all courses taught by Davidson. 3. Find all instructors (C_InstNames) who currently teach at least three courses.The ER diagram is uploaded to the attached files.dbhw2.pdfUnformatted Attachment PreviewWritten Assignment (Homework) #2(10-point) Convert the following ER diagram into a relational database schema:S_FirstNameS_IDS_LastNameS_MajorstudenttakescourseC_IDC_NameC_RoomC_InstName(90-point) Express the following queries on the above schema in both relational algebra(20-point each) and relational calculus (10-point each):1. Find names of all students who take at least two courses taught by Peterson buttake only one course from Davidson.2. Find S_IDs of the students who take all courses taught by Davidson.3. Find all instructors (C_InstNames) who currently teach at least three courses.Please submit legible answers.…Purchase answer to see fullattachment.
100% Original paper Customized to your instructions!