Question

Q1: Each student has a unique student id, name, unique email address, and a phone number. A student is either a degree seeking student or a non-degree seeking student. For degree seeking students, additional information such as catalog year and date of admission are recorded. For non-degree seeking students, additional information on program of interest needs to be recorded. Only degree seeking students can submit financial aid applications. Each degree seeking student can submit multiple financial aid applications or none. However, each financial aid application is submitted by only one student. Create an ER Model to represent this scenario. Q2: A concert includes performance by one or multiple artists. Each artist can perform in none or multiple concerts. For each artist that performs in a concert, record if the artist participated as a guest appearance or as a main artist. Create an ER Model to represent this scenario

Answer 1

Ans 1.

student id student_nam email_id hone number STUDENT tudent i student i Tpursue (o,n) (0, n) NON-DEGREE DEGREE atalog yea inancial_aid app_i program_of_interset admission_yea

ANSWER 2.

artist id rtist name oncert name oncert i ARTIST CONCERT (o, n) pearance typ (0, N) GUEST OR MAIN ppearance concert i