Premium Essay

Csc 352 / 452: Database Programming

In: Business and Management

Submitted By Laynebaril
Words 334
Pages 2
CSC 352 / 452: DATABASE PROGRAMMING
ASSIGNMENT #3 Click Link Below To Buy:

http://hwcampus.com/shop/csc-352-452-database-programming/

Please note that only TEXT files will be accepted. All other file types (e.g., DOC, DOCX, RTF, PDF, JPG, or ZIP) will be rejected. In D2L, only the most recent submission is kept.

• If you modified the DEPARTMENT and EMPLOYEE tables created in Assignment #1, you need to delete and re-populate them.
• Do not try to use complicated queries/cursors (e.g., joins) to get the results. You can use multiple PL/SQL statements to get the results easily.
• You cannot use hard-coded values (e.g., IF department_name = 'MARKETING' THEN ……) in your programs.
• You are not allowed to create temporary tables, views, functions, or procedures.
• The EXCEPTION section is NOT allowed in your programs.
• Please review your assignment file before submitting it to make sure you have the correct one. It is your responsibility to ensure that you upload the correct assignment file.
1) (CSC 352 – 25 Points | CSC 452 – 15 Points)

The table popular_names consists of some popular given names for male and female babies born during the years 1915-2014. Rank 1 is the most popular, rank 2 is the next most popular, and so forth.

2) (CSC 352 – 35 Points | CSC 452 – 20 Points)

Based on the tables created in Assignment #1, write a PL/SQL anonymous block to perform the following tasks:

• Display the number of employees in the company.
• Display the maximum/minimum/average salary for the company.
• Display 50% of the maximum salary for the company.
• For each department whose average salary is greater than 50% of the maximum salary for the company, display the name of the department, the number of employees in the department, and the maximum/minimum/average salary for the department.

3) (CSC 452 only – 25 points)

Similar Documents

Premium Essay

Csc 352 / 452: Database Programming Assignment #3

...CSC 352 / 452: DATABASE PROGRAMMING ASSIGNMENT #3 Click Link Below To Buy: http://hwcampus.com/shop/csc-352-452-database-programming/ Please note that only TEXT files will be accepted. All other file types (e.g., DOC, DOCX, RTF, PDF, JPG, or ZIP) will be rejected. In D2L, only the most recent submission is kept. • If you modified the DEPARTMENT and EMPLOYEE tables created in Assignment #1, you need to delete and re-populate them. • Do not try to use complicated queries/cursors (e.g., joins) to get the results. You can use multiple PL/SQL statements to get the results easily. • You cannot use hard-coded values (e.g., IF department_name = 'MARKETING' THEN ……) in your programs. • You are not allowed to create temporary tables, views, functions, or procedures. • The EXCEPTION section is NOT allowed in your programs. • Please review your assignment file before submitting it to make sure you have the correct one. It is your responsibility to ensure that you upload the correct assignment file. 1) (CSC 352 – 25 Points | CSC 452 – 15 Points) The table popular_names consists of some popular given names for male and female babies born during the years 1915-2014. Rank 1 is the most popular, rank 2 is the next most popular, and so forth. 2) (CSC 352 – 35 Points | CSC 452 – 20 Points) Based on the tables created in Assignment #1, write a PL/SQL anonymous block to perform the following tasks: • Display the number of employees in the company. • Display...

Words: 334 - Pages: 2

Premium Essay

Cataolog

...ork2012 - 2013 Catalog A Message from the President “Sullivan University is truly a unique and student success focused institution.” I have shared that statement with numerous groups and it simply summarizes my basic philosophy of what Sullivan is all about. When I say that Sullivan is “student success focused,” I feel as President that I owe a definition of this statement to all who are considering Sullivan University. First, Sullivan is unique among institutions of higher education with its innovative, career-first curriculum. You can earn a career diploma or certificate in a year or less and then accept employment while still being able to complete your associate, bachelor’s, master’s or doctoral degree by attending during the day, evenings, weekends, or online. Business and industry do not expand or hire new employees only in May or June each year. Yet most institutions of higher education operate on a nine-month school year with almost everyone graduating in May. We remained focused on your success and education, and continue to offer our students the opportunity to begin classes or to graduate four times a year with our flexible, year-round full-time schedule of classes. If you really want to attend a school where your needs (your real needs) come first, consider Sullivan University. I believe we can help you exceed your expectations. Since words cannot fully describe the atmosphere at Sullivan University, please accept my personal invitation to visit and experience...

