Create a list of indexes and Constraints from looking at this E-R Diagram (SQL)

Create a list of indexes and Constraints from looking at this E-R Diagram (SQL)

StudentExam Prerequisite StudentID: Int Exami D: Int CourselD: Int Exa mlD: Int Course ID: Int RequiredCourselD: Int Grade: VarChar Date Time: datetime Student StudentID: Int Department Course StudentNumber: Int Department D: Int CourselD: Int LastNa me: VarChar VarChar InstructorlD: Int FirstName: VarChar Address: VarChar LablD: Int YearEnrolled: Int Phone Number: VarChar DepartmentiD: Int DepartmentiD: Int CRSN: Varchar Email: Text Semester: Varchar PhoneNumber: VarChar StudentLabCourse- Instructor StudentiID:Int Instructorl D: Int LablD: Int Name: VarChar Pass: Boolean PhoneNumber: Varchar Email: Text