Premium Essay

Cis 111

In: Computers and Technology

Submitted By Cjdbcharm
Words 363
Pages 2
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() function

SELECT COUNT(*)

FROM employees

WHERE salary > 25000;

7. How is a field name qualified? How is this used when using a JOIN command, why is it important?

A Field name is qualified by preceding the name of the filed with the name by the table followed by a period. This is used when using the JOIN command when there is potential doubt in listing the field names. This is

Similar Documents

Premium Essay

Cis 111

...Database management system (DBMS) A database management system (DBMS) is a program, or a collection of programs, through which users interact with a database. The actual manipulation of the underlying database is handled by the DBMS. In some cases, users may interact with the DBMS directly. In other cases, users may interact with programs such as those created with Visual Basic, Java, Perl, PHP, or C++; these programs, in turn, interact with the DBMS, as shown in Figure 1-9. In either case, only the DBMS actually accesses the database. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, recovering the database after failures and restoring it from backup files, as well as maintaining database security. Entity An entity is a person, place, object, event, or idea for which you want to store and process data. The entities of interest to Premiere Products, for example, are sales reps, customers, orders, and parts. Attribute, Column, Field An attribute is a characteristic or property of an entity. The term is used in this text exactly as it is used in everyday English. An attribute is also called a field or column in...

Words: 858 - Pages: 4

Premium Essay

Cis 111

...Bring Your Own Device (BYOD) Bikash Rasaily Deborah Blockett CIS 333 10/24/2014 Many working people appreciate Apple with its iPhone as well as blackberry for inventing the concept of BYOD also known as Bring your own device (Egan, 2013). Under BYOD concept, employees bring their own mobile devices and PCs to perform their job tasks at workplace. Many organizations that have embedded this concept in their workplace have benefit from it but we should also keep in mind about IT security of the company. Some of the key benefit of using BYOD include increased productivity and innovation, employee satisfaction and Cost saving (BYOD: Bring your own device, 2014). Employees are more comfortable with their device and are experts in using it, which makes them more productivity and innovative (BYOD: Bring your own device, 2014). They can work whenever and wherever they want and don’t have to be in their desk to do their office work. BYOD programs also help in saving money but shifting the cost to the user, with employees paying for their device and data services (BYOD: Bring your own device, 2014). Employees would be satisfied if they use the device they have chosen and invested in rather then what was selected by IT (BYOD: Bring your own device, 2014). The key way of this concept is about allowing the staff to take and use their own device is seen as employer being open-minded and flexible. The new generation prefers to work in the flexible environment where his or her bosses...

Words: 1110 - Pages: 5

Premium Essay

Cis 111 Assignment 1

