Creating a Query

In: Business and Management

Submitted By GS1150
Words 9127
Pages 37
Citi Bank India Credit Cards: Strategy for
Profitable Growth
By shailanchal |

Journal of Services Research Volume 11 Number 2 October 2011 - March 2012
The Journal of IIMT
Dr. Atanu Adhikari Indian Institute of Management
Kozhikode Kerala, India
Prof. Manpreet Singh Gill faculty of marketing with L.G.C
Ludhiana, India
Journal of Services Research, Volume 11, Number 2 (October 2011 - March 2012) ©2011 by
Institute for International Management and Technology. All Rights Reserved.
Market orientation in B2B industry, both in developed as well as developing countries, acts as the implementation part of marketing. In very limited number of earlier studies conducted in emerging economies, market orientation has been considered as a part of firm capabilities, or as a part of firm resources or how it leads to different types of learning or innovations in organizations. None of the studies so far have tried to find out how firm's resources, capabilities and technology would adversely affect market orientation. In the present study we have treated market orientation differently from firm's resources and capabilities and have tried to find out extent to which the firm's resources, capabilities and technology would contribute to firm's market orientation. From data of 215 Indian B2B companies operating in capability, resource and technology intensive industries we show that which one out of resources capabilities and technology, would play a major role in the market orientation of each of these industries. While resources, capability and technology play an important role in market orientation of firms in

developed countries to achieve sustainable competitive advantage, managers in Indian B2B firms need to look and implement them from customers'…...

Similar Documents

Assignment 3: Oracle Table and Query