Words: 103133 - Pages: 413

Free Essay

C Sharp Language Specification

...C# Language Specification Version 4.0 Notice © 1999-2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Visual Basic, Visual C#, and Visual C++ are either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other countries/regions. Other product and company names mentioned herein may be the trademarks of their respective owners. Table of Contents 1. Introduction 1 1.1 Hello world 1 1.2 Program structure 2 1.3 Types and variables 4 1.4 Expressions 6 1.5 Statements 8 1.6 Classes and objects 12 1.6.1 Members 12 1.6.2 Accessibility 13 1.6.3 Type parameters 13 1.6.4 Base classes 14 1.6.5 Fields 14 1.6.6 Methods 15 1.6.6.1 Parameters 15 1.6.6.2 Method body and local variables 16 1.6.6.3 Static and instance methods 17 1.6.6.4 Virtual, override, and abstract methods 18 1.6.6.5 Method overloading 20 1.6.7 Other function members 21 1.6.7.1 Constructors 22 1.6.7.2 Properties 23 1.6.7.3 Indexers 23 1.6.7.4 Events 24 1.6.7.5 Operators 24 1.6.7.6 Destructors 25 1.7 Structs 25 1.8 Arrays 26 1.9 Interfaces 27 1.10 Enums 29 1.11 Delegates 30 1.12 Attributes 31 2. Lexical structure 33 2.1 Programs 33 2.2 Grammars 33 2.2.1 Grammar notation 33 2.2.2 Lexical grammar 34 2.2.3 Syntactic grammar 34 2.3 Lexical analysis 34 2.3.1 Line terminators 35 2.3.2 Comments 35 2.3.3 White space 37 2.4 Tokens 37 2.4.1 Unicode character escape sequences 37 2.4.2 Identifiers 38 2.4.3 Keywords 39 ...

Words: 47390 - Pages: 190

Premium Essay

Gsl Scientific Library

...GNU Scientific Library Reference Manual Edition 1.14, for GSL Version 1.14 4 March 2010 Mark Galassi Los Alamos National Laboratory Jim Davies Department of Computer Science, Georgia Institute of Technology James Theiler Astrophysics and Radiation Measurements Group, Los Alamos National Laboratory Brian Gough Network Theory Limited Gerard Jungman Theoretical Astrophysics Group, Los Alamos National Laboratory Patrick Alken Department of Physics, University of Colorado at Boulder Michael Booth Department of Physics and Astronomy, The Johns Hopkins University Fabrice Rossi University of Paris-Dauphine Copyright c 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010 The GSL Team. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with the Invariant Sections being “GNU General Public License” and “Free Software Needs Free Documentation”, the Front-Cover text being “A GNU Manual”, and with the Back-Cover Text being (a) (see below). A copy of the license is included in the section entitled “GNU Free Documentation License”. (a) The Back-Cover Text is: “You have the freedom to copy and modify this GNU Manual.” Printed copies of this manual can be purchased from Network Theory Ltd at http://www.network-theory.co.uk/gsl/manual/. The money raised from sales of the manual...

Words: 148402 - Pages: 594

Premium Essay

Customer Relationship Management

...Customer Relationship Management VSF This book is dedicated to my children Emma and Lewis of whom I am enormously proud. Customer Relationship Management Concepts and Technologies Second edition Francis Buttle AMSTERDAM • BOSTON • HEIDELBERG • LONDON • NEW YORK • OXFORD PARIS • SAN DIEGO • SAN FRANCISCO • SINGAPORE • SYDNEY • TOKYO Butterworth-Heinemann is an imprint of Elsevier Butterworth-Heinemann is an imprint of Elsevier Linacre House, Jordan Hill, Oxford OX2 8DP 30 Corporate Drive, Suite 400, Burlington, MA 01803, USA First edition 2009 Copyright © 2009, Francis Buttle Published by Elsevier Ltd. All rights reserved. The right of Francis Buttle to be identified as the author of this work has been asserted in accordance with the Copyright, Designs and Patents Act 1988 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 written permission of the publisher. Permissions may be sought directly from Elsevier’s Science & Technology Rights Department in Oxford, UK: phone ( 44) (0) 1865 843830; fax: ( 44) (0) 1865 853333; email: permissions@elsevier.com. Alternatively you can submit your request online by visiting the Elsevier web site at http://elsevier.com/locate/ permissions, and selecting Obtaining permission to use Elsevier material. Notice No responsibility is assumed by the publisher for any injury and/or damage...

