Answer to Question #260972 in Databases | SQL | Oracle | MS Access for Pyrnce

Question

The names and gender of various people are indicated below:

Male: Fred, Tom

Female: Ann, Mary, Sue

1.                 Express the information about Fred and Ann in unary facts.

2.                 Draw a conceptual schema diagram based on this choice

3.                 Express the same information in terms of binary elementary facts.

4.                 Draw a conceptual schema diagram based on this choice.

Note: For the rest of this exercise, avoid using unary facts.

Answer 1

The answer to your question is provided in the image: