Premium Essay

Cis Database Processing

In: Computers and Technology

Submitted By Redsecret26
Words 448
Pages 2
Chapter 2
2.1 What is a business intelligence (BI) system?
Business intelligence (BI) systems are applications and technologies for gathering, storing, analyzing, and accessing information for better business decision making.
2.2 What is an ad-hoc query?
An AD-HOC Query is a query which is created on the fly, for a specific Non-Generalizable one time requirement and may not be saved
2.3 What does SQL stand for, and what is SQL?
SQL stands for structured query language. It is a special interfacing program that uses a certain language for sending questions to a search engine.
2.4 What does SKU stand for? What is an SKU?
SKU stands for Stock Keeping Unit. A number assigned to a product by a retail store to identify the price, product options and manufacturer of the merchandise.
2.5 Summarize how data were altered and filtered in creating the Cape Codd data extraction.
2.6 Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_ITEM and SKU_DATA tables.
2.7 Summarize the background of SQL
2.8 What is SQL-92? How does it relate to the SQL statements in this chapter?
2.9 What features have been added to the SQL in versions subsequent to the SQL-92?
2.10 Why is SQL described as a data sublanguage?
2.11 What does DML stand for? What are DML statements?
2.12 What does DDL stand for? What are DDL statements?
2.13 What is the SQL SELECT/FROM/WHERE framework?
2.14 Explain how Microsoft Access uses SQL
2.15 Explain how enterprise-class DBMS products use SQL.
2.16 There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is included in INVENTORY. Specifically, why did we include it?
2.17 Write an SQL statement…...

Similar Documents

Premium Essay

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Free Essay

System Evaluation Paper/Cis/319 - Computers and Information Processing

...System Evaluation Paper Professor Mathew Mower CIS/319 - COMPUTERS AND INFORMATION PROCESSING January 21, 2013 Introduction I have been extended the reward of being employed for Yellow Freight Company (YRC), for over 17 years. YRC Freight is a subsidiary of YRC Worldwide Inc., a Fortune 500 company and one of the internationally. With headquarters in Overland Park, Kan., YRC Worldwide employs 55,000 people. I have witnessed many company changes. Yellow Freight was established in 1924. One of the most remarkable displays of our company is our 18 wheelers that are painted in a bright orange color. In the beginning CEO Harrell hired a chemist to find out what was the safest color on the highways of America. The results of the research led to swamp holly orange; was not only the safest, but the most visible from the greatest distance. On Feb. 1, 2012 YRC took another significant successful step, becoming one of the largest operating freight companies. Much more than a new name and logo, this rebranding signals our intent to focus on our core business, helping less-than-truckload shippers throughout North America increase the dependability and reliability of their supply chains. Today, we remain true to our founders' early dedication to safety and service. Their hard work and determination was the foundation for our success and has contributed to the success of thousands of customers. YRC has continue to prosper from the start. There is no surprise, given the......

Words: 722 - Pages: 3

Premium Essay

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Premium Essay

Database

...Introduction $  $  • Purpose of Database Systems • Data Definition Language • Data Manipulation Language • Transaction Management & ' & • Storage Management • Database Administrator • Database Users • Overall System Structure 1.1 Silberschatz, Korth and Sudarshan c 1997 Database Systems Concepts Database Management System (DBMS) • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use Database Systems Concepts 1.2 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Purpose of Database Systems $  $  Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems Database Systems Concepts 1.3 Silberschatz, Korth and Sudarshan c 1997 View of Data An architecture for a database system view level view 1 view 2 … view n logical level physical level Database Systems Concepts 1.4 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Levels of Abstraction $  $  • Physical level: describes how a record (e.g., customer) is stored. • Logical level: describes data stored in database, and the relationships among......

Words: 1023 - Pages: 5

Premium Essay

Database

...CIS 210 Week 7 Assignment 4 08/15/2012 Abstract In this paper I intend to address the following: * Discuss the requirements needed to build a database for the scheduling process. * Describe the advantages and disadvantages of moving the schedule to a database. * Create a graphical representation of your proposed database environment. * Explain how referential integrity can prevent mistakes in a database. Do the advantages outweigh the difficulty of setting it up? * Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements: * Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number, last name, first name, department, and email address. The course data should include: course number, course name, trainer employee ID number, and training location. * A relationship should exist between the tables. * Use referential integrity to make sure that each course has a valid trainer assigned to it. Week 7 Assignment 4 * Discuss the requirements needed to build a database for the scheduling process. The first step in creating a database is creating a plan that serves both as a guide to be used when implementing the database and as a functional specification after it has been implemented. The complexity and......

