...relationships 11 III. The Unified Modeling Language (UML)………...…………….13 Class diagrams 13 Activity diagrams 19 Rules of thumb for UML 21 IV. Requirements Analysis and Conceptual Data Modeling….…..22 Requirements analysis 22 Conceptual data modeling 24 View integration methods 25 Entity Clustering 30 V. Transforming the Conceptual Model to SQL…………...………32 VI. Normalization and normal forms ………………………………38 First normal form to third normal form (3NF) and BCNF 38 3NF synthesis algorithm (Bernstein) 43 VII. An Example of Logical Database Design………………………48 VIII. Business Intelligence………………………………..……….....52 Data warehousing 52 On-line analytical processing (OLAP) 58 IX. CASE Tools for Logical Database Design……………………….60 I. Introduction Introductory Concepts data—a fact, something upon which an inference is based (information or knowledge has value, data has cost) data item—smallest named unit of data that has meaning in the real world (examples: last name, address, ssn, political party) data aggregate (or group) -- a collection of related data items that form a whole concept; a simple group is a fixed collection, e.g. date (month, day, year); a repeating group is a variable length collection, e.g. a set of aliases. record—group of related data items treated as a unit by an application program (examples: presidents, elections, congresses) file—collection...
Words: 8116 - Pages: 33
...RO-752121, Bucharest, Romania gmaris@aira.astro.ro 2 Armagh Observatory College Hill, Armagh, BT61 9DG, N. Ireland mdp@star.arm.ac.uk (Received May 30, 2003) Abstract. We present a review of different solar flare periodicity intervals. Our analysis includes a statistical investigation of flare occurrence and N hemispheric distribution over the last three 11-yr -S solar cycles (SCs 21-23, correspondin g to the period 1976-2001). Moreover, we try to estimate if there is any connection between the flare activity and the strength of solar cycles. For that purpose, we studied not only the number of flares occurring monthly and annually, but we also used two indices that estimate the energy emitted by flares registered in the optical Hα line, as well as in the soft X -ray 1-8 Å band. The strange behaviour of SC 22 descending phase, with short but intense increments in flare activity, having a high degree of N-S asymmetry, could be the cause of the "abnormal" appearance of SC 23. The new magnetic dipole begins to lose part of its energy even during the descending phase of SC 22, so that the activity of SC 23 proves to be below the predicted values. Key words: Sun − solar flares – solar activity cycles − N-S asymmetry. INTRODUCTION Solar flares are wonderfully complex phenomena, seen as sudden and intense increases in brightness on the solar disk. They occur when magnetic field loops undergo reorganization, releasing energy into the solar coronal and chromospheric plasma. It is...
Words: 9009 - Pages: 37
...When the MOS-capacitor is supplied by AC voltage, the gap width increase and contracts with respect to the AC frequency (Huff, 2005, pg. 219). To maintain the reliability and the quality of MOS structures is a vital practice among the MOS capacitors. The C-V measurements are employed mostly to determine the details and quality of gate oxides. On the MOS capacitor, measurements are done at the absence of the drain and source. The test operations provide the process information and at the same time ensuring efficient devices. The interface charges and bulk charges are also part of the parameters that are determined. The capacitor voltage measurements are carried out using tools like the Keithley model. The Keithley model makes use of 4200-SCS apparatus. Parameters like capacitance, voltage and current are taken. Analysis of the obtained results can be done mathematically, graphically or by use of software. When software is used, a wide range of formulas are used so as to extract the basic C-V parameters. The MOS capacitor is a device fabricated by placing an oxide between a metal and a semiconductor. Poly-silicon can also be used in the place of the metal gate....
Words: 1575 - Pages: 7
...modified 2/16/2010 EXCERPTS FROM: Solutions Manual to Accompany Statistics for Business and Economics Eleventh Edition David R. Anderson University of Cincinnati Dennis J. Sweeney University of Cincinnati Thomas A. Williams Rochester Institute of Technology The material from which this was excerpted is copyrighted by SOUTH-WESTERN CENGAGE LearningTM Contents 1. Data and Statistics ....................................................................................................................... 1 2. Descriptive Statistics: Tabular and Graphical Methods.............................................................. 2 3. Descriptive Statistics: Numerical Methods................................................................................. 5 4. Introduction to Probability .......................................................................................................... 8 5. Discrete Probability Distributions............................................................................................. 11 6. Continuous Probability Distributions ....................................................................................... 13 7. Sampling and Sampling Distributions ...................................................................................... 15 8. Interval Estimation .................................................................................................................... 17 9. Hypothesis Testing......................
Words: 10474 - Pages: 42
...CONVERSION FACTORS FROM ENGLISH TO SI UNITS Length: 1 ft 1 ft 1 ft 1 in. 1 in. 1 in. 1 ft2 1 ft2 1 ft2 1 in.2 1 in.2 1 in.2 1 ft3 1 ft3 1 in.3 1 in.3 1 in. 1 in.3 1 ft/min 1 ft/min 1 ft/min 1 ft/sec 1 ft/sec 1 in./min 1 in./sec 1 in./sec 3 0.3048 m 30.48 cm 304.8 mm 0.0254 m 2.54 cm 25.4 mm 929.03 10 4 m2 929.03 cm2 929.03 102 mm2 6.452 10 4 m2 6.452 cm2 645.16 mm2 28.317 10 3 m3 28.317 103 cm3 16.387 10 6 m3 16.387 cm3 0.16387 0.16387 10 mm 10 4 m3 5 3 Coefficient of consolidation: Force: 1 in.2/sec 1 in.2/sec 1 ft2/sec 1 lb 1 lb 1 lb 1 kip 1 U.S. ton 1 lb 1 lb/ft 1 lb/ft2 1 lb/ft2 1 U.S. ton/ft2 1 kip/ft2 1 lb/in.2 1 lb/ft3 1 lb/in.3 1 lb-ft 1 lb-in. 1 ft-lb 1 in.4 1 in.4 6.452 cm2/sec 20.346 103 m2/yr 929.03 cm2/sec 4.448 N 4.448 10 3 kN 0.4536 kgf 4.448 kN 8.896 kN 0.4536 10 3 metric ton 14.593 N/m 47.88 N/m2 0.04788 kN/m2 95.76 kN/m2 47.88 kN/m2 6.895 kN/m2 0.1572 kN/m3 271.43 kN/m3 1.3558 N · m 0.11298 N · m 1.3558 J 0.4162 0.4162 106 mm4 10 6 m4 Area: Stress: Volume: Unit weight: Moment: Energy: Moment of inertia: Section modulus: Hydraulic conductivity: 0.3048 m/min 30.48 cm/min 304.8 mm/min 0.3048 m/sec 304.8 mm/sec 0.0254 m/min 2.54 cm/sec 25.4 mm/sec CONVERSION FACTORS FROM SI TO ENGLISH UNITS Length: 1m 1 cm 1 mm 1m 1 cm 1 mm 1m 1 cm2 1 mm2 1 m2 1 cm2 1 mm2 1m 1 cm3 1 m3 1 cm3 1N 1 kN 1 kgf 1 kN 1 kN 1 metric ton 1 N/m 3 2 3.281 ft 3.281 10 3.281 10 39.37 in. 0.3937 in. 0.03937 in. 2 Stress: 2 3 ft ft 1 N/m2 1 kN/m2...
Words: 183832 - Pages: 736
...Wireless Physical Layer Security: An Information Theoretic Approach DISSERTATION Presented in Partial Fulfillment of the Requirements for the Degree Doctor of Philosophy in the Graduate School of The Ohio State University By Onur Ozan K¨yl¨o˘lu, B.S., M.S. o u g Graduate Program in Electrical and Computer Engineering The Ohio State University 2010 Dissertation Committee: Hesham El Gamal, Adviser C. Emre K¨ksal o Ness B. Shroff Atilla Eryılmaz c Copyright by Onur Ozan K¨yl¨ o˘lu o u g 2010 ABSTRACT We are in the midst of wireless revolution, and increasing demand continues for wireless applications. This explosive growth, of wireless communications and services, inevitably renders security into a challenging quality of service constraint that must be accounted for in the network design. The state of the art methods in combating the security threats are usually founded on cryptographic approaches. These techniques typically assume limited computational resources at adversaries, are usually derived from unproven assumptions, and most of the time do not offer a measurable security notion. Information theoretic security, on the other hand, eliminates the aforementioned limitations of the cryptographic techniques at the physical layer of communication systems. In this thesis, we concentrate on both the theoretical and the practical aspects of physical layer security. We first start by analyzing elemental interference networks, in particular, two-user channels with an adversary...
Words: 47476 - Pages: 190
...Protection of Electrical Networks Protection of Electrical Networks Christophe Prévé First published in Great Britain and the United States in 2006 by ISTE Ltd Apart from any fair dealing for the purposes of research or private study, or criticism or review, as permitted under the Copyright, Designs and Patents Act 1988, this publication may only be reproduced, stored or transmitted, in any form or by any means, with the prior permission in writing of the publishers, or in the case of reprographic reproduction in accordance with the terms and licenses issued by the CLA. Enquiries concerning reproduction outside these terms should be sent to the publishers at the undermentioned address: ISTE Ltd 6 Fitzroy Square London W1T 5DX UK ISTE USA 4308 Patrice Road Newport Beach, CA 92663 USA www.iste.co.uk © ISTE Ltd, 2006 The rights of Christophe Prévé to be identified as the author of this work have been asserted by him in accordance with the Copyright, Designs and Patents Act 1988. Library of Congress Cataloging-in-Publication Data Prévé, Christophe, 1964Protection of electrical networks / Christophe Prévé. p. cm. Includes index. ISBN-13: 978-1-905209-06-4 ISBN-10: 1-905209-06-1 1. Electric networks--Protection. I. Title. TK454.2.P76 2006 621.319'2--dc22 2006008664 British Library Cataloguing-in-Publication Data A CIP record for this book is available from the British Library ISBN 10: 1-905209-06-1 ISBN 13: 978-1-905209-06-4 Printed...
Words: 31240 - Pages: 125
...This article appeared in a journal published by Elsevier. The attached copy is furnished to the author for internal non-commercial research and education use, including for instruction at the authors institution and sharing with colleagues. Other uses, including reproduction and distribution, or selling or licensing copies, or posting to personal, institutional or third party websites are prohibited. In most cases authors are permitted to post their version of the article (e.g. in Word or Tex form) to their personal website or institutional repository. Authors requiring further information regarding Elsevier’s archiving and manuscript policies are encouraged to visit: http://www.elsevier.com/copyright Author's personal copy Pattern Recognition 45 (2012) 3414–3426 Contents lists available at SciVerse ScienceDirect Pattern Recognition journal homepage: www.elsevier.com/locate/pr Silhouette-based gait recognition using Procrustes shape analysis and elliptic Fourier descriptors Sruti Das Choudhury, Tardi Tjahjadi n School of Engineering, University of Warwick, Gibbet Hill Road, Coventry CV4 7AL, United Kingdom a r t i c l e i n f o Article history: Received 6 September 2011 Received in revised form 15 December 2011 Accepted 21 February 2012 Available online 5 March 2012 Keywords: Gait recognition Human identification Procrustes shape analysis Elliptic Fourier descriptor Silhouette Nearest neighbour classifier Classifier combination Hu moments a b s t r a c t ...
Words: 13230 - Pages: 53
...Solution Manual for A Course in Game Theory Solution Manual for A Course in Game Theory by Martin J. Osborne and Ariel Rubinstein Martin J. Osborne Ariel Rubinstein with the assistance of Wulong Gu The MIT Press Cambridge, Massachusetts London, England This manual was typeset by the authors, who are greatly indebted to Donald Knuth (the A creator of TEX), Leslie Lamport (the creator of L TEX), and Eberhard Mattes (the creator of emTEX) for generously putting superlative software in the public domain, and to Ed Sznyter for providing critical help with the macros we use to execute our numbering scheme. Version 1.1, 97/4/25 Contents Preface xi 2 Nash Equilibrium 1 Exercise 18.2 (First price auction ) 1 Exercise 18.3 (Second price auction ) 2 Exercise 18.5 (War of attrition ) 2 Exercise 19.1 (Location game ) 2 Exercise 20.2 (Necessity of conditions in Kakutani's theorem ) 4 Exercise 20.4 (Symmetric games ) 4 Exercise 24.1 (Increasing payo s in strictly competitive game ) 4 Exercise 27.2 (BoS with imperfect information ) 5 Exercise 28.1 (Exchange game ) 5 Exercise 28.2 (More information may hurt ) 6 Exercise 35.1 (Guess the average ) 7 Exercise 35.2 (Investment race ) 7 Exercise 36.1 (Guessing right ) 9 Exercise 36.2 (Air strike ) 9 Exercise 36.3 (Technical result on convex sets ) 10 Exercise 42.1 (Examples of Harsanyi's puri cation ) 10 Exercise 48.1 (Example of correlated equilibrium ) 11 Exercise 51.1 (Existence of ESS in 2 2 game ) 12 Exercise...
Words: 27123 - Pages: 109
...Supply Chain Management and Advanced Planning Hartmut Stadtler ´ Christoph Kilger (Eds.) Supply Chain Management and Advanced Planning Concepts, Models, Software and Case Studies Third Edition With 173 Figures and 56 Tables 12 Professor Dr. Hartmut Stadtler FG Produktion und Supply Chain Management FB Rechts- und Wirtschaftswissenschaften TU Darmstadt Hochschulstraûe 1 64289 Darmstadt Germany stadtler@bwl.tu-darmstadt.de Dr. Christoph Kilger j&m Management Consulting AG Kaiserringforum Willy-Brandt-Platz 5 68161 Mannheim Germany christoph.kilger@jnm.de Cataloging-in-Publication Data Library of Congress Control Number: 2004110194 ISBN 3-540-22065-8 Springer Berlin Heidelberg New York ISBN 3-540-43450-X 2nd edition Springer Berlin Heidelberg New York This work is subject to copyright. All rights are reserved, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilm or in any other way, and storage in data banks. Duplication of this publication or parts thereof is permitted only under the provisions of the German Copyright Law of September 9, 1965, in its current version, and permission for use must always be obtained from Springer-Verlag. Violations are liable for prosecution under the German Copyright Law. Springer is a part of Springer Science+Business Media springeronline.com ° Springer Berlin ´ Heidelberg 2000, 2002, 2005 Printed...
Words: 180845 - Pages: 724
...European Journal of Operational Research 203 (2010) 539–549 Contents lists available at ScienceDirect European Journal of Operational Research journal homepage: www.elsevier.com/locate/ejor Invited Review Research on warehouse design and performance evaluation: A comprehensive review Jinxiang Gu a, Marc Goetschalckx b,*, Leon F. McGinnis b a b Nestle USA, 800 North Brand Blvd., Glendale, CA 91203, United States Georgia Institute of Technology, 765 Ferst Dr., Atlanta, GA 30332-0205, United States a r t i c l e i n f o a b s t r a c t This paper presents a detailed survey of the research on warehouse design, performance evaluation, practical case studies, and computational support tools. This and an earlier survey on warehouse operation provide a comprehensive review of existing academic research results in the framework of a systematic classification. Each research area within this framework is discussed, including the identification of the limits of previous research and of potential future research directions. Ó 2009 Elsevier B.V. All rights reserved. Article history: Received 5 December 2005 Accepted 21 July 2009 Available online 6 August 2009 Keywords: Facilities design and planning Warehouse design Warehouse performance evaluation model Case studies Computational tools 1. Introduction This survey and a companion paper (Gu et al., 2007) present a comprehensive review of the state-of-art of warehouse research. Whereas the latter focuses on warehouse...
Words: 12436 - Pages: 50
...CMOS Analog Circuit Design (2nd Ed.) Homework Solutions : 9/20/2002 1 Chapter 1 Homework Solutions 1.1-1 Using Eq. (1) of Sec 1.1, give the base-10 value for the 5-bit binary number 11010 (b4 b3 b2 b1 b0 ordering). From Eq. (1) of Sec 1.1 we have bN-1 2 + b N-2 2 + bN-3 2 + ...+ b0 2-N = -1 -2 -3 ∑bN-i2-i i=1 N 1 1 0 1 0 1 × 2-1 + 1× 2-2 + 0 × 2-3 + 1 × 2-4 + 0 × 2-5 = 2 + 4 + 8 + 16 + 32 = 16 + 8 + 0 + 2 + 0 26 13 = 32 = 16 32 1.1-2 Process the sinusoid in Fig. P1.2 through an analog sample and hold. The sample points are given at each integer value of t/T. 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 1 2 3 4 5 6 7 8 9 10 11 Sample times t __ T Figure P1.1-2 1.1-3 Digitize the sinusoid given in Fig. P1.2 according to Eq. (1) in Sec. 1.1 using a four-bit digitizer. Amplitude CMOS Analog Circuit Design (2nd Ed.) Homework Solutions : 9/20/2002 2 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 1 1111 1110 1101 1100 1010 1000 0110 0101 0011 0010 0010 1000 Amplitude 2 3 4 5 6 7 8 9 10 11 Sample times t __ T Figure P1.1-3 The figure illustrates the digitized result. At several places in the waveform, the digitized value must resolve a sampled value that lies equally between two digital values. The resulting digitized value could be either of the two values as illustrated in the list below. Sample Time 0 1 2 3 4 5 6 7 8 9 10 11 4-bit Output 1000 1100 1110 1111 or 1110 1101 1010 0110 0011 0010 or 0001 0010 0101 1000 ...
Words: 50299 - Pages: 202
...A FIRST COURSE IN PROBABILITY This page intentionally left blank A FIRST COURSE IN PROBABILITY Eighth Edition Sheldon Ross University of Southern California Upper Saddle River, New Jersey 07458 Library of Congress Cataloging-in-Publication Data Ross, Sheldon M. A first course in probability / Sheldon Ross. — 8th ed. p. cm. Includes bibliographical references and index. ISBN-13: 978-0-13-603313-4 ISBN-10: 0-13-603313-X 1. Probabilities—Textbooks. I. Title. QA273.R83 2010 519.2—dc22 2008033720 Editor in Chief, Mathematics and Statistics: Deirdre Lynch Senior Project Editor: Rachel S. Reeve Assistant Editor: Christina Lepre Editorial Assistant: Dana Jones Project Manager: Robert S. Merenoff Associate Managing Editor: Bayani Mendoza de Leon Senior Managing Editor: Linda Mihatov Behrens Senior Operations Supervisor: Diane Peirano Marketing Assistant: Kathleen DeChavez Creative Director: Jayne Conte Art Director/Designer: Bruce Kenselaar AV Project Manager: Thomas Benfatti Compositor: Integra Software Services Pvt. Ltd, Pondicherry, India Cover Image Credit: Getty Images, Inc. © 2010, 2006, 2002, 1998, 1994, 1988, 1984, 1976 by Pearson Education, Inc., Pearson Prentice Hall Pearson Education, Inc. Upper Saddle River, NJ 07458 All rights reserved. No part of this book may be reproduced, in any form or by any means, without permission in writing from the publisher. Pearson Prentice Hall™ is a trademark of Pearson Education, Inc...
Words: 121193 - Pages: 485
...SCHAUM'S OUTLINE OF THEORY AND PROBLEMS OF COLLEGE PHYSICS Ninth Edition . FREDERICK J. BUECHE, Ph.D. Distinguished Professor at Large University of Dayton EUGENE HECHT, Ph.D. Professor of Physics Adelphi University . SCHAUM'S OUTLINE SERIES McGRAW-HILL New York St. Louis San Francisco Auckland Bogota Caracas Lisbon London Madrid Mexico City Milan Montreal New Delhi San Juan Singapore Sydney Tokyo Toronto McGraw-Hill abc Copyright © 1997, 1989, 1979, 1961, 1942, 1940, 1939, 1936 by The McGraw-Hill Companies, Inc All rights reserved. Manufactured in the United States of America. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher. 0-07-1367497 The material in this eBook also appears in the print version of this title: 0-07-008941-8. All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such designations appear in this book, they have been printed with initial caps. McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. For more...
Words: 181360 - Pages: 726
...AC14/AT11 Database Management Systems TYPICAL QUESTIONS & ANSWERS PART -I OBJECTIVE TYPE QUESTIONS Each Question carries 2 marks. Choosethe correct or the best alternative in the following: Q.1 Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) Union (B) Intersection (C) Difference (D) Join Ans: (D) Q.2 Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency (C) Isolation (D) Durability Ans: (B) Q.3 Relational Algebra does not have (A) Selection operator. (C) Aggregation operators. (B) Projection operator. (D) Division operator. Ans: (C ) Q.4 Checkpoints are a part of (A) Recovery measures. (C ) Concurrency measures. (B) Security measures. (D) Authorization measures. Ans: (A) Q.5 Tree structures are used to store data in (A) Network model. (B) Relational model. (C) Hierarchical model. (D) File based system. Ans: (C ) Q.6 The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is (A) Procedural DML. (B) Non-Procedural DML. (C) Procedural DDL. (D) Non-Procedural DDL. Ans: (B) Q.7 Precedence graphs help to find a 1 AC14/AT11 Database Management Systems (A) Serializable schedule. (C) Deadlock free schedule. (B) Recoverable schedule. (D) Cascadeless schedule. Ans: (A) Q.8 The rule that a value of a foreign key must appear...
Words: 20217 - Pages: 81
