...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
...using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace CIS247_Week3ilabrevised_JohnDoe //John Doe //CIS 247A Week 3 iLab //Employee Class Program { class Employee { private string firstName; private string lastName; private char gender; private int dependents; private double annualSalary; private double pay; public static int numEmployees = 0; public const string DEFAULT_FIRST = " not given"; public const string DEFAULT_LAST = " not given"; public const char DEFAULT_GENDER = 'U'; public const int DEFAULT_DEPENDENTS = 0; private const double DEFAULT_ANNUALSALARY = 20000; public Employee() { FirstName = DEFAULT_FIRST; LastName = DEFAULT_LAST; Gender = DEFAULT_GENDER; Dependents = DEFAULT_DEPENDENTS; AnnualSalary = DEFAULT_ANNUALSALARY; numEmployees++; } public Employee(string first, string last, char gen, int dep, double salary) { firstName = first; lastName = last; gender = gen; annualSalary = salary; numEmployees++; } public string FirstName { get { return firstName; } set {firstName = value;} } public string LastName { get { return lastName; } set {lastName = value;} } public char Gender { get { return gender; } set {gender = value;} } public int Dependents { get { return dependents; } set { dependents = value;} } public double AnnualSalary { get { return annualSalary; } set { if(value > 19999) ...
Words: 415 - Pages: 2
... nevertheless most importantly by my professor. Although, writing can be challenging when writing for professors or future employer or other authority in that category. Due to pressure of excelling , anxiety of doing passing/ failing or anticipation of the ending, for instance if a writing task is given by a supervisor or professor, the paper is not adequate. There is possibility that you can be written up, fired or receive an deteriorating grade . On the other hand, there is a affirmative side, That’s my target . Which will enable me to advance in all of my writing coursework in this class and future classes. In addition, I plan to use my writing skills , not only in the class room setting , but my professional life, instituting my writing ability through my resume, cover letter, or assigned writing task. I also will use writing in my personal life, Through reading more books and which is said to boost your writing skills. However, I take an slightly special approach when setting goals for my dissertations. The first step that take is writing down my ideas about the subject given. Next, I distribute those thoughts and organize them with the outline procedure. Proceeding, I design a first draft, which is...
Words: 328 - Pages: 2
...Shape class
/** * This is a class that represent any shape. This is the superclass of all shapes. * @author yklam2 * */ public class Shape { private boolean canvas[][]; private int width; private int height; /** * Create an empty shape. */ public Shape() { this(0, 0); } /** * Create a shape with a specific width and height. * @param width The width of this shape. * @param height The height of this shape. */ protected Shape(int width, int height) { this.width = width; this.height = height; canvas = new boolean[height][width]; } /** * Set a pixel * @param row The row of the pixel. * @param column The column of the pixel. */ protected void setPixel(int row, int column) { if(row >=0 && row < height && column >=0 && column < width) canvas[row][column] = true; } /** * Clear a pixel * @param row The row of the pixel. * @param column The column of the pixel. */ protected void clearPixel(int row, int column) { if(row >=0 && row < height && column >=0 && column < width) canvas[row][column] = false; } /** * Get the area of this shape. Area is the number of pixel set in this * @return The area. */ public int getArea() { int area = 0;
shape.
for(boolean [] row: canvas) for(boolean pixel: row) if(pixel) ++area; } return area;
/* (non-Javadoc) * @see java.lang.Object#toString() */ public String toString() { String drawing = ""; for(boolean [] row: canvas) { if(drawing.length() > 0) //...
Words: 704 - Pages: 3
...In a classroom setting, discipline and management are two key components for classroom success. The term classroom management is often used interchangeably with the term classroom discipline. However, the two ideas are very different in their application. Management and discipline are two halves of the same coin, they are intrinsicly connected to each other, but they have their own individual properties, with their own look and feel. Classroom management deals with how things in a class are done. Classroom management is the sole responsibility of the teacher. It encompasses all of the teacher’s interactions with students, classroom environment, rules and procedures, instructional strategies and development of engaging work. In a well managed classroom, the teacher implements policies and develops routines that stabilize and direct the flow of a class. Effective teachers manage their classes so that students spend their time more productively. Elements of classroom management vary. No two classes are alike. However the foundational elements a teacher takes into account before students ever set foot in the build can lend to better classroom management. Things such as classroom layout and organization.A neat and organized classroom tells your students you mean business and you expect them to keep the classroom organized as well. Deciding how to divide up classroom time is another important aspect to classroom management.Lunch, recess, breaks, down-time between lessons and activities...
Words: 1027 - Pages: 5
...Women My psychology class meets every Thursday morning. It is a small class of five students and one instructor. Being in such a small class was unsettling at first because I felt I could not be overlooked by the instructor. I have gotten accustomed to bigger classes where I would blend into the crowd and just be a name in the instructor’s book. Over the last three weeks, I have observed my classmates and my instructor and have learned a thing or two about them. I have also realized how being in a smaller class is actually much more pleasant than previously anticipated. Our classroom is fairly big considering the size of the class. There are eight tables with four chairs at each table. The walls are tasteless, showing only one poster advertising Bryant & Stratton’s impeccable ability to create the world’s best workforce. The teacher’s corner sits at the front of the room while the projector screen hangs on the left wall. Because this is a small class, this poses no problems but I can imagine the seating dilemma if the room were actually full while using the projector system. Mr. Streett is the instructor for this class, a recent graduate from Radford University with a Master’s of Art in Experimental Psychology. He speaks quickly repeating short sentences rephrased but implying the same meaning to help his students grasp the concept being taught. Though he seems to know his stuff, he comes to class unprepared, taking the first 30 minutes of class to make copies...
Words: 1052 - Pages: 5
...(FF) had been running a small, for-profit preschool program for young children between the ages of two and four for several decades. FF was one of several privately run programs in the suburban Boston area. For each of the three age groups (i.e., two-, three- and four- year olds), there were two classes per day for a total of six classes in the facility each day. The classes were held both in the morning and in the afternoon, five days a week between September and June; there were approximately 200 days (40 weeks), or 1,200 class meetings, per year. Only about one- third of FF's local competitors offered classes during the summer months. The morning classes ran from 9:00 a.m. to noon, and the afternoon meetings ran from 1:00 p.m. to 4:00 p.m. Lunch was not served in either class. However, each class served a snack to the children. Class size varied from nine to 15 students per class. Although there was a lot of pressure from parents to reduce class sizes, a recent article in an industry newsletter showed that, given current demographics, the market for such programs could increase by 10% a year for the next five years. The year before, a parent suggested that the school begin hosting birthday parties on the weekend. Since FF's three classrooms were empty during this time, it seemed like a good use of the space and could generate additional revenue. Over the past year, the school had managed to quickly build a sizable side business hosting birthday parties. Approximately...
Words: 431 - Pages: 2
...Java Class MIS 304 is not a class for everyone. Not just any student should take the class. This class is structured to assist students in learning how to program using the Java language. This class does not make a student an expert in the language of Java, but instead gives the student the basic fundamentals needed to have practical use of the language and gives them a solid foundation upon which they can build if they choose to do so. The material covered in the class is adequate. Java can be a complex language to learn, but in MIS 304 one is taught the basics and nothing too detailed or complicated. The resources that are given to the students are very good. I know that the Java book used for the class is one of the best reference materials on Java that is on the market today. The lab facilities and proctors are also great resources. The only problem I feel that exists is that students don’t take advantage of the resources they have available. Students hardly look through their book for answering questions they might have. Also students hardly even bring their books to the lab when doing programs. They sometimes look for proctors to fix their problems instead of fixing it themselves. I think it should be emphasized to students that the proctors are not their to do the programs for them, but to rather help them figure out what is going wrong in their programs. Also it should be emphasized that the book should be with them when working on programs so that if questions or...
Words: 2075 - Pages: 9
...similar to a class, which can contain only constants, method signatures, and nested types. There are no method bodies. Interfaces cannot be instantiated—they can only be implemented by classes or extended by other interfaces. In Java, a class can inherit from only one class but it can implement more than one interface. | Superclass Instance Method | Superclass Static Method | Subclass Instance Method | Overrides | Generates a compile-time error | Subclass Static Method | Generates a compile-time error | Hides | An abstract class is a class that is declared abstract. Abstract classes cannot be instantiated, but they can be subclassed. It can contain abstract methods that did not have implemented. Subclasses then provide the implementations for the abstract methods. An abstract method is a method that is declared without an implementation (without braces, and followed by a semicolon), like this: Except for the Object class, a class has exactly one direct superclass. A class inherits fields and methods from all its superclasses, whether direct or indirect. A subclass can override methods that it inherits, or it can hide fields or methods that it inherits. (Note that hiding fields is generally bad programming practice.) The Object class is the top of the class hierarchy. All classes are descendants from this class and inherit methods from it. Useful methods inherited from Object include toString(), equals(), clone(), and getClass(). You can prevent a class from being...
Words: 328 - Pages: 2
...util.ArrayList; public class Student { // Declare the variables private String name; private ArrayList homeworks; // Constructor with one argument public Student(String name) { this.name = name; this.homeworks = new ArrayList(); } // setter or mutator methods change the field values public void setName(String name) { this.name = name; } //Accessor or getter methods provide the field values public String getName() { return name; } public void addHomeworkGrade(int newGrade){ this.homeworks.add(newGrade); } //average homework score public double getComputeAverage(){ int total = 0; //loop through homeworks, add to total for(Integer grade : this.homeworks){ total += grade; } //calculate average double average = total / (double)this.homeworks.size(); return average; } //Override the toString method to return the string representation public String toString() { DecimalFormat pattern = new DecimalFormat("0.00"); return (getName() + "'s average grade is " + pattern.format(getComputeAverage())); } } ------------------------ import java.io.FileReader; import java.io.BufferedReader; import java.io.FileNotFoundException; import java.io.IOException; import java.util.HashMap; import java.util.Iterator; import java.util.LinkedList; import java.util.Queue; import java.util.Set; import java.util.StringTokenizer; public class Test { public static void...
Words: 366 - Pages: 2
...Reflection Paper In our GEP class we discussion many different topics about our first college experience. We were given a list of questions to discuss and one of the main questions we discussed was how different college is from high school. We also had a discussion on how we were all nervous about going to college. Knowing everyone else was just as scared as me made me feel a lot better and I didn’t doubt myself as much because I realized I wasn’t the only one going through those feelings, that it was normal. We all expressed our feelings on what we missed most about home and we love most about home. I felt like we all missed the same things and enjoyed the same things about college. Hearing them say they missed their parents, and animals just like made me feel like we all had a connection. That it’s normal for us to feel that way and it doesn’t mean we can’t do it. In class we also talked about our classes, which ones we like and which ones we don’t. Other students in our class gave me some helpful tips like being about to download Microsoft word for free for our campus help desk. Our teacher also made us feel like we were all the same and could express anything we wanted. He also gave us some helpful tips from his first college year. One topic we talked about that really invoked my feelings was if our parents helped us apply to college. My parents did not go to any college but they tried to help me as much as they could. I realized that some students in our class didn’t have that support...
Words: 613 - Pages: 3
...Package ‘quantmod’ July 24, 2015 Type Package Title Quantitative Financial Modelling Framework Version 0.4-5 Date 2015-07-23 Depends xts(>= 0.9-0), zoo, TTR(>= 0.2), methods Suggests DBI,RMySQL,RSQLite,timeSeries,its,XML,downloader Description Specify, build, trade, and analyse quantitative financial trading strategies. LazyLoad yes License GPL-3 URL http://www.quantmod.com https://github.com/joshuaulrich/quantmod BugReports https://github.com/joshuaulrich/quantmod/issues NeedsCompilation yes Author Jeffrey A. Ryan [aut, cph], Joshua M. Ulrich [cre, ctb], Wouter Thielen [ctb] Maintainer Joshua M. Ulrich Repository CRAN Date/Publication 2015-07-24 21:10:42 R topics documented: quantmod-package addADX . . . . . . addBBands . . . . addCCI . . . . . . addExpiry . . . . . addMA . . . . . . addMACD . . . . . addROC . . . . . . addRSI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
Words: 4206 - Pages: 17
...HELPIDO.COM Follow this link to get the tutorial http://helpido.com/download-and-study-the-code-provided-in-the-bluej-project/ Follow this link to get the tutorial http://helpido.com/download-and-study-the-code-provided-in-the-bluej-project/ Download and study the code provided in the BlueJ project roman_numerals_buggy.zip. Rename this BlueJ project to roman_numeral_soln (this is the BlueJ project you will be submitting). You can rename the project by renaming the folder from roman_numerals_buggy to roman_numeral_soln after extracting the zip file. The purpose of this code is to convert Arabic numerals into Roman numerals. Make an instance of RomanNumerals and invoke the method toRoman(int n). Enter a number in the Arabic notation and it will convert it to a Roman numeral. For example “17” will be converted to “XVII”.You will notice a test suite that we provide with the code. Run the test suite by right-clicking on RomanNumeralsTest and choosing Test All as shown in Figure 6.3 of the book. Alternatively, you can click on the Run Tests button as shown in Figure 6.2 of the book, if you have enabled the ‘Show unit testing tools’ preference. To enable it, go to Tools > Preferences > Miscellaneous, and select ‘Show unit testing tools’. You will notice a total of eight tests of which two fail. Your first task in this assignment is to study the given code, identify why the two tests fail, and correct the code. On studying the code further, you will...
Words: 568 - Pages: 3
...Imagine being in a class that has 10-15 kids in a classroom. Great, right? Always having the teacher when someone needs him or her, and being able to pay attention easier and the class is never too loud. Now imagine being in a class with 40-60 people in it. It’s always loud and hard to pay attention. Now think, do class sizes really matter? Do smaller classes really work better and achieve more? Are they more efficient? Class sizes are becoming more of a problem but what are we going to do? Limiting class sizes is one way to solve this problem but it’s not he only way. For example in “Classes Are Growing”, the author states “Researches compared the achievements of pupils in kindergarten through grade 3 who were randomly assigned to small classes, of 13 to 17 children, or to regular classes, of 22 to 25 with either a teacher or a teacher with a full time aid.” After preforming this analysis in Tennessee the results conclude that by lowering the class size their performance level was increased by a tenth of a standard, but when this research was repeated in California and Wisconsin didn’t have the same conclusion. The author of “Everyone knows students learn more in smaller classes, or do they” has the palpable reason why this happened. The author explains how there are to many variables to know if the size of the class really matters. “Well, what other reasons are there?” Cutting back on class sizes can lead to budget problems. Splitting 60 kids into 5 classrooms is causing more...
Words: 420 - Pages: 2
...Muhammad 1 Mikey Muhammad Date Class Mr.Radev Java Programming and Inheritance As time continues to pass, the world we now live in is dominated by the use of technology. Technology continues to advance, and it seems, as if we can’t function without it. Whether it’s the use of technology in school or work, it is everywhere and you cannot escape it. It is important for us to be able to adapt to it and learn how the new inventions work and function properly. The Internet for example is one of the most important aspects of life today. The Internet allows us to have access to everything, and have endless information at our fingertips, whether it’s through a computer screen or through the use of a cellular device, or even a watch. Some of us choose to only use this amazing tool that has been provided to us, and then some us choose to go more in depth with this tool we call the Internet and want to know how it works. Although it takes millions of programs and concepts and other factors to get the Internet working how it does, the focus of my term paper will be Inheritance in Java. In order to truly understand what the specifics of Java are, you have to start with the totality of the Java program. The Java language could easily be the most difficult to understand because there are so many components to how it works. Java is a programing language and computing platform, which is a huge part of making the Internet work. It was first released by Sun Microsystems in 1995. Without...
Words: 1332 - Pages: 6