...Assignment 1: Business Rules and Data Models A database is an incorporated PC structure that stores end-user information and metadata (Leake, A.). Data is the raw format of information, which when structured properly, it can produce accurate, relevant, and timely information that is the key to making a good database management system. The true purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly. A local college has tasked me to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants me to make the database keep track of the instructors teaching each of the courses. The local college database, will be to store the data of enrolled students, the courses offered and class schedule, and the information of the instructors. The database will provide course matches for each student based off previous courses taken and pre-requisites obtained, as well as keep track of the instructors that are teaching the class. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as student ID. Entities (Tables) are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique object that may be a physical or abstract object within real life (for example:...

Words: 780 - Pages: 4

Premium Essay

Cis: 111 Strayer University Assignment 1

...Assignment 1: Business rules and Data Models CIS 111: Introduction to Relational Database Management Systems Purpose of Database Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models. Entities and Attributes of Database There will be three main entities in the system; the students, the instructors and the courses. The students’ attributes would be last name, first name, social security number, and phone number, date of birth, address, student ID, level of education, enrollment date, GPA, any standardized test scored, all accepted credits, and their class schedule. The attributes for the instructors would be last name, first name, teacher ID, salary, address, telephone numbers (and or extensions), certifications, degrees, and the course code that they will be teaching. The courses attributes would be a specific course code. Along with the course code each individual class would have to have a code as well. This would make the system easier to keep track of instead of having it spelled out next to either the instructors' or the student's name. The relationship...

Words: 691 - Pages: 3

Premium Essay

Director

...he problem with Compaq is that they developed too much IT architecture using financial advisory, where R&D and openness keys to development and the culture, while ignoring the environment. Open communication and trust was barricaded and destroyed by ASK (financial IS). The workers were being motivated by fear, much like Geneen in Morgan’s Images Of Organization. From an IT architecture standpoint, numbers based on the finance division depicted the entire company, even the organizational structure. The organizational structure did not align with the IT architecture, and the culture did not align with it either. Morgan stated, “The division of labor characteristic of industrial societies creates a problem of integration, or what may be more accurately described as a problem of integration, or what may be more accurately described as a problem of “cultural management.”” Compaq started as a functional structure, changed into a divisional fairly soon and then back to functional. Culture was strongly emphasized over anything else. CASH stated, “The process encompassed a whole range of ideas, including (1) the rule of inclusion, (2) teamwork, (3) “working the issue,” and (4) consensus building.” The IS system at Compaq did allow the free-flow of information through email named “B-mail.” ASK was used for financial services so that the company could easily track orders, and know where it stood financially. The culture felt monitored by ASK operators since it “becomes responsible for...

Words: 5841 - Pages: 24

Free Essay

Acs-Code of Ethic

...ACS Code of Ethics Case Studies & Related Clauses to the Code of Conduct Australian Computer Society July 2012 Title ACS Code of Ethics Case Studies & Related Clauses to the Code of Conduct Authors Committee on Computer Ethics Mike Bowern Version History Date Document Version Revision History (reason for change) Author /Reviser July 2012 2.0 ACS Branding Sarah Li Approvals Date approved Version Approved By Date in force Date of Next Review To be confirmed 17 July 2012 2.0 Ruth Graham 17 July 2012 Custodian title & e-mail address: Responsible Business Group: Distribution: ruth.graham@acs.org.au Professional Standards, Learning & Development General (no restriction on distribution) Content Security: Unclassified Australian Computer Society | ACS Code of Ethics Case Studies & Related Clauses to the Code of Conduct | July 2012 Page 2 ACS CODE OF ETHICS CASE STUDIES & RELATED CLAUSES TO THE CODE OF CONDUCT This document provides a range of case studies with references to relevant clauses of the ACS Code of Ethics. These Codes consists of a series of clauses which gradually expand on aspects of ethical behaviour relevant to professional people in the ICT industry. Clause 2.0 describes the Code of Ethics, summarised as six values: The Primacy of the Public Interest; The Enhancement of the Quality of Life; Honesty; Competence; Professional Development; and Professionalism. Clauses 2.1 through to 2.7 cover the ACS Code...

Words: 13862 - Pages: 56

Free Essay

Home Style Cookies

...Case no. 1 Home Style Cookies Members: Abrasaldo, Patty Angela Albina, Ciela Carpio, Rochelle Jinson, Mary Mae Ramirez, Erikka Mae Romano, Mariah Corinne Shiraishi, Chandie Case no. 1 Home Style Cookies Central Problem: The Lew-Mark Baking Company is unadaptive to change and isn’t open for new opportunity of the Company in terms of innovation, productivity and processing. Alternative Courses of Action 1. The Company should try making new product such as hard/ crispy cookies. 2. The Company should use suppliers who are located closer to the plant. 3. The Company should add preservatives or additives to certain product to increase shelf life. 4. The Company should consider the use of technologies in packaging. Than manual labor. 5. The Company should think of new ways to create a new and better products. Evaluation 1. The Company should try making new product such as hard/ crispy cookies. Advantages: A) The Company can attract a new customers. B) The Company can compete with other larger companies. Dis Advantages: A) Additional Cost B) Time- Consuming 2. The Company should use suppliers who are located closer to the plant. Advantage: A) Reduce delivery lead times and transportation cost. Dis Advantage: A) Quality of product might suffer. 3. The Company should add preservatives or additives to certain product to increase shelf life. Advantages: A) The Company can attract new...

Words: 432 - Pages: 2

Free Essay

Lovebunny

