Part 2 (10 marks)

The following is a database on the art work (e.g. paintings, photos, sculptures) completed by different students in a high school. It has three tables: art work, student and student-Artwork; and their table design structure and actual data are below:

Table structure and design for 'art work' as blow: Actual data for 'art work' table as below: Table structure and design for 'student' as below: Actualdataforstudenttableasbelow: Table structure and design for 'student-Artwork' as below: Actual data for 'student-Artwork' table as below: a) Write a QBE (Query By Example) to find all those art work(s) participated by student with ID '10010' with mark =50 or above. Display the name of art work, student surname, student first name, student mark and participation percentage for each art work. [5marks] b) There is an error in the database shown above. Identify and describe this error. [5 marks] Table structure and design for 'art work' as blow: Actual data for 'art work' table as below: Table structure and design for 'student' as below: Actualdataforstudenttableasbelow: Table structure and design for 'student-Artwork' as below: Actual data for 'student-Artwork' table as below: a) Write a QBE (Query By Example) to find all those art work(s) participated by student with ID '10010' with mark =50 or above. Display the name of art work, student surname, student first name, student mark and participation percentage for each art work. [5marks] b) There is an error in the database shown above. Identify and describe this error. [5 marks]