...Assignment 3: Oracle Table and Query Arthur David Knowles Professor Murnane CIS 111 Strayer University 10, 29, 2012 Assignment 3: Oracle Table and Query Today we are going to learn how to do a couple basic things within Oracle. We are going to create a table with three columns and we are going to input five records into it. When we are all done you will be able to create a table, insert data and use a query to find the data. Now let us get started! First launch the putty application and open the one for our class that we created week one. Sign into Oracle until you reach the prompt that reads SQL>. For this example I am going to use NFL quarterbacks for our table creation. Once you have arrived at the SQL prompt type in the following command line, create table NFLQBS ( , then hit enter, you should see a 2 on the left side, on the following lines we will create the columns. On line 2 type in, Player_Team varchar(30), then hit enter. On line 3 type in Player_Name varchar(30), hit enter again. Then on line 4 type in Player_Number varchar(5); and hit enter. If done correctly it should read, “Table Created”. The picture above shows where we should be. I will now explain a few of the things we just did in detail. First command we used was Create Table, this is used to create the base table that forms the heart of our relational database. The number in parentheses is used to set how many character can be used in that column. Now we will move onto inserting......

Words: 491 - Pages: 2


...  Assignment #7 – Queries A query expressed in a high-level query language such as SQL must first be scanned, parsed, and validated. The scanner identifies the language tokens, such as SQL keywords, attributes names, and relation names in the text of the query, whereas the parser checks the query syntax to determine whether it is formulated according to the syntax rules of the query language. The query must also be validated, by checking that all attribute and relation names are valid and semantically meaningful names in the schema of the particular database being queried. An internal representation of the query is then created, usually as a tree data structure called a query tree. It is also possible to represent the query using a graph data structure called a query graph. The DBMS must then devise an execution strategy for retrieving the result of the query from the database files. A query typically has many possible execution strategies, and the process of choosing a suitable one for processing a query is known as query optimization. Optimization in a database makes things work smoothly. One heuristic rule is to use SELECT operation before using the JOIN or other Binary operations. This is because the resultant size of the file from a Binary operation such as JOIN is usually a multiplicative function of the sizes of the input files. So, The SELECT operation reduces the size of a file so it must be used before the JOIN or other binary Operation. Secondly, we can......

Words: 345 - Pages: 2

Creating a Data Warehouse

...Research Paper Creating a Data Warehouse Introduction Data warehouses are the latest buzz in the business world. Not only are they used to store data for reporting and forecasting, but they are part of a decision support system. There are many reasons for creating and using a data warehouse. The data warehouse will support the decisions a business needs to make, usually on a daily basis. The data warehouse collects data, consolidates the data for reporting purposes. Data warehouses are accompanied by analytical tools that accommodate forecasting as part of the decision support system. The purpose of this paper is to explore the creation of a data warehouse. Since the specifics of creating the data warehouse are determined by the database system, this paper will devote its discussion to the design or layout of the data warehouse. Before discussion of the layout of the data ware house proceeds, the basics about a data warehouse need to be discussed. Then the elements of the data ware house will be covered. What is a Data Warehouse? A data warehouse is a warehouse full of data, an electronic warehouse. In a manner of speaking this is true. Don Awalt describes it as follows, “A data warehouse is the cohesive data model that defines the central data repository for an organization. “ He also further stated that “we consider it a complete, integrated data model of the enterprise, regardless of how of where the data is stored.” Thus we can see that the data......

Words: 3953 - Pages: 16

Creating a Jsa

...Creating a Job Analysis Abstract This essay will explain how to create a job analysis. It will explain what a job analysis is, and identifies the objectives of the job duties and roles for a position as a Human Resource Receptionist. Creating a Job Analysis The history of Job analysis was founded in 1900 by Frederick W. Taylor. His interest in improving the studying the principles of work and science developed into what is called a Job analysis. Human Resource Managers create a Job Analysis using task statements, Knowledge Skills Abilities, and create a job description. One method of developing a Job analysis is using the 7 stages of a Functional Job Analysis. The 7 stages are resources in helping to identify the task statements, KSA’s and job description. The following 7 stages are: things functions, work instructions, mathematical, data function, reasoning development, language develop and people function. (Pugh 2007) The thing functions are examples the ability to use office equipment anything tangible. Work instructions requires the ability to perform a given a task. Mathematical function is the ability to operate and handled business math. Data function is dealing with facts, statistics and information with business. Reasoning development show the ability to show comprehensive reasoning. Language develop require oral and written communication. People functions involve interaction with people. All 7 stages are used in developing the process of producing a Job......

Words: 271 - Pages: 2

Creating an Ngo

...AMITY BUSINESS SCHOOL AMITY UNIVERSITY MARKET RESEARCH AND REPORT PREPARATION PROJECT- STARTING OF AN NGO SUBMITTED TO:- Ms. SONIA SINGH SUBMITTED BY:- RITU SHEKHAWAT ROLL NO.-108K03 A0101908415 RICHA CHAUDHARY ROLL NO.-108K23 A0101908045 STARTING an N.G.O. Even before you actually set up an NGO, you may simply not know where to start. A number of queries received at the NGO Cafe ask this question - where do I start? How do I know what to do? I am inspired, I want to do something, I want to help the poor... It’s not easy to get it right the first time. The first project, the first action, is fraught with problems you never anticipated. So, even before you start anything, be prepared: • Find an 'excuse': This is the spark, the initial reason for you to start along a path leading you to the setting up of an NGO. Many times it is a tragedy - such as a disastrous flood or a fire - that needs handling. Sometimes a more joyous event, such as a local festival, that brings the community into the streets to enjoy. Look at these initial trigger events as a learning experience, and as a means of building your network of friends and supporters. • Involve leaders: People and communities, in general, trust their leaders - not the political party types, but the 'real' leaders - the ones who do the actual work for the community, the ones who are active and care for the . Involve them at all stages of the project development and implementation, ask their......

Words: 4343 - Pages: 18

Outer Join and Scalar Queries

...Write the following queries in SQL: Display a list of all instructors, showing their ID, name, and the number of sections that they have taught. Make sure to show the number of sections as 0 for instructors who have not taught any section. Your query should use an outer join, and should not use scalar subqueries. By using the university schema provided by the following queries were done on the university database. The first query uses an outer join which works similar to the join operation but it keeps the rows that don’t match between the two tables that would be lost in a join operation. There are three forms of outer join: a) Left outer join displays the results from the left table even if the condition does not find any matching record in the right table. b) Right outer join will displays the results from the right table regardless if there is matching data in the left table. c) Full outer join will retain all rows from both tables, regardless if the data matches or not. The group by clause when used in a select statement collects data from multiple records and groups the results into one or more columns. The below is the query using left outer join operation: select ID, name, count(sec_id) as Number_of_sections from instructor natural left outer join teaches group by ID, name; The next query was written by using a scalar subquery without using an outer join operation. A scalar subquery is where the output of a subquery returns......

Words: 414 - Pages: 2

Creating Entrepreneurship

...Syrian Arab Republic Damascus University Faculty of Economics MBA program Organizational Theory Module CREATING Entrepreneurship : Organizational pathways through Transformation Prepared by: Hussam Baravi Content: A. Entrepreneurship, Entrepreneurial Organization:  The Concept of Entrepreneurship.  Entrepreneurial Organization Factors. B. Into Transformation:  The Concept.  Slaughters Seven keys to success. 1|P a ge A. Entrepreneurship, Entrepreneurial Organization: In (Metaprofiling, 2013)1 study about the entrepreneurial organizations they differentiated between two concepts, entrepreneurs and entrepreneurial organization. Successful entrepreneurs are opportunists who, through their creativity, drive and vision, create economic or social value. They challenge conventional wisdom by practicing disruptive innovation — innovation that creates new markets through the application of a different set of values. They change the rules of the game by questioning the status quo and upping the stakes. It follows that an entrepreneurial organization can be defined as: An organization that places innovation and opportunism at its heart in order to produce economic or social value. However, for many organizations, this is only a brief moment in their evolution. And according to (Rodrigues et al,2003)2 entrepreneurial organizations, in fact, reflect the basic characteristics of its leadership. Filion shows a set of four indispensable characteristics of an......

