Problem 7 32 Points Se Examine List E Mail Messages Subject Wda2259 Silmailcom Big Wind Wd Q43792433
Problem 7 (32 points) SE Examine the list of e-mail messages. From Subject WDA2259@silmail.com Big Wind WDA22590silmail.com Update WDA22599salmail.com Re: Saturday Am WDA22590s ailmail.com Re: Weather window! WDA22590salmail.com Re: Howdy! WDA2259@salmail.com WDA22590silmail.com Re: Turle Bay WDA22599sailmail.com Turl Bay WDA22590silmail.com Re: Hi WDA 2259@saitmail.com Sunday, Santa Maria K6yu@aol.com Cabo, Thurs. Noon WDAZZS9salmail.com turbo WDA22590s ailmail.com on our way RE: Hola! Tom Cooper RE. Hola! Tom Cooper RE: Hola! Tem Cooper Date 5/13/2011 5/12/2011 5/11/2011 V10/2011 5/10/2011 5/9/2011 5/8/2011 5/8/2011 5/6/2011 5/5/2011 5/2/2011 5/7/2011 4/28/2011 4/26/2011 4/24/2011 4/23/2011 a) (16 points) Draw the complete E-R diagram that includes addressing multi-value attributes for the storeman 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 CompanyID Company Name Company Country STOCK QUOTE Quote Date Index ID Company ID Last Quote Change PercentChange STOCK QUOTE SYMBOL IndexID Company ID Symbol PORTFOLIO PortfoliolD OwnerlastName OwnerFirstName OwnerPhone OwnerEmail PORTFOLIO ITEM Portfolio PortfolioltemiD ok IndexID Company ID NumberOfShares Show transcribed image text Problem 7 (32 points) SE Examine the list of e-mail messages. From Subject WDA2259@silmail.com Big Wind WDA22590silmail.com Update WDA22599salmail.com Re: Saturday Am WDA22590s ailmail.com Re: Weather window! WDA22590salmail.com Re: Howdy! WDA2259@salmail.com WDA22590silmail.com Re: Turle Bay WDA22599sailmail.com Turl Bay WDA22590silmail.com Re: Hi WDA 2259@saitmail.com Sunday, Santa Maria K6yu@aol.com Cabo, Thurs. Noon WDAZZS9salmail.com turbo WDA22590s ailmail.com on our way RE: Hola! Tom Cooper RE. Hola! Tom Cooper RE: Hola! Tem Cooper Date 5/13/2011 5/12/2011 5/11/2011 V10/2011 5/10/2011 5/9/2011 5/8/2011 5/8/2011 5/6/2011 5/5/2011 5/2/2011 5/7/2011 4/28/2011 4/26/2011 4/24/2011 4/23/2011
a) (16 points) Draw the complete E-R diagram that includes addressing multi-value attributes for the storeman 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 CompanyID Company Name Company Country STOCK QUOTE Quote Date Index ID Company ID Last Quote Change PercentChange STOCK QUOTE SYMBOL IndexID Company ID Symbol PORTFOLIO PortfoliolD OwnerlastName OwnerFirstName OwnerPhone OwnerEmail PORTFOLIO ITEM Portfolio PortfolioltemiD ok IndexID Company ID NumberOfShares
Expert Answer
Answer to Problem 7 (32 points) SE Examine the list of e-mail messages. From Subject WDA2259@silmail.com Big Wind WDA22590silmail….
OR