3 Pages

Lecture1

Course: ECO 339, Spring 2012
School: University of Toronto
Rating:
 
 
 
 
 

Word Count: 1477

Document Preview

Across Wages Markets Lecture 1, January 10 2012 Announcements (Many of these are on the supplementary syllabus) Test 2 will be returned in Class on Friday, January 13th (10:00). Reminder: Make-up Test is Friday, January 13th, 9:00-11:00, WI1017. Only for those with previously approved medical accommodation Term Paper Assignment will be distributed on Friday, January 20th (in class) Outline Summarizing...

Register Now

Unformatted Document Excerpt

Coursehero >> Canada >> University of Toronto >> ECO 339

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.
Across Wages Markets Lecture 1, January 10 2012 Announcements (Many of these are on the supplementary syllabus) Test 2 will be returned in Class on Friday, January 13th (10:00). Reminder: Make-up Test is Friday, January 13th, 9:00-11:00, WI1017. Only for those with previously approved medical accommodation Term Paper Assignment will be distributed on Friday, January 20th (in class) Outline Summarizing Wage Variation What summary statistics? Explorations based on LFS, November 2011 Introduce Earnings Function Theoretical Model of Compensating Differentials Demand side: Firm offers of wages and amenities Supply side: Worker preferences for wages and amenities Market Equilibrium: Deriving the Wage-Amenity locus Application: Workplace Safety Regulation Estimation of compensating differentials for job risk Valuing human life Problems of estimation Last Semester The focus was wage and employment determination in a single market, and the theoretical framework was the supply and demand model. Wages Labour Supply W* Labour Demand E* Recall the combined assumptions: Optimization (utility and profit maximization) Equilibrium Employment Summarizing Wage Variation Clearly, however, wages are not the same for everyone. How can we summarize the degree of variation in wages? Most informative would be showing the entire wage distribution, but summary statistics are useful: Percentiles (or quantiles), especially 10th, 25th, 50th, 75th, and 90th, e.g., W10 , W25 , W50 , W75 , W90 Or ratios of percentiles, e.g., W90 W10 Variance, standard deviation, coefficient of variation Gini coefficient, etc. Exploring Wages in Canada Consider the distribution of wages in Canada. Data come from the Labour Force Survey, November 2011 Pooled men and women, ages 20-59, with positive wage earnings. Note: Average Hourly Earnings not quite the same as the wage. The following distributions show: Wages Log Wages Key percentiles (10th, 50th (median), and 90th) 0 .01 Density .02 .03 .04 Distribution of Wages, November 2011 10 20 30 Source: Labour Force Survey 40 50 60 70 Average Hourly Earnings 80 90 100 0 .2 Density .4 .6 .8 1 Distribution of Log Wages, November 2011 2 2.5 Source: Labour Force Survey 3 3.5 Log Average Hourly Earnings 4 4.5 Summary Statistics Key results: Average wage = $23.87 per hour Median = $21.00 per hour W10 = $11.00; W90 = $40.00 W90 W10 = 3.64 ln (W90 W10 ) = ln W90 ln W10 = 3.69 2.40 = 1.29 Links to overall inequality While related, there is significant slippage between wage inequality and income inequality: Wages versus compensation; Wages versus earnings: ln wh = ln w + ln h Earnings versus income; Permanent versus transitory; Taxes and transfers Individual versus household; Still, trends in wage inequality are an important area of research, and related to overall inequality. Consider the following recent (U.S.) evidence from Goldin and Katz. Note the comparable Canadian level (difference in log 90/10 ratio) for men is 1.26. 141 Claudia Goldin and Lawrence F. Katz Figure 2. Selected Measures of Weekly and Hourly Wage Inequality Log wage ratio Log wage ratio March CPS Full-Time Weekly Wages, 19632005 1.7 0.65 1.6 0.60 1.5 1.4 1.3 Overall 90-10 ratio,a males only (left scale) 0.55 0.50 1.2 Residual 90-10 ratio,b males only (left scale) 0.45 1.1 1.0 Collegehigh school wage differential,c both sexes (right scale) 0.9 1965 1970 1975 1980 1985 1990 0.40 1995 2000 CPS MORG Hourly Wages, 19732006d Source: Goldin and Katz, Brookings Papers on Economic Activity, 2007. 1.7 1.6 0.65 Modeling Wage Variation We can imagine a model explaining wage determination as: Or in logs: wi = g ( x1i , x2 i , ..., xki , i ) ln wi = f ( x1i , x2 i , ..., xki , i ) What factors might we include in this function? A linear approximation: ln wi = 0 + 1 x1i + 2 x2 i + ... + k xki + i OBSERVABLES The population wage regression. Which, given the right data, we can estimate by Ordinary Least Squares (OLS) Over this semester We will look at a variety of determinants of relative wages. Compensating Wage Differentials The general theoretical framework Human Capital Immigration Discrimination: Factors that should not affect wages (but do) Male-Female Wage differentials Internal labour markets Unions Modeling relative wages Why not just extend our analysis from last semester? SS SU WS W US D Unskilled DS U Skilled Start with Adam Smith The five following are the principal circumstances which, so far as I have been able to observe, make up for a small pecuniary gain in some employments, and counter-balance a great one on in others: first, the agreeableness or disagreeableness of the employments themselves; secondly, the easiness and cheapness, or the difficulty and expense of learning them; thirdly, the constancy or inconstancy of employment in them; fourthly, the small or great trust which must be reposed in those who exercise them; and fifthly, the probability or improbability of in them. success Key idea for us: Equilibrium wages must compensate individuals for the disamenities associated with a job. Hedonic Model Modeling linkages between wages and working conditions Workers will care about amenities (or disamenities) It will be costly for firms to provide amenities (or provide fewer disamenties). For concreteness, consider the amenity, safety. Need to examine firm payoffs/tradeoffs to providing different combinations of wages and safety; Then turn to workers, to see how willing they are to accept higher/lower wages in return for different levels of safety. Consider a single Firm With two (or many) heterogeneous firms Competition I1 = I 2 Turning to the worker side Consider a single workers preferences over wages and safety: Two (or more) Heterogeneous workers Not everybody is the same: Compare Marginal Rates of Substitution Market Equilibrium With a single firm and individual: No further gains from trade. Equilibrium with several firms The more relevant case: many firms and individuals Implications Individuals with different preferences will get paid different wages in equilibrium: Choose to work at firms that provide them with the best packages of wages and safety. Can think of this as a market for amenities, as much as a labour market. Individuals are willing to pay (in the form of lower wages) for amenities. Firms sell amenities. Implicit Assumptions: Utility maximization (versus wage maximization, or some other objective) Perfect information (workers are aware of the risks involved with the job) Worker mobility (e.g., no monopsony) An alternative portrayal Can reverse the axis and express wages as a function of the disamenity U3 (e.g., risk) Wage Equilibrium Wage Risk Locus U2 I3 U1 I2 I1 Risk Policy Application: Safety Regulation If the market works perfectly, workers are mobile, and they have complete information, then the market solves any problems of workplace danger: Socially optimal (Pareto Optimal) level of safety: neither firms nor workers would want to change the combination. Workers could switch firms if they did not like the tradeoff If no one wanted to work there, dangerous firms would go out of business. Optimal amount of safety is not infinite. Impact of minimum safety standard Consider the imposition of a minimum safety standard, Sr. If the zero-profit constraint is satisfied, worker bears all of the cost: Impact of safety standard If the firm bears the cost: Impact with multiple firms Firm 3 is unaffected; Firm 2 can adjust, as long as wage is lowered; Firm 1 must shut down. Imperfect information What if workers believe that the level of safety is higher than it actually is? With imperfect information, an externally imposed safety standard may improve worker welfare, without harming firms: Final Thoughts on Regulation In the case of imperfect information, it is possible that safety regulation would improve wellbeing (and be Pareto improving) This is predicated on the regulator being able to observe the level of safety. Why not just monitor safety and report to the workers, solving the information problem? Aside from imperfect information: Imperfect competition, or limited worker mobility Behavioural economics (Psychology) also suggests that regulation may be necessary. Finally, if workers do not bear the full cost of their risk, society may be subsidizing risky firms. Empirical Evidence Economists use the earnings function that we saw earlier to estimate the value that workers place on workplace safety: k ln wi = 0 + j x ji + Pi + i j =1 where Pi is the probability of injury of death on the job. Basic result: Market seems to compensate workers for the risk of death. Estimates range from $750 to $10,000 of extra pay per year for every 1/1000th increase in the probability of being killed in a given year. These estimates can be used to estimate the implicit value of human life. Valuing Human Life Assume that $6,000 is a reasonable estimate of the Compensating Differential for each 0.001 increase in the probability of a fatality. This means that a group of 1,000 workers is willing to pay $6,000,000 to reduce the rate of fatalities by one person per year. Or viewed alternatively, willing to accept $6,000,000 in compensation for the extra death per year. Empirical Challenges Can the estimated compensating wage differentials be taken at face value? Consider estimation of an earnings function: k ln wi = 0 + j x ji + Amenityi + i j =1 Can show that the OLS estimator can be written as: = + Amenity, Where Amenity, is the correlation between unobservables, and the Amenity. So if there are unobserved worker or job characteristics that are correlated with Amenities, our estimates will be biased. What if the unobservable is productivity Next week Human Capital: Chapter 9 Extend the idea of compensating differential to the cost of acquiring skills. Selected problems from Chapter 8 They are all useful! But for starters, please try Problems #1, #3, and #5.
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 Toronto - ECO - 339
Human Capital ILecture 2, January 17, 2012Announcements Term Paper Assignment will be distributed on Friday, January 20th (inclass) Remaining copies of Test 2 can also be picked up on Friday.1Review Compensating Differentials We developed the Hedo
University of Toronto - ECO - 339
Human Capital IILecture 3, January 24, 2012Announcements Sketch of the next several Friday classes: January 27: Review of Regression Analysis Leftover time available for Q&A r.e. term paper February 3: Term Paper Session Andrea Williams, Lecturer i
University of Toronto - ECO - 339
Immigration ILecture 4, January 31, 2012Announcements Sketch of the next few Friday classes: February 3: Term Paper Session Andrea Williams, Lecturer in Writing Instruction February 10: Term Paper Session Miscellaneous (e.g., Peer Scholar, Q&A, etc
University of Toronto - ECO - 339
Immigration IILecture 5, February 7, 2012Announcements Sketch of the next couple of Friday classes: February 10: Term Paper Session Miscellaneous (e.g., Peer Scholar, Q&A, etc.) February 17: Term Paper Session Eveline Houtman, Coordinator of Librar
University of Toronto - ECO - 339
Discrimination ILecture 6, February 14, 2012Announcements Friday, February 17: Term Paper Session Miscellaneous (e.g., Peer Scholar, Q&A, etc.) Term Paper: First draft due Friday March 2, 10:00am. 2.5 weeks Reminder: I will be unavailable during re
University of Toronto - ECO - 339
Discrimination IILecture 7, February 28, 2012Announcements Term Paper: First draft due Friday March 2, 10:00am. Be sure to test drive your peerScholar accounts well in advance. Userid: official ROSI email address; Password: utorid Remember: late sub
University of Toronto - ECO - 339
Optimal Compensation SchemesLecture 8, March 6, 2012Announcements Term Paper - Remaining deadlines: Peer Assessments, Tuesday March 13th, 11:00 am Final Submission, Tuesday March 20th, 11:00 am On peerScholar and turnitin. Final Exam: A-LI TUE 17
University of Toronto - ECO - 339
Unions ILecture 9, March 13, 2012Announcements Term Paper - Remaining deadline: Final Submission, Tuesday March 20th, 11:00 am On peerScholar and turnitin. No need for paper submission Dont forget the reflection (no need to go overboard). Final Ex
University of Toronto - ECO - 339
Unions IILecture 10, March 20, 2012Announcements Final Exam: A-LI TUE 17 APR AM 9-11 SEEL LL-Z TUE 17 APR AM 9-11 SHER Final Exam Structure: Three Questions Define and explain the significance Two theoretical/quantitative problems Tutorials conti
University of Toronto - ECO - 339
Unemployment ILecture 11, March 27, 2012Announcements Final Exam: A-LI TUE 17 APR AM 9-11 SEEL LL-Z TUE 17 APR AM 9-11 SHER Final Exam Structure: Three Questions Define and explain the significance Two theoretical/quantitative problems Tutorials
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 11) Draw Lewis structures, showing all unshared electrons, for the following molecules:(a) CH3NH2(b) CH2CH2(c) C2H2(d) CH3CH2CHO(e) CH3CH2OH2+(f) (CH3)3N(g) CH3CN(h) CH3CH(OH)CH3(i) CH3NCO(j) CH2CHCH(OH)CH2CO2H (k) NCCH2COCH
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 1 Answers1) Draw Lewis structures, showing all unshared electrons, for the following covalent molecules:(a) CH3NH2(b) CH2CH2(c) C2H2HHCCHHHCCH(d) CH3CH2CHO(e) CH3CH2OH2+(f) (CH3)3NHHOHCCCHH HHHHCCOHHHHHHHCNCHHC
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #2In this assignment:- Drawing Lewis structures and assigning formal charges- Analyzing the effects of intermolecular forces- Conformational analysis1) Draw Lewis structures for the following molecules. Identify the hybridization
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #2 - Answers1) Draw Lewis structures for the following molecules. Identify the hybridization oft the underlinedatoms.f. Propanoic acida.ClAlAlCl3ClClsp2The "p " or bital is emptyb.g. FormaldehydeHCOHFBB F3HH OCCH
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 31) Identify each of the following pairs as constitutional isomers, stereoisomers (configurationalisomers), or conformers.Assignment 34) Draw each of the following compounds in three dimensions. Draw the mirror image of each andde
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 3 - ANSWERSAssignment 3 - AnswersQuestion 2 contd:g) CH3CClBrH h) (CH3)2CHOHi) CH3CH2CHOHCH3j)CH3CH2CHOHCH2CH31) Identify each of the following pairs as constitutional isomers, stereoisomers (configurationalisomers), or conforme
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 4In this assignment:- Acid/base reactions- Resonance- SN 21) Draw the important resonance forms and show the resonance hybrid structures forthe following:2) For the following, label the major and minor resonance forms, and show
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 4 Answers1) Draw the important resonance forms and show the resonance hybrid structures forthe following:Assignment 4 - Answers2Assignment 4 - Answers3Assignment 4 - Answers2) For the following resonance forms, label the major
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #5 - ANSWERS1. Use arrow notation to show the mechanisms of the following reactions. Use your mechanism topredict the product of the reaction. Identify the nucleophile, its nucleophilic atom, the carbon of theelectrophile and the le
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #5In this assignment:- SN2 reactions- SN1 reactions1. Use arrow notation to show the mechanisms of the following reactions. Use your mechanism topredict the product of the reaction. Identify the nucleophile, its nucleophilic atom,
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 6 2011In this assignment:- Mechanisms- Acid/base- Epoxide reactions- Elimination reactionsRemember how to calculate formal charge?F.C. = # of electrons in the neutral atoms valence # of bonds # of lone electronsWhat does F.C. t
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 6 2011 - ANSWERSIn this assignment:- Epoxide reactions- Elimination reactions1. Draw a mechanism to explain the formation of the following intermediates andproducts. Note that these are not reactions that you have seen (yet) or ne
University of Ottawa - SCIENCE - chm 1321
In this assignment:- Alkene addition reactions- SynthesisCHM 1321Assignment 71. Predict the major product(s) of the following reactions and give a mechanism to account for itsformation.2. When 1, 3-butadiene reacts with HBr, a mixture of 3-bromo-1-
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment 7 AnswersNote: Many synthesis questions have more than one answer. For most questions, only one possible solution ispresented. If you are not sure if one of your answers is correct please check with your TA.In this assignment:- Alk
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #8 - ANSWERSIn this assignment:- Nucleophilic addition to carbonyls- Addition to alkenes, part IINote: you can use the mechanisms as shown in the answers or the ones shown in class.1. Give the products of the following reactions a
University of Ottawa - SCIENCE - chm 1321
CHM 1321Assignment #8In this assignment:- Nucleophilic addition to carbonyls- Addition to alkenes, part II1. Give the products of the following reactions and give mechanisms to show howthey are formed:Assignment #82. Predict the major products of
University of Ottawa - SCIENCE - chm 1321
Please note that this year's midterm (2011) will be slightly longerand will also have questions related to acid-base, resonance and SN2(the material stops at the end of Thursday, Feb 3's class)CHM 1321 CMidterm 1February 8, 2008Note: The points are
University of Ottawa - SCIENCE - chm 1321
CHM 1321 CMidterm 1 - ANSWERSFebruary 8, 2008Note: The points are given as a guide and are subject to minor changes.Surname: _ First name: _Student Number: _1. Identify the hybridization of the indicated atoms: (3 points)1 point eachsp 2OCCCH
University of Ottawa - SCIENCE - chm 1321
CHM 1321 BMidterm 1February 10, 2011ANSWERSNote: The points are given as a guide and are subject to minor changes.Last name: _ First name: _Student Number: _Seat Number: _1. Give the hybridization of each of the indicated atoms in Viagra, shown be
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #1: Answer KeyJan. 19th, 20101. C, H, N, O, P and S are the primary components of organic molecules. Others (<1%):single ions Na+, K+, Mg2+, Ca2+ , Cl-.2. Molecule: two or more atoms bond together to form a molecule (NaCl, H , CH .
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #2Answer Key1. Name the ve functions of the cell membrane.1. Dene boundaries; selectively permeable barrier2. Localisation and organisationScaffold for biochemical activities (enzymes)e.g. mitochondria3. Regulation of solute tra
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #3Answer Key1. What are some of the important functions of the cytoskeleton?Functions include:The provision of structure and support (1)Intracellular transport (2)The positioning of organelles within the cell (4)The generation o
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #4Answer Key1. What is the purpose of the plant cell wall and what are the three classes of moleculesthat are found within it?Purpose:Provides rigidity and protection, regulates permeabilityStructure involves 3 classes of molecul
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #5Answer Key1. Describe the various elements of the cell-signaling system.i. Signaling molecule (rst messenger)ii. ReceptionReceptor membrane, cytosolic or nucleariii. TransductionSignalling cascades and second messengersiv. Re
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #6Answer Key1. Fill in the blanks:i. A base is a purine or a pyridimine.ii. A base + a pentose sugar = _a nucleoside.iii. A nucleoside + a phosphate = _deoxynucleoside.2. What is the role of histones in DNA organization? How does
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #7Answer Key1. i. The DNA structure is antiparallel. DNA strands go from 5 to 3.ii. Synthesis follows the base-pairing rules, A-T, G-C.iii. One new DNA strand is synthesized continuously; the other, discontinuouslyiv. DNA polymera
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #8Answer Key1. What is gene regulation? Why is it so important to understanding life?Gene regulation refers to the regulation of activity and may occur at any level. While themain control is at the level of transcription additional
University of Ottawa - SCIENCE - BIO1140
BIO1140 Study Group #9Answer Key1. Using the accompanying diagram, describe the four steps involved with proteintargetting.Step 2tep 11. Translation2. Interaction with receptor & unfolding-signals on protein (a signal peptide)-proteins aid unfold
University of Ottawa - SCIENCE - BIO1140
BIO1140 StudyFest 2011Answer Key1. Name the ve functions of the cell membrane.1. Dene boundaries; selectively permeable barrier2. Localisation and organisationScaffold for biochemical activities (enzymes)e.g. mitochondria3. Regulation of solute tra
University of Ottawa - SCIENCE - BIO1140
These questions and help were provided by Jayme Lewthwaite who in 2010 was a study leaderfor the residence students. Some are simple but all are meant to help your organize your studyingNOT to provide answers.<Study Tip> Deadlines. Simple as that. Know
University of Ottawa - SCIENCE - BIO1140
Updated April 14, 2010DNA, RNA structure and functionWhy are multiple copies of tRNA and rRNA genes needed?a. These RNAs are destroyed very rapidly.b. These RNAs are very stable.c. These RNAs are needed in large amounts.d. These RNAs do not benefit
University of Ottawa - SCIENCE - BIO1140
Study questions Topic 1 Introduction to cell biologyMultiple choice questions (1 mark per answer)1. Which one of the following statements concerning prokaryotic cells is true?(a) They have no nucleus and hence no DNA.(b) They have no Golgi apparatus(
University of Ottawa - SCIENCE - BIO1140
Study questions Topic 2 Cell membranesMultiple choice questions (1 mark per answer)1. A bacterium is suddenly expelled from a warm human intestine into cold water. Which ofthe following adjustments might the bacterium make to maintain the same level of
University of Ottawa - SCIENCE - BIO1140
Study questions Topic 3 The cytoskeletonMultiple choice questions (1 mark per answer)1. The thick filaments of skeletal muscle cells are composed of the protein.(a) Keratin(b) Actin(c) Kinesin(d) Myosin(e) Titin2. What properties of intermediate f
University of Ottawa - SCIENCE - BIO1140
Study questions Topic 4 Extracellular interactionsMultiple choice questions (1 mark per answer)1. The cellulose fibres in plant cell walls are synthesized.(a) In the rough ER, packaged by the Golgi complex, and transported to the plasmamembrane in ves
University of Ottawa - SCIENCE - BIO1140
Study questions Topic 5 Cell-to-cell signallingMultiple choice questions (1 mark per answer)1. Which of the following is not a cell surface receptor?(a) A ligand-gated channel(b) A ligand-activated transcription factor(c) A receptor tyrosine kinase(
University of Ottawa - SCIENCE - BIO1140
BIO 1140 DGDApril 7, 2011The cell cycle: reviewCell cycle stages: Interphase (G0, G1, S,G2); mitosis (Prophase, prometaphase,metaphase, anaphase, telophase);cytokinsesisThe cell cycle (cont)Regulation of the cell cycleThe length of the cell cycle
University of Ottawa - SCIENCE - BIO1140
BIO 1140 DGDFeb. 10, 2011Review: Plant cell wall andplasmodesmataPlant cell wall (cellulose microfibrils,hemicellulose, pectin) rigidity, protection,regulates permeabilityRosettes (six membered ring) used tocreate the cellulose microfibrils glucos
University of Ottawa - SCIENCE - BIO1140
BIO 1140 DGDMarch 3, 2011Note taking for Dr. JohnsonslecturesDo not write down every word Dr.Johnson says (he tends to tell jokes)Print out the notes (or to save trees havethem open on your laptop) most of theinfo is on there add in information th
University of Ottawa - SCIENCE - BIO1140
BIO 1140 DGDMarch 28, 2011Bacterial gene regulation: thelac operonGenes involved in lactose metabolism:lacZ, lacY, lacA all next to each other expressed only when an inducer (ielactose) is presentBelong to an operon group of genes withrelated fun
Waterloo - CS - 338
CS 338: Computer Applications in Business: Databases(Winter 2012)Assignment 2(Due in class on Tuesday, February 28, 2012)Consider the following set of requirements for a UNIVERSITY database that is used to keeptrack of students' transcripts.(a) The
Waterloo - CS - 338
Chapter 1Databases andDatabase UsersCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 1 OutlineIntroductionAn ExampleCharacteristics of the Database ApproachActors on the SceneWorkers behind the SceneAdvantages
Waterloo - CS - 338
Chapter 2DatabaseSystemConcepts andArchitectureCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 2 Outline Data Models, Schemas, and Instances Three-Schema Architecture and DataIndependence Database Languages an
Waterloo - CS - 338
Chapter 3The RelationalData Modeland RelationalDatabaseConstraintsCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 3 OutlineThe Relational Data ModelRelational Database ConstraintsRelational Model ConstraintsR
Waterloo - CS - 338
Chapter 4Basic SQLCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 4 Outline Basic SQL SQL Data Definition Language (DDL) SQL Data Manipulation Language (DML)Basic Retrieval Queries in SQL INSERT, DELETE, and UPD
Waterloo - CS - 338
Chapter 5More SQL:ComplexQueriesCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyMore Complex SQL RetrievalQueries Additional features allow users to specifymore complex retrievals from database:Nested queries, joined t
Waterloo - CS - 338
Chapter 6The RelationalAlgebra andRelationalCalculusCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 6 Outline Unary Relational Operations: SELECT andPROJECT Relational Algebra Operations from SetTheory Binary
Waterloo - CS - 338
Chapter 7Data ModelingUsing theEntityRelationship(ER) ModelCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 7 Outline Using High-Level Conceptual Data Models forDatabase Design Entity Types, Entity Sets, Attribu
Waterloo - CS - 338
Chapter 8The EnhancedEntityRelationship(EER) ModelCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 8 Outline Subclasses, Superclasses, and Inheritance Specialization and Generalization Constraints and Characteris
Waterloo - CS - 338
Chapter 9RelationalDatabaseDesign by ERand EER-toRelationalMappingCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 9 Outline Relational Database Design Using ER-toRelational Mapping Mapping ER Model Constructs to
Waterloo - CS - 338
Chapter 10PracticalDatabaseDesignMethodologyand Use of UMLDiagramsCopyright 2011 Pearson Education, Inc. Publishing as Pearson Addison -WesleyChapter 10 Outline The Role of Information Systems inOrganizations The Database Designand Implementat