Need help understanding Database ORM Modeling

Scenario describing a simple Bounded Context

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

- 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 show the two fact tables, say EC, and CK ( they should have a common column)!

Example - jo, tara generalize to ???

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

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

2. What is the cardinality of the from Car to Country 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

Inner Join ( 15 pts)

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