Premium Essay

Solution Manual

In: Computers and Technology

Submitted By Sowmya609
Words 3109
Pages 13
Database Modeling and Design – 4th Edition (2006)
Toby Teorey, Sam Lightstone, Tom Nadeau

Exercises with Solutions – Solutions Manual

ER and UML Conceptual Data Modeling

Problem 2-1

Draw a detailed ER diagram for an car rental agency database (e.g. Hertz), keeping track of current rental location of each car, its current condition and history of repairs, and customer information for a local office, expected return date, return location, car status (ready, being-repaired, currently-rented, being-cleaned). Select attributes from your intuition about the situation, and list them separately from the diagram, but associated with a particular entity or relationship in the ER model.

Solution to 2-1

Problem 2-2
Given the following assertions for a relational database that represents the current term enrollment at a large university, draw an ER diagram for this schema that takes into account all the assertions given. There are 2000 instructors, 4000 courses, and 30,000 students. Use as many ER constructs as you can to represent the true semantics of the problem.

Assertions:
An instructor may teach one or more courses in a given term (average is 2.0 courses).
An instructor must direct the research of at least one student (average = 2.5 students).
A course may have none, one, or two prerequisites (average = 1.5 prerequisites).
A course may exist even if no students are currently enrolled.
All courses are taught by exactly one instructor.
The average enrollment in a course is 30 students.
A student must select at least one course per term (average = 4.0 course selections).

Solution to 2-2

Problem 3-1

Draw UML class diagrams for a car rental agency database (e.g. Hertz), keeping track of current rental location of each car, its current condition and history of repairs, and customer information for a local office,…...

Similar Documents

Free Essay

Solutions Manual for Statistical Inference, Second Edition

...Solutions Manual for Statistical Inference, Second Edition George Casella University of Florida Roger L. Berger North Carolina State University Damaris Santana University of Florida 0-2 Solutions Manual for Statistical Inference “When I hear you give your reasons,” I remarked, “the thing always appears to me to be so ridiculously simple that I could easily do it myself, though at each successive instance of your reasoning I am baffled until you explain your process.” Dr. Watson to Sherlock Holmes A Scandal in Bohemia 0.1 Description This solutions manual contains solutions for all odd numbered problems plus a large number of solutions for even numbered problems. Of the 624 exercises in Statistical Inference, Second Edition, this manual gives solutions for 484 (78%) of them. There is an obtuse pattern as to which solutions were included in this manual. We assembled all of the solutions that we had from the first edition, and filled in so that all odd-numbered problems were done. In the passage from the first to the second edition, problems were shuffled with no attention paid to numbering (hence no attention paid to minimize the new effort), but rather we tried to put the problems in logical order. A major change from the first edition is the use of the computer, both symbolically through Mathematicatm and numerically using R. Some solutions are given as code in either of these languages. Mathematicatm can be purchased from Wolfram Research, and R is......

Words: 59353 - Pages: 238

Free Essay

Solution Manual of Stochastic Process- Shreve

...Stochastic Calculus for Finance, Volume I and II by Yan Zeng Last updated: August 20, 2007 This is a solution manual for the two-volume textbook Stochastic calculus for finance, by Steven Shreve. If you have any comments or find any typos/errors, please email me at yz44@cornell.edu. The current version omits the following problems. Volume I: 1.5, 3.3, 3.4, 5.7; Volume II: 3.9, 7.1, 7.2, 7.5–7.9, 10.8, 10.9, 10.10. Acknowledgment I thank Hua Li (a graduate student at Brown University) for reading through this solution manual and communicating to me several mistakes/typos. 1 1.1. Stochastic Calculus for Finance I: The Binomial Asset Pricing Model 1. The Binomial No-Arbitrage Pricing Model Proof. If we get the up sate, then X1 = X1 (H) = ∆0 uS0 + (1 + r)(X0 − ∆0 S0 ); if we get the down state, then X1 = X1 (T ) = ∆0 dS0 + (1 + r)(X0 − ∆0 S0 ). If X1 has a positive probability of being strictly positive, then we must either have X1 (H) > 0 or X1 (T ) > 0. (i) If X1 (H) > 0, then ∆0 uS0 + (1 + r)(X0 − ∆0 S0 ) > 0. Plug in X0 = 0, we get u∆0 > (1 + r)∆0 . By condition d < 1 + r < u, we conclude ∆0 > 0. In this case, X1 (T ) = ∆0 dS0 + (1 + r)(X0 − ∆0 S0 ) = ∆0 S0 [d − (1 + r)] < 0. (ii) If X1 (T ) > 0, then we can similarly deduce ∆0 < 0 and hence X1 (H) < 0. So we cannot have X1 strictly positive with positive probability unless X1 is strictly negative with positive probability as well, regardless the choice of the number ∆0 . Remark: Here the condition X0 = 0 is......

