WebCT-chapter06sols

WebCT-chapter06sols - Answers to the Chapter 6 Problems Data Modeling Problems 1 home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Answers to the Chapter 6 Problems Data Modeling Problems 1. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied home ssn ownname spousename pro fess ion spousepro fess owner owns 2. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied comm iss ion sa lesprice home ssn ownname spousename pro fess ion spousepro fess owner owns agen tid agen tname o ffice id phone agen t lists 2/23/2011 Answers to the Chapter 6 Problems 3. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied comm iss ion sa lesprice home ssn ownname spousename pro fess ion spousepro fess owner owns agen tid agen tname phone agen t lists o ffice id address mgrname phone o ffice worksa t 4. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied comm iss ion sa lesprice home ssn ownname spousename pro fess ion spousepro fess owner owns agen tid agen tname phone agen t lists o ffice id address mgrname phone o ffice worksa t ssn buyername address bdrms b thrms m inprice maxprice buyer worksw ith 2 2/23/2011 Answers to the Chapter 6 Problems 5. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied comm iss ion sa lesprice home ssn spousename pro fess ion spousepro fess owner owns agen tid agen tname phone agen t lists o ffice id address mgrname phone o ffice worksa t ssn address m inprice bdrms b thrms maxprice buyer worksw ith ssn name phone person D ,C 3 2/23/2011 Answers to the Chapter 6 Problems 6. home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup ied comm iss ion sa lesprice home ssn spousename pro fess ion spousepro fess owner owns agen tid agen tname phone agen t lists o ffice id address mgrname phone o ffice worksa t ssn address m inprice bdrms b thrms maxprice buyer worksw ith ssn name phone person D ,C O fferNo expda te price coun tero ffer Subm itDa te offer made for makes 4 2/23/2011 Answers to the Chapter 6 Problems 7. The following solution uses a two level generalization hierarchy. The investment entity type was added because mutual funds and stocks share two attributes. The share balance is not shared because the balance for stocks is a whole number (no partial shares) but a real number of mutual funds (fractional shares). The set constraints (disjoint and complete) are used because the financial software does not permit other kinds of accounts to be defined. These constraints may not hold in other financial software databases. Checking CheckAcctNo BankName RouteNo CreditCard CardNo ExpDate Limit D,C Stock Shares Exchange LastDivAmt LastDivDate MutualFund TaxExempt Region FundType ShareBalance D,C Investment Symbol LastClosePrice Account AcctID AcctName Balance DateEst 8 and 9....
View Full Document

This note was uploaded on 02/21/2011 for the course MIS 310 taught by Professor Staff during the Spring '08 term at George Mason.

Page1 / 20

WebCT-chapter06sols - Answers to the Chapter 6 Problems Data Modeling Problems 1 home id stree t c ity sta te z ip nobedrms noba ths sq ft ownoccup

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online