For each question below, develop a relational schema clearly showing the tables, primary key/s, foreign key/s, and maximum cardinality constraints on both sides of each linkage (as shown in class). Note: we assume that both the phone number and the email can have a missing value. phone emall DOB first Im Id d le. stre e t ame CUSTOMER address las t city s ta te zip ID age a) The ER diagram below shows the relationship among several entities, i.e., the museum, the art objects displayed by the museum, the clients who buy the art objects, and the artists who create the art objects. The art objects fall into two subtypes, paintings and sculpture. Please convert this conceptual ER diagram to a relational schema. name email Caddress type 10 description type year created title "P" PAINTING style CLIENT buys ART O BJECT material draw n D type displayed at material "S" SCULPTURE height created by weight stre et advertised by person- in-charge city Caddress MUSEUM name ARTIST date born state zip name date died country main style total Part 2 Suppose we have a relation shown below with the data describing how employees are assigned to different projects and receiving different hourly charge (ChgHour) per hour according to their job class (JobClass). The relation also shows the number of hours each employee works on a project. Assume that there are dependencies among different attributes (as shown below). The example data in the relation is given below. ProjNum (i.e., Project Number) and EmpNum (Employee Number) constitute the composite primary key for the relation. ProjNum Proj Name EmpNum Example data in the given relation: EmpNum 103 101 ProjNum ProjName 15 Evergreen 15 Evergreen 15 Evergreen 22 27 Rolling Tide Starfight 105 105 104 EmpName JobClass EmpName June E Arbough John G News Alice K Johnson Alice K Johnson Anne K Ramoras JobClass Electrical Engineer Database Designer Database Designer Database Designer Systems Analyst Please convert the relation above to a 3NF relational schema. ChgHour ChgHour $84.50 $105.00 $105.00 $105.00 $96.75 Hours Hours 23.8 19.4 35.7 30 20.4