Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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-54

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 11 The Ultimate Database For Cloud Analytics And Mobile

Authors: John Campbell, Chris Crone, Gareth Jones, Surekha Parekh, Jay Yothers

1st Edition

ISBN: 1583474013, 978-1583474013

More Books

Students also viewed these Databases questions