A MOISE level III director wants to rationalize their employee parking permit assignments, and so wants to know who drives what cars. Management is also interested in where those cars came from, that is, imported from where? Surveys and interviews find out the following:

{ jo, identified by name, drives a car identified by registration id (.regId) = PKX that was imported from country(.code) MX(Mexico), jo also drives a car identified by registration id = ABZ, imported from UK, tara,, identified by name, drives a car identified by id = PKX, and taraalso drives a car identified by id = KLM imported from AU, additionally, a car with registration XXX was found in the parking lot, and apparently was imported from MX (unknown driver!) }

Q2(

show the two fact tables, say EC, and CK ( they should have a common column)!

Q5

Draw the ORM2 diagram of the Scenario complete with uniqueness constraints, and verbalization predicates ( the fact tables dont need to be included as they were asked for in Q2)

Q6

Given the two fact table of question Q2, ( arbitrarily labeled EC, CK, calculate and show the inner join table result

Q7 Right outer join (15 pts)

Given EC, CK fact tables from Q2, perform a right outer join and show your result