...CHAPTER 2 DATA MINING TECHNIQUE OVERVIEW 2.1 Introduction In the 21st century as we are moving towards more and more online system, the databases have grown into terabytes. Within this huge data, information of importance needs to be identified. Since the evolution of human life, the people discover patterns. As farmer recognizes pattern of growth in the field, bank recognizes the earning and spending pattern of a customer and politicians seeks pattern in voter opinion. This huge amount of data needs to be used either for business growth or scientific discoveries. The process of discovering the patterns and relationships in data using the analysis tools is called Data Mining. The simplest form of data mining is as follows: 1. Describing...
Words: 2594 - Pages: 11
...CIS 515 ASSIGNMENT 2 To purchase this visit following link: https://coursehomework.com/product/cis-515-assignment-2/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 515 ASSIGNMENT 2 CIS515 Assignment 2: Database Systems and Database Models Instant Download Due Week 2 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets: • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice (InvNumber, InvDate, EmpNumber, InvAmount) • InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity) • Product (ProductNumber, ProductDescription, ProductCost) • Department (DepartmentID, DepartmentDescription) • Job...
Words: 494 - Pages: 2
...CIS 336 Entire Course: Devry University For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University _________________________________________ CIS 336 Final Exam 1 For more course tutorials visit www.tutorialrank.com 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational 2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4) information processing applications programming 3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4) referential restrictive secondary redundant 4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table? (Points : 4) UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL __________________________________________________ CIS 336 Week 1 iLab 1 Devry University For more course tutorials visit www.tutorialrank.com L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which...
Words: 689 - Pages: 3
...technology is more than being just a machine, it is being our life. Therefore, somebody should invent, produce and adapt our desires to this technology. In this research paper, I am going to find answers to some questions about career opportunities in computer and information sciences that creates all of this technologies. Question List 1. What are the major activities assigned to people employed in the CIS field? 2. What technical skills are necessary in order to be successful in CIS? 3. What educational preparation is required? 4. What kinds of organizations hire people in this occupation? 5. What kind of work would an entry-level bachelor's degree person would likely do? 6. What are the opportunities for advancement? What positions might someone hold as he or she advances? Give a sequence of positions starting from entry level position and also show expected salary in each position. 7. Are the opportunities generally limited to specific geographic locations? If so, where? In addition, what states or countries are experiencing the fastest growth in CIS? 8. What is the salary range at the entry-level? 9. What are the working conditions? Will you work alone, with others, as a team? Is the environment noisy or quiet? How much travel, if any, is required? Are there certain peak periods...
Words: 4626 - Pages: 19
...18.5/20 Database Memorandum Paper J. S CIS/319 –Computer and Information Processing 07/23/2012 Prepare a 2- to 3-page memorandum analyzing the use of databases in a business environment. Include what database applications should be used: Microsoft® Access®, IBM® DB2®, Oracle®, and so on. Conclude by proposing improvements. For large organizations, restrict the scope of the paper to the department in which you work. The use of database in the business environment has become an integral part in business processing. According to an article, Database Evolution: Microsoft Access within an Organization's Database Strategy, Chung explains that databases are used in a variety of levels for various reasons: Enterprise level, Department level, Workgroup/Team Level and Individual/small groups. With these, database systems are used as data centers in order for companies to process data, whether customer transactions, storing information (business) or to maintain security. The most popular database used today is Microsoft Office Access, or which most know it as Microsoft Access. This was developed my Microsoft Corporation and can also be used as a “frontend” with other products as the “backend” table. Which means that all the data processing can be done by Microsoft SQL Server, a Microsoft product and other database applications, for example Oracle. Microsoft Access is the main database application used by our company (Affiliated Computer Service). Due to the nature of our business...
Words: 825 - Pages: 4
...and Data Warehouses Kevin Gainey Mr. Brown CIS 111 Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs substantially from the design of an online transaction processing system (OLTP) database. The topics in this paper address approaches and choices to be considered when designing and implementing a data warehouse. The paper begins by contrasting data warehouse databases with OLTP databases and introducing OLAP and data mining, and then adds information about design issues to be considered when developing a data warehouse with Microsoft® SQL Server™ 2000. A data warehouse supports an OLTP system by providing a place for the OLTP database to offload data as it accumulates, and by providing services that would complicate and degrade OLTP operations if they were performed in the OLTP database. Without a data warehouse to hold historical information, data is archived to static media such as magnetic tape, or allowed to accumulate in the OLTP database. If data is simply archived for preservation, it is not available or organized for use by analysts and decision makers. If data is allowed to accumulate in the OLTP so it can be used for analysis, the OLTP database continues to grow in size and requires more indexes...
Words: 721 - Pages: 3
...Global Trade of Wood and Paper Products Abstract Global trade of wood products is accelerating amid shifting regional production of raw materials. At the same time structural change is occurring in regional production and consumption of finished and semi-finished wood and paper products. Some countries which once were major net exporters of wood products, such as the United States, have become major net importers. Conversely, China, a country that not long ago was a major net importer of wood products, is increasingly dominant as an exporter of value-added wood products such as furniture. What are the reasons behind these shifts in sources of supply and demand for wood and wood products? Direct forces such as population growth and rising socio-economic levels drive demand for wood and paper products. Increasing purchasing power in developing economies empowers consumers, both private and public, to purchase homes, furnishings and accessories. Indirect factors, such promotion of wood, strengthen demand and translate to significant gains in consumption in some markets. Consciousness of climate change and the advantages of wood for products and energy is creating a new impetus for increasing wood products consumption, including wood-derived energy products. Government and industry policies are important market drivers. Government policies can support increased utilization of wood, or can restrict wood in construction when standards favor competitive building materials...
Words: 3931 - Pages: 16
...College of Information Systems & Technology Bachelor of Science in Information Technology with a Concentration in Information Management The Bachelor of Science in Information Technology (BSIT) degree program is focused on the acquisition of theory and the application of technical competencies associated with the information technology profession. The courses prepare students with fundamental knowledge in core technologies, such as systems analysis and design; programming; database design; network architecture and administration; web technologies; and application development, implementation, and maintenance. This undergraduate degree program includes 45 credits in the required course of study and 15 credits in the concentration. Some courses have prerequisites. In addition, students must satisfy general education and elective requirements to meet the 120-credit minimum, including a minimum of 48 upper-division credits required for completion of the degree. At the time of enrollment, students must choose a concentration. The Information Management concentration is designed to provide coverage of the collection, architecture, modeling, retrieval and management of data for meaningful presentation to the organization. This concentration prepares students to develop, deploy, manage, and integrate data and information systems to support the organization. Note: The diploma awarded for this program will read: Bachelor of Science in Information Technology and will not reflect the concentration...
Words: 1892 - Pages: 8
...CIS 260 Home Work # 1 Due to: 21/3/2013 Chapter 1: Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, meta-data, and transaction-processing application. 1.2. What four main types of actions involve databases? Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database systems and information retrieval systems. Chapter 2: Review Questions 2.1. Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture. 2.2. Discuss the main categories of data models. What are the basic differences between the relational model, the object model, and the XML model? 2.3. What is the difference between a database schema and a database state? 2.4. Describe the three-schema architecture. Why do we need mappings between schema levels? How do different schema definition...
Words: 1108 - Pages: 5
...CIS 3400 Database Management Project Proposal: Bikorama Background Information The philosophy behind Bikorama is simple and direct, to embrace life and nature while living responsibly. With 4 locations in the core of New York City, the founders of Bikorama generated a vision of a cleaner, healthier environment by engaging New Yorkers and visitors to enjoy a ride around the city with a much deeper passion. Bikorama offers bike rentals as healthy transportation alternatives to vehicles or taxi’s, while being much cheaper than public transit. Bike rentals are offered in hourly, daily or weekly rates to accommodate the purposes of rentals, such as getting to work, contests, events and city tours. Bikes rented from one location are able to return bikes to any of Bikorama stores. Overall Purpose of Incorporating Database Management System Bikorama requires a database management system to record and maintain records of bike rental cycles per bike, customer registration, payment transactions and management of inventory within the store. Moreover, the data collected will also include maintenance records for the company to measure durability of bikes from vendors. Records of sales revenue will also reflect store performance and determines stability of business for the first few years. The system will provide information for decision making, such as ordering more bikes if inventory does not meet level of demand, increasing and decreasing rates or developing marketing strategies...
Words: 435 - Pages: 2
...Running head: SHORT TITLE OF PAPER (<= 50 CHARACTERS) Data Warehousing and Data Mining Bruce Nimo CIS 111 March 19, 2012. Prof Jones Data mining is a process of numerical analysis. Analysts use technical tools to query and sort through terabytes of data looking for patterns. Usually, the analyst will develop a hypothesis, such as customers who buy product X usually buy product Y within six months. Running a query on the relevant data to prove or disprove this theory is data mining. Data warehousing describes the process of designing how the data is stored in order to improve reporting and analysis. Data warehouse experts consider that the various stores of data are connected and related to each other conceptually as well as physically. A business's data is usually stored across a number of databases. However, to be able to analyze the broadest range of data, each of these databases needs to be connected in some way. This means that the data within them need a way of being related to other relevant data and that the physical databases themselves have a connection so their data can be looked at together for reporting purposes. Businesses then use this information to make better business decisions based on how they understand their customers' and suppliers' behaviors. Examples of businesses that use data warehousing and data mining are amason.com, Wal-Mart stores Inc etc. Both data mining and data warehousing are business intelligence tools that are used to...
Words: 1181 - Pages: 5
...Data Warehouses Kevin Sloley Professor Dammlash Gebre CIS-111 Intro to Related Database Management Systems Due March, 2016 Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data. The primary difference between your application database and a data warehouse is that while the former is designed (and optimized) to record, the latter has to be designed (and optimized) to respond to analysis questions that are critical for your business. Application databases are OLTP (On-Line Transaction Processing) systems where every transaction has to be recorded, and super-fast at that. Consider the scenario where a bank ATM has disbursed cash to a customer but was unable to record this event in the bank records. If this started happening frequently, the bank wouldn't stay in business for too long. So the banking system is designed to make sure that every trasaction gets recorded within the time you stand before the ATM machine. This system is write-optimized, and you shouldn't crib if your analysis query (read operation) takes a lot of time on such a system. A Data Warehouse (DW) on the other end, is a database (yes, you are right, it's a database) that is designed for facilitating querying and analysis. Often designed as OLAP (On-Line Analytical Processing) systems, these databases contain read-only data that can be queried and analyzed far...
Words: 1350 - Pages: 6
...implement and run, to allow for the development of structured and well organized programs, and to serve as a tool to teach the important concepts of computer programming. The program was named after a mathematician named Blaise Pascal. It was used as the primary language in the Apple Lisa and for the Mac in the early years of the computer. SQL SQL, which is short for, Structured Query Language, was designed by an IBM research center in 1974-1975. The Oracle Corporation introduced it as a commercial database system in 1979, the first time it was introduced. It has been a favorite query language for the use of database management systems for the microcomputer and mainframes, but is being supported by the PC database. C C was created at the Bell Laboratory in 1972 by Dennis Ritchie. It was created for the purpose in designing UNIX. Prolog Was created from 1971-1973 and was distributed in 1974-1975. It was created not as a programming language on purpose but as a tool for processing natural languages specifically French. It was created by Robert Pasero, Philippe Roussel, Alain Colmerauer, and Jean Trudel. Smalltalk Developed in the early 1970’s, at the Xerox Palo Alto Research Center. It was created by Alan Kay, Dan Engalls, Adele Goldberg, and Dave Robson. The five popular programming languages of the 1980’s are: 1983: Ada 1983: C++ 1985:...
Words: 988 - Pages: 4
...The Design and Development of Business Warehouse Systems CIS 537 July 31, 2011 What type of new BW System you would want? The system that I want is the SAP NetWeaver Business Warehouse systems on the IBM InfoSphere Warehouse that is on IBM. With a business intelligence database with common properties in a class that can be a wide variation. The SAP NetWeaver Business Warehouse databases tend to have some features that are typical, of a standard BI database. It will fit into the InfoSphere Balanced Warehouse design and there are many benefits to running SAP NetWeaver BW on InfoSphere Balance Warehouse. Timely access to relevant information has always been critical to business success, with new data sources and increased access, managing, processing and making sense of data volumes is important. With the SAP NetWeaver Business Warehouse will lead the way to providing a complete business from data sources. A comprehensive set of tools, planning and simulation capabilities as the components of the SAP NetWeaver platform to combines powerful business warehouse infrastructure and data warehousing functionality. It will give a timely access to relevant information that has been critical to business success. The decision will be based on the full range of information available as the volume of available information grows. The InfoSphere Balanced Warehouse is a complete data warehousing solution that is comprised on pretested, scalable and fully integrated system. The system is...
Words: 626 - Pages: 3
...Systems Analysis and Design CIS 3512 Professor Setterlind July 6, 2014 Information Systems have been around for a long time, whereas, the term Information Technology is relatively new. The U.S. Postal Service could be considered an information system with sub-systems including logistics, and transportation. With a system of main post offices and community locations, the Postal Service is able to move letters and packages around the world in only a few days. Since the introduction of computers into the business industry, Information Systems focus on making use of technology to disseminate information. Information Technology could be considered a sub-system of Information Systems since the technology supports and enables the system through software and hardware development. The five main components of an information system are people, hardware resources, software resources, data resources, and network resources. (2010). People include the end-users and also the programmers, analysts, and other technical specialists that support the system. Hardware resources include the servers, client workstations, monitors, keyboards, and all other peripherals that interconnect them. Human interface devices allow users to input data to the system, which is translated into usable information. Software resources include the system operations programs, such as Windows, or Unix, and application software that are specific to a particular task, such as, word processing or finance. Included with software...
Words: 846 - Pages: 4
