0
$\begingroup$

I have the following task:

Translate the following ER diagram to the relational model. Use as few relations as possible. Do not increase or decrease the capacity. How many relations does the relational model have?

Hint: Assume that attributes are declared as unique to maintain the capacity when merging relations.

enter image description here

Now my question:

If It translate the ER diagram to the relational model, then I would get something like this:

Pizza($\underline{PizzaName}$)

Person($\underline{PersonID}$, PizzaName $\to$ Pizza, online) (a)

Person($\underline{PersonID}$, ComputerID $\to$ Computer) (b)

Computer($\underline{ComputerID}$)

Can I combine (a) and (b)?

Because then I would have 3 relations and not 4. Would this answer the task?

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.