Premium Essay

Premier Products Normalization

In:

Submitted By sdloadtoad
Words 448
Pages 2
Premiere Products Exercises
The following exercises are based on the Premiere Products database.
1. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.
Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice) )

The functional dependencies are as follows:

PartNum—Description OnHand Class WareHouse Price

OrderNum—OrderDate CustomerNum

CustomerNum—CustomerName RepNum

RepNum—LastName FirstName

PartNum, OrderNum—NumOrdered QuotedPrice

New tables would be as follows:

Part (PartNum, Description, OnHand, Class, Warehouse, Price)

OrderLine (PartNum, OrderNum) NumOrdered, QuotedPrice)

Rep (RepNum, LastName, FirstName)

Customer (CustomerNum, CustomerName, RepNum)

Orders (OrderNum, OrderDate, CustomerNum)

2. List the functional dependencies in the following table that concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions. For a given invoice (identified by the InvoiceNum), there will be a single customer. The customer’s number, name, and complete address appear on the invoice, as does the date. Also, there may be several different parts appearing on the invoice. For each part that appears, display the part number, description, price, and number shipped. Each customer that orders a particular part pays the same price. Convert this table to an equivalent collection of tables that are in third normal form.
Invoice (InvoiceNum, CustomerNum, LastName, FirstName,
Street,

Similar Documents

Premium Essay

Science

...| | | Home | Previous Page | | | | | | | | | | | | UNITED STATES DISTRICT COURT FOR THE SOUTHERN DISTRICT OF NEW YORK SECURITIES AND EXCHANGE COMMISSION, 450 Fifth St., N.W. Washington, D.C. 20549, Plaintiff, v. KPMG LLP, JOSEPH T. BOYLE, MICHAEL A. CONWAY, ANTHONY P. DOLANSKI, RONALD A. SAFRAN and THOMAS J. YOHO Defendant. | ) ) ) ) ) ) ) ) ) ) ) ) ) ) | Civil Action No. 03 CV 0671 (DLC) FIRST AMENDED COMPLAINT SECURITIES FRAUD Jury Trial Demanded | The Securities and Exchange Commission ("the Commission") alleges for its First Amended Complaint as follows:1. Defendants KPMG LLP ("KPMG") and certain KPMG partners permitted Xerox Corporation ("Xerox") to manipulate its accounting practices and fill a $3 billion "gap" between actual operating results and results reported to the investing public from 1997 through 2000. The fraudulent scheme allowed Xerox to claim it met performance expectations of Wall Street analysts, to mislead investors and, consequently, to boost the company's stock price. The KPMG defendants were not the watch dogs on behalf of shareholders and the public that the securities laws and the rules of the auditing profession required them to be. Instead of putting a stop to Xerox's fraudulent conduct, the KPMG defendants themselves engaged in fraud by falsely representing to the public that they had applied professional auditing standards to their review of Xerox's accounting, that Xerox's...

Words: 17525 - Pages: 71

Free Essay

Us China Relationship

...GNlu | US-CHINA RELATIONS | SUBMITTED TO:Dr.Aruna Kumar Malik | | SUBMITTED BY :ABHISHEK CHATTERJEE | REG NO :11A006 INDEX Introduction Pg 2 US China Comparison Pg 3 Brief History Of US-China Relations Pg 5 Conclusion Pg 21 INTRODUCTION Since the dawn of civilization there have been great nations, 5000 years back the Mesopotamian,Egyptian and Indus Valley Civilization were the super-powers,if not the only advanced civilization of their time,2000 years back we had the roman empire and the chineese,500 years back the mughal empire,the ottoman empire etc. The world order keeps on changing, the end of the first world war saw the rise of America along the ranks of other European superpowers like the British Empire,France and Germany and saw the fall of 2 superpowers,the ottoman and the Austria-hungry empire. The second world war ushered the modern world into a new world order. The United Nations was born and its membership suddenly grew. The United States brought about reconstruction of the war torn economies of Europe and Japan and ensured stable democracies for her new allies...

Words: 8393 - Pages: 34

Free Essay

Notes

