# Solution Manual

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

#### 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

#### 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

#### Solution Manual

...CHAPTER 19 RELEVANT COSTS FOR DECISION MAKING I. Questions 1. Quantitative factors are those which may more easily be reduced in terms of pesos such as projected costs of materials, labor and overhead. Qualitative factors are those whose measurement in pesos is difficult and imprecise; yet a qualitative factor may be easily given more weight than the measurable cost savings. It can be seen that the accountant’s role in making decisions deals with the quantitative factors. 2. Relevant costs are expected future costs that will differ between alternatives. In view of the definition of relevant costs, historical costs are always irrelevant because they are not future costs. They may be helpful in predicting relevant costs but they are always irrelevant costs per se. 3. The differential costs in any given situation is commonly defined as the change in total cost under each alternative. It is not relevant cost, but it is the algebraic difference between the relevant costs for the alternatives under consideration. 4. Analysis: |Future costs: |Replace |Rebuild | | New Truck |P10,200 | | | Less: Proceeds from | | | | disposal, net | 1,000 | | | ...

Words: 3314 - Pages: 14

#### 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

#### Finance Solution Manual

...Chapter 1 The Financial Manager and the Firm Learning Objectives 1. Identify the key financial decisions facing the financial manager of any business firm. 2. Identify the basic forms of business organization used in the United States, and review their respective strengths and weaknesses. 3. Describe the typical organization of the financial function in a large corporation. 4. Explain why maximizing the current value of the firm’s stock price is the appropriate goal for management. 5. Discuss how agency conflicts affect the goal of maximizing stockholder wealth. 6. Explain why ethics is an appropriate topic in the study of corporate finance. I. Chapter Outline 1.1 The Role of the Financial Manager A. It’s All about Cash Flows • The financial manager is responsible for making decisions that are in the best interest of the firm’s owners. • A firm generates cash flows by selling the goods and services produced by its productive assets and human capital. After meeting its obligations, the firm can pay the remaining cash, called residual cash flows, to the owners as a cash dividend, or it can keep the money and reinvest the cash in the business. • A firm is unprofitable when it fails to generate sufficient cash flows to pay operating expenses, creditors, and taxes. Firms that are unprofitable over time will be forced into bankruptcy by their creditors. In bankruptcy, the company will be reorganized, or the......

Words: 7130 - Pages: 29

Free Essay

#### Lakeside

Words: 2722 - Pages: 11

Free Essay

#### Delima

...between several modules Alternative solutions: i. Buy new software ii. Develop in-house accounting system iii. Outsourcing the system Problem: Documents are not properly pre numbered, recorded and documented -Sales invoice are manually produces and not pre-numbered -Monthly statement of account not periodically prepare Alternative solutions: i. Adopted auto pre numbered system ii. Implement manual pre numbered system Problem: Lean organization -Organization chart was drawn with simple structure -Directors makes all major decisions and monitor all activities Alternative solution: i. Adopted concept of functional structure En. Zayed CEO Pn. Hashimah COO En. Salam HR & Admin Manager Pn. Balqis Operation Manager (Vacant) Account & Finance Manager (Vacant) Admin Executive (Vacant) Project Manager Cik Amy Finance Executive Project Team (Contract basis) Problem: Timesheet are manually prepared by employees -They’re record time in & out by themselves -Wrongly calculate and paid over Alternative solutions: i. Use access card ii. Use time clock machine @ thumbprint iii. Should hire an additional employee who can monitor the attendance and timesheet iv. Use CCTV Problem: No SOP adopted by Delima Enterprise Sdn Bhd -All decision are authorized by En. Zayed and Pn. Hashimah -No reconciliation was performed for each accounts Withdrawals are made from the Company without proper documentation Alternative solution: i. Each department should......

Words: 270 - Pages: 2

#### Auditing Eilifsen Solutions Manual

