Archives: Solution Manual

Solutions Manual Chapter 15 Section 15.2 Exercise 15.2.1 (a) The pseudocode for the iterator for projection πA1,A2,..,An(R) is as follows: Open ( ) { R . Open ( ) ; } GetNext ( ) 2 { xTuple ←R . GetNe […]

The open-circuit voltage is given by       L s L soctRRR R tvtvtv   In terms of phasors, this becomes: L s L st RRR R  VV (1) Zeroing the source, we find […]

— (d) i = 3, n = 8, r = 16 — 1000 000 0000 — 1001 001 0001 — 1010 010 0010 — 1011 011 0011 — 1100 100 0100 — 1101 101 0101 — 1110 110 0110 — […]

Solutions Manual Chapter 14 Section 14.1 Exercise 14.1.1 (a) For dense index we need a key-pointer pair for each record, and so will need n 10 blocks. For the data, we will need n 3blocks, and so the total number […]

CHAPTER 6 Exercises E6.1 (a) The frequency of )20002cos(2)( in ttv   is 2000 Hz. For this frequency .602)(   fH Thus,  60402602)( in out  VV fH and we have ).6020002cos(4)( out   ttv  […]

     120cos200  ttvcn                 90cos3200 30cos3200 150cos3200    ttv ttv ttv bc ab    ca P5.90 […]

Solutions Manual Chapter 13 Section 13.1 Exercise 13.1.1 For this exercise we treat the sizes as if they were powers of 10 (i.e. petabyte is 1015). Results would be slightly different if powers of 2 were used (i.e. petabyte is […]

2500 959 649 3673 239 100 200 <Printer model=”3006″ price=”100″>…</Printer> <Printer model=”3007″ price=”200″>…</Printer> A E 1001 1002 A E Section1 Exercise 12.1.1 a) //PC/RAM <RAM>1024</RAM> b) //@price 2114 995 1150 c) //Printer <Printer model=”3002″ price=”239″>…</Printer> d) /Products/Maker[Printer/Type = “laser”]/@name E […]

P5.45* The peak value of   tiL is five times larger than the source current! This is possible because current in the capacitance balances the current in the inductance (i.e., 0 C L II ).   mA 9050 […]

Section 1 Exercise 11.1.1 a) b) c) Exercise 11.1.2 Exercise 11.1.3 <Name>Carrie Fisher</Name> <Address> <Street>123 Maple St.</Street> <City>Hollywood</City> </Address> <Address> <Street>5 Locust Ln.</Stree> <City>Malibu</City> </Address> </Star> <Star starID = “mh” starredIn = “sw”> <Name>Mark Hamill</Name> <Address> Exercise 11.1.4 Exercise 11.1.5 […]

