Problem

Examine the list of email messages in Figure 5-54. Using the structure and example data it...

Examine the list of email messages in Figure 5-54. Using the structure and example data items in this list, do the following:

A. Create a single-entity data model for this list. Specify the identifier and all entities.


B. Modify your answer to A to include entities SENDER and SUBJECT. Specify the identifiers and attributes of entities and the types and cardinalities of the relationships. Explain which cardinalities can be inferred from Figure 5-54 and which need to be checked out with users.


C. The email address in the From column in Figure 5-54 is in two different styles. One style has the true email address: the second style (e.g., Tom Cooper) is the name of an entry in the user’s email directory. Create two categories of SENDER based on these two styles. Specify identifiers and attributes.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search