Premium Essay

Cis110

In:

Submitted By mssawn
Words 369
Pages 2
Assignment #2: Give a short definition for each of the following terms: compound condition is formed by connecting two or more simple conditions using either And and Or.
SQL is short for Structured Query Language
CREATE TABLE is a command to create a table by describing its layout. computed field isa filed whose values are derived from existing fields. sub query A sub query is a query that’s inside another query. A sub query is evaluated first.
SQL built-in functions Otherwise known as aggregate functions are used to calculate the number of entries, the sum of all of the entries,and the largest or smallest values in a column.

Answer the following questions:
1. What is the simplest SQL retrieval? The SELECT-FROM-WHERE command.
2. What is the purpose of the Where clause when using SELECT? The purpose of this clause is to be able to list any conditions that are to be applied to the data retrieved.
3. What are data types and why are they important?
4. Provide an example of the GROUP by clause, when would you use this clause? You would use this clause if you wanted to organize your data for a particular record.
5. What is an aggregate function (provide 4)? How are they used? COUNT, SUM,AVG, MIN. Aggregate functions are the built in functions in SQL. They are used to count within the query.
6. Provide example using the COUNT() function
SELECT COUNT(*)
FROM Customer
WHERE Class=’HW’

7. How is a field name qualified? A Field name is qualified by preceding the name of the filed with the name by the table followed by a period. How is this used when using a JOIN command, why is it important? This is used when using the JOIN command when there is potential doubt in listing the field names. This is important to make sure that you are joining the correct fields.
8. What are the three update commands in SQL?

Similar Documents

Premium Essay

Cis110

...CIS110 Midterm 1. In Word Document, explain how to merge cells. To merge the cells together you first need to make a table with columns and rows. To do this you need to click on the insert tab and then click on the table’s icon. Next you select the number of rows and columns that you need to have. Once you have inserted the table you can take your white pointer to the left side of the row that you are trying to merge together and highlight that row. Then you can go to the top of the page and click on the layout tab and then click on the merge icons tab located directly below the layout tab. 2. In Word document, explain how to create and modify a “Heading” by using Distinctive Style. To modify a heading using distinctive styling you need to go to the top of the screen and click on the little arrow icon in the bottom right hand corner of the styles box. The scroll over to heading 1 and right click and select modify. There you will make your changes to the specifications that you are given and once you have done all of your changes you can save them. Next you’re going to want to go back to the top of the screen and click on the Change Styles icon located at the top right corner of the windows screen. Click on the icon then scroll down to the style select and click on distinctive. Extra Credit Question #4. In Excel, Explain how to select a number of cells, and explain how to copy the content of a cell to other cells. First of all to select a number of cells what...

Words: 411 - Pages: 2

Free Essay

Cis110

...Running head: Module 1 Module 1 Homework Lesly Purvis Allied American University Author Note This paper was prepared for CIS 110, Module 1, taught by Farooq Afzal. Flow of Control Flow of Control refers to the order in which statements we have in the program are executed. The order can be ascending, descending or can execute a set of instructions a certain number of times where some values ​​are changed and until the value meets some condition is stop executing those instructions. Determine, the order of the instructions, depends primarily on the algorithm that we developed in the program (Campbell, Islam, Raila, & Madany, 1993). Sequential flow Refers to the execution of instructions one after the other, i.e., a line to the next without skipping any, is where the output of one is the input of another. The sequential flow is almost nonexistent since many programs do function calls, and this makes it not sequential. Function When you call a function jump either conditional or unconditional is done, the "code block" class is executed and when it completes the block is returned to the address stored in memory before the jump, the function causes it to return to that address with the instruction "return". This is what we call function subroutines or subprograms (Calder & Grunwald, 1994). Alternative flow It is when the program counter does not follow the next instruction (as in the sequential flow) and jump directly to another although this in one direction...

Words: 685 - Pages: 3

Free Essay

Informatiom System

