(40 points) Represent the complex attribute Prevdue. Recall that a complex attribute is a combination of composite and mult valued attributes possibly nested to several levels. Create a complex attribute for a STUDENT entity type that keeps track of the student's previous college education Name this sont attribute Previdue. The prevedue complex atribute will have one entry value for each college previously attended. Each entry value in composed of the following items: College name . Start date End date Degree entries (degrees awarded at that college it any-hey include Degree name Month and year degree was warded Transcript entries courses completed at that college) --they include Course name Semester and year Grade You will design the complex attribute Provided to hold this information in 3 alternative ways: Write the answer of each of the 3 ways on paper, then, shoot A picture (png or jpg of ALL the 3 answers and upload it here, under the link of this question 111 points) Design the complex attribute Previdue using the notation in the example for the complex attribute with the name Address Phone used in the textbook, the notes and in class [NOTE For your reference, the example with this notation is shown on the next few lines Thorel (PhoneAreaCode, Phone Number, Address(StreetAddress/Number, Street, Aptomban City State. Zp} >> The complex attribute in THIS problem is different -- it is to be called Previduc ] 2 (11 points) Now let the Prevedue complex attribute belong to the STUDENT entity type. Draw on paper, using the ER diagram notation, the complex attribute PrevEduc, which you designed in 1 above 3 (18 points) Show an alternative design for the same complex attribute Providuc described above by constructing an ER diagram that uses only Entity Types (ET) (including weak ET) and Relationship Types (RTS) Use the following specification in addition to the above specification of the prevede A (weak) ET attendance to represent a period (attendance) in which a student attended a particular college identified by the student ET and the start date of the period. Each attendance is related to one college and to 0 or more degrees An ET for students An ET for for college A (weak) ET for transcript of the student to give the record of the student in one course during the attendance period An ET for degree . Four RTs between student and attendance, attendance and transcript, attendance and degree, attendance and college will meet the requirements (40 points) Represent the complex attribute Preveduc. Recall that a complex attribute is a combination of composite and multi-valued attributes possibly nested to several levels. Create a complex attribute for a STUDENT entity type that keeps track of the student's previous college education Name this STUDENT attribute Prevedue. The prevede complex attribute will have one entry value for each college previously attended Each entry value is composed of the following items College name Start date End date Degree entries (degrees awarded at that college if anythey include Degree name Month and year degree was awarded Transcript entries (courses completed at that college) they include Course name Semester and year Grade You will design the complex attribute PrevEdue to hold this information in 3 alternative ways Write the answer of each of the 3 ways on paper then, shoot A picture png or jpg) or ALL the 3 answers and upload there, under the link of this question (40 points) Represent the complex attribute Prevdue. Recall that a complex attribute is a combination of composite and mult valued attributes possibly nested to several levels. Create a complex attribute for a STUDENT entity type that keeps track of the student's previous college education Name this sont attribute Previdue. The prevedue complex atribute will have one entry value for each college previously attended. Each entry value in composed of the following items: College name . Start date End date Degree entries (degrees awarded at that college it any-hey include Degree name Month and year degree was warded Transcript entries courses completed at that college) --they include Course name Semester and year Grade You will design the complex attribute Provided to hold this information in 3 alternative ways: Write the answer of each of the 3 ways on paper, then, shoot A picture (png or jpg of ALL the 3 answers and upload it here, under the link of this question 111 points) Design the complex attribute Previdue using the notation in the example for the complex attribute with the name Address Phone used in the textbook, the notes and in class [NOTE For your reference, the example with this notation is shown on the next few lines Thorel (PhoneAreaCode, Phone Number, Address(StreetAddress/Number, Street, Aptomban City State. Zp} >> The complex attribute in THIS problem is different -- it is to be called Previduc ] 2 (11 points) Now let the Prevedue complex attribute belong to the STUDENT entity type. Draw on paper, using the ER diagram notation, the complex attribute PrevEduc, which you designed in 1 above 3 (18 points) Show an alternative design for the same complex attribute Providuc described above by constructing an ER diagram that uses only Entity Types (ET) (including weak ET) and Relationship Types (RTS) Use the following specification in addition to the above specification of the prevede A (weak) ET attendance to represent a period (attendance) in which a student attended a particular college identified by the student ET and the start date of the period. Each attendance is related to one college and to 0 or more degrees An ET for students An ET for for college A (weak) ET for transcript of the student to give the record of the student in one course during the attendance period An ET for degree . Four RTs between student and attendance, attendance and transcript, attendance and degree, attendance and college will meet the requirements (40 points) Represent the complex attribute Preveduc. Recall that a complex attribute is a combination of composite and multi-valued attributes possibly nested to several levels. Create a complex attribute for a STUDENT entity type that keeps track of the student's previous college education Name this STUDENT attribute Prevedue. The prevede complex attribute will have one entry value for each college previously attended Each entry value is composed of the following items College name Start date End date Degree entries (degrees awarded at that college if anythey include Degree name Month and year degree was awarded Transcript entries (courses completed at that college) they include Course name Semester and year Grade You will design the complex attribute PrevEdue to hold this information in 3 alternative ways Write the answer of each of the 3 ways on paper then, shoot A picture png or jpg) or ALL the 3 answers and upload there, under the link of this