Words: 171161 - Pages: 685

Premium Essay

Police

...39211 Belhaven University 15115 Park Row Suite 175 Houston, TX 77084 Belhaven University Online 1500 Peachtree St. Box 279 Jackson, MS 39202 Belhaven University 1790 Kirby Parkway Suite 100 Memphis, TN 38138 Belhaven University 4151 Ashford Dunwoody Rd. Suite 130 Atlanta, GA 30319 Belhaven University 5200 Vineland Rd. Suite 100 Orlando, FL 32811 Traditional Admission Adult and Graduate Studies Admission – Jackson Atlanta Chattanooga Desoto Houston Memphis Orlando Alumni Relations/Development Belhaven Fax Business Office Campus Operations Integrated Marketing Registrar Student Life Security Student Financial Planning Student Development Online Admission Online Student Services (601) 968-5940 or (800) 960-5940 (601) 968-5988 or Fax (601) 352-7640 (404) 425-5590 or Fax (404) 425-5869 (423) 265-7784 or Fax (423) 265-2703 (622) 469-5387 (281) 579-9977 or Fax (281) 579-0275 (901) 896-0184 or Fax (901) 888-0771 (407) 804-1424 or Fax (407) 367-3333 (601) 968-5980 (601) 968-9998 (601) 968-5901 (601) 968-5904 (601) 968-5930 (601) 968-5922 (601) 968-5969 (601) 968-5900 (601) 968-5933 (601) 968-5932 (601) 965-7043 (601) 968-8947 Website http://www.belhaven.edu http://atlanta.belhaven.edu http://chattanooga.belhaven.edu http://houston.belhaven.edu http://jackson.belhaven.edu http://memphis.belhaven.edu http://orlando.belhaven.edu http://online.belhaven.edu Visitors are welcome at Belhaven University. The admission office for...

Words: 151104 - Pages: 605

Premium Essay

Human Resources Management

...This page intentionally left blank This page intentionally left blank Less managing. More teaching. Greater learning. INSTRUCTORS... Would you like your students to show up for class more prepared? class is much more fun if everyone is engaged and prepared…) (Let’s face it, Want ready-made application-level interactive assignments, student progress reporting, and auto-assignment grading? (Less time grading means more time teaching…) Want an instant view of student or class performance relative to learning objectives? (No more wondering if students understand…) Need to collect data and generate reports required for administration or accreditation? (Say goodbye to manually tracking student learning outcomes…) Want to record and post your lectures for students to view online? With McGraw-Hill's Connect Management, ™ INSTRUCTORS GET: • Interactive Applications – book-specific interactive assignments that require students to APPLY what they’ve learned. • Simple assignment management, allowing you to spend more time teaching. • Auto-graded assignments, quizzes, and tests. • Detailed Visual Reporting where student and section results can be viewed and analyzed. • Sophisticated online testing capability. • A filtering and reporting function that allows you to easily assign and report on materials that are correlated to accreditation standards, learning outcomes, and Bloom’s taxonomy. • An easy-to-use lecture capture tool. STUDENTS... Want an online, searchable...

Words: 209749 - Pages: 839

Premium Essay

Henry Ford

...This page intentionally left blank This page intentionally left blank Less managing. More teaching. Greater learning. INSTRUCTORS... Would you like your students to show up for class more prepared? class is much more fun if everyone is engaged and prepared…) (Let’s face it, Want ready-made application-level interactive assignments, student progress reporting, and auto-assignment grading? (Less time grading means more time teaching…) Want an instant view of student or class performance relative to learning objectives? (No more wondering if students understand…) Need to collect data and generate reports required for administration or accreditation? (Say goodbye to manually tracking student learning outcomes…) Want to record and post your lectures for students to view online? With McGraw-Hill's Connect Management, ™ INSTRUCTORS GET: • Interactive Applications – book-specific interactive assignments that require students to APPLY what they’ve learned. • Simple assignment management, allowing you to spend more time teaching. • Auto-graded assignments, quizzes, and tests. • Detailed Visual Reporting where student and section results can be viewed and analyzed. • Sophisticated online testing capability. • A filtering and reporting function that allows you to easily assign and report on materials that are correlated to accreditation standards, learning outcomes, and Bloom’s taxonomy. • An easy-to-use lecture capture tool. STUDENTS... Want an online, searchable...

Words: 211687 - Pages: 847