Premium Essay

Database Processing

In: Computers and Technology

Submitted By wsbloxton
Words 462
Pages 2
7.1 What does DDL stand for? List the SQL DDL statements.
7.2 What do es DML stand for? List the SQL DML statements.
7.4 Write a CREATE TABLE statement for the DEPARTMENT table.
7.6 Write a CREATE TABLE statement for PROJECT table. The default value for MaxHours is 100. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

7.9 Write an alternate SQL statement that modifies your answer to Review Question 7.7 to make the relationship between EMPLOYEE and ASSIGNMENT a 1:1 relationship.
7.10 Write an ALTER statement to add the column AreaCode to EMPLOYEE. Assume that
AreaCode is 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…...

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

Premium Essay

Database

...form. Once the system is done with the coding stage it tests the systems and sees to it that it is working as per the expectations or not. System implantation is one of the most vital phases as in this phase the analyst actually gives the system to the customer and expects for a positive feedback. Finally, the system maintenance is that the analyst needs to maintain the system and see to it that it working within the standards set. He needs to maintain the system by removing the defects of flaws occurred. I think this relates to database development because in 1960 the developers, Elliott and Strachan and Radford developed large scale functional business systems in an age of large scale business conglomerates. Information systems activities revolved around heavy data processing and number crunching routines. The database is also a design lie cycle in my opinion because it is design in different stages in storing data and each of the components in the database might work similar but also in different ways. In requirements analysis, the head topics that I found are: project management tools, five common errors, and business analysts....

Words: 368 - Pages: 2

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

...A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs includeMySQL, PostgreSQL, SQLite, Microsoft SQL Server,Oracle, SAP, dBASE, FoxPro, IBM DB2, LibreOffice Base and FileMaker Pro. A database is not generally portable across different DBMS, but different DBMSs can by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database. Contents   [hide]  * 1 Terminology and overview * 2 Applications and roles * 2.1 General-purpose and special-purpose DBMSs * 3 History * 3.1 1960s Navigational DBMS * 3.2 1970s relational DBMS * 3.3 Database machines and appliances * 3.4 Late-1970s SQL DBMS * 3.5 1980s desktop databases * 3.6 1980s object-oriented databases * 3.7 2000s NoSQL and NewSQL databases * 4 Database research * 5 Database type examples * 6 Database design and......

Words: 771 - Pages: 4

Free Essay

Database

...of computers in information handling, there appeared a number of databases containing bibliographic details of documents, often married with abstracts, keywords, and so on, and consequently the concept of information retrieval came to mean the retrieval of bibliographic information from stored document databases. Information retrieval is concerned with all the activities related to the organization of, processing of, and access to, information of all forms and formats. An information retrieval system allows people to communicate with an information system or service in order to find information – text, graphic images, sound recordings or video that meet their specific needs. Thus the objective of an information retrieval system is to enable users to find relevant information from an organized collection of documents. In fact, most information retrieval systems are, truly speaking, document retrieval systems, since they are designed to retrieve information about the existence (or non-existence) of documents relevant to a user query. Lancaster3 comments that an information retrieval system does not inform (change the knowledge of) the user on the subject of their enquiry; it merely informs them of the existence (or non-existence) and whereabouts of documents relating to their request. However, this notion of information retrieval has changed since the availability of full text documents in bibliographic databases. Modern information retrieval systems can either retrieve......

Words: 5238 - Pages: 21

Premium Essay

Database

...meaning. Database - represents some aspect of the real world (miniworld or universe of discource – UoD). Collection of related data (a random assortment of data is not a database). A DB is designed, built, and populated with data for a specific purpose. It has an intended group of users and a some preconceived applications in which the users are interested. DBMS - is a collection of programs that enables users to create and maintain a database. database system – it is a combination of database and DBMS software. program – data independence – The structure of data files is stored in the DBMS catalog separately from the access programs. user view - – includes a number of external schemas that describes the part of the database that a particular user group is interested in and hides the rest of the database from that user group. DBA – is an IT professional that is responsible for Installation, Configuration, Upgrade, Administration, Monitoring, Maintenance and Securing of databases in an organization. The chief administrator of the database. end user - are the people whose jobs require access to the database for querying, updating, and generating reports; the database primarily exists for their use. data model - a collection of concepts that can be used to describe the structure of a database-provides the necessary means to achieve this abstraction. database schema - of a database system is its structure described in a formal language supported by the database......

Words: 959 - Pages: 4

Premium Essay

Cis Database Processing

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

Words: 448 - 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

...Database: Database is a group or collection of information which are assembled in such a way that a computer program can easily access the stored information and select required pieces of data. Databases are characterized in such a way that that it helps to store, retrieve, modify and delete data which is linked with various data processing operations. Advantages of Databases: • It helps to control data redundancy by centralizing databases although it is not necessary to eliminate all redundancy because sometimes it is used to store multiple copies of data due to business and technical reasons. • It helps to enforce integrity by enforcing specific integrity constraints which increases data integrity and independence of application programs. • It improves data security by restricting unauthorized access. • It helps to create an environment in which end users have easy access to data which helps them to respond quickly to changes in their environment. • It provides a backup for recovering from hardware or software failures. Disadvantages of Databases: • Database systems come at high cost which includes specific and sophisticated hardware, software and personnel for operating and maintaining this database system. • The complexity and breadth of functionality makes this system an extremely large piece of software which occupies large amount of disk space and requiring substantial amounts of memory to run efficiently. • There is a higher impact of failure due to the......

Words: 252 - Pages: 2

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

...meet the problems or opportunities of the business. 1) ___A. database analysis____ A) Database analysts B) Users C) Systems analysts D) Programmers TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 2) Database development projects are never done in a bottom-up fashion. 2) __False_ 3) A well-structured database establishes the entities between relationships in order to derive the desired information. 3) _False_ ESSAY. Write your answer in the space provided or on a separate sheet of paper. 4) Provide a brief overview of the various components of the database environment. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 5) Database processing programs are coded and tested during the design stage of the systems development life cycle. 5) __F__ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 6) Organizing the database in computer disk storage is done in the ________ phase. 6) _Design__ A) analysis B) design C) implementation D) maintenance 7) A workgroup database is stored on a central device called a(n): 7) __c. server_____ A) client. B) network. C) server. D) remote PC. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 8) Many of the disadvantages of file processing systems can also be limitations of databases. 8) ___T____ MULTIPLE CHOICE. Choose the one alternative......

Words: 336 - Pages: 2

Premium Essay

Databases

...Database and database components Database management system Database models Database languages Database warehouse Database dictionary and indexing Databases A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic قائمة مراجع, full-text, numeric, and images. Database components Tables, Columns and Rows These three items form the building blocks of a database. They store the data that we want to save in our database. * Character or information about the attributes of an entity is stored in fields that is, individual items of data that we wish to store (like customer’s name). and it is represented in a cell. Columns * All fields containing data about one entity form a record (like one customer). And it is represented by columns. Rows * All related records form a file (like the customer file). And it is represented by rows. In databases, a row can be made up of as many or as few columns as you want. This makes reading data much more efficient - you fetch what you want. Tables * A set of interrelated, centrally coordinated Files forms a database (like a customer database). And it is represented by tables that make up the entire database and it is important that we do not duplicate data at all, including both rows and columns. Keys * Keys are used to relate one table for another. For example, A......

Words: 3581 - Pages: 15

Equalizer Music Player Pro APK Full Version | Game Updates / DLC's | SONY Vegas PRO v13.0.373.