Premium Essay

Oracle

In:

Submitted By BillyQ
Words 409
Pages 2
DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone)
Solution:
CREATE TABLE DEPARTMENT(
DepartmentName Char(35) NOT NULL,
BudgetCode Char(30) NOT NULL,
OfficeNumber Char(15) NOT NULL,
Phone Char(12) NOT NULL,
CONSTRAINT DepartmentPK PRIMARY KEY(DepartmentName)
);
========================================================================================== 7.5 Write a CREATE TABLE statement for the EMPLOYEE table. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE. • EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Phone, Email)
• Department in EMPLOYEE must exist in DepartmentName in DEPARTMENT
• EmployeeNumber is a surrogate key that starts at 1 and increments by 1.
Solution:
CREATE TABLE EMPLOYEE(
EmployeeNumber Int NOT NULL IDENTITY(1,1),
FirstName Char(25) NOT NULL,
LastName Char(25) NOT NULL,
Department Char(35) NOT NULL DEFAULT ‘Human Resources’,
Phone Char(12) NULL,
Email Char(100) NOT NULL,
CONSTRAINT EmployeePK PRIMARY KEY(EmployeeNumber),
CONSTRAINT DepartmentFK FOREIGN KEY(Department)
REFERENCES DEPARTMENT(DepartmentName)
ON UPDATE CASCADE
ON DELETE NO ACTION,
CONSTRAINT EmployeeAK UNIQUE(Email)
);
=========================================================================================

7.6 Write a CREATE TABLE statement for PROJECT table. The default value for MaxHours is 100. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE. • PROJECT (ProjectID, Name, Department, MaxHours, StartDate, EndDate)
• Department in PROJECT must exist in DepartmentName in DEPARTMENT
• ProjectID is a surrogate key that starts at 1000

Similar Documents

Free Essay

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also included...

Words: 1424 - Pages: 6

Free Essay

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle Corporation 500...

Words: 3160 - Pages: 13

Free Essay

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download the...

Words: 1320 - Pages: 6

Free Essay

Oracle Rac

...A white paper prepared with Oracle and IBM technical collaboration March 2010 Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability Executive Overview ........................................................................... 2 Introduction ....................................................................................... 2 Problem validation ......................................................................... 3 Examining the AIX Error Logging................................................... 3 Examining the Oracle oprocd logging ............................................ 4 Recommendations for system stability............................................... 5 1. Implement AIX tuning recommendations for Oracle ................... 5 2. Modify Oracle ‘diagwait’ parameter............................................ 6 3. Install the required updates and patches ................................... 8 4. Reduce heavy paging activity. ................................................. 11 Appendix A: Oprocd logging examples ............................................ 14 Clean oprocd log files .................................................................. 14 Oprocd log files showing scheduling delays................................. 14 Oprocd log files after a node reboot or CRS restart .................

Words: 4075 - Pages: 17

Free Essay

Dell and Oracle

...Oracle Corporation It’s a huge company that provides enterprise software and computer hardware products and services. It develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems. It is organized into three businesses: software, hardware systems and services. Its software business consists of two segments: new software licenses and software license updates and product support. It’s hardware systems business consists of two segments: hardware systems products and hardware systems support. It authorizes database and middleware software, including database and database management, application server and cloud application, service-oriented architecture and business process management, business intelligence, identity and access management, data integration, Web experience management, portals, and content management and social network software, as well as development tools and Java, a software development platform; and applications software comprising enterprise resource planning, customer relationship management, financials, governance, risk and compliance, procurement, supply chain management, enterprise portfolio project and enterprise performance management, business intelligence analytic applications, Web commerce, and industry-specific applications software. It also provides customers with rights to unspecified software product upgrades and maintenance releases; Internet access to technical content; and...

Words: 2530 - Pages: 11

Free Essay

Oracle Database

...types of bases to get the job done. The one database used more by logistics personnel is the Oracle Discoverer Plus database. In this paper will discuss what is Discoverer Plus, we will breakdown some of its function areas like End User layer (EUL), Business Area, and Folders. We will discuss some feature of Discoverer Plus database, and last, we will provide the dated problems of Discoverer’s Plus database. Discoverer Plus is one of five parts of the Air Force Supply Central Database (AFSCD). According to AFM 23-110 “Discoverer Plus is an oracle database that provides supply technician and analyst with a user friendly ad hoc data retrieval tool. It gives the user capability of retrieving, organizing, and displaying data when they want it, in the way they want it” (USAF 2009). Discoverer Plus also gives user the choice of creating their own queries from scratch with the help of a friendly wizard. In addition a number of standard ad hoc queries are provided to each user under their user-ids. Although standard ad hoc queries contain a predefined set of data, they also have flexibility of applying conditions, change sort order, and modifying the display. Discoverer Plus is also invaluable to Air Staff, Headquarter, and supply managers as it help makes important decisions with the deep-rooted analytical function. EUL is a part of Discoverer Plus, it is a layer of information used by Oracle Discoverer to hide the complexities and details of the underlying database. EUL provides a...