...PASSAIC COUNTY COMMUNITY COLLEGE APPROVED SCHEDULE OF TUITION AND FEES FOR FY 2012-2013 2011-2012 TUITION All Students (with the exception of online and dual enrollment students noted below) NJ Residents/Per Credit Out-of-State Residents/Per Credit ONLINE TUITION Students Taking Online Classes - NJ Residents/Per Credit Out-of-State Residents/Per Credit ONLINE FEES (Per Student, Per Semester) All online courses (OL section code) taken by PCCC students*** *** This fee is charged only once, regardless of the number of online course taken per semester. DUAL ENROLLMENT/HIGH SCHOOL STUDENTS All PCCC courses offered at high schools when taught by high school teachers^^ ^^This fee is per course without additional fees charged. GENERAL FEES (Charged Per Credit)^ General College/Per Credit (All Students) Student Activity/Per Credit Athletic Activity Fee/Per Credit Technology Fee/Per Credit (All Students) ^ Online credit will be charged the General College fee per credit as well as a Technology Fee per credit. Online courses do not have associated Student Activity or Athletic Activity Fees. REGISTRATION, BURSAR & OTHER FEES Immunization Fees Measles, Mumps & Rubella (MMR) (per dose) Hepatitis B (per dose) Transcript (Overnight mail only) Diploma Replacement Non-Credit Certificate Replacement Fee Late Registration Non-Attendance Fee (per course) Credit by Examination (per course) Credit by Examination (NU 101) Payment Plan Set-up Fee Late Payment Fee Bad Check ID Card Replacement Paterson...

Words: 853 - Pages: 4

Premium Essay

Cis111

...The Advantages of a relational Model According to ACME Global’s website the mission of ACME Global is to “Help clients achieve profitable growth by aligning and improving customer facing processes and by continually seeking ways to improve operational performance"(“ACME Global,”2014) Because of your consultants over 100 clients maintain successful business with financially and operationally sound strategies. To continue this success and expand on that success a relational model would be easy to use. The revision of any information as tables consisting of rows and columns is much easier to understand. This would play a vital role in organization of not just your consultants but when you stop and look at your clients and the data you are responsible to managing along with the common data and information you want to know. An E-R Model provides Flexibility: Different tables from which information has to be linked and extracted can be easily manipulated by operators such as project and join to give information in the form in which it is desired. This would be most beneficial to you when you look at your areas of Strategic Development and Business planning, marketing & Sales Strategy and your Operations and Organization Management. In all of these are areas are key data and resources of ACME Global that would be enhanced by using a relational model. Purpose of an E-R Model Specific to ACME Global Consulting ACME Global along with your partner Deegit, Inc. deliver innovative...

Words: 672 - Pages: 3

Free Essay

Cis 510 Week 7 Assignment 3

...A++PAPER;http://www.homeworkproviders.com/shop/cis-510-week-7-assignment-3/ CIS 510 WEEK 7 ASSIGNMENT 3 CIS 510 Week 7 Assignment 3, CIS 510 Week 7 Assignment 3 – Strayer Assignment 3: Creating a Domain Model Class Diagram Due Week 7 and worth 150 points Refer to the RMO CSMS domain model class diagram shown in Figure 4-23 on page 111 of the textbook and the discussion of subsystems in Chapter 3. Write a two to three (2-3) page paper in which you: Using Microsoft Visio or an open source alternative such as Dia, create a domain model class diagram for the RMO CSMS marketing subsystem. Note: The graphically depicted solution is not included in the required page length. Provide a narrative describing your diagram that includes: An overview of the diagram An analysis of the different classes in the diagram Use at least three (3) quality resources outside of the suggested resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. Include a cover page containing the title of the assignment, your name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required...

Words: 322 - Pages: 2

Premium Essay

Get Online Help with Ur Assignment Ashford a+Material

...http://homeworktimes.com/downloads/acc-202-complete-course-acc-202-entire-course/ http://homeworktimes.com/downloads/acc-206-entire-course-new/ http://homeworktimes.com/downloads/acc-206-new-week-1-assignment-chapter-one-problems/ http://homeworktimes.com/downloads/acc-206-new-week-2-assignment-chapter-two-three-problems/ http://homeworktimes.com/downloads/acc-206-new-week-2-journal-institute-management-accounting/ http://homeworktimes.com/downloads/acc-206-new-week-3-assignment-chapter-four-five-problems/ http://homeworktimes.com/downloads/acc-206-new-week-3-journal-hershey-company/ http://homeworktimes.com/downloads/acc-206-new-week-4-assignment-chapter-six-seven-problems/ http://homeworktimes.com/downloads/acc-206-new-week-5-assignment-chapter-eight-problems/ http://homeworktimes.com/downloads/acc-206-new-week-5-assignment-final-paper/ http://homeworktimes.com/downloads/acc-212-financial-accounting/ http://homeworktimes.com/downloads/acc-250-complete-course-acc-205-entire-course/ http://homeworktimes.com/downloads/acc-290-complete-course-acc-290-entire-course/ http://homeworktimes.com/downloads/acc-291-complete-course-acc-290-entire-course/ http://homeworktimes.com/downloads/acc-340-entire-course-acc-340-complete-course/ http://homeworktimes.com/downloads/acc-400-complete-course-acc-400-entire-course/ http://homeworktimes.com/downloads/acc-407-entire-course/ http://homeworktimes.com/downloads/acc-455-complete-course/ http://homeworktimes.com/downl...

