...CMIS102 Homework Assignment 3 Problem definition: Write a program that would calculate and display the results for the multiplication table for values ranging from 1 to 100. A. Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section. In order to write this program, two variables, ROWNUM and COLUMNNUM, will be used with nested repetition loop to complete the necessary calculations. ROWNUM will be used in an outerloop and contain numbers between1-10 and COLUMNNUM will be used in an innerloop and contain numbers between 1-10. For each iteration of the outerloop, the inner loop will be executed 10 times and the product of ROWNUM*COLUMNNUM will produce the multiplication table of ROWNUM. The ROWNUM and COLUMNNUM variables will be incremented by 1in each iteration of loops. The new line will be printed to display the multiplication table for each value of ROWNUM in a separate line. This table shows the outputs that will be generated from the calculations: 1 2 3 4 5 6 7 8 9 10 2 4 6 8 10 12 14 16 18 20 3 6 9 12 15 18 21 24 27 30 4 8 12 16 20 24 28 32 36 40 5 10 15 20 25 30 35 40 45 50 6 12 18 24 30 36 42 48 54 60 7 14 21 28 35 42 49 56 63 70 8 16 24 32 40 48 56 64 72 80 9 18 27 36 45 54 63 72 81 90 10 20 30 40 50 60 70 80 90 100 B. Program...
Words: 565 - Pages: 3
...Join in SQL SQL Join is used to fetch data from two or more tables, which is joined to appear as single set of data. SQL Join is used for combining column from two or more tables by using values common to both tables. JoinKeyword is used in SQL queries for joining two or more tables. Minimum required condition for joining table, is(n-1) where n, is number of tables. A table can also join to itself known as, Self Join. Types of Join The following are the types of JOIN that we can use in SQL. * Inner * Outer * Left * Right Cross JOIN or Cartesian Product This type of JOIN returns the cartesian product of rows from the tables in Join. It will return a table which consists of records which combines each row from the first table with each row of the second table. Cross JOIN Syntax is, SELECT column-name-list from table-name1 CROSS JOIN table-name2; Example of Cross JOIN The class table, ID | NAME | 1 | abhi | 2 | adam | 4 | alex | The class_info table, ID | Address | 1 | DELHI | 2 | MUMBAI | 3 | CHENNAI | Cross JOIN query will be, SELECT * from class, cross JOIN class_info; The result table will look like, ID | NAME | ID | Address | 1 | abhi | 1 | DELHI | 2 | adam | 1 | DELHI | 4 | alex | 1 | DELHI | 1 | abhi | 2 | MUMBAI | 2 | adam | 2 | MUMBAI | 4 | alex | 2 | MUMBAI | 1 | abhi | 3 | CHENNAI | ...
Words: 1005 - Pages: 5
...Displayed in table 3 is result of the survey conducted for question number 2. Table 3 Q2: Do you find it hard not to visit your Facebook account? Yes | Percentage | No | Percentage | Total | Percentage | 28 | 35% | 52 | 65% | 80 | 100% | Table 3 shows that the 52% disagreed that it’s not hard to visit their facebook account while the remaining 32% of the 80 respondents agreed. Displayed in table 4 is result of the survey conducted for question number 3. Table 4 Q3: Do you have Facebook friends that you really don’t know personally? Yes | Percentage | No | Percentage | Total | Percentage | 65 | 81% | 15 | 19% | 80 | 100% | Table 4 shows that the 81% agreed that they have friends they don’t know personally in facebook while the remaining 19% of the 80 respondents disagreed. Displayed in table 5 is result of the survey conducted for question number 3. Table 5 Q4: Do you spend more than an hour in Facebook? Yes | Percentage | No | Percentage | Total | Percentage | 49 | 61% | 31 | 39% | 80 | 100% | Table 5 shows that 61% agreed that they spend more than an hour using facebook while the 39% of the 80 respondents disagreed. Displayed in table 6 is result of the survey conducted for question number 5. Table 6 Q5: Do you have a Facebook account? Yes | Percentage | No | Percentage | Total | Percentage | 80 | 100% | 0 | 0% | 80 | 100% | Table 6 shows that all of them have a Facebook account. 100% Table 6 shows that 100% of the...
Words: 569 - Pages: 3
...query. Queries allow you to retrieve information from one or more tables based on a set of search conditions you define. Access 2007 will display your results in their very own table that you can analyze and manipulate further. This lesson will explain how to plan a query using a three-question planning process. You will learn how to use the Query Design command to run the query, as well as how to modify the query to hide fields or other information in your query results. Finally, it will show you how to save the query for later use. Using Queries Queries retrieve information from one or more tables based on a set of search conditions that you set up and then combine that information in a way that is easy for you to analyze. If you have used an Advanced Filter in Access 2007, then you have already run a very basic query on only one table. If you want to pull data from more than one table, though, you will need to use either the Query Design command or the Query Wizard. Before using the Access 2007 query tools, it is important to plan out the query using a logical process. Otherwise, you may not get the results you expect. Planning a Query There are three questions you need to answer when you are planning a query: What do you want the results to look like? Identify every field or bit of information that you want included in the results. Where is the information stored in the database? List which tables (and/or queries) hold the information that you want to see. ...
Words: 2519 - Pages: 11
...CHAPTER 6 Introduction to SQL LEARNING OBJECTIVES After studying this chapter, you should be able to: ■ Concisely define each of the following key terms: relational DBMS (RDBMS), catalog, schema, data definition language (DDL), data manipulation language (DML), data control language (DCL), scalar aggregate, vector aggregate, base table, virtual table, dynamic view, and materialized view. ■ ■ ■ ■ ■ Visit www.pearsonhighered.com/ hoffer to view the accompanying video for this chapter. Interpret the history and role of SQL in database development. Define a database using the SQL data definition language. Write single-table queries using SQL commands. Establish referential integrity using SQL. Discuss the SQL:1999 and SQL:2008 standards. INTRODUCTION Pronounced “S-Q-L” by some and “sequel” by others, SQL has become the de facto standard language for creating and querying relational databases. (Can the next standard be the sequel to SQL?) The primary purpose of this chapter is to introduce SQL, the most common language for relational systems. It has been accepted as a U.S. standard by the American National Standards Institute (ANSI) and is a Federal Information Processing Standard (FIPS). It is also an international standard recognized by the International Organization for Standardization (ISO). ANSI has accredited the International Committee for Information Technology Standards (INCITS) as a standards development organization; INCITS is working on the next version...
Words: 22483 - Pages: 90
...DB2 & SQL Concepts 1.2.1 What is SQL? Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. In accordance with the relational model of data, the database is perceived as a set of tables, relationships are represented by values in tables, and data is retrieved by specifying a result table that can be derived from one or more tables. DB2 transforms the specification of a result table into a sequence of internal operations that optimize data retrieval. This transformation occurs when the SQL statement is prepared. This transformation is also known as binding. 1.2.2 Static SQL The source form of a static SQL statement is embedded within an application program written in a host language such as COBOL. The statement is prepared before the program is executed and the operational form of the statement persists beyond the execution of the program. A source program containing static SQL statements must be processed by an SQL precompiler before it is compiled. The precompiler checks the syntax of the SQL statements, turns them into host language comments, and generates host language statements to invoke DB2. 1.2.3 Dynamic SQL A dynamic SQL statement is prepared during the execution of an SQL application, and the operational form of the statement is not persistent. The source form of the statement is a character string...
Words: 30246 - Pages: 121
...Resistors in Series ECET110 Seddik Benhamida November 2, 2014 Table of Contents 1. List of Figures and Tables …………………..…….……..…………….. 3 2. Project Objectives ………………………………….…….…………….. 4 3. System Requirements ….……………………………………………….. 4 4. Theory ………………………………………………………………….. 5 5. Multisim Simulation Results …………………………..………………………. 5 6. Experimental Procedure ………………………………………………… 6 7. Analysis of Results ..……………..…………………………………….. 6 8. Troubleshooting ….……..…………………………………………….. 6 9. Conclusion ..……………………………..…………………………….. 6 List of Figures 1. Resistor Circuit Schematic .………………………………….. 5 2. Multisim Simulation Circuit ………………………………………….. 6 3. Simulation circuit ..…. ………………………………………….. 7 List of Tables 1. Theoretical Analysis Results ………………………………………….. 5 2. Simulation Results …………………………………………………….. 6 3. Experimental Results …….…………………………………………….. 7 4. Results Comparison …………………………………………………… 8 Project Objectives When putting resistors in series, we can use this experiment to prove Kirchoff’s Voltage Law and Ohm’s Law by comparing our theoretical values to the Experimental values. System Requirements Equipment and Material Equipment: Macbook Air with the Citrix receiver software DC Power Supply DMM (Digital Multimeter) Software: Multisim Version 13 Parts: 3 – 1.0 kΩ Resistor 1 – 2.2 kΩ Resistor 1 – 6.8 kΩ Resistor Breadboard and hookup wires ...
Words: 291 - Pages: 2
...candidate set of facilities may also be known. The candidate set of facilities is selected from the demand points. The objective is to find the best P locations from the M candidate sites where P is less than or equal to M. 2. PROBLEM INSTANCE: The problem instance given in PMED01.dat file is considered for comparing Logware method and Linear Programming method. Problem data is taken from PMED01.dat file and demonstrated in Table 1. There are 12 markets being served from up to 5 candidate warehouse locations. The product is shipped over a road network. The annual volumes of the markets, the transportation rates, and the candidate sites with their fixed costs and X&Y Coordinates are shown in Table 1. Point X Y Volume, Transport Rate, No Coordinate Coordinate cwt $/cwt/mi M1 200 100 3000 0,002 M2 500 200 5000 0,0015 M3 900 100 17000 0,002 M4 700 400 12000 0,0013 M5 1000 500 10000 0,0012 M6 200 500 9000 0,0015 M7 200 700 24000 0,002 M8 400 700 14000 0,0014 M9 500 800 23000 0,0024 M10 800 900 30000 0,0011 M11 1200 300 4000 0,0001 M12 200 2000 2000 0,0002 Table 1. Problem Data of 12 Markets Fixed Candidate Cost, $ Sites 200 X 0 0 600 X 0 0 50 X 0 75 X 0 150 35 X In this problem; the objective is to find the best P locations from the 5 candidate sites. After preparing a problem database, the number of facilities to locate are specified. Calculated total costs by Logware and Excel/Solver are compared 3. SOLUTION BY LOGWARE/PMED TOOL: The problem database is prepared in Input...
Words: 1796 - Pages: 8
...on the table below. | Review Date |Reviewer | | | | | | | | | | Table of Contents 1 INTRODUCTION 1 2 IT SYSTEM CHARACTERIZATION 2 3 RISK IDENTIFICATION 6 4 CONTROL ANALYSIS 8 5 RISK LIKELIHOOD DETERMINATION 11 6 IMPACT ANALYSIS 13 7 RISK DETERMINATION 15 8 RECOMMENDATIONS 17 9 RESULTS DOCUMENTATION 18 LIST OF EXHIBITS Exhibit 1: Risk Assessment Matrix 18 List of Figures Figure 1 – IT System Boundary Diagram 4 Figure 2 – Information Flow Diagram 5 List of Tables Table A: Risk Classifications 1 Table B: IT System Inventory and Definition 2 Table C: Threats Identified 4 Table D: Vulnerabilities, Threats, and Risks 5 Table E: Security Controls 6 Table F: Risks-Controls-Factors Correlation 8 Table G: Risk Likelihood Definitions 9 Table H: Risk Likelihood Ratings 9 Table I: Risk Impact Rating Definitions 13 Table J: Risk Impact Analysis 13 Table K: Overall...
Words: 1518 - Pages: 7
...value for the specified attribute, but count considers null values. As an example, we can find the highest low-temperature reading anywhere with Execute the following query using postgreSQL and see the results: SELECT max(temp_lo) FROM weather; Note: The aggregate max cannot be used in the WHERE clause (This restriction exists because the WHERE clause determines the rows that will go into the aggregation stage; so it has to be evaluated before aggregate functions are computed.) Aggregates are also very useful in combination with GROUP BY clauses. For example, we can get the maximum low temperature observed in each city with Execute the following query using postgreSQL and see the results: SELECT city, max(temp_lo) FROM weather GROUP BY city; which gives us one output row per city. Each aggregate result is computed over the table rows matching that city. We can filter these grouped rows using HAVING: Execute the following query using postgreSQL and see the results: SELECT city, max(temp_lo) FROM weather GROUP BY city HAVING max(temp_lo) < 40; which gives us the same results for only the cities that have all temp_lo values below 40. Finally, if we only care about cities whose names begin with “S”, we might do Execute the following query using postgreSQL and see the results: SELECT city, max(temp_lo) FROM weather WHERE city LIKE ’S%’ GROUP BY city Begum Durgahee HAVING max(temp_lo) < 40; 1 Labsheet02 PostgreSQL7.4 The...
Words: 2268 - Pages: 10
...Which is not true about the USING keyword? A) you use it to simplify the syntax for joining tables B) you code a USING clause in addition to the ON clause C) it can be used with inner or outer joins D) the join must be an equijoin, meaning the equals operator is used to compare the two columns Points Earned: 0.0/2.0 Correct Answer(s): B Correct 2. When you code a SELECT statement, you must code the four main clauses in the following order A) SELECT, FROM, ORDER BY, WHERE B) SELECT, ORDER BY, FROM, WHERE C) SELECT, WHERE, ORDER BY, FROM D) SELECT, FROM, WHERE, ORDER BY Points Earned: 2.0/2.0 Correct Answer(s): D Correct 3. When coded in a WHERE clause, which search condition will return invoices when payment_date isn’t null and invoice_total is greater than or equal to $500? A) payment_date IS NULL AND invoice_total > 500 B) payment_date IS NOT NULL OR invoice_total >= 500 C) NOT (payment_date IS NULL AND invoice_total = 500 Points Earned: 2.0/2.0 Correct Answer(s): D Correct 4. The order of precedence for the logical operators in a WHERE clause is A) Not, And, Or B) And, Or, Not C) Or, And, Not D) Not, Or, And Points Earned: 2.0/2.0 Correct Answer(s): A Correct 5. Which of the following types of SQL statements is not a DML statement? A) INSERT B) UPDATE C) SELECT D) CREATE TABLE Points Earned: 2.0/2.0 Correct Answer(s): D Incorrect 6. Which of the following is not a common error when entering and...
Words: 1309 - Pages: 6
...With some adaptation, the format can be extended to other type of technical writings as well. TABLE OF CONTENTS ABSTRACT ................................................................................................................................i LIST OF FIGURES AND TABLES ......................................................................................... iii LIST OF SYMBOLS .................................................................................................................iv ACKNOWLEDGEMENTS ........................................................................................................v INTRODUCTION ......................................................................................................................1 EXPERIMENTAL DETAILS.....................................................................................................1 RESULTS AND DISCUSSIONS................................................................................................2 SECTION DESCRIPTIONS ...................................................................................................2 Letter of transmittal.............................................................................................................3 Abstract...............................................................................................................................3 Table of Contents...
Words: 3413 - Pages: 14
...Sankhadeep Biswas | | 3 | 12FN-131 | Soumya Roy | | 4 | 12FN-138 | SubhenduMitra | | 5 | 12FN-026 | Aritra Raymukherjee | | 6 | 12FN-048 | Gaurav Garg | | 7 | 12IT-001 | AbhisekKarmakar | | 8 | | | Contents Table of figures: 3 Introduction: 4 Hypotheses: 4 Hypotheses testing: 4 Descriptive Statistics: 4 Ho1: There is no difference in terms of investor’s response to all IPO Graded Issues. 5 Ho2: There is no difference in the IPO possessing different Grades in terms of Underpricing 6 Ho3: There is no relation between the IPO Grades and the Liquidity of the Issue on the listing Day 6 Ho4: There is no relation between IPO Grades and the IPOs Valuation 7 Impact of IPO grading on different Output Variables:Regression Analysis 9 Table of figures: Table 1: Descriptive Statistics of Age and frequency distribution for different IPO gradings 4 Table 2: Descriptive statistics for different subscriptions (times) against various gradings: 5 Table 3: Dependent variable: Overall subscription 5 Table 4: Dependent Variable: R_I_Subscription 5 Table 5: Dependent Variable: HNI_Subscription 5 Table 6: Dependent Variable: QIB_Subscription 6 Table 7: Listing Day Returns and Market adjusted returns means: 6 Table 18: Dependent Variable: issue_price_to_BV_Ratio 10 Introduction: This study investigates the...
Words: 2409 - Pages: 10
...Name: _____________________________________Date: ____/_____/_____ Course/Session: ___________ PreLab Composition and Resolution of Forces: Force Table Instructions: Prepare for this lab activity by answering the questions below. Note that this is a PreLab. It must be turned in at the start of the lab period. Time cannot be given in lab to perform PreLab activities. After the start of lab activities, PreLabs cannot be accepted. Q1. What is the basic difference between scalars and vectors? Q2. Do the plus and minus signs that signify positive and negative temperatures imply that temperature is a vector quantity? Explain. Q3. Which of the following statements, if any, involves a vector? (a) My bank account shows a negative balance of –15 dollars. (b) I walked two miles due north along the beach. (c) I walked two miles along the beach. (d) I jumped off a cliff and hit the water traveling straight down at 17 miles per hour. (e) I jumped of a cliff and hit the water traveling at 17 miles per hour. Q4. Two vectors, A and B, are added by means of vector addition to give a resultant vector R: R = A + B. The magnitudes of A and B are 2 m and 7 m, respectively, and they can have any orientation. What are the maximum and minimum possible values for the magnitude of R? Q5. Top of Form Q5. During a relay race, runner A runs a certain distance and then hands off the baton to runner B, who runs a certain distance and hands off the baton...
Words: 1445 - Pages: 6
...Wangal, La Trinidad , Benguet. The study aimed to determine if the plant kakawate can be used as a ripening agent to tropical fruits such as bananas. The study is experimental in nature utilizing the Randomized Block Design (RCBD). The independent variable was the kakawate. The dependent variable was banana.the five treatments , 100g, 75g, 50g, 25g, of the independent variable was complemented with 3 trials. The best treatments were compared to the controls, banana with no ripening applied and with calcium carbide. The control, banana witn calcium carbide, had only one treatment, 10g, and had three trials. The likest scale was the statistical test utilized. Results reveal that kakawate has the potential as ripening agent on bananas. Findings disclose the color, odor and taste of the banana. Based on the results, the researcher conclude that the plant are not as comparable to the control in different aspects, but still considerably effective. ACKNOWLEDGEMENT The researcher is filled of gratitude and appreciation to the following people who lend hands for the success of this study. First, to the Almighty God for guidance, strength and wisdom through all the hindrances that the researchers surpassed. Through him, in him that this research was accomplish. Ms. Rose Pecay for her enduring patience, advices, encouragement and her helping hand to the researcher; The researcher’s family members for understanding and unending moral support and financial support from the...
Words: 935 - Pages: 4