Words: 19710 - Pages: 79

Premium Essay

Audit Chapter 8 Solutions Manual

...Solutions for Chapter 8 Tools to Gather Audit Evidence Review Questions: 8-1. The three main tools the auditor might use in gathering and evaluating audit evidence are: • Audit sampling • Generalized Audit Software • Analytical procedures 8-2. Non-sampling risk is the risk that the auditor makes an improper assessment of inherent and/or control risk or did not apply audit procedures carefully. It can be minimized through: (1) Good hiring, training and supervision practices; and (2) Careful and knowledgeable review of audit documentation and audit procedures. Sampling risk is the risk that the misstatement projections based on the sample results lead to the wrong conclusion about the population because of a non-representative sample. Sampling risk can be reduced by increasing the sample size – to the extreme of auditing the entire population therefore eliminating sampling risk altogether. 8-3. Factors to consider when choosing between statistical and nonstatistical sampling include: • Need to quantify and control sampling risks. • Additional cost of designing, selecting, and evaluating a statistical sample. • Availability of computer software to assist in designing, selecting, and/or evaluating the sample. • Ability of the audit staff to properly implement statistical sampling. 8-4. a. Tolerable deviation rate depends on the significance of the control procedure being......

Words: 11678 - Pages: 47

Free Essay

Rudin W Solution Manual of Principles of Mathematical Analysis

...MATH 413 [513] (PHILLIPS) SOLUTIONS TO HOMEWORK 1 Generally, a “solution” is something that would be acceptable if turned in in the form presented here, although the solutions given are often close to minimal in this respect. A “solution (sketch)” is too sketchy to be considered a complete solution if turned in; varying amounts of detail would need to be filled in. Problem 1.1: If r ∈ Q \ {0} and x ∈ R \ Q, prove that r + x, rx ∈ Q. Solution: We prove this by contradiction. Let r ∈ Q\{0}, and suppose that r +x ∈ Q. Then, using the field properties of both R and Q, we have x = (r + x) − r ∈ Q. Thus x ∈ Q implies r + x ∈ Q. Similarly, if rx ∈ Q, then x = (rx)/r ∈ Q. (Here, in addition to the field properties of R and Q, we use r = 0.) Thus x ∈ Q implies rx ∈ Q. Problem 1.2: Prove that there is no x ∈ Q such that x2 = 12. Solution: We prove this by contradiction. Suppose there is x ∈ Q such that x2 = 12. Write x = m in lowest terms. Then x2 = 12 implies that m2 = 12n2 . n Since 3 divides 12n2 , it follows that 3 divides m2 . Since 3 is prime (and by unique factorization in Z), it follows that 3 divides m. Therefore 32 divides m2 = 12n2 . Since 32 does not divide 12, using again unique factorization in Z and the fact that 3 is prime, it follows that 3 divides n. We have proved that 3 divides both m and n, contradicting the assumption that the fraction m is in lowest terms. n Alternate solution (Sketch): If x ∈ Q satisfies x2 = 12, then x is in Q and satisfies 2 x 2 = 3. Now prove......

Words: 37998 - Pages: 152

Premium Essay

Solution Manual Gitman

...Principles of Managerial Finance Solution Lawrence J. Gitman PART 1 Introduction to Managerial Finance CHAPTERS IN THIS PART 1 2 3 The Role and Environment of Managerial Finance Financial Statements and Analysis Cash Flow and Financial Planning INTEGRATIVE CASE 1: TRACK SOFTWARE, INC. CHAPTER 1 The Role and Environment of Managerial Finance INSTRUCTOR’S RESOURCES Overview This chapter introduces the student to the field of finance and explores career opportunities in both financial services and managerial finance. The three basic legal forms of business organization (sole proprietorship, partnership, and corporation) and their strengths and weaknesses are described, as well as the relationship between major parties in a corporation. The managerial finance function is defined and differentiated from economics and accounting. The chapter then summarizes the three key activities of the financial manager: financial analysis and planning, investment decisions, and financing decisions. A discussion of the financial manager's goals – maximizing shareholder wealth and preserving stakeholder wealth – and the role of ethics in meeting these goals is presented. The chapter includes discussion of the agency problem – the conflict that exists between managers and owners in a large corporation. Money and capital markets and their major components are introduced in this chapter. The final section covers a discussion of the impact of taxation on the firm's......