...CHAPTER 1 AN INTRODUCTION TO ASSURANCE AND FINANCIAL STATEMENT AUDITING Answers to Review Questions 1-1 The study of auditing is more conceptual in nature compared to other accounting courses. Rather than focusing on learning the rules, techniques, and computations required to prepare financial statements, auditing emphasizes learning a framework of analytical and logical skills to evaluate the relevance and reliability of the systems and processes responsible for financial information, as well as the information itself. To be successful, students must learn the framework and then learn to use logic and common sense in applying auditing concepts to various circumstances and situations. Understanding auditing can improve the decision making ability of consultants, business managers, and accountants by providing a framework for evaluating the usefulness and reliability of information. 1-2 There is a demand for auditing in a free-market economy because the agency relationship between an absentee owner and a manager produces a natural conflict of interest due to the information asymmetry that exists between the owner and manager. As a result, the agent agrees to be monitored as part of his/her employment contract. Auditing appears to be a cost-effective form of monitoring. The empirical evidence suggests auditing was demanded prior to government regulation such as statutory audit requirements. Additionally, many private companies and other entities not......

Words: 26005 - Pages: 105

#### Engineering Thermodynamics Solutions Manual

...Assignment # 2 Petroleum Engineering Thermodynamic 1. PCB/PDB 1043 A piston–cylinder device initially contains 0.07 m3 of nitrogen gas at 130 kPa and 120°C. The nitrogen is now expanded to a pressure of 100 kPa polytropically with a polytropic exponent whose value is equal to the specific heat ratio (called isentropic expansion). Determine the final temperature and the boundary work done during this process. 2. A frictionless piston–cylinder device contains 2 kg of nitrogen at 100 kPa and 300 K. Nitrogen is now compressed slowly according to the relation PV1.4 =constant until it reaches a final temperature of 360 K. Calculate the work input during this process. 3. Complete the table below on the basis of the conservation of energy principle for a closed system. Qm kJ 350 350 130 260 -500 -50 Wout kJ E1 kJ 1020 550 600 1400 1000 900 E2 kJ 860 M kg 3 5 2 7 3 -200 150 e2-e1 kJ/kg 4. A well-insulated rigid tank contains 2 kg of a saturated liquid-vapor mixture of water at 150 kPa. Initially, three-quarters of the mass is in the liquid phase. An electric resistor placed in the tank is connected to a 110-V source, and a current of 8 A flows through the resistor when the switch is turned on. Determine how long it will take to vaporize all the liquid in the tank. Also, show the process on a T-V diagram with respect to saturation lines. 5. An 80-L vessel contains 4 kg of refrigerant -134a at a pressure of 160 kPa. With the help of Pressure Table for saturated......

Words: 866 - Pages: 4

#### Synthesis of Acetanilide & Purification by Recrystallization

...Recrystallization Par, B., Ramos, S., Reynaldo, H., Roque, P., Servidad, Y., and Soriente, P. 2D-Pharmacy, Group No. 7, Department of Pharmacy, Faculty of Pharmacy, University of Santo Tomas, España Boulevard, 1015 Manila, Philippines Abstract Recrystallization is the primary method of purification used to isolate organic compounds in a supersaturated solution by the difference of solubility at different temperature that results to the separation of the compound from the solution. The purpose of this experiment is to synthesize acetanilide by the acetylation of aniline and to obtain pure acetanilide by purification of the collected crude acetanilide by crystallization. The recrystallizing solvent was chosen among ethanol, water and hexane. The acetanilide was synthesized and formed by acetylation of aniline and acetic anhydride, and it was then cooled to hasten the formation of crystals. After cooling, the mixture was filtered and dried to obtain the crude acetanilide. The crude acetanilide and the chosen recrystallizing solvent was mixed and heated in the water bath until the solid dissolved. The solution was filtered while hot and its filtrate was cooled in an ice bath. The filtrate was then filtered to collect the crystal residue formed. The crystals were washed with distilled water and allowed to dry to obtain the pure acetanilide. The weight of pure acetanilide was measured and the melting point of the pure acetanilide was determined. Based on the......

Words: 1798 - Pages: 8

#### Solution Manual to Introduction to Management

...Problem 1-14B (45 minutes) 1. | |House Of Pianos, Inc. | | |Traditional Income Statement | | |For the Month Ended September 30 | | | | | | | |Sales (60 pianos × \$3,300 per piano) | |\$198,000 | | |Cost of goods sold | |   89,520 | | |(60 pianos × \$1,492 per piano) | | | | |Gross margin | |108,480 | | |Selling and administrative expenses: | | | | |Selling expenses: | | | | |Advertising ...

Words: 2262 - Pages: 10

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 ﬁnance, by Steven Shreve. If you have any comments or ﬁnd 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

#### 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

#### 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