Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please explain and create data model (ERDs) for the email problem below...an identifier is a table name and attributes are fields/columns within that table. Examine
Please explain and create data model (ERDs) for the email problem below...an identifier is a table name and attributes are fields/columns within that table.
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 relation- ships. Explain which cardinalities can be inferred from Figure 5-54 and which need to be checked out with users. | Subject Big Wind Size 3 KB Update 4 KB From Sailor Bob256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com SailorBob 256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com SailorBob256@somewhere.com Re: Saturday Am Re: Weather window! Re: Howdy! Still here 4 KB 4 KB 3 KB 3 KB 4 KB Re: Turle Bay Turle Bay Date 5/13/2018 5/12/2018 5/11/2018 5/10/2018 5/10/2018 5/9/2018 5/8/2018 5/8/2018 5/6/2018 5/5/2018 5/2/2018 5/1/2018 4/28/2018 4/26/2018 4/24/2018 4/23/2018 Re: Hi Sunday, Santa Maria Cabo, Thurs. Noon 4 KB 3 KB 3 KB turbo MotorboatBobby314@elsewhere.com SailorBob 256@somewhere.com Sailor Bob256@somewhere.com 2 KB 3 KB 3 KB 3 KB on our way RE: Hola! 2 KB TugboatAmanda756@anotherwhere.com TugboatAmanda756@anotherwhere.com TugboatAmanda756@anotherwhere.com RE: Hola! RE: Hola! 3 KB FIGURE 5-54Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started