Words: 5096 - Pages: 21

Premium Essay

Solution Manual

...CHAPTER 1 INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING IN A GLOBAL BUSINESS ENVIRONMENT MULTIPLE CHOICE 1. In comparing financial and management accounting, which of the following more accurately describes management accounting information? a. historical, precise, useful b. required, estimated, internal c. budgeted, informative, adaptable d. comparable, verifiable, monetary ANSWER: c EASY 2. Management and financial accounting are used for which of the following purposes? Management accounting Financial accounting a. internal external b. external internal c. internal internal d. external external ANSWER: a EASY 3. One major difference between financial and management accounting is that a. financial accounting reports are prepared primarily for users external to the company. b. management accounting is not under the jurisdiction of the Securities and Exchange Commission. c. government regulations do not apply to management accounting. d. all of the above are true. ANSWER: d EASY 4. Which of the following statements about management or financial accounting is false? a. Financial accounting must follow GAAP. b. Management accounting is not subject to regulatory reporting standards. c....

Words: 4206 - Pages: 17

Premium Essay

Financial Accounting Harrison Solution Manual Chapter 7

... | | |($360,000 − $50,000) × |75 + 85 + 135 + 39 | |(103,540)a | | |1,000 | | | | |_______ | | Book value of old truck………………………………….. |$256,460 | _____ aAlternate solution setup for accumulated depreciation: | |($360,000 − $50,000) | |= |$.31 per mile | | |1,000,000 miles | | | | | | | | |75,000 + 85,000 + 135,000 + 39,000 = 334,000 miles driven | | | | ...

Words: 9421 - Pages: 38

Premium Essay

Solution Manual for a Course in Game Theory

...Solution Manual for A Course in Game Theory Solution Manual for A Course in Game Theory by Martin J. Osborne and Ariel Rubinstein Martin J. Osborne Ariel Rubinstein with the assistance of Wulong Gu The MIT Press Cambridge, Massachusetts London, England This manual was typeset by the authors, who are greatly indebted to Donald Knuth (the A creator of TEX), Leslie Lamport (the creator of L TEX), and Eberhard Mattes (the creator of emTEX) for generously putting superlative software in the public domain, and to Ed Sznyter for providing critical help with the macros we use to execute our numbering scheme. Version 1.1, 97/4/25 Contents Preface xi 2 Nash Equilibrium 1 Exercise 18.2 (First price auction ) 1 Exercise 18.3 (Second price auction ) 2 Exercise 18.5 (War of attrition ) 2 Exercise 19.1 (Location game ) 2 Exercise 20.2 (Necessity of conditions in Kakutani's theorem ) 4 Exercise 20.4 (Symmetric games ) 4 Exercise 24.1 (Increasing payo s in strictly competitive game ) 4 Exercise 27.2 (BoS with imperfect information ) 5 Exercise 28.1 (Exchange game ) 5 Exercise 28.2 (More information may hurt ) 6 Exercise 35.1 (Guess the average ) 7 Exercise 35.2 (Investment race ) 7 Exercise 36.1 (Guessing right ) 9 Exercise 36.2 (Air strike ) 9 Exercise 36.3 (Technical result on convex sets ) 10 Exercise 42.1 (Examples of Harsanyi's puri cation ) 10 Exercise 48.1 (Example of correlated equilibrium ) 11 Exercise 51.1 (Existence of ESS in 2 2 game ) 12......

Words: 27123 - Pages: 109

Premium Essay

Intermediate Financial Accounting Kieso Solution Manual Chapter 6

...|Pension funding. |Complex |25–30 | |P6-12 | |Pension funding. |Moderate |20–25 | |P6-13 | |Expected cash flows and present value. |Moderate |20–25 | |P6-14 | |Expected cash flows and present value. |Moderate |20–25 | |P6-15 | |Fair value estimate. |Complex |20–25 | SOLUTIONS TO CODIFICATION EXERCISES CE6-1 (a) According to the Master Glossary, present value is a tool used to link uncertain future amounts (cash flows or values) to a present amount using a discount rate (an application of the income approach) that is consistent with value maximizing behavior and capital market equilibrium. Present value techniques differ in how they adjust for risk and in the type of cash flows they use. (b) The discount rate adjustment technique is a present value technique that uses a risk-adjusted discount rate and contractual, promised, or most likely cash flows. (c) Other codification references to present value are at (1) FASB ASC 820-10-35-33 and (2) FASB ASC 820-10-55-55-4. Details for these......

