...Jose P. Mendoza CISS 430 Database Systems January 24, 2016 Instructor: Gary Farrar Assignment: Week 2 Dropbox Q 2.20 Write an SQL statement to display unique WarehouseIDs. Statement: select DISTINCT WarehouseID from INVENTORY Q 2.29 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. Do not use the BETWEEN keyword. Statement: select SKU, SKU_Description, WarehouseID, QuantityOnHand from INVENTORY where QuantityOnHand > 1 and QuantityOnHand < 10; Q 2.31 Write an SQL statement to show a unique SKU and SKU_Description for all products having an SKU description starting with “Half-Dome”. Statement: select SKU, SKU_Description from INVENTORY where SKU_Description = 'Half-dome'; Q 2.33 Write an SQL statement to show a unique SKU and SKU_Description for all products having a ‘d’ in the third position from the left in SKU_Description. Statement: select SKU, SKU_Description from INVENTORY where SKU_Description like '__d%'; Q 2.36 Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order to TotalItemsOnHand. Statement: select distinct WarehouseID, SUM(QuantityOnHand) as TotalItemsOnHand from INVENTORY group by WarehouseID order by TotalItemsOnHand; Q2.42 Write an SQL statement to display the SKU, SKU_Description...
Words: 376 - Pages: 2
...Chapter 1 Databases and Database Users Copyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-Wesley Chapter 1 Outline Types of Databases and Database Applications Basic Definitions Typical DBMS Functionality Example of a Database (UNIVERSITY) Main Characteristics of the Database Approach Types of Database Users Advantages of Using the Database Approach When Not to Use Databases Copyright © 2011 Ramez Elmasri and Shamkant Navathe Types of Database Applications Traditional Applications: Numeric and Textual Databases in Business Applications More Recent Applications: Multimedia Databases (images, videos, voice, etc.) Geographic Information Systems (GIS) Data Warehouses Real-time and Active Databases Many other applications Initial part of book focuses on traditional applications A number of recent applications are described later in the book (for example, Chapters 26,27,28,29) Copyright © 2011 Ramez Elmasri and Shamkant Navathe Basic Definitions Database: A collection of related data. Data: Known facts that can be recorded and have an implicit meaning. Mini-world: Some part of the real world about which data is stored in a database. For example, student registration, grades and transcripts at a university. Database Management System (DBMS): A software package/system to facilitate the creation and maintenance...
Words: 1892 - Pages: 8
...Database Systems name 3-12-2012 Web-407 Advanced Web Development instructor's name Introduction Most companies need some type of database. A company may be small or extremely large but they all share one thing in common, if they make any type of product, sell anything, keep contacts, balance the books, pretty much anything a business can any will do, they need some type of database or multiple databases to store and later retrieve the data a typical business generates. Choosing the right database is even more important in the age of the Internet, products and services can be sold around the world now and the data from shopping carts and other payment and shipping needs a database too. This article will go into a bit more detail on some of the types of databases that are available and how to pick the right one for your company. Open Source vs. Proprietary This is the big question on a lot of businesses minds these days. Rather to try and cut costs by integrating an Open Source database or a proprietary one. First off let us go over what open source means. Open source software, in this case a database, is software that generally has a limited license for free using. The software is developed and maintained by developers and coders around the world that continuously work at improving the software but providing security upgrades and bug fixes. Proprietary software on the other hand is generally developed, upgraded and patched by a company that sells or licenses the software...
Words: 1313 - Pages: 6
...Hector Platon Carol Segura Fundamentals of Database Systems CS251-1303B-03 20 Aug 2013 According to Mike Chapple, Server Base Databases (Microsoft SQL, Oracle or IBM DB2) are commonly used in large organization as this type of database is able to handle sufficient amount of data simultaneously within reach of any users. This data is being updated to the server once a user resaves the file (Chapple, 2013). Server Base Database offers flexibility, powerful performance and scalability for its users which makes it a major choice for servers in most organizations. File Database (QSYS, SQLite) uses simple functions and generally uses single disk file. File Database can use several platforms. File Database can be used in 32 bit and 64 bit systems. File Database offers an excellent array of stability to its users as it functions cross platforms. Data sharing is better processed in bigger line of database management systems such as server base, wherein throughout the organization the synchronization of data is immense and constant changes is created simultaneously while File database may offer and give out cross formatting features for its clients however it can only handle minimal amount of data and is rather less reliable than the server base (Hip, 2013). My recommendation to my supervisor is to use a single database in both receiving and shipping area. The conflict begins with the shipping department that uses a Cobol program that is a stand-alone and cannot...
Words: 480 - Pages: 2
...Legacy Database Systems What is a Database? Data is collection of facts and figures which can be processed to produce information whereas a database is a collection of related data. For Example, Name of a student, age, class and the subjects can be counted as data for recording purposes. And the names, telephone numbers, and addresses of the people which have been recorded in an indexed address book or stored on a portable hard drive using software such as Microsoft Access or Excel. This collection of related data having an absolute meaning is a database. Databasе Managеmеnt Systеm: Database Management System or DBMS refers to the mechanism of storing and reclaiming users’ data with uttermost efficiency along with the sеcurity fеaturеs....
Words: 1258 - Pages: 6
...DATABASE SYSTEMS To understand what drives database design, you must understand the difference between data and information. Data are raw numbers or other findings which, by themselves, are of limited value to decision makers. Information, on the other hand, is the result of organizing, processing, and interpreting data, thus transforming the findings into facts that are useful to decision makers. For example, the number of new users your clinic serves in a month means little until you compare it with the number of new users from previous months and years to see whether there has been an increase or decrease in the trend over time. Data are transformed into information by: Selection: Choosing the data that are useful and adequate for answering the questions that have been posed, and ignoring the data that are useless or inadequate for that purpose. Interpretation: Analyzing the data to put them into context, uncover patterns or problem areas, and reflect on the meaning of these patterns in relation to the questions being asked. The overall objective of converting data to information is to describe, explain, predict, and/or evaluate a program and its results. In this “information age” production of accurate, relevant and timely information is the key to good decision making. In turn, good decision making is the key to business survival in a global market. We are now said to be entering to “knowledge age”. Data are the foundation of information which is bedrock of knowledge...
Words: 4278 - Pages: 18
...Problems 2,4,5,6 2. What is data redundancy, and which characteristics of the file system can lead to it? Data redundancy is a condition that exists when data environment contains redundant (unnecessarily duplicated) data and conflicting types of the data show up in other places. It can also cause information anomalies, as a change event may require multiple changes to the data. 4. What is a DBMS, and what are its functions? A database management system is a collection of programs that manages the database structure and controls access to the information stored in a database. 5. What is structural independence, and why is it important? Data characteristics that exists when changes in the database schema do not affect data access. Structural independence is important because when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. 6. Explain the differences among data, information, and a database. Data are raw facts and information is the result of processing raw data to reveal meaning and stored in a database. Chapter 2 problems 13, 14, 15 13. What is a table, and what role does it play in the relational model? A table is a matrix of intersecting rows and columns. In the relational model, the table view of data makes it easy to spot and define entity relationships, thereby greatly simplifying the task of database design. 14. What is a relational diagram? Give an example. The relations diagram...
Words: 427 - Pages: 2
...How can Play On Toys ensure its information technology systems are ready for growth? Issue: Play On Toys has enjoyed 5 years of success in the European market, experiencing strong growth, particularly in the past year, increasing its staff from 16 to 60 employees. With 200 customers, Play On Toys fulfils 3000 orders annually, with a turnover of 5million Euro and 1.4 million in pre-tax profit. Having expanded its range from 2 to 20 products, Play On Toys now works with 30 suppliers to acquire the 110 parts required to manufacture its wares. Expansion into Asia, Africa and America is planned over the coming three years, with the accompanying growth and challenges of moving into new markets and expanding the operation, Play On Toys is at a critical junction. Ensuring that internal systems are functioning at highest efficiency and are prepared for growth are essential elements for the continued success of Play On Toys. Currently, records and information for critical areas including sales, financial, production, and customer relations are held in isolated electronic and paper files as well as some small databases. Essential reporting and transaction processing are highly dependent on manual inputs. Critically, sales orders submitted via the website must be manually processed by sales administrators in a process requiring printing orders and entering them into a spreadsheet manually. The current system of record keeping and reporting lacks cohesion and efficiency, and coupled...
Words: 3888 - Pages: 16
...DATABASE S YSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT CARLOS CORONEL • STEVEN MORRIS • PETER ROB Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob Vice President of Editorial, Business: Jack W. Calhoun Publisher: Joe Sabatino Senior Acquisitions Editor: Charles McCormick, Jr. Senior Product Manager: Kate Mason Development Editor: Deb Kaufmann Editorial Assistant: Nora Heink Senior Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted...
Words: 189848 - Pages: 760
...Examination Paper of Data Base Management Systems IIBM Institute of Business Management Examination Paper Subject Code- E1010 Database Management Systems Section A: Objective Type (20 marks) This section consists of Multiple Choice Questions / True & False. Answer all the questions. Each Question carries 1 mark. MM.100 Multiple Choices: 1. Structured Query Language (SQL) is the language for working with a. DDBMS b. RDBMS c. Both (a) & (b) d. None of the above 2. Decomposition in database design means a. Breaking one table into multiple tables b. Breaking two table into multiple tables c. Composing multiple tables into one table d. None of the above Locking helps a. Hiding the database b. To solve concurrency problems c. Both (a) & (b) d. None of the above 3. 4. Database optimizer a. Enhances the speed of query execution b. Minimizes the speed of query execution c. Is a program d. None of the above 5. Data is __________. a. Raw facts b. Processed information c. Both (a) & (b) d. None of the above 6. Mobile computing means a. Ability to use computer while on still b. Ability to use computer while on move c. Calculation with the help of mobile d. None of the above 1 IIBM Institute of Business Management Examination Paper of Data Base Management Systems 7. Operation Data Store (ODS) provides a. Situation sensitive decision support & operational reporting b. Time sensitive decision support & operational reporting c. Both (a) & (b) d. None of the above 8. Transaction...
Words: 831 - Pages: 4
...Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security Needs and Security Plan Keywords: Grandfield College, Database Design, Recommendations, Business Rules, Data model, Security Plan Database Management System Grandfield College is in need of Database Management System as law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. For this purpose I have developed a Software Tracking database for Grandfield College. Problem Grandfield College is in need of a database for effectively tracking faculty and staff computers, the software installed on those systems, User access to each computer, and requests for new software installation...
Words: 4672 - Pages: 19
...HR Database Systems Question 1 The two commercial HR database systems that I would recommend for my organization are the Oracle Human resources Management systems and the HR Quik HR database system. Using the HR Quik HR database system provides an advantage in that its reports are very simple to run with all its data being generated in Excel. It can track the costs and benefit plans of employees and all the data within the systems can easily be merged with an employee’s documents (Lee, Tan & Wuwongse, 2006). This database also generates forms automatically with regards to the newly hired employees and those who have been terminated; it saves the documents which have been scanned and offers sample forms for guiding users in their generation and use (Kavanagh, Thite & Johnson, 2011). However, the database also has several disadvantages manifested in its inability of creating security profiles, facilitating the effective performance of audit trails due to its concurrent access anomalies and it only offers cloud-hosting features as an optional tool only in some of those models found in the market (Singh, 2009). On the other hand, the Oracle Human Resource Management System also offers several advantages to its users that include the creation and definition of user and security profiles, enabling the effective performance of audit trails and enables the HR to make payroll payments as it has the capability of handling multiple assignments. The Oracle Human Resource Management System...
Words: 1036 - Pages: 5
...Addis Ababa Institute of Technology ITSC Fundamentals of Database Systems Laboratory Practice Note: This laboratory practice will be evaluated at the end (10% of final grade) Prepared BY: Tigabu D. Based on the information given below Develop: i) ER diagram for the company ii) Convert the ER diagram you designed in question I in to tables (relational database) iii) Implement the tables and relationships in question ii using a DMBS of below a. Microsoft access 2007/2010/2013 (Select One version) b. My SQL or Windows SQL Server 2005/08/12 (Select One version) Company Information: ■ The company is organized into Departments. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. ■ Each department controls a number of Projects. Each project has a unique name, unique number and is located at a single location. ■ We store each Employee’s social security number, address, salary, sex, and Birthdate. ■ Each employee works for one department but may work on several projects. ■ We keep track of the number of hours per week that an employee currently works on each project. . ■ Each employee may have a number of Dependents. ■ For each dependent, we keep track of their name, sex, Birthdate,...
Words: 254 - Pages: 2
... Page 19 Conclusion Page 20 Bibliography Page 21 Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database architecture related to their online activities. Internal Schema (Server) Conceptual Schema (Programmer) External (Customer) External (Supplier) External (Business partners) External (Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these...
Words: 2877 - Pages: 12
...Database What is a database system? A database is can be thought of as an electronic file cabinet where everything is placed in it that needs to be remembered or to be documented for future referencing and where what you put in is exactly what you get out. In other words, a database holds everything that is important for you work or home. It is your e-filing cabinet. (Shenron, 2008) A database keeps important information for any future work close to hand so that the access of this information is almost instant without the hassle of paperwork or manual filing. This type of electronic data storage is very useful for users who are accessing the data from a network or shared drive. This allows users on the same network to have access to all the information at the same time without loss of data. Working for the State of Alaska as a Title 36 (public construction) Accounting Technician is very challenging as Alaska is a very big state and the requirements for this position are many and varied. One of the responsibilities is the management of the public construction database. This database holds all data on any public construction (over $2,000) in the state. The information is about the prime contractors, awarded state projects, the state agencies, who bid out the projects, and the projects themselves. Without the use of a database, there would be no reasonable way to track all the information that is required by this state office such as monthly reports, investigator reports, tracking...
Words: 611 - Pages: 3
