Premium Essay

Accessing Oracle

In: Computers and Technology

Submitted By VInings523
Words 953
Pages 4
ACME Global Consulting
Brenda Lucas

Entity relationship modeling is extremely valuable in a complex data environment. In relational database management system, entity relationship modeling becomes essential when dealing with a large number of entities and/or complex relationships. In addition, some entities that have many different relationships, or even multiple relationships with a single entity, can be difficult to conceptualize without the assistance of a well-thought-out model. As pointed out by Allen (2005), entity relationship modeling provides a highly intuitive reference for developers of a database system.

ACME Global Consulting is an organization that services a vast number of clients across many domains. They deal with thousands of orders and products on a daily basis. From their customer service department to their order fulfillment department, the need for an efficient, accurate information system is self-evident. However, when dealing with so much information in such a complex system, the importance of proper planning and design cannot be overstated. There is no area of the system development lifecycle more critical than planning and design.

The purpose of the entity relationship model to be developed for ACME Global Consulting is to visualize the entities and relationships that will exist within the relational database. As is discussed by Chilton (2006), it can be difficult to wrap one’s mind around the concept of relational databases at first. It really is not that difficult. It is exactly what it sounds like. Consider all of the different entities of which a sales transaction might consist. There would probably be a customer, a product, a sale, a salesperson, and a shipment. This is just a very simplified example of the entities that could exist in a system. Now consider that each of these entities have very obvious relationships...

Similar Documents

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......

Words: 471 - Pages: 2

Free Essay

Assignment 1: Accessing Oracle

...Assignment 1: Accessing Oracle Intro to Relational Dbase Management Sys Accessing the Strayer University Oracle Server is not a hard task to do with the proper instructions presented to you. I have broken down the steps in which accessing the database can be an easy experience even for those that are not experienced with Telnet sessions. The tool I used to take my screen shots is SnagIt 11 which is a great tool for capturing screen shots especially inside a telnet session or remote desktop. The program allows for capturing the image you want without have to crop it which would happen using the Ctrl-Print Screen option which will capture your entire desktop work space. The first steps in accessing the Strayer University Oracle server is making sure you have a good telnet session in which to remote into the server. As described in the Strayer University procedures I’ll be showing this telnet session using the program Putty. There are many other telnet programs available to advanced users such as IBM’s 3270 and Microsoft Telnet that can be used as well. First step to accessing an Oracle Server via a Telnet session is actually configuring the session to make the connection to the server happen. Below shows the setup within Putty to establish the connection: Configure the Host Name or IP address to the Oracle server and Port number are the biggest part of making the connection happen. Once this information has been setup you are able to create it as a saved session so...

Words: 551 - Pages: 3

Premium Essay

Riodan Manufacturing

...Riodan Manufacturing Compared to the expansion and growth of business companies have witnessed throughout history, modern companies face many challenges and have some of the most advanced tools to be utilized. The invention of the modern day computer systems has revolutionized the way companies do business and allow for unprecedented growth. Unfortunately, the failure to embrace and understand this technology will lead to the down fall of even the largest corporate empire. Riodan Manufacturing is one of these companies. Riodan is an international company with locations in Georgia, Michigan, and Hangzhou, China. Having locations spread across the globe poses a challenge for the companies Information Technology Department. Having a good understanding of the company’s size and needs, the IT department helps ensure the company’s overall success. Riordan Manufacturing employs over 550 people, and has annual earnings of $46 million dollars. (Apollo Group, Inc., 2013) Riodan needs to find a way to align its IT Strategy and Business Strategies to ensure its future growth and profitability. The purpose of this paper is to identify the weakness in Riodan’s current information systems and make suggestions what improvements need to be made, leading to improved profits. The Financial and Accounting department will require several upgrades to both hardware and software to ensure the transition is not only seamless, but also easily upgradable in the future as well. After examining all......

Words: 2539 - Pages: 11

Free Essay

Delphi

...Delphi: The bellybutton of the ancient world Look beyond simply the famed oracular priestess breathing in hallucinogenic gases and you find a place whose past speaks directly to the 21st century. That is the argument of Cambridge University's Dr Michael Scott who is researching how and why Delphi, a small Greek town and religious sanctuary perched on a difficult to reach mountainside, was for 1,000 years the proclaimed the 'bellybutton', the very centre of the ancient world. Famed for its oracle at the Temple of Apollo, he is also examining the evidence of Delphi's many other gods, athletic and musical games and the monuments to unity - as well as civil war - that crowded its religious sanctuaries. Dr. Scott uses the latest architectural plans of the temple of Apollo which reveal for the first time archaeological traces of what may have been the oracular priestess's consultation room inside the temple. He also argues that the town, which drew kings and emperors as well as cities and commoners from all corners of the Mediterranean world and beyond, still speaks as powerfully to us today as it did in the past. He said: "Imagine a place with the wealth of the Swiss banks, the religious power of the Vatican, the advertising potential of the World Cup and the historical importance of all the world's museums combined; that was Delphi. We would all like to know what the future has in store for us. In that, perhaps the most important thing Delphi teaches us is to look inward,......

