(Solved): Your task is to perform a step of logical database design, i.e. to transform a conceptual schema giv ...

Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume, that superset method must be used to implement a generalization. Note: license include ID1 is one, not two attributes