Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this question has part A and B Problem 7 (32 points] From SE Examine the list of e-mail messages. Subject WDA2259@szilmail.com Big Wind WDA22590silmail.com Update
this question has part A and B
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 Step 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