Question: 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.

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]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Form 1 To be inserted by Court Case Number: 0 - CIV - 23 - 008215 Date Filed: ( a / 1 1 / 2 3 FDN: SCSA CLAIM SUPREME COURT OF SOUTH AUSTRALIA CIVIL JURISDICTION Please specify the Full Name...

I need some help of question 3 in the individual part of this assignment. Plz give me some advice and references about this question. By the way, the choice of me is the America Movil from Mexico(an...

Information Management Assignment 2 Assessment Weighting: 15% of the course total Total marks = 50 marks Due date: 26 th April, 2023 group of 4 to 6 students submissions. Write each students...

With the help of the case State Fair of Virginia, answer the following questions: What caused State Fair of Virginia to be in its current precarious financial condition? Who are the parties impacted...

(iii) Now express your decision rule instead using only the quantities p(Ck), p(Cj ), p(x|Ck), p(x|Cj ), and relate it to the diagram above. [2 marks] (iv) If the classifier decision rule assigns...

Congratulations! Your firm* has been engaged to conduct a research study for a professional football team, the Melbourne Royals. Your client would like to better understand the match day experience...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

1. What is the original return on investment (ROI) for Rouse Ceramics (before making any additional investment)? 2. What would the ROI be for Rouse Ceramics if this investment opportunity were...

The payoff matrix for a game is given by 2 -4 -4 3 Compute the expected payoffs of the game for the pairs of strategies in parts (a-d). (Round your answers to one decimal place.) 0], e (a) P = E =...

Income tax expense is not necessarily equal to the amount owed to the tax authorities even if this is the most objectively measured amount. True False

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

b. How do they influence communication between U.S. Americans and people from other countries?

8. Explain the relationship among identity, stereotyping, and prejudice.

2. Stereotypes in Prime-Time TV. Watch four hours of television during the next week, preferably during evening hours when there are more commercials. Record the number of representatives of...