Take the ER-model create in problem1 and translate it into a relational schema using the rules presented in class. Present the relational schema as an SQL script. Present the results of the following intermediate steps in this order (write which rule you are using in your translation). Translate strong entities (including the ISA relation) unnest composite attributes 1. Translate weak entities 2. Translated multi-valued attributes 3. Translate relationships

Solved
Show answers

Ask an AI advisor a question