...Name: Ariagna Briceno Date: 01/23/2012 CIS110 Smartlipo Smartlipo Laser Body Sculpting is a revolutionary, minimally invasive treatment that does something, no fitness routine in the world can: permanently destroy fat cells. Since your body has only a finite amount of these cells, no new fat cells come back. You can finally have that body you have always wanted. How does Laser Body Sculpting work? This laser-assisted lipolysis procedure is performed using a one millimeter cannula (or tube) inserted into the skin. A laserfiber inside of the cannula delivers energy directly to fat cells, causing them to rupture and drain away as liquid. Simultaneously, tissue around the area coagulates, resulting in overall tighter skin tissue. What areas of the body can be treated? Laser Body Sculpting is ideal for the neck, jaw line, arms, breasts, bra fat, abdomen, inner and outer thighs and knees. Who is a good candidate? A perfect candidate is in good health and of normal body weight. How does Laser Body Sculpting compare to conventional liposuction? Convention liposuction is meant to remove greater amounts of fat. However, since this can leave behind unsightly pockets of skin. Is there a recovery period? Laser Body Sculpting is a minimally invasive procedure which usually requires only local anesthesia. Some light trauma can occur, but you will be able to return to work in a couple of days and resume exercise after 2 weeks. How...

Words: 263 - Pages: 2

Premium Essay

Cis 111

...1. What is the simplest SQL retrieval? The simplest versions of the most important SQL command are SELECT, FROM statement. Then if you need to limit the result you introduce the WHERE clause. In the WHERE clause you can use operators such as LIKE, AND, OR, EQUAL, BETWEEN and IN. 2. What is the purpose of the Where clause when using SELECT? The purpose of this clause is to be able to list any conditions that are to be applied to the data retrieved. 3. What are data types and why are they important? A data type is a classification identifying one of various types of data, they are important because assigning data types gives meaning to collections of information 4. Provide an example of the GROUP by clause, when would you use this clause? SELECT Salesperson, SUM(Revenue) AS ‘Total’, MIN(Revenue) AS ‘Smallest’, MAX(Revenue) AS ‘Largest’, AVG(Revenue) AS ‘Average’, COUNT(Revenue) AS ‘Number’ FROM Orders GROUP BY Salesperson You use this clause when you need to see the information in a certain order 5. What is an aggregate function (provide 4)? How are they used? An aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement AVG() - Returns the average value (average) COUNT() - Returns the number of rows (count) FIRST() - Returns the first value LAST() - Returns the last value 6. Provide example using the COUNT()...

Words: 363 - Pages: 2

Premium Essay

A Long Way Gone

...CIS110-041 29 September 2014 A Long Way Gone Essay Questions 1. At the beginning of the novel, Ishmael describes war as too abstract for his mind to understand. He describes this as the mindset for all of the other people in his village as well. When Ishmael and his friends have nowhere to go, they roam nearby cities and what they see is unbearable to their young eyes. All of the destruction, dead bodies, and ransacked homes really put things in perspective for young Ishmael. I feel like this is the first time that Ishmael realizes what is really happening around him. When Ishmael is forced into the army, killing becomes his second nature. He is also on drugs such as cocaine, marijuana, and “brown brown” to help conceal his emotions. Dead bodies and carrying an AK-47 becomes a normal, every day thing for Ishmael. He completely loses sight of any sort of morals or self-respect that he had for himself as a young child. Ishmael had transformed from an innocent, unaware kid into a cold-blooded killer. Later on in the book, UNICEF rescues Ishmael and the other child soldiers that were in his army. UNICEF handed over Ishmael to the United Nations and they then entered him into rehab. After the rehab and all of the caring people, especially from one particular nurse named Esther, Ishmael is finally able to forgive himself. Being dehumanized was very easy for Ishmael, but reclaiming his humanity was extremely hard. 2. From previous years of studying about Africa and all the problems...

Words: 428 - Pages: 2

Free Essay

Latest Operating System in Modern World

