...1 INTRODUCTION SQL is divided into the following Data Definition Language (DDL) Data Manipulation Language (DML) Data Retrieval Language (DRL) Transaction Control Language (TCL) Data Control Language (DCL) DDL -- create, alter, drop, truncate, rename DML -- insert, update, delete DRL -- select TCL -- commit, rollback, savepoint DCL -- grant, revoke CREATE TABLE SYNTAX Create table (col1 datatype1, col2 datatype2 …coln datatypen); Ex: SQL> create table student (no number (2), name varchar (10), marks number (3)); INSERT This will be used to insert the records into table. We have two methods to insert. a) By value method By address method USING VALUE METHOD Syntax: insert into (table_name) values (value1, value2, value3 …. Valuen); © Copy rights are reserved. 2 Ex: SQL> insert into student values (1, ’sudha’, 100); SQL> insert into student values (2, ’saketh’, 200); To insert a new record again you have to type entire insert command, if there are lot of records this will be difficult. This will be avoided by using address method. b) USING ADDRESS METHOD Syntax: insert into (table_name) values (&col1, &col2, &col3 …. &coln); This will prompt you for the values but for every insert you have to use forward slash. Ex: SQL> insert into student values (&no, '&name', &marks); Enter value for no: 1 Enter value for name: Jagan Enter value for marks: 300 old new ...
Words: 42387 - Pages: 170
...Objectives Capital market, being an essential element of today’s economy, demands an intensive and special attention. The objective of this study is to look into every aspect of Bangladesh capital market and identify its various pros and cons along with some recommendations to overcome the existing problems. The specific objectives of this study are: To give an overall idea about the capital market-its structures, functions, importance, etc. To identify the current situations of our capital market of Bangladesh. To compare the relative conditions of Bangladesh capital market to other countries of the world. To sort out the problems associated with our capital market. To suggest some practicable solutions to these problems. - Page | 1 - 1 Ch[pt_r 1 Secondary data and information were used in preparing this seminar paper, and these were collected through teamwork by adopting the following processes: ■ Visiting in person, the following organizations and respective key personnel: Dhaka Stock Exchange (DSE) Dhaka Chamber of Commerce (DCC) Bangladesh Bank (BB) Monetary Policy Department (MPD), BB ■...
Words: 10549 - Pages: 43
...edu. California Law Review VOL. 57 JANUARY 1969 Copyright © 1969 by California Law Review, Inc. No. 1 The Legal Roles of Shareholders and Management in Modern Corporate Decisionmaking Melvin Aron Lisenberg* TABLE OF CONTENTS I A GENERAL THEORY ...... A. ... ............... 4 A NORMATIVE MODEL OF'VOTING RIGHTS IN PRIVATELY HELD CORPORATIONS ....... ................ A NORMATIVE MODEL OF VOTING RIGHTS IN PUBLICLY HELD ................ CORPORATIONS ....... 7 15 B. . ........ 1. Considerations of Public Policy .. (a) "Shareholder democracy ". . .. ........ ... . ......... (b) Client-group participation .. (c) Managerialism ..... ........... . ........ 2. Managerial Conflicts of Interest .. .. ........... 3. Shareholder Expectations ... ............ (a) The AT&T myth .... ... .... (b) The fallacy of "the average shareholder" (i) The proprietary principle of corporate law . (ii) Institutional investors as shareholders in publicly .......... held corporations ... (A) The magnitude of institutional shareholdings (B) The...
Words: 89092 - Pages: 357
...Data of Phas-II Sr no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 NAME Abdul Hafeez Abu Bakar Siddique Awais Munir Basharat Mahboob Maroof Ilyas Mazhar Iqbal Miss Ayesha Ch. Miss Fariha Iftikhar Miss Kashaf Yaseen Miss Ujala Ashraf Muhammad Abdullah Waleed Muhammad Aftab Muhammad Essa Khalid Muhammad Khalid Hameed Muhammad Maqsood Khan Muhammad Shoaib Muhammad Waqar Murzooq Saleem Noor Nauman Altaf Roman Majeed Syed Ahmad Hassan Bukhari Waqar Ali Zain Qayyum Abdul Ghaffar ABDUL REHMAN Abdul Rehman ABDUL SHAKOOR Abrar Anwar ABRAR JAMIL ADEEL AHMED ADEEL IRSHAD ADNAN SHAUKAT Aftab Shaukat Ahmed Zeeshan Ahsan Mahmud AIMEN BASHIR ALI AUN ALI EHSAN MANJ ALI EJAZ ALI HAMED ALI MEHBOOB ALI USMAN BASHIR Allah Ditta Shahid Ameer Hamza ANAM ALVI ANAM MOOSA Anam Ullah Aneel Shahzad ANUM INTISAR ANUM JAVED ARSLAN RAZZAQ CNIC 3310226618167 3310114158887 3530374620369 3830212044729 3310246045471 3640282454573 3310068099318 3310208917468 3430126117362 3110248981000 3660180459853 3660119940117 3210224181181 3310054615453 3660215126755 3430288411671 3310221134839 3310286092337 3310267032475 3330104275587 3130374936045 3530220857361 3310031746769 3520130546281 3540489657861 3230412338735 3310206565785 3310425262179 3510288617907 3310002339509 3310271578631 3310330195673 3410434351359 3310694673473 3310266881555 3310094300496 3550103015009 3410316103425 3410254910063 3640240257955 3310280974795 3310365417863...
Words: 32408 - Pages: 130
...Yinzhi Miao Oversea Listing and State-Owned-Enterprise Governance in China: the Role of the State LL.M. Long Paper Harvard Law School Supervised by Prof. Reinier Kraakman and Mark Roe April 2012 Oversea Listing and State-Owned-Enterprise Governance in China: the Role of the State Yinzhi Miao Abstract: There are both considerate horizontal and vertical governance problems in the Chinese state-owned-enterprises (SOEs). Due to their privileged positions in the political economy, traditional institutions of corporate governance are far from perfect. Thus the value of oversea listing as a governance mechanism is highlighted, and that could be better revealed by a deeper analysis of the benefit-and-cost balance by the government which controls the SOEs. However, effective as it is, oversea listing could not be a marvelous antidote to all governance ills. Further, as the two major governance disasters of oversea listed SOEs shows, if the government lacks a proper self-positioning, nontrivial negative implications will be brought to SOEs governance via oversea listing. The ultimate function of corporate governance in SOEs thus relies heavily on public governance. Key words: state-owned-enterprises, oversea listing, corporate China governance, 2 Table of contents I. Introduction ....................................................................................................................4 II. The Governance problems of Chinese SOEs and the limitations of...
Words: 30398 - Pages: 122
...Scholarship Repository University of Minnesota Law School Articles Faculty Scholarship 1988 Discovery in Labor Arbitration Laura J. Cooper University of Minnesota Law School, lcooper@umn.edu Follow this and additional works at: http://scholarship.law.umn.edu/faculty_articles Part of the Law Commons Recommended Citation Laura J. Cooper, Discovery in Labor Arbitration, 72 Minn. L. Rev. 1281 (1988), available at http://scholarship.law.umn.edu/ faculty_articles/307. This Article is brought to you for free and open access by the University of Minnesota Law School. It has been accepted for inclusion in the Faculty Scholarship collection by an authorized administrator of the Scholarship Repository. For more information, please contact lenzx009@umn.edu. Discovery in Labor Arbitration Laura J.Cooper* The mere statement of the topic, discovery in labor arbitration, suggests a paradox. Is not the essence of the arbitration process an effort to avoid the procedural complexities that make litigation comparatively slow and costly? More than forty years ago, Learned Hand admonished a litigant distressed with the procedural failings of an arbitration proceeding: Arbitration may or may not be a desirable substitute for trials in courts; as to that the parties must decide in each instance. But when they have adopted it, they must be content with its informalities; they may not hedge it about with those procedural limitations which it is precisely its purpose...
Words: 22162 - Pages: 89
...SECOND EDITION I/1ANAGEMEIVT AND POLICY James C.Van Horne \ STANFORD UNIVERSITY PRENTICE-HALL INC., ENGLEWOOD CLIFFS, NEW JERSEY F I NANCI AL M A N A G E M E N T A N D POLICY, 2nd EDITION James C. Van Horne © 1971, 1968 by PRENTICE-HALL, INC., ENGLEW O O D CLIFFS, N.J. All rights reserved. No part of this book m ay be reproduced in any form or by any m eans without permission in writing from the publishers. Library of Congress C atalo g C ard No.: 71-140760 Printed in the United States of America Current Printing (last digit): 1 0 9 8 7 6 5 4 3 2 13-315309-6 PRENTICE-HALL, INTERNATIONAL, LONDON PRENTICE-HALL OF AUSTRALIA PTY. LTD., SYD NEY PRENTICE-HALL O F CAN AD A, LTD., TO RONTO PRENTICE-HALL OF INDIA PRIVATE LTD., NEW DELHI PRENTICE-HALL OF JAPAN, INC., TO KYO 1 To Mimi, D rew , Stuart, and Stephen Preface Though significant portions of Financial Management and Policy have been changed in this revision, its purpose remains: first, to develop an understanding of financial theory in an organized manner so that the reader may evaluate the firm’s investment, financing, and dividend deci sions in keeping with an objective of maximizing shareholder wealth; second, to become familiar with the application of analytical techniques to a number o f areas o f financial decision-making; and third, to expose the reader to the institutional material necessary to give him a feel for the environment in which financial...
Words: 230115 - Pages: 921
...1 1 Fundamentals of Semiconductor Electrochemistry and Photoelectrochemistry Krishnan Rajeshwar The University of Texas at Arlington, Arlington, Texas 1.1 1.2 1.3 1.3.1 1.3.2 1.3.3 1.3.4 1.4 1.4.1 1.4.2 1.4.3 1.5 1.5.1 1.5.2 1.5.3 1.5.4 1.5.5 1.6 1.7 1.7.1 1.7.2 1.7.3 1.7.4 1.7.5 Introduction and Scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Electron Energy Levels in Semiconductors and Energy Band Model . The Semiconductor–Electrolyte Interface at Equilibrium . . . . . . . . The Equilibration Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The Depletion Layer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Mapping of the Semiconductor Band-edge Positions Relative to Solution Redox Levels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Surface States and Other Complications . . . . . . . . . . . . . . . . . . . Charge Transfer Processes in the Dark . . . . . . . . . . . . . . . . . . . . Current-potential Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . Dark Processes Mediated by Surface States or by Space Charge Layer Recombination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Rate-limiting Steps in Charge Transfer Processes in the Dark . . . . . Light Absorption by the Semiconductor Electrode and Carrier Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Light Absorption...
Words: 180197 - Pages: 721
...CHENNAI CHENNAI TAMIL NADU ICIC0000002 560229002 BANGALORE - M G ROAD ICICI BANK LTD TOWERS, 1, COMMISSARIAT ROAD, GROUND FLOOR, BANGALORE 560025. BANGALORE BANGALORE URBAN KARNATAKA ICIC0000003 390229002 VADODARA LANDMARK BUILDING, RACE COURSE CIRCLE, ALKAPURI, VADODARA. 390007 VADODARA VADODARA GUJARAT ICIC0000004 400229002 MUMBAI GREATER MUMBAI MAHARASHTRA ICIC0000005 411229002 PUNE - BUND GARDEN A-WING, SHANGRILA GARDENS, BUND GARDEN ROAD, PUNE. 411001 PUNE PUNE MAHARASHTRA ICIC0000006 700229002 KOLKATA - R N MUKHERJEE (RETAIL) 22, R N MUKHERJEE ROAD, KOLKATA. 700001 KOLKATA KOLKATA WEST BENGAL MUMBAI - NARIMAN 215, FREE PRESS HOUSE, FREE PRESS MARG, POINT NARIMAN POINT, MUMBAI. 400021 Page 1 ICICI BANK IFSC CODES IFSC CODE MICR CODE BRANCH NAME ADDRESS CITY DISTRICT STATE ICIC0000007 110229002 NEW DELHI CONNAUGHT PLACE 9A, PHELPS BUILDING, INNER CIRCLE,CONNAUGHT PLACE, NEW DELHI. 110001 NEW DELHI NEW DELHI DELHI ICIC0000008 500229002 HYDERABAD KHAIRATABAD 6-2-1012, TGV MANSIONS, OPP. INSTITUTION OF ENGINEERS, KHAIRATABAD, HYDERABAD. 500004 HYDERABAD HYDERABAD URBAN ANDHRA PRADESH ICIC0000009 600229003 CHENNAI NUNGAMBAKKAM 110, PRAKASH PRESIDIUM, UTHAMAR GANDHI SALAI, (NUNGAMBAKKAM HIGH ROAD), CHENNAI. 600034 CHENNAI CHENNAI TAMIL NADU ICIC0000010 ...
Words: 120257 - Pages: 482
...THE INTELLIGENT INVESTOR A BOOK OF PRACTICAL COUNSEL REVISED EDITION B E NJAM I N G RAHAM Updated with New Commentary by Jason Zweig To E.M.G. Through chances various, through all vicissitudes, we make our way. . . . Aeneid Contents Epigraph iii Preface to the Fourth Edition, by Warren E. Buffett viii A Note About Benjamin Graham, by Jason Zweig x Introduction: What This Book Expects to Accomplish COMMENTARY ON THE INTRODUCTION 1. 1 12 35 The Investor and Inflation 47 COMMENTARY ON CHAPTER 2 3. 18 COMMENTARY ON CHAPTER 1 2. Investment versus Speculation: Results to Be Expected by the Intelligent Investor 58 65 COMMENTARY ON CHAPTER 3 4. A Century of Stock-Market History: The Level of Stock Prices in Early 1972 80 General Portfolio Policy: The Defensive Investor 88 COMMENTARY ON CHAPTER 4 5. 101 124 Portfolio Policy for the Enterprising Investor: Negative Approach 133 COMMENTARY ON CHAPTER 6 7. 112 COMMENTARY ON CHAPTER 5 6. The Defensive Investor and Common Stocks 145 iv 155 COMMENTARY ON CHAPTER 7 8. Portfolio Policy for the Enterprising Investor: The Positive Side 179 The Investor and Market Fluctuations 188 v Contents COMMENTARY ON CHAPTER 8 9. Investing in Investment Funds COMMENTARY ON CHAPTER 9 213 226 242 10. The Investor and His Advisers 257 COMMENTARY ON CHAPTER 10 272 11. Security...
Words: 224262 - Pages: 898
...FACULTAD DE GESTIÓN Y ALTA DIRECCIÓN TDC TALENT DEVELOPMENT CONSULTING CONSULTORA DE RECURSOS HUMANOS Tesis presentada para obtener el Título Profesional de Licenciado en Gestión Empresarial por Diestra Mejía, Miguel Ángel 20058040 Espinoza Delgado, Lizeth Maryuri 20023064 Liao López, Remo Alonso 20051160 Portocarrero Guerra, Cinthya Lissette 20064665 Lima, 16 de Julio de 2012 i Esta tesis TDC – Consultora de Recursos Humanos ha sido aprobada. ___________________________________ [Presidente del Jurado] ___________________________________ [Asesor de la Tesis] ___________________________________ [Jurado] ii FACULTAD DE GESTIÓN Y ALTA DIRECCIÓN A mi madre por su amor y paciencia, a mi padre por su motivación y consejos, a mi hermano Marco por su carisma, a Heffer por su compañía, a mi familia por su apoyo y a mis amigos por las alegrias. Miguel Ángel Diestra Mejía A Dios por permitirme llegar a este momento tan especial en mi vida. A mis padres Lorenzo y Manuela por su abnegacion y amor. A mi hermano Alex y a toda mi familia por su apoyo incondicional. A Fernando con amor por su apoyo y compañia. Lizeth Maryuri Espinoza Delgado A Dios, a mi madre, a mis tios Manuel, Gloria, Teresa y José Luis y a mi familia, por su amor, su apoyo, su esfuerzo, su sabiduría y la confianza que depositaron en mí. Remo Alonso Liao López A Dios por brindarme la fortaleza para seguir adelante. A mis padres Jaime y César ...
Words: 44305 - Pages: 178
...permission in writing from the publisher. Permissions may be sought directly from Elsevier’s Science & Technology Rights Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333, E-mail: permissions@elsevier.com. You may also complete your request on-line via the Elsevier homepage (http:/ /elsevier.com), by selecting “Support & Contact” then “Copyright and Permission” and then “Obtaining Permissions.” Library of Congress Cataloging-in-Publication Data Gharajedaghi, Jamshid. Systems thinking : managing chaos and complexity : a platform for designing business architecture / Jamshid Gharajedaghi. p. cm. Includes bibliographical references and index. ISBN 0-7506-7163-7 (alk. paper) 1. System analysis. 2. Chaotic behavior in systems. 3. Industrial management. 4. Technological complexity. I. Title. T57.6.G52 1999 003—dc21 98-55939 British Library Cataloguing-in-Publication Data A catalogue record for this book is available from the British Library. ISBN 13:...
Words: 116913 - Pages: 468
...NATIONAL STOCK EXCHANGE OF INDIA LIMITED Test Details: Sr. No. 1 2 3 4 5 6 7 8 9 10 11 12 13 Name of Module Fees (Rs.) Test Duration (in minutes) 120 120 120 120 120 120 105 105 120 120 120 120 120 No. of Questions 60 60 60 60 60 60 60 60 60 60 60 60 100 Maximum Marks 100 100 100 100 100 100 100 100 100 100 100 100 100 Pass Certificate Marks Validity (%) (in years) 50 50 50 50 50 50 60 50 60 60 60 60 50 5 5 5 5 5 5 5 5 3 5 5 3 3 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Financial Markets: A Beginners’ Module * 1500 Mutual Funds : A Beginners’ Module 1500 Currency Derivatives: A Beginner’s Module 1500 Equity Derivatives: A Beginner’s Module 1500 Interest Rate Derivatives: A Beginner’s 1500 Module Commercial Banking in India: A Beginner’s 1500 Module Securities Market (Basic) Module 1500 Capital Market (Dealers) Module * 1500 Derivatives Market (Dealers) Module * 1500 FIMMDA-NSE Debt Market (Basic) Module 1500 Investment Analysis and Portfolio 1500 Management Module NISM-Series-I: Currency Derivatives 1000 Certification Examination 1000 NISM-Series-II-A: Registrars to an Issue and Share Transfer Agents – Corporate Certification Examination NISM-Series-II-B: Registrars to an Issue and 1000 Share Transfer Agents – Mutual Fund Certification Examination NISM-Series-IV: Interest Rate Derivatives 1000 Certification Examination NISM-Series-V-A: Mutual Fund Distributors 1000 Certification Examination * NISM-Series-VI: Depository Operations 1000 Certification Examination...
Words: 108326 - Pages: 434
...MODERN DATABASE MANAGEMENT / JfFFREY A. HOFFER . Warehousing Success 426 Data Warehouse Architectures 428 Generic Two-Level Architecture 428 Independent Data Mart Data Warehousing Environment 426 429 C O NTENTS Dependent Data Mart and Operational Data Store Architecture: A Three-Level Approach Logical Data Mart and Real-Time Data Warehouse Architecture 432 Three-Layer Data Architecture 435 Role of the Enterprise Data Model 435 Role of Metadata 436 Some Characteristics of Data Warehouse Data Status Versus Event Data 437 Transient Versus Periodic Data 438 An Example of Transient and Periodic Data 438 Transient Data 438 Periodic Data 439 Other Data VVarehouse Changes 440 The Reconciled Data Layer 441 Characteristics of Data after ETL 441 The ETL Process 442 Extract 442 Cleanse 444 Load and Index 446 Data Transformation 447 Data Transformation Functions 448 Record-Level Functions 448 Field-Level Functions 449 More Complex Transformations 451 Tools to Support Data Reconciliation 451 Data Quality Tools 451 Data Conversion Tools 452 Data Cleansing Tools 452 Selecting Tools 452 The Derived Data Layer 452 Characteristics of Derived Data 452 The Star Schema 453 Fact Tables and Dimension Tables 453 Example Star Schema 454 Surrogate Key 455 Grain of Fact Table 456 Duration of the Database 456 Size of the Fact Table 457 Modeling Date and Time 458 Variations of the Star Schema 458 Multiple Fact Tables 458 Factless Fact Tables...
Words: 80097 - Pages: 321
...THE PDMA HANDBOOK OF NEW PRODUCT DEVELOPMENT T HIRD E DITION Kenneth B. Kahn, Editor Associate Editors: Sally Evans Kay Rebecca J. Slotegraaf Steve Uban JOHN WILEY & SONS, INC. Cover image: © Les Cunliffe/iStockphoto Cover design: Elizabeth Brooks This book is printed on acid-free paper. Copyright © 2013 by John Wiley & Sons, Inc. All rights reserved Published by John Wiley & Sons, Inc., Hoboken, New Jersey Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 7486008, or online at www.wiley.com/go/permissions. Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with the respect to the accuracy or completeness of the contents of...
Words: 165678 - Pages: 663
