# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

1 Page

### Tutorial 4

Course: FACULTY OF WXGE6320, Winter 2009
School: University of Malaya
Rating:

Word Count: 240

#### Document Preview

Algebra 1.Consider Relational the following AIRLINE database schema that describes the database for airline flight information: AIRPORT (Airport-code, Name, City) FLIGHT (Number, Airline, Weekdays) FLIGHT_LEG (Flight-number, Leg-number, Departure-airport-code Scheduled-departure-time, Arrival-airport-code, Scheduled-arrival-time) LEG_INSTANCE (Flight-number, Leg-number, Date, Number-of-available-seats,...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Other International >> University of Malaya >> FACULTY OF WXGE6320

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.
Algebra 1.Consider Relational the following AIRLINE database schema that describes the database for airline flight information: AIRPORT (Airport-code, Name, City) FLIGHT (Number, Airline, Weekdays) FLIGHT_LEG (Flight-number, Leg-number, Departure-airport-code Scheduled-departure-time, Arrival-airport-code, Scheduled-arrival-time) LEG_INSTANCE (Flight-number, Leg-number, Date, Number-of-available-seats, Airplane-id) Assume the following set of requirements: An AIRPORT is identified by an Airport-code. Each FLIGHT is identified by a Flight-number and consists of one or more FLIGHT_LEGs with leg-number being 1, 2, 3, etc. Weekdays (e.g. Monday, Tuesdays, etc.) are also recorded with each FLIGHT. Each leg has scheduled arrival and departure times and airports. It has also many LEG_INSTANCEs - one each for Date on which the flight travels. For each LEG instance, the airplane used in the leg, the number of available seats and the actual arrival and departure times and airports and kept. Write the following queries in relational algebra: (i) (ii) (iii) Retrieve the number of available seats and the leg number for flight number 'NY197' on '01-Mar-93'. For each flight, list the flight number, the departure airport for the first leg of the flight and the arrival airport for the last leg of the flight. List the flight numbers and weekdays of all flights or flight legs that depart from New York International Airport (airport code 'IANY') and arrive in London International Airport (airport code 'IALD'). List the flight number and weekdays of all flights or flight legs that depart from some (iv)
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:

University of Malaya - FACULTY OF - WXGE6320
Exercise II1.Consider the following AIRLINE database schema that describes the database for airline flight information: AIRPORT (Airport-code, Name, City) FLIGHT (Number, Airline, Weekdays) FLIGHT_LEG (Flight-number, Leg-number, Departure-airport-code Sc
University of Malaya - FACULTY OF - WXGE6320
Information VisualizationPart One1Introduction Thereare some aspects that may be understood better from graphics than from the textual format, such as the possibility for finding an alternative route, or the existence of historical places in the vici
University of Malaya - FACULTY OF - WXGE6320
Virtual Reality Markup Language (2) Understanding Shape AppearanceRecall that Shape nodes describe: Appearance nodes describe: Shape cfw_ geometry . . . appearance . . . geometry form, or structure appearance color and texture Shape cfw_ ap
University of Malaya - FACULTY OF - WXGE6320
VRML Script Node and JAVAWhy would you want to use Java with your VRML? Java class has more flexibility to define complex behaviors Java has its simple networking classes create multi-user VRML worlds, visualizations of the Internet or visualizations o
University of Malaya - FACULTY OF - WXGE6320
Virtual Reality Markup LanguageAn Introduction to VRML &amp; Modeling Shapes, Geometry, Colour Introduction The Virtual Reality Modeling Language A file format for describing interactive threedimensional objects and worlds (a model of a 3D space, which
University of Malaya - FACULTY OF - WXGE6320
WXGE6320: Web Application Tutorial 31. Develop a JavaScript program that will determine whether a department-store customer has exceeded the credit limit on a charge account. For each customer, the following facts are available: a. b. c. d. e. Account nu
University of Malaya - FACULTY OF - WXGE6320
WXGE6320: Web Application Tutorial 5Write a complete JavaScript program to request user for the radius of a sphere, and call function sphereVolume to calculate and display the volume of the sphere. Use the statement volume = (4.0 / 3.0) * Math.PI * Math.
University of Malaya - FACULTY OF - WXGE6320
WXGE6320: WEB DEVELOPMENT Tutorial 4 Answer All Questions 1. Draw a flowchart for selection statement below. Document.writeln( studentGrade &gt;= 70 ? &quot;Passed&quot; : &quot;Failed&quot;); 2. Write a JavaScript function to validate the username and password entered by a use
University of Malaya - FACULTY OF - WXGE6320
Tutorial 02 Carrier Sense Multiple Access (CSMA)1IntroductionIn the IEEE 802 protocols for shared multi-access LANs, the data link layer is divided into two sub layers, as shown next. The upper LLC (Logical Link Control) layer provides a way to address
University of Malaya - FACULTY OF - WXGE6320
Writing PapersStudents too often put off a written assignment, considering it a chore too formidable to approach until the last minute. As a result, grades inevitably suffer. Writing is not a talent reserved for a select few, it is a skill that can be le
University of Malaya - FACULTY OF - WXGE6320
Group Assignment 1 : Bellman-Ford's Algorithm and Applications to the Network Routing Theory Chapter 1 : Introduction a) Introduction to Algorithm : An algorithm is a type of effective method in which a systematic list of a known set of instructions for c
University of Malaya - FACULTY OF - WXGE6320
Chapter 4 - Introduction to XHTML: Part 1Outline 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 4.10 4.11 Introduction Editing XHTML First XHTML Example W3C XHTML Validation Service Headers Linking Images Special Characters and More Line Breaks Unordered Lists Nest
University of Malaya - FACULTY OF - WXGE6320
Chapter 5 - Introduction to XHTML: Part 2Outline5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 5.10 5.11 Introduction Basic XHTML Tables Intermediate XHTML Tables and Formatting Basic XHTML Forms More Complex XHTML Forms Internal Linking Creating and Using Image M
Harvard - ECON1723 - 312
1. Which of the following illustrates the concept of external cost? a. Margaret purchases all her food and clothing in the big city outside her residence. b. A small business owner frequently buys raw materials by using her bank's line of credit. *c. Raym
Harvard - ECON1723 - 312
1. Which of the following illustrates the concept of external cost? a) Margaret purchases all her food and clothing in the big city outside her residence. b) A small business owner frequently buys raw materials by using her bank's line of credit. c) Raymo
Harvard - ECON1723 - 312
ECON 102 Professor Jose J Vazquez Exam-3 FORM A2011Please choose the best answer. For all questions, only consider the change(s) implied by the question while holding &quot;all other things equal&quot;. PLEASE READ ALL QUSTIONS CAREFULLY; MANY OF THEM ARE NOT EXA
Ryerson - ECONMICS - 801
Time Value of Money and Economic EquivalenceChapter 3 Contemporary Engineering Economics Third Canadian Edition Copyright 2012 2012 Pearson Canada Inc., Toronto, Ontario1Chapter Opening Story: Take a Lump Sum or Annual Installments Millionaire Life i
Ryerson - ECONMICS - 801
Time Value of Money and Economic EquivalenceChapter 3 Contemporary Engineering Economics Third Canadian Edition Copyright 2012 2012 Pearson Canada Inc., Toronto, Ontario1Chapter Opening Story: Take a Lump Sum or Annual Installments Millionaire Life i
Ryerson - ECONMICS - 801
Debt Management Lecture No. 8 Chapter 4 Contemporary Engineering Economics Third Canadian Edition Copyright 2012 2012 Pearson Canada Inc., Toronto, Ontario1Lecture 10 ObjectivesHow are commercial loans and mortgages structured in terms of interest an
Ryerson - ECONMICS - 801
Simple Harmonic MotionPART I: POSITION AND VELOCITY IN SHMLots of things vibrate or oscillate. A vibrating tuning fork, a moving child's playground swing, and the loudspeaker in a radio are all examples of physical vibrations. There are also electrical
Ryerson - ECONMICS - 801
Ryerson - ECN - 801
Engineering Economic DecisionsChapter 1 Contemporary Engineering Economics Third Canadian Edition Copyright 2012 2012 Pearson Canada Inc., Toronto, Ontario1A Little Google History1995 Developed in dorm room of Larry Page and Sergey Brin, graduate s
Ryerson - PHYSICS - 125
ECN801, V. Bardis Sample Test 21. Suppose a bank charges a 16% semiannual rate, compounded quartely. (a) (3 marks) What is the nominal annual rate? What is the nominal quarterly rate?r_1 = 2 (16%) = 32% r_4 = (2/4) r_2 = 8% or r_4 = (1/4)r_1 = 8%(b) (3
Ryerson - PHYSICS - 125
Ry eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oM
Ryerson - PHYSICS - 125
(1)Giventhreeresistors Rr = 40 Q rated0.5 W Rz= 20 O rated1.5 W Rs= 10 O rated1.0W+(.(a) \Mat is the largestvoltageV, that can be safelyapplied the series combination these to of threeresistors ? (b) Whatis the largestcurrentIt that can be safelypasse
Ryerson - PHYSICS - 125
ECN 801: PRINCIPLES OF ENGINEERING ECONOMICSContact Instructor: Office Hours: Email: Lecture: Course Description The objective of this course is to introduce basic concepts and ideas of engineering economics and to apply them to economically evaluate var
Ryerson - PHYSICS - 125
Ryerson - PHYSICS - 125
Ryerson - PHYSICS - 125
MTH 140TestII - Winter 2008 question) If /(r) : r@ + | find /&quot;(2). 1. (2 pts.) (multiple-choice Selectthe correctanswer. Irswsr'A) -+B ) 3f'r*l= f tlx+4i?-4= e (4*+Lir/'c) -?D ) ?E ) *+ f a r x t= e A D f t x t D - e t 4 =- a ( f u * t ; \- - 4 .
Ryerson - PHYSICS - 125
MTH 140FinalExam W 0? 1. (10pts.) (u).llfil( Sor^tiD)4A )Find the followinglimits. If a limit doesnot exist,explainwhy:,. 9r2-1-&quot;-\$ 3r * It7/eo/o = /:'\*,nthk t '/e'r. Bx't-1 Bx+t) r+ 'Yt 3x+ L-ltftx-D= 3fZ)-L-2..a!&amp;22:t'flofi.tuaA 4ule(
Ryerson - PHYSICS - 125
Ryerson University Department of Mathematics MTH 140 Fall 2007 Test IILAST NAME: (Please print)FIRST NAME: (Please print)I.D. NUMBER:SIGNATURE:Date: November 2, 2007Duration: 1 hourVersion: 3BT824G-TR0952Prof. Ha: Prof. Kim: Prof. Tasic: Prof. Pas
Ryerson - PHYSICS - 125
A-PDF Image To PDF Demo. Purchase from www.A-PDF.com to remove the watermarkRyeHub.CoMRy eH ub .C oMRy eH ub .C oMRy eH ub .C oM
Ole Miss - ECON - 564
Copper is a soft and malleable compound that has a reddish-orange color. It is primary used as a conductor of heat and electricity, a building material, and a component of various metal alloys. Most copper is mined or extracted from large open pit mines i
South Carolina - ECON - 293
econ
South Carolina - ECON - 293
South Carolina - ECON - 293
INTRODUCTION TO MICROECONOMICSLecture 1Lecture OutlineChapte r 1: What Microeconomics Is About What is a Market?What Microeconomics Is AboutMic ro e c o no mic s :Branch of economics that deals with the behavior of individual economic units-consumer
South Carolina - ECON - 293
Supply and DemandChapter 2Lecture Outline Math R e vie w Chapte r 2: Supply and Demand Market Equilibrium ElasticitiesBasics of Supply and DemandMo de l o f S upply and De mand Economic Model designed to explain how prices are determined in certain
South Carolina - ECON - 293
Consumer BehaviorChapter 3Chapter OutlinePreferences Budget Constraints Consumer ChoiceConsumer Behaviortheory of consumer behavior Description of how consumers allocate incomes among different goods and services to maximize their well-being.Consume
South Carolina - ECON - 293
Individual and Market DemandChapter 4Chapter OutlineIndividual Demand Income and Substitution Effects Market Demand Consumer SurplusWillingness to Pay (WTP)A buyer's willing ne s s to pay for a good is the maximum amount the buyer will pay for that g
South Carolina - ECON - 293
Uncertainty and Consumer BehaviorChapter 5Chapter OutlineDescribing Risk Preferences Toward Risk Reducing RiskDescribing Riskpro bability Likelihood that a given outcome will occur.S ubje ctive probability is the perception that an outcome will occu
South Carolina - ECON - 293
Uncertainty and Consumer BehaviorChapter 5Chapter OutlineDescribing Risk Preferences Toward Risk Reducing RiskDifferent preferences toward risk risk averse Condition of preferring a certain income to a risky income with the same expected value. risk
South Carolina - ECON - 293
Uncertainty and Consumer BehaviorChapter 5Chapter OutlineDescribing Risk Preferences Toward Risk Reducing RiskDifferent preferences toward risk risk averse Condition of preferring a certain income to a risky income with the same expected value. risk
South Carolina - ECON - 293
ProductionChapter 1Chapter OutlineThe Technology of ProductionProduction with One Variable Input (Labor)Production with Two Variable InputsReturns to ScaleTheory of the firmDescribeshow a firm makes cost-minimizing productiondecisionshow the fi
South Carolina - ECON - 293
The Cost of ProductionChapter 7Cost in the Long Runus e r c o s t o f c apital Annual cost of owning and using a capital asset, equal to economic depreciation plus forgone interest.The user cost of capital is given by the sum of the economic depreciat
South Carolina - ECON - 293
The Cost of ProductionChapter 7AC TIVE LEAR NI NGOptimum input choiceDavy Metal Company has the following production function: Q =500L0.6K0.8, MPL =300L-0.4K0.8 MPK =400L0.6K-0.2 Employees earn \$15 per hour. Rental charge is \$50 per hour on capital. D
South Carolina - ECON - 293
The Cost of ProductionChapter 7A C T I V E L E A R N I N G Brainstorming costsYou run General Motors. List 3 different costs you have. List 3 different business decisions that are affected by your costs.2Chapter Outline Measuring Cost: Which Costs
South Carolina - ECON - 293
Profit Maximization and Competitive SupplyChapter 8Introduction: A ScenarioThree years after graduating, you run your own business. You must decide how much to produce, what price to charge, how many workers to hire, e tc. What factors should affect th
South Carolina - ECON - 293
Profit Maximization and Competitive SupplyChapter 8A C T I V E L E A R N I N G Identifying a firm's profitDetermine this firm's total profit. Identify the area on the graph that represents the firm's profit.A competitive firm Costs, P MC P = \$10 \$6 M
South Carolina - ECON - 293
The Analysis of Competitive MarketsChapter 9Chapter OutlineEvaluating the Gains and Losses from Government Policies-Consumer and Producer Surplus The Efficiency of a Competitive Market The Impact of a Tax or Subsidy Review of Consumer and Producer Su
South Carolina - ECON - 293
The Analysis of Competitive MarketsChapter 9ExternalitiesIn absence of market failures, the competitive market outcome is efficient, maximizes total surplus. One type of market failure: e xte rnality, the uncompensated impact of one person's actions on
South Carolina - ECON - 293
Market Power: Monopoly and MonopsonyChapter 10Chapter Outline 10.1 10.2 10.3 10.4 10.7Monopoly Monopoly Power Sources of Monopoly Power The Social Costs of Monopoly Power Limiting Market Power: The Antitrust LawsMarket Power: Monopoly and Monopsony
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293
South Carolina - ECON - 293