Your task is to perform logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema created clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume that the superset method must be used to implement a generalization (if any). A way how a conceptual schema can be transformed into a collection of relational schemas is explained in a presentation 06 Logical Design The relational schemas must be listed in a format presented in the slides 44 and 45 in a presentation 06 Logical Design. Listing of the relational schemas in the other format scores no marks. Note that the order of the definitions on the relation schemas is important. You must define a parent relation schema (referenced) before its child relational schema (references to the parent relational schema).