Words: 681 - Pages: 3

Premium Essay

Database Proposal

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

Words: 435 - Pages: 2

Premium Essay

Database Processing

...not required. 7.13 Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE. If you are using a DBMS, then at this point you should create a database named WPC and run the SQL statements from Review Questions 7.4, 7.5, 7.6, and 7.8 only. (Hint: Write and test an SQL script, and then run the script. Save the script as DPB-e12-WPC-Create-Tables.sql for future use.) Do not run your answers to Review Questions 7.7 or 7.9! After the tables are created, run your answers to Review Questions 7.10 through 7.13. Note that after these four statements have been run the table structure is exactly the same as it was before you ran them. 7.17 Write INSERT statements to add the data shown in Figure 2-32 to the ASSIGNMENT table. Run these statements to populate the ASSIGNMENT table. (Hint: Write and test an SQL script, and then run the script. Save the script as DBP-e12-WPC-Insert-ASSIGNMENTData. sql for future use.) 7.26 Write one DELETE statement that will delete all data for project ‘2011 Q3 Product Plan’ and all of its rows in ASSIGNMENT. Do not run this statement. 7.30 What is an SQL view? What purposes do views serve? Why is this useful? 7.39 Explain how views can be used to improve data security. Chapter 7 SQL for Database Construction and Application Processing 303 7.40 Explain how views can be used to provide additional trigger functionality. 7.48 What is a trigger? 7.53 Assume that the View Ridge Gallery will allow a row to......

Words: 462 - Pages: 2

Premium Essay

Database Processing Ch 1 and Part of Ch 2

...Review Questions 1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things. 1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information. 1.12 What is the purpose of the largest databases used by e-commerce companies such as Amazon.com? - The largest databases used by e-commerce companies are Web-activity databases used to track customer behavior. 1.13 How do the e-commerce companies use these databases? - The e-commerce companies’ Web-activity databases are used to determine which Web page items are popular and successful, and to test if certain variations in Web page design will generate more orders. 1.14 How do digital dashboard and data mining applications differ from transaction processing applications? - Digital dashboard and data mining applications do not generate new data, but instead are used to summarize existing data to provide information to management. 1.15 Explain why a small database is not necessarily simpler than a large one. - While small databases vary from large databases in terms of the amount of data they store,......

Words: 1418 - Pages: 6

Premium Essay

Database Processing Chapt 2

...2.22 Write an SQL statement to display all of the columns using *. SELECT * FROM INVENTORY; 2.26 Write an SQL statement to display the SKU, SKU_Description, and Warehouse on products having QuantityOnHand equal to 0. Sort the results in descending order by Warehouse and ascending order of SKU. SELECT SKU, SKU_Description, Warehouse FROM INVENTORY WHERE QuantityOnHand =0 ORDER BY Warehouse DESC, SKU; 2.30 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Use the BETWEEN keyword. SELECT SKU, SKU_Description, WarehouseID, QuantityOnHand FROM INVENTORY WHERE QuantityOnHand BETWEEN 2 AND 9; 2.30 (11th Edition) Write an SQL statement to display the SKU and SKU_Description of all items stored in the Seattle, Chicago, or New Jersey warehouse. Use the IN keyword. SELECT SKU, SKU_Description FROM INVENTORY WHERE Warehouse IN ('Seattle', 'Chicago', 'New Jersey'); 2.35 Explain the difference between the SQL built-in functions COUNT and SUM. COUNT counts the number of rows or records in a table, while SUM adds up the data values in the specified column. 2.35 (11th Edition) Write an SQL statement to show SKU and SKU_Description for all products having an SKU_Description starting with “Half-dome”. SELECT SKU, SKU_Description FROM INVENTORY WHERE SKU_Description LIKE 'Half-dome%'; 2.36 Write an SQL statement to show SKU......

Words: 476 - Pages: 2

Free Essay

Database

...transformation processes. In actual sense, relational database offers a solution to this menace. Data organization, keeping, storage, and retrieval among other essentials can easily be realized by adopting relational data management model. In this kind of model, tables are made use of in such a way that data items are formally described and organized according to their level of relations. The data item contained in a given table represents a relation. I am convinced beyond reasonable doubt that through the use of relational database model, an organization can be able to effectively manage their wide range of information encountered on a daily basis. Relational database model offers a more efficient means of managing data. Some of the huge benefits are discussed as follows. A relational database is a collection of relations or tables. The rows of a table in a relational database are known as tuples and each column of a table is called an attribute. By definition, a relation becomes a set of tuples having the same attributes. Operations, which can be performed on the relations are select, project and join. The join operation combines relations, the select queries are used for data retrieval and the project operation identifies attributes. The information oif the organization can be captured, manipulated, managed, and shared, and the value the database brings to the organization is immense. The advantages of a relational database are that they contribute to sound logical......