Words: 3197 - Pages: 13

Premium Essay

Pico Notes

...Title: Pain, Coping and Sleep in Children and Adolescents with Sickle Cell Disease (Quantitative?) Abstract: Purpose The study examined the relationships among pain, pain coping, and sleep, and assessed factors (age, gender, frequency, and intensity of pain) that affect pain, coping, and sleep in children with sickle cell disease ( SCD). Methods Participants (66) were 39 children ( M = 11.5 years) and 27 adolescents ( M = 15.5 years) with SCD who completed an electronic visual analog scale ( eVAS), Pain Coping Questionnaire, and Pittsburg Sleep Quality Index. Results About two-thirds of the children reported pain the previous month. No significant differences were found between pain and age, gender, pain intensity, or frequency. Most children coped with pain by seeking information, problem solving, seeking social support, and positive self-statements. There were significant negative correlations in males between worse pain severity and behavioral distraction and internalizing or catastrophizing. The majority (91.2%) had mild to severe sleep disturbances, with 18.2% requiring sleeping medication three or more times a week. There were no significant differences between sleep and age, gender, pain intensity, or frequency. Conclusion Children with SCD experience pain that affects sleep patterns and the way they cope with pain. Nurses need to concurrently assess pain, coping, and sleep and promote sleep hygiene and positive coping strategies during pain episodes. Graves, J. K....

Words: 3160 - Pages: 13

Free Essay

Compressor Controls

...Cas # 1 Travail présenté à la Faculté des sciences de l’administration à M. Donald Béliveau Université Laval Comme exigence partielle pour le cours MRK-6087 : Politique de prix Par Tébéreye Bâ 111 062 283 Arlette Gounouo 111 063 138 Félix Létourneau 909 331 414 Salomé Thériault 111 073 071 Le 18 septembre 2013 Question 1 : En utilisant un modèle, montrez de quelle façon la valeur économique pourrait être calculée pour ce produit. Veuillez faire toutes les hypothèses qui sont pertinentes. Pour estimer la valeur économique de notre produit, nous avons utilisé le modèle "Value-based pricing" proposé notamment par les auteurs Nagle, Hogan & Zale (2011). Cela consiste à identifier le prix de la meilleure alternative à notre produit, à évaluer tous les gains supplémentaires que procure le produit pour le consommateur, autant monétairement que psychologiquement, et finalement à soustraire les différenciations que ce dernier perçoit comme étant négatives. Dans notre cas, le produit offert est un système qui permet d’éviter une surtension des compresseurs qui pressurisent et dirigent le gaz vers les "pipelines". La valeur de notre produit est donc basée sur le fait qu’il diminue le risque (nombre) de surtensions. Ceci permet aux clients d'éviter des pertes de production potentielles et des coûts supplémentaires. Lorsqu’il n’y a aucun mécanisme de contrôle, on estime que par année, il y a 0.4 surtension mineure et 0.004 surtension majeure...

Words: 2908 - Pages: 12

Free Essay

Business