...Part 1: Check Your Understanding Instructions: Answer the questions below for more practice with key terms and concepts from Part 1. Visit www.pearsonhighered.com/techinaction to check your answers and to find other activities related to the chapter. Multiple Choice 1. Which is not an example of a smartphone operating system? a. iOS b. BlackBerry c. Android d. Linux 2. You are most likely to find a real-time operating system (RTOS) a. in your automobile b. on a laptop c. on a smartphone d. on an iPad 3. All of the following are key attributes of an operating system EXCEPT a. manages memory and storage b. provides a user interface c. manages the CPU d. tracks connections to external networks 4. Modern operating systems such as Windows and OS X use a _____________ interface. a. command-driven b. graphical user c. menu-driven d. text-based 5. If your computer can’t store all the required operating system data in RAM, it can use a temporary file on the hard drive to store data. This is known as a _________ file. a. Linux b. non-volatile c. swap d. thrash True–False _____ 1. Each device attached to your computer needs a device driver to communicate with the operating system. (True) _____ 2. The first step of the boot process is the Power-on self-test (POST). (False) Part 1: Critical Thinking 1. Market Dominance Microsoft and Apple are large corporations and have control of most of the OS market. Although there have been some innovative changes to...

Words: 1075 - Pages: 5

Premium Essay

Doc, Docx Pdf

...Free eChapters (FALL 2012) eChapters offer students immediate access to the first few chapters of their textbooks while they are waiting for the print book to arrive. eChapters help students to keep up with required reading and assignments until they receive their course material, without having to pay expedited shipping costs. eChapters that are available from the publisher are attainable free of charge. How do students gain access to free eChapters? Not all courses or textbooks have eChapters available. For all courses where eChapters are available, the files are located in the student’s Blackboard course shell under the Student Center. Below is a list of courses with eChapters loaded into the course shells, giving students free access as of the first day of classes. * = eChapters are forthcoming Course ID ACC100 ACC206 ACC303 ACC304 ACC305 ACC306 Text Title Accounting Principles – 9th edition Accounting Principles – 9th edition Intermediate Accounting 14e Intermediate Accounting 14e Intermediate Accounting 14e Microcomputer Applications for Accounting Excel 2010 Microsoft® Excel 2010: A Case Approach, Complete, 1st Edition, copyright 2011 SOUTH WESTERN FEDERAL TAXATION 2012: COMPREHENSIVE, 36th ed. South-Western Federal Taxation 2013: Corporations, Partnerships, Estates and Trusts, 36th Edition Cost Accounting 13th 09 ed. Advanced Accounting 4th 10th ed. Auditing & Assurance Services 13th 10 ed. Core Concepts of Government and Not for Profit Accounting 2nd ed., 2011 ed ACC...

Words: 3676 - Pages: 15

Premium Essay

Aau Catalog

...ALLIED AMERICAN UNIVERSITY Personalized. Flexible. Dedicated. Online Programs – Individual Support – Open Enrollment – Ease of Transfer Credits UNIVERSITY CATALOG 2013 Seventh Edition 22952 Alcalde Drive, Laguna Hills, CA 92653 Phone: (888) 384-0849 ∼ Fax: (949) 707-2978 7:00 A.M. – 5:00 P.M. (Monday – Friday) Email: info@allied.edu Website: www.allied.edu KEY STAFF AND FACULTY Charlotte Hislop, Ph.D. Candidate, President/CEO Bonny Nickle, Ed.D., Provost Eric Sharkey, M.Ed., Director of Education Bill Luton, Ph.D., Director of Assessment and Dean of Business Carlo Tannoury, Ph.D. Candidate, Dean of Computer Information Systems Patricia Drown, Ph.D., Dean of Criminal Justice and General Studies C.J. Bishop, M.B.A., Institutional Research Frank Vazquez, Operations Director Parrish Nicholls, J.D., Director of Compliance Lindsay Oglesby, Admissions Director Abby Dolan, B.A., Registrar Sasha Heard, M.B.A., Student Services Manager Barbara Jobin, B.S.B.A., Career Center Manager Hugo Aguilar, B.A., Chief Financial Officer Richard Madrigal, B.A., Financial Aid Officer As a prospective student at Allied American University, you are encouraged to review this catalog prior to signing an enrollment agreement. You are also encouraged to review the student performance fact sheet which must be provided to you prior to signing an enrollment agreement. This catalog is not a contract between the student, AAU, or any party or parties. Reasonable effort was made at the time this document...

Words: 52297 - Pages: 210