EssayproSolutions

Problem 7 32 Points Se Examine List E Mail Messages Subject Wda2259 Szilmailcom Big Wind W Q43792378

this question has part A and BProblem 7 (32 points] From SE Examine the list of e-mail messages. Subject WDA2259@szilmail.com Big Wind WDA22590silmail.com Update WDA2259@salmail.com Re: Saturday Am WDAZZ5Sosailmail.com Re: Weather window! WDA22590salonail.com Re: Hond! WDA2259@salmail.com Still here WDA2259@salmail.com Re: Turle Bay WDA22590s silmail.com Turl Bay WDA 22590silmail.com Re: Hi WDA 2250 aitmail.com Sunday, Santa Maria Kibu@aol.com Cabo, Thurs. Neon WDAZZ590s allmail.com turbo WDA 22590s silmail.com on our way Tom Cooper RE? Hola! RE. Hola! Tom Cooper RE: Hola! Tom Cooper Date & 5/13/2011 5/12/2011 5/11/2011 1/10/2011 1/10/2011 5/9/2011 5/8/2011 S//2011 5/6/2011 5/6/2011 5/2/2011 5/2/2011 4/28/2011 4/26/2011 4/24/2011 4/23/2011 кб 3 KB a) (16 points) Draw the complete E-R diagram that includes addressing multi-value attributes for am that includes addressing multi-value attributes for the list of email messages. A complete E-R diagram includes identifiers, minimum/maximum cardinality, entity type, and all needed attributes. b) (16 points) Draw the logical (also called physical in class) model based on this E-R diagram Assume the stock portfolio has an owner name, a phone number, an e-mail address, and a list of stocks held. The list includes the identity of the stock and the number of shares held. Clearly mark the primary key(s) (underlined or draw a key), foreign key(s) (“FK”), and corresponding relationships. No need to specify alternate keys or column properties. INDEX IndexiD IndexName Index Country COMPANY Company ID Company Name Company Country STOCK QUOTE QuoteDate IndexID Company ID LastQuote Change PercentChange STOCK QUOTE SYMBOL IndexID Company ID Symbol PORTFOLIO Portfolio OwnerlastName OwnerFirstName OwnerPhone OwnerEmail PORTFOLIO ITEM Portfolio PortfolioltemiD Ok IndexID Company ID NumberOfShares Show transcribed image text Problem 7 (32 points] From SE Examine the list of e-mail messages. Subject WDA2259@szilmail.com Big Wind WDA22590silmail.com Update WDA2259@salmail.com Re: Saturday Am WDAZZ5Sosailmail.com Re: Weather window! WDA22590salonail.com Re: Hond! WDA2259@salmail.com Still here WDA2259@salmail.com Re: Turle Bay WDA22590s silmail.com Turl Bay WDA 22590silmail.com Re: Hi WDA 2250 aitmail.com Sunday, Santa Maria Kibu@aol.com Cabo, Thurs. Neon WDAZZ590s allmail.com turbo WDA 22590s silmail.com on our way Tom Cooper RE? Hola! RE. Hola! Tom Cooper RE: Hola! Tom Cooper Date & 5/13/2011 5/12/2011 5/11/2011 1/10/2011 1/10/2011 5/9/2011 5/8/2011 S//2011 5/6/2011 5/6/2011 5/2/2011 5/2/2011 4/28/2011 4/26/2011 4/24/2011 4/23/2011 кб 3 KB
a) (16 points) Draw the complete E-R diagram that includes addressing multi-value attributes for am that includes addressing multi-value attributes for the list of email messages. A complete E-R diagram includes identifiers, minimum/maximum cardinality, entity type, and all needed attributes.
b) (16 points) Draw the logical (also called physical in class) model based on this E-R diagram Assume the stock portfolio has an owner name, a phone number, an e-mail address, and a list of stocks held. The list includes the identity of the stock and the number of shares held. Clearly mark the primary key(s) (underlined or draw a key), foreign key(s) (“FK”), and corresponding relationships. No need to specify alternate keys or column properties. INDEX IndexiD IndexName Index Country COMPANY Company ID Company Name Company Country STOCK QUOTE QuoteDate IndexID Company ID LastQuote Change PercentChange STOCK QUOTE SYMBOL IndexID Company ID Symbol PORTFOLIO Portfolio OwnerlastName OwnerFirstName OwnerPhone OwnerEmail PORTFOLIO ITEM Portfolio PortfolioltemiD Ok IndexID Company ID NumberOfShares

Expert Answer

Answer to Problem 7 (32 points] From SE Examine the list of e-mail messages. Subject WDA2259@szilmail.com Big Wind WDA22590silmail…