Words: 3678 - Pages: 15

Sql Query Design

...Assignment 1: SQL Query Design Diane King June 24, 2014 IT526-01 SQL Query Design Pr4ofessor: Jon McKeeby, DSc. Kaplan University Part1. Install SQL Express Part2. Questions. a. Each CHAR and VARCHAR store non binary strings characters as the maximum length allowed. The difference between the two is the maximum length allowed and how each handle trailing spaces (My SQL, n.d.). The CHAR data type is a fixed length typed and VARCHAR is a variable length data type. When the CHAR data type is used the length of strings allowed in each column definition should be from 0-225. As an example in the SQL database there is a dbo.table where tables hold a type column defined as (CHAR 12). This requires 12 characters for each value. My SQL states that values shorter than the designated length are padded spaces to that length when they are stored; and trailing spaces are removed from CHAR values when they are retrieved, so retrieved values may not be the same length as when stored (para, 2). The VARCHAR maximum numbers are up to 65-535. Any string stored in a VARCHAR column takes the number of characters required “plus one or two bites to record the strings length” (My SQL, n.d.). b. The Query gave the error: Msg 207, Level 16, State 1, Line 3 Invalid column name 'YearHired'. c. The Query returned a error on both therefore, I’m unsure. Msg 207, Level 16, State 1, Line 5 Invalid column name 'FileName'. Msg 207, Level 16, State 1, Line 4 Invalid column name......

Words: 515 - Pages: 3

Creating a Methodology

... Creating a Methodology Nicole Barrett Professor C. Lodge BUS 375 October 18, 2014 Creating a Methodology In the 1900s Methodology was a system to help streamline projects to eliminate redundancies and make processes more efficient. The system included project management, total quality management, concurrent engineering, and scope change control and risk management. In the twenty century, methodology has the same results; to make processes more efficient however some of the processes have changed. The twenty-century processes are supply chain management, business processes, feasibility studies, cost-benefit analyses (ROI) and capital budgeting. Regardless of the changes in the processes, the end result is to streamline the process, reduce paperwork and eliminate duplications. Methodology has been known to lower cost and improve customer satisfaction. Based on the case study titled “Creating a Methodology”, the executive staff had many concerns about implementing an enterprise project management methodology (EPM). The executive staff knew it was necessary to continue to compete in the request for proposal (RFP) process. In addition this was a requirement from corporate to implement a methodology. The employees of the company had a routine way of doing things and they did not like a change. This was a clear indication of a company with employees whose vision is low whose believes were based on their powers and not the goals of the organization. The company headed by the......

Words: 544 - Pages: 3

Mist Mysql Queries

...Project 6 Required Queries: *  Create a query that includes at least two INNER JOINS (i.e. spans at least three tables), a search criteria, and orders the resulting data. * >select M.MID, M.MFName * >from MEMBER as M * >inner join LINEITEM as LI on LI.MID=M.MID * >inner join ITEM as I on I.IID=LI.IID * >inner join DVD as D on D.IID=I.IID; * This shows which members have checked out DVDs * Create a query that includes a calculation (e.g. average, sum, etc.). * >Select M.MID, M.MFName, count(B.IID) as “Books Checked Out” * >from MEMBER as M * >inner join LINEITEM as LI on LI.MID=M.MID * >inner join ITEM as I on I.IID=LI.IID * >inner join BOOK as B on B.IID=I.IID; * This query shows how many books a member has checked out * Create a query that includes at least one RIGHT or LEFT outer join. * >select MEMBER.MID, MEMBER.MFName, LIBRARIAN.LFName * >from MEMBER * >left outer join LINEITEM on LINEITEM.MID=MEMBER.MID * >left outer join LIBRARIAN on LINEITEM.LID=LIBRARIAN.LID * >order by MEMBER.MID; * This query uses a left join to show the relations between which librarians have checked out which members * Create a query that uses a GROUP BY to perform a calculation on information spanning at least two tables. * Create a query that includes a GROUP BY, but selects items......

Words: 289 - Pages: 2