Words: 12226 - Pages: 49

Premium Essay

Concepts in Federal Taxation 2011 Murphy Higgins 18th Edition Solutions Manual

...Higgins 18th Edition Solutions Manual Click here to download immediately!!! http://www.testbankpdf.com/taxation/concepts-in-federal-taxation-2011murphy-higgins-18th-edition-solutions-manual/ ----------------------------------------------------------------------Concepts Concepts Concepts Concepts in in in in Federal Federal Federal Federal Taxation Taxation Taxation Taxation 2011 2011 2011 2011 Murphy Murphy Murphy Murphy Higgins Higgins Higgins Higgins 18th 18th 18th 18th Edition Edition Edition Edition Solutions Solutions Solutions Solutions Manual Manual Manual Manual -------------------------------------------------------------------------***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Solution Manual in e-version of the following book*** Name: Concepts in Federal Taxation 2011 Author: Murphy Higgins Edition: 18th ISBN-10: 0538467924 Type: Solutions Manual - The file contains solutions and questions to all chapters and all questions. All the files are carefully checked and accuracy is ensured. - The file is either in .doc, .pdf, excel, or zipped in the package and can easily be read on PCs and Macs. - Delivery is INSTANT. You can download the files IMMEDIATELY once payment is done. If you have any questions, please feel free to contact us. Our response is the fastest. All questions will always be answered in 6 hours. This is the quality of service we are providing and we hope to be your helper. Delivery is in the next moment. Solution Manual is accurate. Buy......

Words: 30213 - Pages: 121

Premium Essay

Auditing Eilifsen Solutions Manual

...knowledge about: (1) the nature of the entity, (2) its objectives and strategies, (3) its industry, regulatory, and other external factors, (4) its management, (5) its governance, (6) its measurement and performance process, and (7) its business processes. 1-11 Sometimes auditors will face situations where no standard audit procedure exists, such as the example from the text of verifying the inventory of reindeer. Such circumstances require that the auditor possess creativity and innovation when planning and administering audit procedures where little or no precedent exists. Every client is different, and applying auditing concepts in different situations requires logic and common sense, and frequently creativity and innovation. Solutions to Problems 1-12 The memo should cite the following facts: • There is a historical relationship between accounting and auditing. 2 • • • When parties to the agency relationship (contract) do not possess the same amount of information (information asymmetry) there is a natural conflict of interest between the parties. For example, when an owner and manager are negotiating an employment contract, the owner may assume that the manager likely will use organizational funds for personal uses. Auditing plays an important role in such relationships. The owner and manager will consummate an employment contract only if the manager agrees to be monitored. Auditing can be used to monitor the contract agreed to by the......

Words: 26005 - Pages: 105

Premium Essay

Solution Manual for Mgmt 6 Chuck Williams

...MGMT6 Chapter 1: Management Pedagogy Map This chapter begins with the learning outcome summaries and terms covered in the chapter, followed by a set of lesson plans for you to use to deliver the content in Chapter 1. Lesson Plan for Lecture (for large sections) Lesson Plan for Group Work (for smaller classes) Assignments with Teaching Tips and Solutions What Would You Do? Case Assignment––Netflix Self-Assessment––Is Management for You? Management Decision––Should We Try to Make More Money Management Team Decision––Negotiating with Investors Practice Being a Manager––Finding a Management Job Develop Your Career Potential––Interview Two Managers Reel to Real Video Assignment: Management Workplace ––Camp Bow Wow Review Questions Additional Activities and Assignments |Highlighted Assignments |Key Points | |What Would You Do? Case Assignment |After a period of phenomenal growth, Netflix faces several challenges as it looks | | |to develop new ways to deliver movies. | |Self-Assessment |Students get a first glimpse to determine if......

Words: 12875 - Pages: 52

Premium Essay

Finance Solution Manual

