...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...
Words: 3109 - Pages: 13
...This article is published in a peer-reviewed section of the Utrecht Law Review The Use and Influence of Comparative Law in ‘Wrongful Life’ Cases Ivo Giesen* 1. Introduction** 1.1. Comparable stories of great grief In 1993, a South African boy named Brian Stewart was born severely handicapped. He suffers from ‘spina bifida’, a congenital defect to the lower spine, which negatively affects the nerve supply to the lower limbs, bladder and bowel. He suffers from a brain defect as well.1 In 1994, a Dutch girl named Kelly Molenaar was also born severely handicapped. By the time she was two-and-half-years old she was diagnosed as being retarded, autistic, not fully grown, not able to walk or talk, suffering from heart disease, bad hearing and poor eyesight and she was not able, at that time, to recognize her parents. She had been admitted to hospital on nine occasions due to continuous crying, believed to be caused by pain.2 Comparable stories about severely handicapped children can be found in several other countries as well. Both Brian and Kelly were not supposed to have been born in the sense that their mothers would have chosen for an abortion had they known in time about the birth defects their children would suffer. Brian’s mother would have undergone a termination of her pregnancy had the obstetrician and gynaecologist she consulted detected any abnormalities in the foetus and advised her thereof. Kelly’s mother had asked the obstetrician she consulted to carry out some...
Words: 18173 - Pages: 73
...Erfolgsfaktoren interkultureller Strategischer Allianzen - am Beispiel von bilateralen Kooperationen zwischen deutschen, franzo sischen und japanischen Automobilunternehmen - INAUGURALDISSERTATION zur Erlangung des Grades eines Doktors der Wirtschaftswissenschaft des - Fachbereichs Wirtschaftswissenschaft der Gerhard-Mercator-Universita t Gesamthochschule Duisburg Vorgelegt von Dipl.-O k. Carola Krieger 46537 Dinslaken 2001 PDF wurde mit FinePrint pdfFactory-Prüfversion erstellt.http://www.context-gmbh.de II Inhaltsverzeichnis Abbildungsverzeichnis...................................................................................... VI Abku rzungsverzeichnis ..................................................................................... IX I. Fragestellung.................................................................................................... 1 II. Forschungsstand und Vorgehensweise ........................................................... 5 III. Aufbau der Arbeit.......................................................................................... 8 1. Strategische Allianzen................................................................................... 11 1.1 Definition der Strategischen Allianz und ihrer charakteristischen Merkmale ........................................................................................................................... 14 1.2 Herleitung des theoretischen Bezugsrahmens.........................
Words: 131050 - Pages: 525
...Prepared for: Dr. David Conner (Department of CARRS) Dr. Dale Rozeboom (Animal Science) Prepared by: Victoria Campbell-Arvai Department of CARRS, Michigan State University August 17, 2009 Literature Review: A Comparison of Dairy Production Systems SUMMARY This literature review focused on studies comparing the effects of dairy production systems (pasture-based, conventional/confinement1, and mixed) on (i) environmental issues, (ii) social issues, (iii) economic issues, (iv) human health issues, and (v) animal welfare issues. The review was based on peer-reviewed research papers identified by experts at MSU, as well as (where specifically suggested) non peer-reviewed university and government reports. Additional studies were identified from the reference section of recommended papers, as well as via their citation index (primarily Google Scholar). A synopsis of each section is available below, as well as at the end of each section. There is a great deal of research –much of it based in the United States- on the environmental effects of all types of dairy farming, including intensive/confinement, mixed, pasture-based, and management-intensive rotational grazing (MIRG) operations. The vast majority of studies identified for this review focused on the fate and management of excess nitrogen and phosphorous, their effects on terrestrial and aquatic ecosystems, and contributions to air quality and climate change. Many environmental mitigation efforts were suggested, including...
Words: 15922 - Pages: 64
...NEW YORK UNIVERSITY SCHOOL OF LAW JOURNAL OF INTERNATIONAL LAW AND POLITICS GUIDE TO FOREIGN AND INTERNATIONAL LEGAL CITATIONS FIRST EDITION ● 2006 © Copyright 2006 by New York University Contents FORWARD AND GENERAL INSTRUCTIONS................................................................................................. xiii ACKNOWLEDGEMENTS ......................................................................................................................................xv COUNTRY CITATION GUIDES ARGENTINA...............................................................................................................................................................1 I. COUNTRY PROFILE ..................................................................................................................................1 II. CITATION GUIDE.......................................................................................................................................2 1.0 CONSTITUTION...................................................................................................................................2 2.0 LEGISLATION......................................................................................................................................2 3.0 JURISPRUDENCE ................................................................................................................................3 4.0 BOOKS .....................................
Words: 102405 - Pages: 410
...THE PRINCETON REVIEW SNAP SAMPLE PAPER 1 INSTRUCTIONS – Please read these carefully before attempting the test This test is based on pattern of this years’ SNAP paper. 2. There are five sections. Section 1- General English (24 questions) Section 2- Quantitative Ability (30 questions) Section 3- Data Interpretation & Data Sufficiency (40 questions) Section 4-Analytical reasoning and Logical ability(40 Questions) Section 5-Business Awareness and GK(25 Questions) 3. The total time allotted is 2 hours exactly. Please note your start time and end time on the answer sheet. Do not take more than 2 hours, or you will get a wrong assessment. 4. Please fill all the details, as asked on top of the answer sheet. 5. Please try to maximize your attempt overall, but you need to do well in all sections. 6. There is 1 mark for every right answer and 0.25 negative mark for every wrong one. 7. There is no sectional time limit. 8. Since it is a time constrained test and you have 2 hours, and all questions carry equal marks, please do not get stuck on any question, move fast to try and do easier ones. 9. Please do all scratch work on paper only, no extra sheets to be used. Put all your answers on the answer sheet. E E N T IO A N IC U M M M E D IA & C O Relax. You are competing against yourself. S R S 1. SECTION 1 1. Women’s health status is basic to their advancement in...
Words: 12947 - Pages: 52
...á«Hô©dG ô°üe ájQƒ¡ªL º«∏©àdGh á«HÎdG IQGRh ÖàμdG ´É£b iOGóYE’G ådÉãdG ∞°ü∏d ∞````«dCÉJ πª÷G ø°ùM óªfi º«gGôHEG Ω 2012 - 2011 ≈°SGQódG ΩÉ©dG º«∏©àdGh á«HÎdG IQGRh êQÉN ÜÉàμdG Gòg ∫hGóàH ìô°üe ÒZ CMYK CMYK á`````eó```≤``e AÉ°SQEG ≈a ÉgQhO ,™ªàÛG ≈a ICGôŸG QhO óMCG ≈∏Y ≈Øîj ’ º∏°ùdG ≈Øa .Üô◊Gh º∏°ùdG ≈a ÉgQhO ,¬°ù°SCG â«ÑãJh ,¬ªFÉYO ¢Sô¨Jh ,áÁƒb ájƒHôJ ¢ù°SCG ≈∏Y ∫É«LC’G Å°ûæJh ôª©Jh ≈æÑJ .샪£dGh Iõ©dG º¡«a ,√QRCG øe ó°ûJ ¬d GAOQ πLôdG AGQh øe ∞≤J Üô◊G ≈ah k ä’ƒ£H ∫ÉÛG Gòg ≈a â≤≤M óbh .ô°üædG ¬d ºàj ≈àM ¬æ«©Jh .ÚØ≤ãª∏d GOGRh ,ÜÉÑ°û∏d Ihób âdGRÉe ,IódÉN k â≤°T ,äGódÉîdG ÉæFÉ°ùf øe IóFGQ Ωó≤f ÜÉàμdG Gòg ≈ah ,É¡JOGQEG Iƒbh ,É¡àÁõ©H Égó› â©æ°Uh ,ôî°üdG ≈a É¡≤jôW .(@)zQódG Iôé°T{ á°üb É¡fEG ∞``dDƒ```ªdG .AÉàdG ¿hóH zQódG ôé°T{ OQh ɪc ™LGôªdG ¢†©H ≈a AÉàdÉH zQódG Iôé°T{ º°SG OQh (@) .Qƒ°TÉY ìÉàØdGóÑY ó«©°S :Qƒàcó∏d zΩÉ°ûdGh ô°üe ≈a ∂«dɪªdGh ¿ƒ«HƒjC’G{ :™LôªdG CMYK º`````jó```````≤J ¬JÉÑdÉWh iOGóYE’G ådÉãdG ∞°üdG ÜÓW ÉæJÉæHh ÉæFÉæHCG ¤EG π˘˘Ñ˘ ofh áÁõ˘˘©˘ dG ᢢHÓ˘˘°Uh IOGQE’G Iƒ˘˘ b ó˘˘ °ùŒ ᢢ °üb º˘˘ μ˘ d Ωó˘˘ ≤˘ f ¿Éc ɪ¡e ¿É°ùfE’G 샪W ≥«≤– ≈a ∂dP ôKCG RÈJh ,¥ÓNC’G â°TÉY ób ÉÄk «°T ÉgôeCG øe ∂∏“ ’ IÉàa √ò¡a ,∫ÉæŸG Ö©°U ’h ,ájQÉ÷G ¥Q ∞≤j ⁄h ,iΰûoJh ´ÉÑoJ ájQÉL ¤hC’G É¡JÉ«M É¡aGógCG ≥«≤– ≈∏Y â∏ªY ó≤a ,É¡MƒªW ΩÉeCG ICGôŸG ∞©°V áë∏°ùàeh ,É¡Jó°T øe ºZôdÉH äÉÑ≤©dGh ÜÉ©°üdG πc IRhÉéàe iCGôdG ÉgRƒ©j øμj ⁄h .Ú∏J ’ IOGQEGh ,∞©°†J ’ áÁõ©H ,çGóMCÓd á«∏Ñ≤à°ùe ájDhQ É¡d âfÉc ó≤a ¬«dEG êÉà– ÚM ójó°ùdG â©bh GPEÉa ,∫ƒ∏◊G É¡d ™°†Jh ,É¡Yƒbh πÑb É¡H Égô©°ûà°ùJ .ádƒ¡°Sh...
Words: 32038 - Pages: 129
...OSCOLA Oxford Standard for the Citation of Legal Authorities Fourth Edition Faculty of Law, University of Oxford www.law.ox.ac.uk/oscola Contents Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1 1 General notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3 1 .1 Citations and footnotes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3 1 .1 .1 1 .1 .2 1 .1 .3 1 .1 .4 Citing cases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3 Citing legislation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4 Citing secondary sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4 Order of sources in footnotes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4 1 .2 Subsequent citations, cross-references and Latin ‘gadgets’ . . . . . . . . . . . . .5 1 .2 .1 Subsequent citations . . . . . . . . . . . . . . . . . . . . . . ....
Words: 18564 - Pages: 75
...BSRM STEELS LIMITED FOR ISSUE OF 2,000,000 ORDINARY SHARES AT TK.100.00 EACH TOTALING TK.200, 000,000 Opening date for subscription November 09, 2008 Closing date for subscription November 13, 2008 For Non-Resident Bangladeshi Quota subscription closes on November 22, 2008 Managers to the issue ■ ■ ■ Alliance Financial Services Limited South Asia Capital Limited Underwriters South Asia Capital Limited Nascent Tower (2nd floor) 806/A, Agrabad C/A, Chittagong Trust Bank Limited Peoples Insurance Bhaban 36, Dilkusha C/A, Dhaka- 1000 Equity Partners Limited 9/E Motijheel C/A Dhaka- 1000 CREDIT RATING BY CREDIT RATING INFORMATION AND SERVICES LIMITED Long Term A Short Term ST-3 Entity Rating Issue date of the prospectus: October 12, 2008 The issue shall be placed in “N” Category BSRM STEELS LIMITED Corporate Head Office: Ali Mansion, 1173/1207 Sadarghat Road, Chittagong Project Site: 4 Fouzderhat Industrial Estates, Latifpur, Sitakunda, Chittagong “CONSENT OF THE SECURITIES AND EXCHANGE COMMISSION HAS BEEN OBTAINED TO THE ISSUE/OFFER OF THESE SECURITIES UNDER THE SECURITIES AND EXCHANGE ORDINANCE, 1969, AND THE SECURITIES AND EXCHANGE COMMISSION (PUBLIC ISSUE) RULES, 2006. IT MUST BE DISTINCTLY UNDERSTOOD THAT IN GIVING THIS CONSENT THE COMMISSION DOES NOT TAKE ANY RESPONSIBILITY FOR THE FINANCIAL SOUNDNESS OF THE ISSUER COMPANY, ANY OF ITS PROJECTS OR THE ISSUE PRICE OF ITS SECURITIES OR FOR THE CORRECTNESS OF ANY OF THE STATEMENTS MADE OR OPINION EXPRESSED WITH...
Words: 28995 - Pages: 116
...Zehn Jahre Dublin Feiern kein Grund zum Zur Umsetzung der Dublin-II-Verordnung in Deutschland Zehn Jahre Dublin – Kein Grund zum Feiern Abkürzungen AsylVfG AsylZBV AufenthG BAMF BMI BPol B-UMF BVerfG EGMR EMRK EuGH FamFG D-II-VO D-II-DVO GG GRCh LG MS NGO OVG UMF VG VGH Asylverfahrensgesetz Asylzuständigkeitsbestimmungsverordnung Aufenthaltsgesetz Bundesamt für Migration und Flüchtlinge Bundesministerium des Inneren Bundespolizei Bundesfachverband Unbegleitete minderjährige Flüchtlinge Bundesverfassungsgericht Europäischer Gerichtshof für Menschenrechte Europäische Menschenrechtskonvention Europäischer Gerichtshof Gesetz über das Verfahren in Familiensachen und in den Angelegenheiten der freiwilligen Gerichtsbarkeit Dublin-II-Verordnung (Verordnung (EG) Nr. 343/2003 des Rates vom 18. Februar 2003) Dublin-II-Durchführungsverordnung (Verordnung (EG) Nr. 1560/2003 der Kommission vom 2. September 2003 mit Durchführungsbestimmungen zur Verordnung (EG) Nr. 343/2003) Grundgesetz Grundrechtecharta der Europäischen Union Landgericht Mitgliedsstaat (hier: der die D-II-VO anwendet, d.h. alle 27 EU-Staaten sowie die Schweiz, Norwegen, Liechtenstein und Island) Nichtregierungsorganisation Oberverwaltungsgericht (auch VGH=Verwaltungsgerichtshof) unbegleitete(r) minderjährige(r) Flüchtling(e) Verwaltungsgericht Verwaltungsgerichtshof (auch OVG=Oberverwaltungsgericht) Danksagung Wir danken den vielen Flüchtlingen, die ihre Erfahrungen...
Words: 26351 - Pages: 106
...CRIME, PROCEDURE AND EVIDENCE IN A COMPARATIVE AND INTERNATIONAL CONTEXT This book aims to honour the work of Professor Mirjan Damaška, Sterling Professor of Law at Yale Law School and a prominent authority for many years in the fields of comparative law, procedural law, evidence, international criminal law and Continental legal history. Professor Damaška’s work is renowned for providing new frameworks for understanding different legal traditions. To celebrate the depth and richness of his work and discuss its implications for the future, the editors have brought together an impressive range of leading scholars from different jurisdictions in the fields of comparative and international law, evidence and criminal law and procedure. Using Professor Damaška’s work as a backdrop, the essays make a substantial contribution to the development of comparative law, procedure and evidence. After an introduction by the editors and a tribute by Harold Koh, Dean of Yale Law School, the book is divided into four parts. The first part considers contemporary trends in national criminal procedure, examining cross-fertilisation and the extent to which these trends are resulting in converging practices across national jurisdictions. The second part explores the epistemological environment of rules of evidence and procedure. The third part analyses human rights standards and the phenomenon of hybridisation in transnational and international criminal law. The final part of the book assesses Professor...
Words: 195907 - Pages: 784