...welq ZvwiL I w`b mKvj 10Uv n‡Z ‡ejv 1Uv ch©šÍ †KvW we‡Kj 2Uv n‡Z 5Uv ch©šÍ †KvW evsjv (Avewk¨K) 1g cÎ 101 mnR evsjv 1g cÎ 103 01/04/2013 X X evsjv fvlv I evsjv‡`‡ki ms¯‹…wZ 1g cÎ 105 †mvgevi evsjv (Avewk¨K) 1g cÎ (DIBS) evsjv (Avewk¨K) 2q cÎ 102 mnR evsjv 2q cÎ 104 03/04/2013 X X evsjv fvlv I evsjv‡`‡ki ms¯‹…wZ 2q cÎ 106 eyaevi evsjv (Avewk¨K) 2q cÎ (DIBS) Bs‡iwR (Avewk¨K) 1g cÎ 107 07/04/2013 X X iweevi Bs‡iwR (Avewk¨K) 1g cÎ (DIBS) Bs‡iwR (Avewk¨K) 2q cÎ 108 09/04/2013 X X g½jevi Bs‡iwR (Avewk¨K) 2q cÎ (DIBS) A_©bxwZ 1g cÎ 109 1| evsjv fvlv I mvwnZ¨ 1g cÎ 147 c`v_©weÁvb(ZË¡xq) 1g cÎ 174 149 11/04/2013 2| Bs‡iwR fvlv I mvwnZ¨ 1g cÎ e¨emvq bxwZ I cÖ‡qvM 1g cÎ 229 e„n¯úwZevi e¨emvq msMVb I e¨e¯’vcbv (Ave:) 1g cÎ (DIBS) A_©bxwZ 2q cÎ 110 1| evsjv fvlv I mvwnZ¨ 2q cÎ 148 c`v_©weÁvb(ZË¡xq) 2q cÎ 175 15/04/2013 2| Bs‡iwR fvlv I mvwnZ¨ 2q cÎ 150 e¨emvq bxwZ I cÖ‡qvM 2q cÎ 230 †mvgevi e¨emvq msMVb I e¨e¯’vcbv (Ave:) 2q cÎ (DIBS) ‡cŠibxwZ 1g cÎ 111 1| Bmjv‡gi BwZnvm I ms¯‹…wZ 214 RxeweÁvb (ZË¡xq) 1g cÎ 178 (Bmjvgx wk¶v kvLv) 1g cÎ 18/04/2013 e¨emvq D‡`¨vM I e¨envwiK e¨e¯’vcbv 1g cÎ 231 2| D”Pv½ msMxZ (ZË¡xq) 1g cÎ 218 e„n¯úwZevi evsjv muvUwjwc (ZË¡xq) 1g cÎ (DIBS) ‡cŠibxwZ 2q cÎ 112 1| Bmjv‡gi BwZnvm I ms¯‹…wZ 215 RxeweÁvb (ZË¡xq) 2q cÎ 179 (Bmjvgx wk¶v kvLv) 2q cÎ 21/04/2013 e¨emvq D‡`¨vM I e¨envwiK e¨e¯’vcbv 2q cÎ 232 2| D”Pv½ msMxZ (ZË¡xq) 2q cÎ 219 iweevi Bs‡iwR kU©n¨vÛ (ZË¡xq) 1g cÎ (DIBS) 22/04/2013 g‡bvweÁvb...

Words: 1954 - Pages: 8

Free Essay

Politique de Sécurité Mobile Ti

...SIO-2102 Sécurité, contrôle et gestion du risque | Travail individuel 2 2014/10/22 | | François-Jérôme Gosselin | 111 061 640 | Faculté des Sciences de l’administration | Politique sur l’usage des technologies mobiles de l’Industrielle Alliance (IA). 1.0 Raison d’être La raison d’être de cette politique est de mettre en place des procédures de contrôle du matériel informatique mobile, des restrictions d’utilisation à des fins de sécurité et des protocoles d’accès sécurisés au matériel de stockage amovible contenant des informations confidentielles de l’IA. 2.0 Portée La portée de cette politique englobe l’utilisation de tout matériel informatique mobile utilisant, contenant ou pouvant contenir des informations sensibles appartenant à l’IA. À prendre en compte que cette politique s’applique strictement sur l’utilisation du matériel, les précautions et mesures à adopter par les courtiers, sans toutefois représenter pour autant une politique sur la propriété matérielle de l’IA. Le terme « employé » peut être utilisé afin de désigner les « courtiers » de l’IA à travers la politique. Politique 3.1 Contrôle Tout le matériel mobile devant accéder au système d’informations de l’IA doit être muni d’un pare-feu à identification unique pour chaque courtier affilié à l’IA. La combinaison d’un numéro d’employé unique et d’un mot de passe unique est donc obligatoire sur n’importe quel appareil mobile, appartenant à l’IA ou non, afin...

Words: 857 - Pages: 4