solution1
4 Pages

solution1

Course Number: CMPT 361, Spring 2012

College/University: Simon Fraser

Word Count: 1268

Rating:

Document Preview

Database Systems Instructor: Hao-Hua Chu Fall Semester, 2007 Homework 1: ER Diagram Questions 1. (Textbook Q2.6) Computer Sciences Department frequent flies have been complaining to Dane County Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design...

Unformatted Document Excerpt
Coursehero >> Canada >> Simon Fraser >> CMPT 361

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Database Systems Instructor: Hao-Hua Chu Fall Semester, 2007 Homework 1: ER Diagram Questions 1. (Textbook Q2.6) Computer Sciences Department frequent flies have been complaining to Dane County Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows: Every airplane has a registration number, and each airplane is of a specific model. The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity and a weight. A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician.

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Simon Fraser - CMPT - 361
CMPSCI 645 - Homework 1Due February 10, before classExercise 1 [24 points]: ER ModelingComputer Sciences Department frequent fliers have been complaining to Amherst Airport officials about thepoor organization at the airport. As a result, the official
Simon Fraser - CMPT - 361
Cmpt 371Assignment #3 SolutionsJune 16, 2012From the problems at the end of Chapter 2 in the text:1. [P24] This question asks you to specify distribution schemes that will work in a P2P architecture. The challenge here is to see how we can use the ban
Simon Fraser - CMPT - 361
1Assignment 1 (Solution)CMPT 354 (Summer 2012)Due Date: 2:00 pm June 8, 2012 (in 354 assignment box inside CSIL)Total Marks: 70 (This assignment accounts for 25% of total assignment grade)Question 1 (35 Marks)You are to design a database system for
Simon Fraser - CMPT - 361
Assignment 2CMPT 354 (Summer 2012)Due Date: June 15, 2012 (to the submission server before 2:00 pm)Total Marks: 60. (This assignment accounts for 20% of all assignments)Question 1(40 Marks)Write SQL queries for the questions below, against the sample
Simon Fraser - CMPT - 361
Introduction to Computer GraphicsRichard (Hao) ZhangCMPT 361 Introduction to Computer GraphicsLecture 1How is it related to graphics?RatatouilleLife of PiSharp Aquos LCD TVA triangleWii and computer gamesFourier transformOpenGL programmingMicr
Simon Fraser - CMPT - 361
Programming using OpenGL3.1: A First IntroductionRichard (Hao) Zhang(first 60 slides adopted from Torsten Mller)Introduction to Computer GraphicsCMPT 361 Lecture 3May 17, 20121TodayOpenGL API overview and modern architectureOpenGLOpenGL librari
Simon Fraser - CMPT - 361
Cmpt-300, Summer 2012, Assignment 1Due date May 25 2012.Petra BerenbrinkQuestion 1 Which of the following instructions should only be allowed in kernel mode?1. Disable all interrupts.2. Read the time-of-the-day clock.3. Change the memory map.Questi
Simon Fraser - CMPT - 361
Cmpt 371Assignment #1May 14, 2012Due Wednesday May 23rd by 16:00 in the black course assignment box located in the CSIL.Be sure you place your solution in the box assigned to Cmpt 371.From the problems at the end of Chapter 1 in the text:1. P62.(a
Simon Fraser - CMPT - 371
Cmpt 371Midterm ExamJune 20, 2012This midterm contains 4 questions totalling 48 points. The weight assigned to each questionis meant to reect the total time required to think up the answer and write it down. Weight isnot necessarily proportional to t
Waterloo - BIOL - 130
The cell cycle is a universal sequence of events that all cells go through in order to divideinto its daughter cells. It allows for the growth, reproduction, and repairing of cells (Karp, 2010).The cell cycle is categorized into 4 main phases. Being a v
Waterloo - BIOL - 130
Biol 130 - Tutorial 7 Respiration Concept Map ExerciseGoal - Create a concept map to illustrate the relationship between the mitochondria andthe processes related to cellular respiration (energy production).We have already done some of the steps of cre
Waterloo - BIOL - 130
Biol 130 - Tutorial 8 Receptor-Mediated Endocytosis Concept Map ExerciseGoal - Create a concept map to illustrate the process of receptor-mediated endocytosis.When you have finished it should answer the question How does receptor-mediatedendocytosis re
Waterloo - BIOL - 130
Create a concept map to organize the four groups of macromolecules into theircomposite parts and relate each group to a molecule that is important in this course.MacromoleculesPROTEINCARBOHYDRATESLIPIDSNUCLEIC ACIDS
Waterloo - BIOL - 130
Biol 130 - Tutorial 9 Genetic Information Concept Map ExerciseGoal - Create a concept map to illustrate the flow of information from DNA to aminoacids and then the structural protein fibronectin in liver cells and fibroblasts ineukaryotes. Join this in
Waterloo - BIOL - 130
Biol 130 - Tutorial 6 Glycolysis Concept Map ExerciseGoal - Create a concept map to compare and contrast the metabolic processes involved inglycolysis and gluconeogenesis.We have already done some of the steps of creating a concept map for you. We have
Waterloo - BIOL - 110
Biol 110Introductory ZoologyLectures:Tues. and Thurs.Sec. 01: 8:30 DC 1350Sec. 02: 12:30 RCH 112Instructor:Ted Ozerskytozersky@gmail.comB2 257Bx33227Lab co-ordinator: Bruce Wolffbrwolff@uwaterloo.caB1 381x6435Lecture slides with help from D
Waterloo - BIOL - 110
Triploblastic Prostomia and DeuterostromiaDeu echinoderms, chordates,Differences between prostomia and deutrEmbryonic develop. Balstopore becaome mouth -proWhile blastopore forms anus - deucoleomschizogony - proenteroceoly deuBody PlanDerived for
Waterloo - BIOL - 110
Characteristics of phyum arthropodaJointed appendages mover efficient mvmtSegmentation I ArthropodaAnalogous trait similar structures that evolved independentlyAncestors of annelids and arthropods were both unsegmentedTagmatisationArthropod cuticle
Waterloo - BIOL - 110
CHIEF TAXONOMIC SUBDIVISIONS and ORGAN SYSTEMS of the Animal PhylaPhylum ClassesMammalia Aves Reptilia AmphibiaEndomesodermal pouches give rise to coelom Primitive gut Blastocoel (later obliterated) Blastopore Radial CleavageSkin and ExoskeletonStrat
Waterloo - BIOL - 110
B110 Intro ZoologySection 1 8:30 DC 1350Section 2 12:30 RCH 112Tec Ozersky B2 257B x33227Bruce Wolff B1 381Bio 110 Lab manual, dissecting kit, lab coat, goggles, paper for diagrams, whmis thingWhat is Zoology?Study of animal biology; physiology, ec
Waterloo - BIOL - 110
BIOL110: Introductory ZoologyFall 2010Instructor: Ted OzerskyEmail: tozersky@gmail.comOffice: B2 257BOffice hours: Tuesdays and Thursdays 11:00- 12:00Lab instructor: Bruce WolffEmail: brwolff@uwaterloo.caOffice: B1 381Lecture: Tuesday and Thursda
Waterloo - BIOL - 140
CrenarchaeotaHabitats of CrenarchaeotaDiversity-Sulfolobales-IgnicoccusSulfolobus-Electron acceptor is oxygen (b/c its aerobic)-h2so4 creates acidic environment-can use organic carbon too-versatile depends on whats availableAcidic Sulfolobus hab
Waterloo - BIOL - 140
PersonHistory of MicrobiologySignificanceExperiment/ObservationHooke (1635-1703)Saw moldsFirstmicroorganismwitnessedvan Leeuewenhook(1632-1723)Saw bacteriaSaw bacteriaCohn (1828-1898)Studied bacteria extensivelyFoundedbacteriologyPasteur (
Waterloo - BIOL - 140
Biology 140 Lecture Topics, Video Schedule, F10 This listing includes an outline of Topics covered in the F10 version of course, and lists relevant sections in Madigan et al. 12th ed. The introductory paragraphs pr
Waterloo - BIOL - 140
Fundamentals of Microbiology (Biology 140) Syllabus, Fall 2010 Dr. Josh D. Neufeld Office hours: M, 35pm B1275, ext. 38344 email: jneufeld@uwaterloo.caCourse overview This course will introduce you to the biology
Waterloo - CHEM - 120
Free radicalsAnd capable of independent existence.Short livedHighly reactive and damaging to cellsReactive oxygen species (ROS)Might be a cause of aging because of damage to cells from free radicalsVitamin a c minimize damage from free radicalsEnvi
Waterloo - CHEM - 120
Extra Problems for CHEM 120 (Solutions are available on the course home page.)B1. After dissolving 2.21 g of a mixture of Na2SO4 and NaCl in water, you add an excess of BaCl2 solution. You thenfilter offthe BaSO4 which forms, dry it, and find that it w
Waterloo - CHEM - 120
Question 1: (1 point)A 428-g chunk of iron is removed from an oven and plunged into 414 grams of water in aninsulated container. The temperature of the water increases from 26.0oC to 87.0oC. If the specificheat of iron is 0.449 J g-1 oC-1, what must ha
Waterloo - CHEM - 120
Question 9: Score 0.33/1Which of the following statements concerning the structures below is/are true?ChoiceSelectedThe formal charge on the central I atom is zero instructure B.Yes[answerwithheld]The formal charge is -1 for the I atom on the rig
Waterloo - CHEM - 120
Ex. 1: Given the following reactions and reaction efficiencies, what mass of Fe3Br8 isproduced from 10.0g of Fe and excess Br2?Fe + Br2FeBr2 (efficiency: 92.5%)3FeBr2 + Br2Fe3Br8 (efficiency: 82.0%) Ex 2: What mass of Ag2CrO4 will precipitate if 17
Waterloo - CHEM - 120
Question 1: (1 point)The amino acid methionine, which is essential in human diets, has the molecular formula C 5H11NO2S. Determine the number ofgrams of O in 0.223 grams of methionine.Use atomic masses accurate to at least four significant figures!Ent
Waterloo - CHEM - 120
CHEM120 Outline 2Chapter 7: ThermochemistryIntroduction to Energy Systems-types of systems: open, closed, isolated-define system vs. surroundings-types of energy: kinetic, potential, thermalHeats of Reaction-exothermic (q < 0), endothermic (q > 0)
Waterloo - CHEM - 120
Question 1: (1 point)What is the wavelength, in nanometers, of light with an energy content of 1.97E-8 kJ/mol?Enter your answer with three significant figures.Enter scientific notation as 1.23E4.Enter only numbers in your answer. (Do not include units
Waterloo - CHEM - 120
Question 1: Score 0/1What is the wavelength, in nanometers, of light with an energy content of1.97E-8 kJ/mol?Enter your answer with three significant figures.Enter scientific notation as 1.23E4.Enter only numbers in your answer. (Do not include units
Waterloo - CHEM - 120
Question 1: (1 point)In this experiment, the variable "V" in theIdeal Gas Law, PV = nRT, represents:the volume of volatile liquid that remains in the flask after hethe volume of water in the water baththe total volume of the flask interior125 mL, th
Waterloo - CHEM - 120
Question 1: (1 point)What is the pressure (in mmHg) of the gas inside the apparatus below if the atmospheric pressureis Patm=751 mmHg, h1=49 mmHg, and h2=77 mmHg?Enter your answer in mmHg, with 3 significant figures. Do not include units as part of you
Waterloo - CHEM - 120
Question 1: (1 point)Indicate the smallest and the largest species (atom or ion) in the following group:(a)Smallest(a)(b)(c)(d)(e)(f)(a)(b)(c)(d)(e)(f)(b)Sn atomSe atomAs atomSr2+ ionSe2 ionO atomSn atomSe atomAs atomSr2+ ionSe2
Waterloo - CHEM - 120
EXTRA PROBLEMS FOR CHEM 120 (PROBLEMS B1-B10)B1.After dissolving a 2.21-g sample of a mixture of Na2SO4 and NaCl in water, you add anexcess of BaCl2 solution. You then filter off the BaSO4 that forms, dry it, and find it weighs2.57 g. What is the perc
Waterloo - CHEM - 120
EXTRA PROBLEMS FOR CHEM 120 (PROBLEMS B17-B20)B17.a)b)c)Consider the allene molecule, H2C=C=CH2. Draw the Lewis structure and answer thequestions below.Classify each bond as or and identify the orbitals involved.What is the H-C-C bond angle? What
Waterloo - CHEM - 120
EXTRA PROBLEMS FOR CHEM 120 (PROBLEMS B11-B16)B11.Examine the plots of 2 versus r shown in the upper portion of Fig. 9-23 of Petrucci (8thedition). Focus on the right hand portion of each plot (i.e .the region with r > 0.) The figuresare reproduced he
Waterloo - CHEM - 120
CHEM 120 Tutorial Week 71. Announcement: On-line Assignments on MapleTA areAVAILABLE again .The recommended due date for Assignment #3 has beenextended to Monday, October 25th at 4:30 pm2. Today: Overview of Chapter 7 (Thermochemistry) includingsamp
Waterloo - CHEM - 120
CHEM 120 Tutorial Week 9Announcements1. Assignment #4 is due Nov. 222. Assignment #5 is due Nov. 26 (do it now!)3. Your test is TOMORROW! Check UW-ACE formore info.4. Tutoring in residence:Tuesday Nov. 9 - REV Great HallWednesday/Thursday Nov.10/1
Waterloo - BIOL - 140L
Suggestions for Report #1General:See Appendix of lab manual for specific directions on How to Write a Lab ReportThis will be a lab report that will include Experiments 4, 5 and 6. These threeexperiments all pertain to various staining techniques that
Midlands Tech - MGT - 3500
By Tuesday, February 14, 2012 submit your autobiography to this Discussion Area. Includethe following information in your autobiography: Name Age Location Profession How will this course help your professional aspirations? What is your level of fam
Midlands Tech - MGT - 3500
Compare the determination of the future value and the present value.Present Value describes the process of determining what a cash flow to be received in the futureis worth in today's dollars. Its the current worth of a future sum of money or stream of
Midlands Tech - MGT - 3500
Total:641. Future Value. What is the future value ofAnswersa. $572 invested for 5 years at 15 percent compounded annually?1,150.50b. $449 invested for 15 years at 14 percent compounded annually?3,204.93c. $270 invested for 7 years at 6 percent com
Midlands Tech - MGT - 3500
1. Stock. What is the value of a stock with aa. $1.25 dividend just paid and a 9 % required return with 0 % growth?Value = 1.25/9% = $13.89b. $4.25 dividend just paid and a 6 % required return with 1 % growth?Value = (4.25*1.01)/(.06-.01)= $85.85c. $
Midlands Tech - MGT - 3500
The cost of debt is lower than the cost of equity as debt provides tax shield on interest payment.So, adding debt to capital structure lowers the cost of capital. A leveraged firm will have lowercost of capital than a non-levered firm.However, high deb
Midlands Tech - MGT - 3500
1)Face ValueCoupon RateCoupon PaymentCurrent PriceFlotation CostsNet ProceedsMarginal Tax Rate$1,0008%$80$1,1005%$1,04539%Settlement DateMaturity DateCoupon RateBond Price (% of par)Redemption Value (% of par)Number of PaymentsYield t
Midlands Tech - MGT - 3500
Capital is the source of fianc through which resources are provided. It may be debtfinancing or equity financing. The cost of debt financing is interest which is the beforetax cost of capital, while after tax cost of capital is r (1-t). At present the c
Midlands Tech - MGT - 3500
Project A01234Cash flows D.f = .05 PVD.f = .1-10001-10001200 0.952381 190.4762 0.909091300 0.907029 272.1088 0.826446400 0.863838 345.535 0.751315500 0.822702 411.3512 0.683013NPV219.4713 NPVIRR-1000178.5714239.1582284.7121317.7592
Midlands Tech - MGT - 3500
Capital budgeting is very critical for every company. One good decision may change the fate ofthe company and one bad decision may destroy the company. The scope of capital budgetingmay be construction of new factory, installation of new machines, resea
Midlands Tech - MGT - 3500
1. Degree of OperatingLeverage= Contribution / Net Operating Income= 14000000 / 4000000= 3.52. Degree of Financial Leverage = Net Operating Income / Earning Before Tax= 4000000 / 3880000= 1.033. Degree of Combined= Contribution / Earning Before T
Midlands Tech - MGT - 3500
ANALYSIS OF CAPITAL STRUCTURE1. Determine the EBIT indifference pointThe EBIT indifference point is the point where a company would neither favor the choice between no debt andsome debt structuring choices.Under this point EPS (earnings per share) wou
Midlands Tech - MGT - 3500
Cash conversion cylce toyota motorsFor 2010 the recent yearInventory turnover period(inventory/cost of sales)*365Accounts receivable turnover period(Accounts receivable/sales)*365132.58Accounts payable turnover period(Accounts payables/cost of sal
Midlands Tech - MGT - 3500
1. Prepare a cash budget for Redbird covering the first seven months of 2010.NOTE: Double click the table to see the formulas used.2. They have $100,000 in notes payable due in July that must be repaid, or an extension renegotiated. Will theybe able to
Midlands Tech - MGT - 3500
Estimate Oranges total financing requirements for 2010 and its net fundingrequirements.Total Financing Requirement= Change in Asset due to Increase Sales - Change in Liabilities= Change in Current Asset+ Change in Fixed Asset - Change in Accounts Paya
Midlands Tech - MGT - 3500
PEER REVIEWREVIEWER Larry WeyerWRITER Darlene Drakeford(Please note your responses in a different color)Does the writer demonstrate an understanding of the Feminist Critical perspective?Please excerpt a portion of the students essay that illustrates
Midlands Tech - MGT - 3500
PEER REVIEW FOR WEEK TWOREVIEWER Larry WeyerWRITER Valerie Ellis(Please note your responses in a different color) Does the writer demonstrate an understanding of the Feminist Critical perspective?Please excerpt a portion of the students essay that il
Midlands Tech - MGT - 3500
Week Three Peer-Review WorksheetWriter_ Alexis Mills_Reviewer_Larry Weyer_Remember to use a different colored font when responding to these questions.Does the writer use a psychoanalytical perspective when evaluating the drama? If so,please discuss t
Midlands Tech - MGT - 3500
Week Three Peer-Review WorksheetWriter_Valerie Ellis_Reviewer_Larry Weyer_Remember to use a different colored font when responding to these questions.Does the writer use a psychoanalytical perspective when evaluating the drama? If so,please discuss t