Words: 554 - Pages: 3

Premium Essay

Database Management

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

Free Essay

Database

...1.1 Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data merupakan satu satuan informasi yang akan diolah dimana sebelum diolah dikumpulkan di dalam suatu file database. Pengumpulan data dilakukan secara sistematis menurut struktur file database. • Database merupakan kumpulan data yang terkait satu sama lain. Atau sekumpulan data yang terintegrasi yang diorganisasi untuk memenuhi kebutuhan pemakai untuk keperluan organisasi. • Dalam database pastinya mengenal istilah DBMS (Databse Management System) yang mana merupakan suatu koleksi dari program yang mana pengguna bisa mengcreate dan memaintain suatu database. Dalam DBMS terdiri atas proses-proses yang harus dilakuka nyaitu defining, constructing, manipulating dan sharing. Komponen-komponen DBMS yaitu terdiri atas hardware, software, data, prosedur, people. Fungsi dari defining yaitu DBMS harus dapat mengolah pendefinisian data. Fungsi dari manipulating DBMS harus dapat menangani permintaan-permintaan dari pemakai untuk mengakses data. Fungsi dari constructing yaitu DBMS harus mengontrol proses pengiriman data ke penyimpanan medium. Fungsi dari sharing yaitu database memperbolehkan banyak orang dan program untuk mengakses database. • Meta data: informasi terstruktur yang bertujuan untuk mendeskripsikan,......

Words: 1618 - Pages: 7

Premium Essay

Database Analysis

...Database Analysis Paper Angel Vega CIS/205 7/14/2011 Prof. Allen Database Analysis Paper The Countertop Guys is an organization located in Fort Lauderdale, Florida that provides service to The Home Depot and Lowes stores as a countertop and cabinet manufacturer. This small business currently covers all South Florida and part of the Treasure Coast. The Countertop Guys uses a SQL Database to keep up with the manufacturing, customer service and work order processing. The database application used is Filemaker Pro and this application enables the users to keep track of work orders status, material daily production reports among others. Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used. It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures, indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB. The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with an .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension. Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. A page is the......

Words: 930 - Pages: 4

Premium Essay

Database

...Business Rules and Data Models DeMone Wallace Professor Carmen Flores CIS 111 July 25, 2015 Databases are very helpful because they contain and organize content on many different topics. Perhaps the three most important uses of creating and using a database would be to store, retrieve, and analyze information. A database can typically be accessed easily, and is usually stored on computers. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as a personal phone and address book. Though the data and categories may change from business to business, the direct use of the information in a college student database can vary from marketing and advertising to obtaining new student enrollment and creating programs for funding. When collecting information for databases that are used for business purposes, certain laws must be followed that protect consumers to avoid the mishandling of the information. Data collected by college databases serve multiple purposes from marketing and advertising, to government and business reporting. Information that may be commonly useful in this type of database is date of birth, marital status, sex, income, race, location, and veterans/military status. When students are searching for colleges and universities online, student surveys collect demographic information used for tracking enrollment trends. In 2010, Collegetrend.com......

Words: 683 - Pages: 3

Premium Essay

Database

...Case Study: Database Development ALEXANDRA DESINORD PROFESSOR OSAMA MORAD CIS 515- STRAT PLAN FOR DBASE SYSTEMS Week 7 Assignment February 29, 2016 The more companies base their large elements of their business strategy around data, the need for IT team and executives with deep understanding of data and analytics is growing rapidly. Data changes all of the time. That is why it is essential that companies should try to stay up to par with the ever changing technology so that they can ensure that the system can withstand anything that comes about. Down below I will discuss briefly the various aspects of the SLDC and the tasks that can be completed to help solve certain common problems that exist from within. Customer data management is not high on many organizations' lists of priorities until it has to be. The term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system is called Systems development life cycle (SDLC). This term is also referred to as the application development life-cycle, which is a term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system. The task of optimizing the software development process has faced many obstacles. The main obstacle is a lack of accurate and complete data on the development process. The use of the......

Words: 2352 - Pages: 10