Words: 624 - Pages: 3

Free Essay

Oracle 10g Forms

...Oracle Forms 10g : Demos, Tips and Techniques Oracle Forms 10g release 2 : Demos, Tips and Techniques Home page 1. Introduction Here is a collection of Oracle Forms 10g sample dialogs extracted from a complete Oracle Forms tutorial. This tutorial has been written in French and it would be too time consuming to translate it all in English. This is the reason why I have only extracted and translated these sample dialogs. The purpose of this article is not to teach how to build a new form from scratch. It intends to show some of the main advanced features of the product. To clearly understand in details how these dialogs work, you will have to open them in the Forms Builder and examine them thoroughly. However, in this article, I am going to explain the best I can the most important mechanisms of each sample. These sample have been tested with an Oracle Forms 10g release 10.1.2.0.2 on an Oracle Database 10g Express Edition Release 10.2.0.1.0. 2. Description of the sample dialogs 2.1 Main screen TUTO_FORMS.FMB This dialog is the entry point of the samples. Click on a button to start the corresponding dialog. file:///D|/Cours/tuto_forms/paper/PDFtutoforms10g.htm (1 sur 24)29/05/2006 23:09:57 Oracle Forms 10g : Demos, Tips and Techniques 2.2 Canvases TEST_CANVAS.FMB This sample shows three types of canvas : § § § The content canvas (light green) The stacked canvas (white) The tab canvas (dark green) Stacked canvas A stacked canvas is displayed atop—or stacked on—the content...

Words: 3526 - Pages: 15

Premium Essay

Oracle Sql Tutorial

...Oracle/SQL Tutorial1 Michael Gertz Database and Information Systems Group Department of Computer Science University of California, Davis gertz@cs.ucdavis.edu http://www.db.cs.ucdavis.edu This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu/dbs. Comments, corrections, or additions to these notes are welcome. Many thanks to Christina Chung for comments on the previous version. Recommended Literature George Koch and Kevin Loney: Oracle8 The Complete Reference (The Single Most Comprehensive Sourcebook for Oracle Server, Includes CD with electronic version of the book), 1299 pages, McGraw-Hill/Osborne, 1997. Michael Abbey and Michael Corey: Oracle8 : A Beginner’s Guide [A Thorough Introduction for First-time Users], 767 pages, McGraw-Hill/Osborne, 1997. Steven Feuerstein, Bill Pribyl, Debby Russell: Oracle PL/SQL Programming (2nd Edition), O’Reilly & Associates, 1028 pages, 1997. C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition), Addison-Wesley, 1997. Jim Melton and Alan R. Simon: Understanding the New SQL: A Complete Guide (2nd Edition, Dec 2000), The Morgan Kaufmann Series in Data Management Systems, 2000. 1 revised Version 1.01, January 2000, Michael Gertz, Copyright 2000. Contents 1. SQL – Structured Query Language 1.1. Tables 1.2. Queries (Part I) 1.3. Data Definition...

Words: 21631 - Pages: 87

Free Essay

Oracle Ebs

...to Oracle EBS 1.1 About EBS 1.2 EBS Application Products 2. The EBS architecture 2.1 Desktop Tier 2.2 Application Tier 2.3 Database Tier 3. Oracle EBS database features 3.1 Monitoring Features 3.2 Performance Features 3.3 Scalability Features 3.4 Business Intelligence Features 3.5 Security Features 4. Oracle EBS user list 5. Oracle EBS success stories 5.1 Home Box Office (HBO) 5.2 Mallcom limited 5.3 AT&T INC. 5.4 Facebook 5.5 HCL 1.1 ORACLE EBS Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management(CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms. Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java). Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM — "E-Business Suite Technical Reference Manuals". The applications found in the Oracle EBS include: * Oracle CRM ...

Words: 7162 - Pages: 29

Free Essay

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana 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 Sections 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. 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) 748-6008, or online...

Words: 106399 - Pages: 426

Premium Essay

Accessing Oracle

