I need B$)$ and C$)$ answer.

The relational database below contains two related tables $-$ "Painting' and "Painter"

in a museum. Table structure and design for 'painting' is below:

Actual sample data $($incomplete$)$ for 'painting' table is below:

Table structure and design for 'painter' is below.

Actual sample data $($incomplete$)$ for 'painter' table is below:

a$.$ Write a QBE $($Query By Example$)$ query to find out which paintings painted by

$"$ZzZ$"($painter$\text{'}$s last name$)$ that cost more than $$40000000.$ Display the painter's

code, painter's first name, painting's title, painting's weight and cost. $(6$ marks$)$

b$.$ From the above data, what type of relationships: one$-$to$-$one, one$-$to$-$many, or

many$-$to$-$many, do the above two tables have? Explain your answer.

$(3$ marks$)$

c$.$ The above database contains an error in the data. Identify and describe this

errorl