A High school recently held an art exhibition showing all the art works done by the school's students, and would like to

[answerhappygod]

A High School Recently Held An Art Exhibition Showing All The Art Works Done By The School S Students And Would Like To 1 (67.49 KiB) Viewed 31 times

A High school recently held an art exhibition showing all the art works done by the school's students, and would like to set up a database recording which student created which piece of art work etc. Each student has a unique student ID and each piece of artwork has a unique artworkin, and the following attributes are found for student and artwork: STUDENT: studentID, surname, first name, birthdate, class-code, sex ARTWORK: artworkID. completion date, height, width, depth, art type An art teacher has a list of art works that are completed by each student, see below for some samples: studenti artworkID 20140000 X123, P234, C883, D678 20171111 X234, P334, D222, C883 20192222 X243, P123, C883, D888 20153333 X111, D123 20164444 X222, P234 You are responsible to help design this database for the school. a) What relationship (one-to-one, one-to-many, many-to-many) exists between STUDENT and ARTWORK? Explain your answer or draw an entity relationship diagram. (2 marks) b) How many tables would be needed to implement the relationship as indicated in (a)? List out the attributes in each table, indicating which field(s) form the primary key, and which field is the foreign key (if foreign key exists). (5 marks)