...budgeting decision. Solution: Financing decisions determine how a firm will raise capital. Examples of financing decisions would be securing a bank loan or the sale of debt in the public capital markets. Capital budgeting involves deciding which productive assets the firm invests in, such as buying a new plant or investing in a renovation of an existing facility. 2. What is the decision criterion for financial managers when selecting a capital project? Solution: Financial managers should only select a capital project if the value of the project’s future cash flows exceeds the cost of the project. In other words, managers should only take on investments that will increase the firm’s value and thus increase the shareholders’ wealth. 3. What are some ways to manage working capital? Solution: Working capital is the day-to-day management of a firm’s short-term assets and liabilities. It can be managed through maintaining the optimal level of inventory, keeping track of all the receivables and payables, deciding to whom the firm should extend credit, and making appropriate investments with excess cash. 4. Which one of the following characteristics does not pertain to corporations? a. can enter into contracts b. can borrow money c. are the easiest type of business to form d. can be sued e. can own stock in other companies Solution: c 5. What are typically the main components of an executive compensation package? Solution: The......

Words: 7130 - Pages: 29

Premium Essay

Solution Manuals

...Management Accounting: Information for Decision-Making and Strategy Execution - 6.Edition - 2012 Anthony A. Atkinson, Robert S. Kaplan Pearson I have both Solution Manulas And Test Banks Of this Book Contact  ahad2030@yahoo.com Chapter 1 How Management Accounting Information Supports Decision Making QUESTIONS 1-1 Management accounting is a discipline that designs planning and performance measurement systems, using financial and nonfinancial information, to help an organization develop and implement its strategy. The information must be relevant and helpful, and customized to serve multiple purposes, such as making decisions, allocating resources, and monitoring, evaluating, and rewarding performance. Information for the “plan” and “do” steps of the PDCA cycle includes prospective data on costs, profits, efficiency, and quality associated with alternative ways to produce or provide goods or services. Information for the “check” and “act” steps includes assessments of how well the organization is achieving its objectives. Common information requirements include measures of cost, quality, profitability, and timeliness. 1-2 A company’s operators, managers, and executives need information for their operational control and improvement activities, as well as on the performance of their individual processes, products, services, and customers. This information is important to direct managers’ attention to areas where improvement is needed, to provide......

Words: 7550 - Pages: 31

Premium Essay

Solution Manual of Principles of Corporate Finance

...is to solve for the present value of: (1) $100 per year for 10 years, and (2) $100 per year in perpetuity, with the first cash flow at year 11. If this is a fair deal, these present values must be equal, and thus we can solve for the interest rate (r). The present value of $100 per year for 10 years is: ⎡1 ⎤ 1 PV = $100 × ⎢ − 10 ⎥ ⎣ r (r) × (1 + r) ⎦ The present value, as of year 10, of $100 per year forever, with the first payment in year 11, is: PV10 = $100/r At t = 0, the present value of PV10 is: ⎡ 1 ⎤ ⎡ $100 ⎤ PV = ⎢ × ⎥ 10 ⎥ ⎢ ⎣ (1 + r) ⎦ ⎣ r ⎦ Equating these two expressions for present value, we have: ⎡1 ⎤ ⎡ 1 ⎤ ⎡ $100 ⎤ 1 = × $100 × ⎢ − ⎥ 10 ⎥ ⎢ 10 ⎥ ⎢ ⎣ r (r) × (1 + r) ⎦ ⎣ (1 + r) ⎦ ⎣ r ⎦ Using trial and error or algebraic solution, we find that r = 7.18%. 17. Assume the amount invested is one dollar. Let A represent the investment at 12 percent, compounded annually. Let B represent the investment at 11.7 percent, compounded semiannually. Let C represent the investment at 11.5 percent, compounded continuously. After one year: FVA = $1 × (1 + 0.12)1 FVB = $1 × (1 + 0.0585)2 FVC = $1 × e(0.115 × 1) After five years: FVA = $1 × (1 + 0.12)5 FVC = $1 × e(0.115 × 5) = $1.7623 FVB = $1 × (1 + 0.0585)10 = $1.7657 = $1.7771 = $1.1200 = $1.1204 = $1.1219 13 After twenty years: FVA = $1 × (1 + 0.12)20 FVC = $1 × e(0.115 × 20) The preferred investment is C. 1 + rnominal = (1 + rreal) × (1 + inflation rate) Nominal Interest Rate 6.00% 23.20% 9.00% Inflation Rate......

Words: 74775 - Pages: 300