Words: 388 - Pages: 2

Premium Essay

Sony Barcelona Plant (a)

...Sony Barcelona Plant (A) This paper is written to analysis the case of “Sony Barcelona Plant (A)”. This case is mainly to discuss how was going on in new strategy plan in Europe plants. In this report, there have some of main topics will be discussed which are including that what factors causes STAR project difficult to complete smoothly, how to define a new strategy, what are Information system problems, what are the different opinions in changing the Information system and why to select Oracle ERP Suite. Then, some recommendations will be provided at the end as well. What factors causes STAR project difficult to complete smoothly? 1. According to different real situation or environment, there were different needs among the different plants which made it difficult to create the synthesis hoped for; 2.Not significant advances had been made and the real implementation of any application was not being planned; 3.The NTT consultants’ lack of experience; 4.A lack of commitment because the entire project team was centralized in one location; 5.Production information system was built base on the theoretical idea. How to define a new strategy? 1.Create more flexibility and economies of scale in the production process and in the procurement of common elements; 2.Reduce production time cycles; 3.Improving materials and resource planning and shortening the “time-to-market” and “time-to-delivery” cycles; 4.Reduce inventory costs and improve material planning; 5.Increase......

Words: 523 - Pages: 3

Free Essay

Maruti Suzuki

...1. Before Maruti Suzuki adopted the Oracle suite their databases were because they were rapidly growing larger and the technology that hosted their data wasn’t keeping up with their growth. Their previous systems weren’t very flexible and were very inefficient. The systems required extensive training and offered low turn around times. 2. The advantages of the company moving to a single vendor is that all of their systems and databases will be compatible with each other which promotes flexibility and makes it easier for the company to expand. Possible risks of using a single vendor could include data loss if the system as a whole were to crash, also if the vendor goes out of business the system could go down. 3. The important business factors management used when evaluating Oracles offerings were, the need for the systems to be simple and easily scalable, the company needed the databases to run multiple processes on a single network, Oracles databases also had to be compatible with legacy systems. 4. Its important that a companies vendors can integrate with legacy systems because the company doesn’t want to pay more money to replace systems already in use, with the use of middleware the company can update old systems instead of crating new ones. 5. Some of the benefits management reported from using oracles suit of products included, data being available online almost immediately, as well as allowing multiple views of data and consolidating accounts......

Words: 252 - Pages: 2

Premium Essay

Apology by Socrates

...people found him as a evil-doer and corrupter of the youth and that Socrates did not receive the same gods which whom the state received but instead he would introduce other new deities. The Athenian society felt as if everyone should believe in the same gods and anyone who did not or whomever taught that there could be something greater or even something different was considered an outcast and that they had to get rid of them in this case Socrates was this outcast. When Socrates has to present in court and to respond about his charges he is calm and plain spoken. Socrates explains to the courts that he has no experience with the court laws and he will speak the way he knows how. Socrates goes on to explain that his teachings come from the Oracle Delphi which he claims that he is the wisest man of all men. Socrates speaks of his ignorance and explains that he has to be wiser than other men only that he knows nothing. I believe that the premise would be when he explains his ignorance and that when he went to politians, poets and craftsmen and they too knew nothing. Socrates claims that society needs him and I believe that the premise would be when...

Words: 518 - Pages: 3

Premium Essay

Transaction Security in Single Ou

...Implementing Transactional Security in Single OU through form personalization Version 1.0 Overview: This document explains the procedure & step-by-step approach for implementing transactional security in single operating unit based on a segment in Chart of Accounts or any given criteria. White Paper: Implementing transactional security in single operating unit of Oracle Applications Version 11.5.10 Introduction: Transactional security has traditionally been one of the driving factors for businesses to opt of multiple operating units in Oracle Application Implementations. However, a large number of business establishments are now increasingly looking for transactional security even in the single operating unit. Transactional security in an operating unit can be of two types: ➢ To restrict access to transactional entry, say AP invoices etc, based on a specific chart of account or any given criteria ➢ To prevent users from viewing transactions, say AP invoices etc, with a specific chart of account or any given criteria even if the opt for a blind query by pressing Ctrl + F11 General Ledger security rules come handy in implementing the first part of the transactional security i.e. to prevent users from entering transactions with specific COA segments. However, GL security rules can be used only if the criterion is based on the COA segments. Also GL security rules have no effect on query mode. So viewing cannot be prevented with the......

