answer please

Q1. [8 marks] Draw an EER diagram for the following scenario. Royal Jordanian depends on different types of employees for its daily operation: Royal Jordanian is interested in the following attributes for all of these employees: national number, name - first name, last name - address - city, state, postal code and telephones. Three employees are of greatest interest: pilots, crew, and engineers. Pilots have date hired attribute and rank, and crews have skills attribute and bonus. Engineers have a relationship with the maintenance center. An engineer must register in at least one maintenance center, which is identified by a location ID, and a maintenance center may have many engineers. There are employees other than pilots, crews, and engineers who are of interest to the Royal Jordanian. On the other hand, at a given time an employee must belong to one of these groups. Q2. [10 marks] Convert the following Relation into INF. 2NF, and 3NF if applicable, and show the functional dependencies. Part Number Description Vender Name Lait Cost Address 10 1234 Logchup FA Chips SmartChips Memory chup NY CA NY IN NI CA Quality Chips Smart Clups