...CREATING QUERIES Lesson 9 Introduction The real power of an Access 2007 database is in the ability to pull data for quick analysis, which is what happens when you run a 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......

Words: 2519 - Pages: 11

Creating a Methodology

...Creating a Methodology July 20, 2015 Lanika Jones Project Management Dr. Christopher Hase   John Compton, the president of the company could not understand why his executive team waited so long to develop an enterprise project management methodology (EPM) for their company. Being that they knew about what steps, how to go about it the start up and the time frame are was going to take to execute this plan. But first when you think about a methodology what it is? A methodology a set of methods, rules, or ideas that are important in a science or art: a particular procedure or set of procedures. When Compton’s executive team was presented with this idea of creating a methodology for his company his team was stagnant with following through because they had to go through the change process. The change process is “when the employees’ initially refuse to admit to the need of change”(Kerzner 98). When a change process come into play when a employees refuse to admit or adapt to the need of change different corporate culture factors need to be put in to play in order for the Compton’s team EPM could be successful. Being that the team had to create a methodology the two cultures that I see fit for the beginning is cooperative cultures and competitive cultures. But in order for the team to understand these cultures is that “good cultures are teamwork, trust, communication and cooperation (Kerzner 99) from all member of the staff. Cooperative culture are base upon trust and...

Words: 738 - Pages: 3

Creating Methology

...CREATING A METHODOLOGY BUS 375 Week 2 Assignment Professor Christopher Hase By: Nicole Brevard 07/11/2015 There were two contributing factor that stood out that surrounded the corporate culture that were at play that contributed to the executive staff waiting so long to develop an Enterprise Project Management Methodology. The first contributing factor was the executives were afraid of losing their power and authority they had. I believe they knew by developing a Enterprise Project Management Methodology, that only one executive would be in charge and more powerful than the other executive's. The executives new at some point they would have to do it, but what they did not understand is by not developing an Enterprise Project Management Methodology they were putting the company’s growth and competitiveness in jeopardy. The second contributing factor was the executives had no clue on were to begin with developing an Enterprise Project Management Methodology. The executives were so afraid of who was going to be in control that they really never thought it out. The executive staff recommended 12 life cycles which would have increased paper work and less time to manage the project. A consultant was called in to assist them in creating an Enterprise Project Management Methodology explaining the pros of having. My recommendation for Mr. John Compton and his executive staff is that the Project Management office should not report to the CIO. My reasoning is the...

Words: 324 - Pages: 2

Creating Accessible

...Creating Accessible Adobe PDF Files ® A Guide for Document Authors © 2004 Adobe Systems Incorporated. All rights reserved. Adobe, the Adobe logo, Acrobat, Acrobat Capture, the Adobe PDF logo, FrameMaker, GoLive, InDesign, PageMaker, Photoshop, PostScript, and Reader are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries. Mac is a trademark of Apple Computer, Inc., registered in the United States and other countries. Microsoft, Windows, and Windows XP are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. Mention of third party products is for informational purposes only and constitutes neither an endorsement nor recommendation. iii Creating Accessible Adobe® PDF Files Contents Introduction Section One: Checking PDF Documents for Accessibility Checking the reflow order of a document Additional accessibility tests . . . . . . . . . . . . . . . . . . . . . .10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10 Section Two: Accessibility Basics Tagged PDF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14 Section Three: Accessible PDF documents from Native Applications Creating accessible PDF documents using Adobe InDesign . . . . . . . . . . . . . . . . . . . . . . . . . . ...

Words: 22110 - Pages: 89

Creating an Outline

...Creating an Outline An outline helps you arrange the order of ideas in a paper. Many students eliminate outlining in the writing process as an unnecessary step. However, writing an essay without an outline can create disjointed results. An outline provides a roadmap so that the essay can move smoothly from point A to point B to point C. Without an outline, the essay could easily become disorganized, e.g., A, B, A, C, B. This can confuse readers because the points of the essay are not arranged in correct sequence. Use the following suggestions to create an effective outline. Creating Correct Formatting The following information will help you format an outline correctly:  Include at least two elements under each of the sections in the outline. If you have only one element, however, you can add additional information to create at least two points.  Create parallel wording at the beginning of each section of the outline. If the first word begins with a noun, the first words in all other elements in that section must also begin with nouns. If the first word is a verb, the other elements must begin with verbs, etc.  Include a period, and space or tab after each letter or number. Be consistent on using spaces or tabs throughout. (See the sample outline below.)  Use double spacing in the outline for ease in reading or use single spacing throughout and double space between each of the major elements (I, II, II).  Capitalize the first word after each number...

Words: 270 - Pages: 2