With proper assumptions and using ONE of the following relations to answer the question. You can refer to the schema of university database shown at the end of the question

student(ID, name, dept_name, tot_cred)

takes(ID, course_id, sec_id, semester, year, grade)

course(course_id, title, dept_name, credits)

Explain how to create different indices: primary index, secondary index, dense index, sparse index, respectively. Using any relation, you can either describe based on the definition of the indices or answer with the instance of the relation using some fake data/tuples.

University schema diagram is given below

classroom(building, room number, capacity)

department(dept name, building, budget)

course(course id, title, dept name, credits)

instructor(ID, name, dept name, salary)

section(course id, sec id, semester, year, building, room number, time slot id)

teaches(ID, course id, sec id, semester, year)

student(ID, name, dept name, tot cred)

takes(ID, course id, sec id, semester, year, grade)

advisor(s ID, i ID) time slot(time slot id, day, start time, end time)

prereq(course id, prereq id)