...1 – Introduction to Computer Concepts History of Computer * Often referred to the different generations of computing devices. * The circuitry is smaller and more advanced than previous generation. * First Generation - 1940-1956: Vacuum Tubes * Often enormous, very expensive, use a great deal of electricity and generate a lot of heat. * E.g., UNIVAC, ENIAC * Second Generation - 1956-1963: Transistors * Computers are smaller, faster, cheaper, more energy-efficient and more reliable. * Third Generation - 1964-1971: Integrated Circuits * Miniaturized Transistors were placed on silicon chips called semiconductors. * Increased speed and efficiency. * Fourth Generation - 1971-Present: Microprocessors * Thousands of Integrated Circuits (IC) were onto a silicon chip. * Computers are more powerful and linked to networks. * Fifth Generation - Present and Beyond: Artificial Intelligence * Uses parallel processing, quantum computation and nano-technology. * Respond to natural language input and capable of learning and self-organization. Computer Literacy * Knowledge and understanding of computers and their uses. Computer * An electronic device that transform input into output. Information Processing Cycle * Is a series of Input, Process, Output and Storage. Components of a Computer * Input, Process, Output, Storage and Communication Computer Systems * It has data inputs, processes that transform data...

Words: 10287 - Pages: 42

Free Essay

Malaysia-China

...Malaysia’s Foreign Policy (DIS 3113) Tun Abdul Razak: Malaysia-China Relationship Normalization Mej Suresh Vijayaratnam TUDM 814114 Mej Razali bin Ahmad Jumali TUDM 8141138 Introduction TUN ABDUL RAZAK’S BIOGRAPHY Tun Abdul Razak was born in Pulau Keladi, Pahang on March 11, 1922 and is the only child to Dato' Hussein bin Mohd Taib and Hajah Teh Fatimah bt Daud. He was a brilliant student and received his early education at the Malay College Kuala Kangsar in 1934. In 1939, Tun Razak joined the Malay Administrative Service. Thereafter in 1940 he was awarded a scholarship to study at Raffles College in Singapore. His studies at the college ceased with the onset of the Second World War. However Tun Razak left for Britain in 1947 to study law with a Malayan Union scholarship at the age of 25. In 1950 he received a Degree of an Utter Barrister from Lincoln's Inn. Tun Razak was a member of the British Labour Party and a prominent student leader of the Kesatuan Melayu Great Britain (Malay Association of Great Britain) during his student days in England. He also shaped the Malayan Forum, an organisation for Malayan students to discuss their country's political issues. Upon his return, he joined the Malayan Civil Service. Tun Razak joined United Malays National Organisation (UMNO) in 1950 he became the youth chief. He worked as the Assistant State Secretary of Pahang and in February 1955 and at a young age of 33 years, Tun Razak became Pahang's Chief Minister. He won...

Words: 5628 - Pages: 23

Premium Essay

Happy