...Running head: ACCESSING ORACLE Accessing Oracle Intro to Relational Database Management Systems CIS111 Professor Rachelle Howard October 21, 2012 Accessing Oracle Accessing Strayer University UNIX server is an information technology tool that assists the completion of curricula activities and student lab assignments designed to expand the knowledge base in relational database management systems. For the first assignment, the following steps were taken to accomplish access to Oracle: 1. The first step to get to the Oracle server, Click on Start-> Programs -> Putty, was simple and easy. 2. After typing in the host name, UNIX-online.strayer.edu, I ensured the port was set to 22 and that the radio button was set for SSH. After entering Student Unix Server in the Saved Sessions box I selected “open” instead of going to the next step of selecting Category, which caused me to have to start over. 3. In the Category area on the left I selected Window. In the Columns and Rows boxes I entered 120 and 60 respectively to set the initial window size when opening the terminal window. Under Lines of scrollback, I enter 20000 and verified the remaining boxes. 4. I experienced dificulty with setting the colours. Under the Categories\Window to select Colours I selected ANSI Blue and typed in the values in the illustration before I selected Modify. I changed the colour to yellow and selected OK. This caused me to start the initial setup from step 1. I repeated this...

Words: 471 - Pages: 2

Free Essay

Oracle Dba

...Golden rules of RAC diagnostics By Riyaj Shamsudeen ©OraInternals Riyaj Shamsudeen Me n  n  n  n  n  n  n  n  n  20+ years using Oracle products/DBA OakTable member, Oracle ACE Director Certified DBA -7.0,7.3,8,8i,9i &10g Specializes in RAC, performance tuning, EBS, & Exadata Chief DBA with OraInternals Co-author a few books Email: rshamsud@orainternals.com Blog : orainternals.wordpress.com Web: www.orainternals.com ©OraInternals Riyaj Shamsudeen 2 Golden rules of RAC diagnostics 1. Beware of top event tunnel vision. 2. Eliminate infrastructure as an issue. 3. Identify problem instance(s). 4. Review Send side metrics, and not just Receive side metrics. 5. Use histograms to identify any abnormalities, and not just averages. ©OraInternals Riyaj Shamsudeen Top event tunnel vision n  In RAC, the root cause can be hidden in other node and might not show up in the Top-5 wait events. Impact of side effect events can be much, much worse then actual root cause event itself. Performance of the instances are intertwined. Performance of background processes in one node, can affect the application performance in the all other nodes. n  n  n  ©OraInternals Riyaj Shamsudeen Top event tunnel vision ..2 Example 1 ©OraInternals Riyaj Shamsudeen 5 Top event tunnel vision ..3 Example 2 ©OraInternals Riyaj Shamsudeen 6 Top event tunnel vision ..4 Example 3 ©OraInternals Riyaj Shamsudeen 7 ...

Words: 964 - Pages: 4

Free Essay

Oracle vs Peoplesoft

...Oracle  –  PeopleSo-  Takeover   Contents   •  •  •  •  •  •  •  •  •  •  •  Introduc-on   Products   Market  Structure   Why  PeopleSo8   Oracle’s  /  PeopleSo8’s  View   Timeline  of  the  Acquisi-on   Pre-­‐Merger   Post-­‐Merger   Defense  /  An-defense  Strategies   A8er  Takeover   Conclusion   Oracle  -­‐  PeopleSo8  Takeover   2   Introduc-on   •  The  acquisi-on  would  enable  Oracle  to   capture  the  Enterprise  Applica-on  so8ware   business,  used  by  large  companies.   •  Merger  would  be  a  legi-mate  rival  to  SAP.   •  Oracle  made  a  hos-le  bid  of  $10.3  billion  for   PeopleSo8  in  June  2003   •  Lasted  for  18  months   Oracle  -­‐  PeopleSo8  Takeover   3   Oracle   •  Founded  in  1977  by  Larry   Ellison  (CEO)   •  One  of  largest   developers  of  “Database   Management  Systems” •  More  than  41,000   employees  and  reported   revenue  of  more  than   $10.2  billion  in  2003   Oracle  -­‐  PeopleSo8  Takeover   4   PeopleSo8   •  Founded  in  1987  by   David  Duffield  &Ken   Morris   •  Craig  Conway  is  CEO   •  Specializes...

Words: 1427 - Pages: 6

Free Essay

Oracle Apps

...|Current Location |Hyderabad | |Current Employer |Tata Consultancy Services | Executive Summary: My ambition is to work for the leading consulting firms within the IT industry as I believe I am skilled and have much to offer potential employers and their clients. Currently, I am a System Engineer with Tata Consultancy Services Limited. Primary Skills: 2years & 9 Months of experience as Technical Consultant in Oracle E-Business Suite Applications. Resume Details: • 2 years and 9 month of analysis, design, development and support experience in Oracle apps. • Has exposure in working with Onsite – Offshore models. • Experience in all phases of the system development /implementation life cycle. • Experience in Oracle Apps...

Words: 1310 - Pages: 6

Free Essay

Oracle Database Trends

...researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our experience and the results done by the previous researchers. However, the time constraint is considered as a big obstacle in completing the project to our best satisfaction. Our project will mainly concentrate on database trends in general. However, we will make a short mention to ORACLE whom adopted new trends in database. DEFINITION...

Words: 3078 - Pages: 13