1 CHAPTER 5 Exercises E5.1 (a) We are given )30200cos(150)(   ttv  . The angular frequency is the coefficient of t so we have radian/s 200   . Then Hz 1002/  f ms 10/1  fT […]

Exercise 10.3.5 Section 10.4 Exercise 10.4.1 Movies( title TitleType, year YearType, length DurationType, genre GenreType, studioName BusinessNameType, producerC# CertificateType ) MovieStar( name PersonNameType, address AddressType, gender GenderType, birthdate DateType ) StarsIn( movieTitle TitleType, movieYear YearType, starName PersonNameType ) MovieExec( name […]

Since we have 0 ωα  , this is the under-damped case. The natural frequency is given by Equation 4.76 in the text: 322 010660.8  αωω n The complementary solution is given in Equation 4.77 in the text:  […]

Solutions Manual Chapter 10 Section 10.1 Exercise 10.1.1 (a) SELECT on MovieStar, SELECT on MovieExec. (b) SELECT on MovieExec, SELECT on Movies, SELECT on StarsIn. (e) UPDATE on MovieExec (or UPDATE(name) on MovieExec). (f) REFERENCES on MovieStar (or REFERNCES(gender, name) […]

Thus, 1 2 K and the current (in amperes) is given by     0 for 20exp1 0 for 0   tt tti P4.34 The general form of the solution is     LtRKKtiL  […]

else { printf(“pc model: %s\n”, pc_model); } /* get Printer within the budget */ rest_budget = total_budget – pc_price; color = “true”; if (!rs.next()) { color = “false”; execStat.setInt(1, rest_budget); execStat.setString(2, color); ResultSet rs = execStat.executeQuery(); print_model = rs.getString(1); print_price […]

CHAPTER 4 Exercises E4.1 The voltage across the circuit is given by Equation 4.8: )/exp()( RCtVtv i C  in which Vi is the initial voltage. At the time t 1% for which the voltage reaches 1% of the initial […]

SQLBindCol(execStat, 1, SQL_CHAR, model, sizeof(model), &colInfo); SQLBindCol(execStat, 2, SQL_FLOAT, speed, sizeof(speed), &colInfo); while(SQLFetch(execStat) != SQL_NO_DATA) { if( FOUND ) /* print fetched info */ } /* get Printers made by the manufacturer */ SQLPrepare(execStat, “SELECT * FROM Printer WHERE model […]

P3.46        1 0 10 1 t LLL idttv L ti A 20010)6( 6 0 3 1  dtiL       W 200666  LL ivp J 600)6()6( 2 2 […]

9.3.1 a) In the following, we use macro NOT_FOUND as defined in the section. void closestMatchPC() { EXEC SQL BEGIN DECLARE SECTION; char manf, SQLSTATE[6]; int targetPrice, /* holds price given by user */ /* ask user for target price […]

CHAPTER 3 Exercises E3.1 V )10sin(5.0)102/()10sin(10/)()( 5656 ttCtqtv   A )10cos(1.0)10cos()105.0)(102()( 5556 tt dt dv Cti   E3.2 Because the capacitor voltage is zero at t = 0, the charge on the capacitor is zero at t = […]

b) SELECT RichExec.name from RichExec, StudioPres where RichExec.name = StudioPres.name; c) SELECT ExecutiveStar.name from ExecutiveStar, StudioPres WHERE ExecutiveStar.netWorth >= 50000000 AND StudioPres.cert# = RichExec.cert#; CREATE VIEW StudioPres (name, address, cert#) AS SELECT MovieExec.name, MovieExec.address, MovieExec.cert# FROM MovieExec WHERE MovieExec.cert# IN […]

%50%100  s L P P η On the other hand, for t LRR 9 , we have       %90%100 9 9.0 10 2 22      s L t t L […]

length INT, genre CHAR(10), studioName CHAR(30), producerC# INT REFERENCES MovieExec(cert#) ON DELETE SET NULL ON UPDATE SET NULL, PRIMARY KEY (title, year) ); length INT, genre CHAR(10), studioName CHAR(30), producerC# INT REFERENCES MovieExec(cert#) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY […]

102040 21  ii 04020 21  ii Solving, we find 3333.0 1 i and 1667.0 2 i . Thus,   V 333.320 21  iiv . P2.72 The mesh currents and corresponding equations are: mA 30 A i […]

b) SELECT DISTINCT C.class FROM Classes C, Ships S , c) SELECT S.name FROM Ships S, Classes C WHERE C.class = S.class AND C.bore =16 ; d) SELECT O.battle FROM Outcomes O, Ships S WHERE S.Class =’Kongo’ AND S.name = […]

P2.18 (a) For a series combination 321 /1/1/1 GGG  (b) For a parallel combination of conductances 321 GGGGeq  1 Geq  P2.19 To supply the loads in such a way that turning one load on or off does […]

b) SELECT DISTINCT C.class FROM Classes C, Ships S WHERE C.class = S.class AND EXISTS c) SELECT S.name FROM Ships S WHERE S.class IN (SELECT class FROM Classes C WHERE bore=16 ) ; SELECT S.name FROM Ships S WHERE EXISTS […]

CHAPTER 2 Exercises E2.1 (a) R 2 , R 3 , and R 4 are in parallel. Furthermore R 1 is in series with the combination of the other resistors. Thus we have:    3 /1/1/1 1 432 […]

Solutions Chapter 6 6.1.1 Attributes must be separated by commas. Thus here B is an alias of A. 6.1.2 a) SELECT address AS Studio_Address FROM Studio WHERE NAME = ‘MGM’; c) SELECT starName FROM StarsIn WHERE movieYear = 1980 OR […]

(b) If the diameter of the wire is doubled, the cross sectional area A is increased by a factor of four. Thus, the resistance is decreased by a factor of four to 2.5 .  P1.56 The resistance is proportional […]

Exercise 5.1.1 As a set: speed 2.66 2.10 1.42 As a bag: speed 2.66 2.10 1.42 2.80 3.20 3.20 2.20 2.20 2.00 2.80 1.86 2.80 3.06 Average = 2.48 Exercise 5.1.2 As a set: 2.80 3.20 2.20 2.00 1.86 3.06 […]

CHAPTER 1 Exercises E1.1 Charge = Current  Time = (2 A)  (10 s) = 20 C E1.2 A )2cos(200 )200cos(2000.01 0t)0.01sin(20( )( )( tt dt d dt tdq ti  E1.3 Because i 2 has a positive value, […]

4.7.6 4.7.7 4.7.8 We convert the ternary relationship Contracts into three binary relationships between a new entity set Contracts and existing entity sets. 4.7.9 a) b) c) 4.7.10 A self-association ParentOf for entity set people has multiplicity 0..2 at parent […]

4.4.3 a) b) c) 4.4.4 a) b) 4.5.1 Customers(SSNo,name,addr,phone) Flights(number,day,aircraft) Bookings(custSSNo,flightNo,flightDay,row,seat) Relations for toCust and toFlt relationships are not required since the weak entity set Bookings already contains the keys of Customers and Flights. 4.5.2 (a) (b) Schema is changed. […]

Solutions Chapter 4 4.1.1 4.1.2 a) b) c) In c we assume that a phone and address can only belong to a single customer (1– m relationship represented by arrow into customer). d) In d we assume that an address […]

We also found out that the keys are AB, AC and AD. FDs where the left side is not a superkey or the attributes on the right are not part of some key are 3NF violations. The 3NF violations are […]

Exercise 3.1.1 Answers for this exercise may vary because of different interpretations. Some possible FDs: Social Security number → name Exercise 3.1.2 Answers for this exercise may vary because of different interpretations Some possible FDs: ID → x-position, y-position, z-position […]

(maker4 = maker AND (model4=model OR model4=model2 OR model4=model3)) πmaker Exercise 2.4.3a R1 := σbore ≥ 16 (Classes) R2 := πclass,country (R1) class country Iowa USA North Carolina USA Yamato Japan Exercise 2.4.3b Product PC πmaker,model ρR2(maker2,model2) ρR3(maker3,model3) ρR4(maker4,model4) (maker […]

Exercise 2.2.1a For relation Accounts, the attributes are: Exercise 2.2.1b For relation Accounts, the tuples are: (12345, savings, 12000), (23456, checking, 1000), (34567, savings, 25) For relation Customers, the tuples are: (Robbie, Banks, 901-222, 12345), (Lena, Hand, 805-333, 12345), (Lena, […]

Chapter 31 Financial Management in Not-for–Profit Businesses ANSWERS TO END-OF-CHAPTER QUESTIONS 31-1 The major difference in ownership structure is that investor–owned firms have well- defined owners, who own stock in the business and exercise control over the firm through 31-2 […]

Chapter 30 Pension Plan Management ANSWERS TO END-OF-CHAPTER QUESTIONS 30-1 a. Under a defined benefit plan, the employer agrees to give retirees a specifically defined benefits package. The payments could be set in final form as of the retirement date, […]

1/15/2015 1. Defined benefit plan 2. Defined contribution plan 1. Under a defined benefit plan, the employer agrees to give retirees a specific defined benefit, such as $500 per month, 80 percent of his or her average salary over the […]

SOLUTION TO SPREADSHEET PROBLEM 29-23 The detailed solution for the spreadsheet problem is available in the file Solution for IFM10 Ch 29 P23 Build a Model.xls on the textbook’s web site.. Answers and Solutions: 29 – 20 © 2016 Cengage […]

Chapter 29 Basic Financial Tools: A Review ANSWERS TO END–OF–CHAPTER QUESTIONS 29-1 a. PV (present value) is the value today of a future payment, or stream of payments, discounted at the appropriate rate of interest. PV is also the beginning […]

1/15/2015 FUTURE VALUE $100 lump sum at the end of year 2. I% = 10% Ordinary annuity of $100 per year for three years. I% = 10% Time period 0 1 2 3 Cash Flow 0 100 100 100 FV […]

h. 4. What is the effective annual rate (EAR or EFF%)? What is the EFF% for a nominal rate of 12%, compounded semiannually? Compounded quarterly? Compounded monthly? Compounded daily? Answer: The effective annual rate is the annual rate that causes […]

28-34 Information given: The nominal time line is shown below, with a different payment each period and a FV of a nominal $1 millon: This is a growing annuity, with a nominal rate of 8% and an inflation rate of […]

Chapter 28 Time Value of Money ANSWERS TO END-OF-CHAPTER QUESTIONS 28-1 a. PV (present value) is the value today of a future payment, or stream of payments, discounted at the appropriate rate of interest. PV is also the beginning amount […]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 38 39 40 41 42 43 44 45 46 Time period 0 1 2 3 FV at year end 100 110.00 121 133.10 Note: […]