...M I C R O S O F T T E C H N O L O G Y A S S O C I AT E Student Study Guide EXAM 98-364 Database Administration Fundamentals Preparing for MTA Certification for Cert ca n Certification MICROSOFT TECHNOLOGY ASSOCIATE (MTA TECHNOLOGY ASSOCIATE (MTA) ECHNOLOGY C (MTA A) STUDENT STUDY GUIDE FOR DEVELOPERS UDY F DEVELOPERS 98-364 Database Administration Fundamentals Authors Peggy Fisher (Web Development and Database Administration). Peggy teaches computer science at a rural high school in central, Pennsylvania. Indian Valley High School offers courses in programming (C#, VB, and Java for the AP course), and Web design (Expression Web, HTML, JavaScript, and CSS). Peggy worked for a large insurance company outside Philadelphia, Pennsylvania, prior to leaving the corporate world to join the field of education. She has been at IVHS for the past eight years and truly enjoys her new career. Peggy also teaches part-time at Pennsylvania State University in the Continuing Education program. Her goal in teaching is to instill the love of learning so that her students will graduate and become lifelong learners. Peggy is the co-author of the Web Development Exam Review Kit in the MTA Exam Review Kit series. Patricia Phillips (Lead Author and Project Manager). Patricia taught computer science for 20 years in Janesville, Wisconsin. She served on Microsoft’s National K-12 Faculty Advisory Board and edited the Microsoft MainFunction website for technology teachers for two years...

Words: 11425 - Pages: 46

Premium Essay

Customer Satisfaction in Banks

...INTRODUCTION In the organized segment, banking system occupies an important place in nation’s economy. It plays a pivotal role in the economic development of a country and forms the core of the money market in an advanced country. The commercial banks in India comprise of both Public sector as well as private sector banks. There are total 28 Public sector and 27 private sector banks are functioning in the country presently. Banks have to deal with many customers everyday and render various types of services to its customer. It’s a well known fact that no business can exist without customer. Customer satisfaction, a business term, is a measure of how products and services supplied by a company meet or surpass customer expectation. It is seen as a key performance indicator within business. In a competitive marketplace where businesses compete for customers, customer satisfaction is seen as a key differentiator and increasingly has become a key element of business strategy. Customer satisfaction is unambiguous and abstract concept and the actual manifestation of the state of satisfaction will vary from person to person and service to service. The state of satisfaction depends on a number of both psychological and physical variables. BANKING INDUSTRY: AN OVERVIEW For centuries banks have played an important role in financial system of the country. The vital role continues even today although the form of banking has changed today with changing need of the economy and individuals...

Words: 10253 - Pages: 42

Free Essay

China vs Taiwan

...April 23, 1999 Policy Consideration by the NATIONAL SECURITY COUNCIL On US POLICY TOWARDS THE POTENTIAL QUESTION OF INDEPENDENCE OF THE REPUBLIC OF CHINA, TAIWAN POLICY CONSDERATION History of the Republic of China, past and present In December 1978, the representative of China in the United Nations, the Republic of China, Taiwan was asked to leave the UN. Taiwan had to give up its seat in the UN Security Council as a permanent member and in the UN General Assembly. This is due to the US’s recognition of communist China, the Peoples’ Republic of China. Ever since 1949, both Chinas, have claimed be the legal government of China. Until 1992, both states were in a state of war ever since the nationalists Kuomintang were exiled to Taiwan. Since then, the US has pledged the security of Taiwan in the event of a communist China invasion by the People’s Liberation Army. As a result of this, the PRC has refrained from invading Taiwan because of US involvement. What this policy paper will address is the potential conflict that will occur if Taiwan declares itself as an independent state. The Republic of China, Taiwan is situated on an island called Formosa. It was settled by the Chinese in the 17th Century and saw early colonial rule of the Dutch between 1620 to 1662, when it reverted back to Imperial Chinese rule. Between 1845 and 1945, the island of Formosa also saw Imperial Japanese rule. At the end of World War Two in 1945, the nationalist...

Words: 3004 - Pages: 13

Premium Essay

Accounting Information Systems: Course Objectives, Description, Topics, and Assignments

...ACCOUNTING INFORMATION SYSTEMS: COURSE OBJECTIVES, DESCRIPTION, TOPICS, AND ASSIGNMENTS ACCT-5600 DR. NICOLAOU Fall 2010 COURSE STRUCTURE In the modern world, the majority of accounting entries occur electronically. Accountants and auditors store information in databases, managed by enterprise systems that have a set of controls to ensure that transactions and record keeping happen as expected. E-business Web sites handle transactions automatically, with the accounting data going directly into the necessary databases. The concept of a paper trail has become a bit of a misnomer; today, because of accounting information systems, there is often no paper involved at all; however, it is important to establish the flow the data in different areas of the organization, or audit trail, so as to properly exercise internal controls. AISs help in this purpose. At the outset of this course, you will learn the basics of accounting information systems and business processes. Next, you will learn about database management systems, and the design of various database models. Finally, you will learn about how to use internal controls effectively for risk management, as well as the requirements for business reporting. After completing this course, you should not only have a clear idea of how accounting information systems work, but you should also be prepared to design and configure them to meet the record-keeping and risk management requirements of the organization. In addition...

Words: 6838 - Pages: 28

Premium Essay

Modern Russian Foreign Policy

...Modern Russian Foreign Policy In the 20 years since the fall of communism, Russia has seen tumultuous times. In a relatively short period of time, a former world superpower has suffered through dramatic changes – some positive, and some painful. The 1980s ultimately brought about the fall of communist U.S.S.R, the 1990s showed the world the phoenix-like rise of democracy from the ashes of communism, and the 2000s have now shown us the rise of autocracy, or “sovereign democracy” , wrapped in a Russian flag. The Russian state that enters into this new decade is an entirely different state than that of its communist, or even democratic, predecessors. Such quick, drastic changes and Western inexperience in dealing with Russia’s new form of democracy has left Western governments sometimes scrambling to find a proper response to the actions of a Russia which they do not understand. The foreign policy and resulting actions of 21st century Russia are often misinterpreted by Western powers as those of a belligerent and sometimes antagonistic state. Western media also often does not understand and does not accurately convey Russia’s foreign policy goals to the public, sometimes deciding to demonize Russia and capitalize on the fact that much of the Western populace sees little distinction between the actions of modern Russia and those of the Soviet Union. Miscalculated Western foreign policy leads to nearly the same situation inside of Russia, where an antagonistic West can only...

Words: 3079 - Pages: 13

Premium Essay

Edumentor

...STRATEGIES AND MEASURING THE EFFECTIVENESS OF DIRECT MARKETING ALONG WITH STUDENT’S PREFRENCES FOR ENTRANCE EXAM PREPARATION AT EduMENTOR COMPANY NAME: EduMENTOR EDUCATIONAL SERVICES UNDER GUIDANCE OF Prof.Dr.Y Malini Reddy SUBMITTED BY: NAME: Eshita Miglani ENROLLMENT ID: 09BSHYD0272 CONTACT NO.: 09910436436 EMAIL ID: eshitamiglani@yahoo.co.in ABSTRACT The project focuses on the various business operations that an organization, relating to the field of educational services undertakes, that help them build an identity for themselves in the niche marketing that they are catering to. In presence of immense competition, the major part of the study comprises of the detailed study of areas that not only improve and develop the product of the company but also help them reach a wider target audience. The business model of Edumentor has immense growth potential in the future, keeping in mind the recessionary periods. Hence, a study on organizational development of Edumentor and its various operations is the most prudent thing to do. In all, the study will encompass all functional areas of the organization. The project has been broken down into various phases for better understanding and segregation of work and operations undertaken   ACKNOWLEDGEMENT The project I had undertaken required a lot of information gathering and guidance which has been provided by various people at various stages of the project. For this purpose, I would like to thank the Head of...

Words: 12857 - Pages: 52

Premium Essay

Sql Book

...Edition Philip J. Pratt, Mary Z. Last Vice President, Publisher: Jack Calhoun Editor-in-Chief: Alex von Rosenberg Senior Acquisitions Editor: Charles McCormick, Jr. Product Manager: Kate Hennessy Development Editor: Jessica Evans Editorial Assistant: Bryn Lathrop Marketing Director: Brian Joyner Marketing Manager: Bryant Chrzan Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Project Manager: Matt Hutchinson Art Director: Stacy Jenkins Shirley, Marissa Falco Cover Designer: Joseph Sherman Cover Image: Getty Images/Taxi/Chris Bell Manufacturing Coordinator: Denise Powers © 2009 Course Technology, Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright hereon may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher. For product information and technology assistance, contact us at Cengage Learning Customer & Sales Support, 1-800-354-9706 For permission to use material from this text or product, submit all requests online at www.cengage.com/permissions Further permission questions can be emailed to permissionrequest@cengage.com ISBN-13: 978-0-324-59768-4...

Words: 48772 - Pages: 196

Free Essay

China Fragile Superpower

...China Fragile Superpower This page intentionally left blank Fragile Superpower Susan L. Shirk China 2007 Oxford University Press, Inc., publishes works that further Oxford University’s objective of excellence in research, scholarship, and education. Oxford New York Auckland Cape Town Dar es Salaam Hong Kong Karachi Kuala Lumpur Madrid Melbourne Mexico City Nairobi New Delhi Shanghai Taipei Toronto With offices in Argentina Austria Brazil Chile Czech Republic France Greece Guatemala Hungary Italy Japan Poland Portugal Singapore South Korea Switzerland Thailand Turkey Ukraine Vietnam Copyright © 2007 by Susan L. Shirk Published by Oxford University Press, Inc. 198 Madison Avenue, New York, NY 10016 www.oup.com Oxford is a registered trademark of Oxford University Press All rights reserved. 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, or otherwise, without the prior permission of Oxford University Press. Library of Congress Cataloging-in-Publication Data Shirk, Susan L. China: fragile superpower / by Susan L. Shirk. p. cm. Includes bibliographical references and index. ISBN 978-0-19-530609-5 1. Nationalism—China. 2. China—Politics and government—2002– I. Title. JC311.S525 2007 320.951—dc22 2006027998 135798642 Printed in the United States of America on acid-free paper For Sam, Lucy, and David Popkin This page intentionally left...

Words: 135807 - Pages: 544

Premium Essay

Excellence in Financial Management

...Part 1 of this course, we learned that competitive intelligence relies on a very analytical process to transform data and information into intelligence. We also understand that competitive intelligence is not just about studying the competition, but studying the entire external landscape - customers, suppliers, regulators, and all forces that impact the organization. Therefore, our analysis must be very broad in scope. The primary output from competitive intelligence is the ability to make forward-looking decisions. For example, Jack Welch, former CEO of General Electric determined strategy based on key intelligence questions: What is the detailed global position of your business and that of your competitors: market shares, strengths by product line, and by region today? What actions have your competitors taken in the past two years that have changed the competitive landscape? What are you most afraid your competitors might do in the next two years to change the landscape? “If the defining goal of modern day business can be isolated to just one item, it would be the search for competitive advantage. And, as everyone in business knows, it’s a lot harder...

Words: 12266 - Pages: 50

Free Essay

Sona 2015 Pnoy

...THE 2015 STATE OF THE NATION ADDRESS TECHNICAL REPORT Prepared by: The Office of the President of the Philippines TABLE OF CONTENTS TRANSPARENT, ACCOUNTABLE, AND PARTICIPATORY GOVERNANCE 1. Institutionalized Public Accountability .............................................................. 1 2. Upheld Transparency and Citizen Engagement in Government .................... 11 RAPID, INCLUSIVE, AND SUSTAINED ECONOMIC GROWTH 1. Sustained Strong and Broad-Based Economic Growth ................................. 14 2. Increased Opportunities for Employment and Economic Activity .................. 24 POVERTY REDUCTION AND EMPOWERMENT OF THE POOR AND VULNERABLE 1. Invested in the Filipino Workforce for Decent and Productive Work .............. 44 2. Sustained Equitable Access to Affordable and Quality Health Care .............. 50 3. Empowered the Poor and Marginalized towards Self-Reliance ..................... 56 JUST AND LASTING PEACE AND THE RULE OF LAW 1. Protected our National Territory and Boundaries........................................... 61 2. Ensured Public Order and Safety .................................................................. 64 3. Pursued Efforts for Peace and Development in Mindanao ............................ 68 4. Advanced and Protected Human Rights ........................................................ 71 5. Reformed the Justice Sector ......................................................................... 76 INTEGRITY...

Words: 48288 - Pages: 194

Free Essay

Hist

...Deng Xiaoping and the Transformation of China Ezra F. Vogel REFERENCES American Rural Small-Scale Industry Delegation. Rural Small-Scale Industry in the People’s Republic of China. Berkeley: University of California Press, 1977. Atkinson, Richard C. “Recollection of Events Leading to the First Exchange of Students, Scholars, and Scientists between the United States and the People’s Republic of China,” 4 pp. Bachman, David. “Differing Visions of China’s Post-Mao Economy: The Ideas of Chen Yun, Deng Xiaoping, and Zhao Ziyang,” Asian Survey, 26, no. 3 (March 1986), 293-321. Bachman, David. “The Fourteenth Congress of the Chinese Communist Party.” New York: Asia Society, 1992. Bachman, David. “Implementing Chinese Tax Policy.” In Lampton, ed., Policy Implementation in Post-Mao China, pp. 119-153. Backhouse, E. and J.O.P. Bland. Annals & Memoirs of the Court of Peking. Boston: Houghton Mifflin, 1914. Bainian chao (百年潮) (Hundred Year Tide). Monthly. Beijing: Zhongguo zhonggong dangshi xuehui, 1997 -- . Barfield, Thomas J. Perilous Frontier: Nomadic Empires and China. Cambridge: Basil Blackwell, 1989. Barman, Geneviève Barman and Nicole Dulioust. “Les années Françaises de Deng Xiaoping,” Vingtième Siècle: Revue d’histoire, no. 20 (October-December 1988), 17-34. Barman, Geneviève and Nicole Dulioust. “The Communists in the Work and Study Movement in France,” Republican China, 13, no. 2 (April 1988), 24-39. Barnett, A. Doak, with a contribution...

Words: 14725 - Pages: 59