Words: 595 - Pages: 3

Free Essay

Larry Ellison

...Q 1: The big 5 personality factors are Emotional stability, Agreeableness, Extraversion, Conscientiousness and Openness. Let’s Analyze the Larry Ellison in details on each of these. Emotional Stability reflects the calmness, poise and stability in their interpersonal dealings. Larry does not score very high on Emotional stability. He does not hide his irritation at others. He is not resilient as he does not accommodate others of different view. Though, he is surely a confident person. He does have high degree of confidence in himself. He believes he can be success without others help though it may not be entirely true. No one person regardless of how smart he or she is can be success all alone. There should be lot of contribution from other people at all levels. He does not seem to realize or recognize this. He may have a lot of arrogance. He definitely is an effective leader. Starting a small company and turning into one of best companies on the planet takes great personality. He has knack for success and he has demonstrated it. All that reflects He is quite Emotionally Stable person. No man is perfect. He has some weakness as well. Agreeableness is the capability of getting along others. This is Larry’s biggest weakness. Really intelligent and capable people are often hard to get along with others as they have their own independent ideas and opinions about everything. They feel they are right always. Others may think of him rude. On......

Words: 907 - Pages: 4

Premium Essay

Reflective Journal

...Below is the information I got so far, and I'll update this post as I get more information. I've also reached out to some friends in Jollibee hoping to get some inside information. Please note that none of these are from official statements. If anyone wants to provide me with more accurate information on this, or better yet, official statements from the parties concerned, please send me a message and I will gladly incorporate it into the article. My objective here is to provide lessons to the IT and business community so that we can hopefully avoid the all-too-often costly mistakes of IT projects in the future. The Issues 1. Rip and Replace Jollibee had originally been using an Oracle product for managing its supply chain - including deliveries of supplies to stores. Because of a dispute with Oracle, Jollibee decided to move its entire supply chain over to Oracle’s rival in this space, SAP. Now, supply chain software aren’t just out-of-the-box products that you can just install and run. These need to be customized heavily in order to fit a company’s business processes, which...

Words: 583 - Pages: 3

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......

Words: 1424 - Pages: 6

Premium Essay

Database Systems and How They Are Used

...Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013). Database Architecture Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, have lots of generic data or data designed for a specific purpose, or be transactional or analytical. Take Oracle database architecture for example. “Oracle9i, Oracle8i, and Oracle8 databases are powerful, flexible, and scalable relational database management system (RDBMS) servers that run on a range of computer systems, from personal computers to largest mainframes. Oracle is designed to run effectively in a client/server environment and supports hundreds to thousands of users” (Oracle, "Migration Process", 1998). Summary Without database systems, companies would have no means by which to access the information stored in their databases. This information is required for day-to-day operations. For instance, Craig works for Verizon FiOS selling cable, phone, and Internet......

Words: 497 - Pages: 2

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......

Words: 21631 - Pages: 87

Free Essay

Cis499

...Business Requirements for ADCA 10/30/2013 Professor Dr. Phillip Duncan Strayer University CIS 499 Information Systems Capstone Business Requirement Plan Currently our system consist of SQL database sitting on 5 Cisco servers onsite. I plan to have that changed to oracle databases in a virtual world and out sourcing the cloud storage. Our current data warehouse is at ten terabytes. This is expected to increase by twenty percent a year therefore this must also be taken into account when searching for a provider of cloud storage. This will save on cost of equipment and also space. This savings of cost and space will be used to hire more technical personnel such as an oracle database administrator and a JavaScript programmer. We currently are running windows 7 but will be upgrading to windows 8 because it is better suited to the virtual world than windows 7. In regards to infrastructure and security, right now we have a basic to average network set up with a DMZ for our clients and intranet with a few firewalls. Not much can be done since we are running a SQL database. This will change when we upgrade to oracle. More security on the network and our client’s information will now be able to be applied. We will also create and maintain a backup center located off site. This center will not be cloud based but an actual server room. We will have to address that privacy issues associated with using a JavaScript method instead of log files to maintain the sites. ......

Words: 1621 - Pages: 7

Free Essay

Computers

...Copyright © Oracle Corporation, 1999, 2000, 2001. All rights reserved. This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the following legend is applicable: Restricted Rights Legend Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed to be Restricted Rights software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988). This material or any portion of it may not be copied in any form or by any means without the express prior written permission of Oracle Corporation. Any other copying is a violation of copyright law and may result in civil and/or criminal penalties. If this documentation is delivered to a U.S. Government Agency not within the Department of Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987). The information in this document is subject to change without notice. If you find any problems in the documentation, please report them in writing to Education Products, Oracle......

Words: 41259 - Pages: 166