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!) }

Q1

Write the elementary facts (Hint there are 8 by my count, use ditto marks () for repetitive entries if you wish, show these)

1. jo drives car PKX

2. ??? ???

. . .

Q2

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

Q3

Generalize the elementary facts into entitytypes

1. jo, tara generalize to ???

2. . . . generalize to ???

3. . . .

Q4

Given the fact tables EC, CK , and assuming they are significant ( representative),

1. What is the cardinality of the fromEmployee to Car relationship? ________

2. What is the cardinality of the fromCar toCountry relationship? _________

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

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