Premium Essay

Portfolio Management Database Design

In: Computers and Technology

Submitted By suemetzger
Words 437
Pages 2
Stock Portfolio Management
The following exercises are designed to provide you more practice with querying an Access database. To begin this exercise, retrieve the file PortfolioManagment.accdb from Blackboard (found in the Learning Module called Databases & Access -> Presentation & Data Files). Open the database file.
Design Challenges 1. Open the Client table. How many records does it have? ______ How many fields does it have? ______

2. What is the primary key for the Client table?

3. Set the primary key for the Stock table.

4. Review the data types assigned to the Stock Purchase table. One data type is incorrect. Please correct the data type and save the change.

5. Set the primary key for the Stock Purchase table.

6. Create a form for the Client table that allows easy entry of a new client.

7. Using your form you just created, add yourself to the Client table. Call the form Client Entry Form.

8. Add your favorite stock to the Stock table. Make up data if you do not know specifically what exchange or current price it trades at.

9. Buy 100 shares of the stock that you just added to the Stock table.

Query Challenges

10. Select the Stock table. Create a query called NYSE Stocks that lists all stock tickers traded on the NYSE. The resulting query should be sorted by the stock’s name.

11. Select the Stock table. Create a query called Expensive Stocks that lists all stocks whose stock price is greater than $100/share.

12. Modify the Expensive Stocks query to list all NYSE stocks that are worth more than $100/share.

13. Select the Client table. Create a query called PA Clients that will display only those client’s whose live in Pennsylvania (PA). List only the client’s name and zip code.

14. Select the Client table. Create a query called Client Listing that will display...

Similar Documents

Premium Essay

Project Control Systems Integration

...©Copyright ISPE 2011 The article presents the implementation of a suite of software packages that together provide a total Enterprise project management system. The Science of Project Management: Project Controls Systems Integration by Frederick Cramer, Susanne Keller, Christopher Law, Thomas Shih, and Britton Wolf G The concepts in this article were applied to the ECP-1 Facility, Overall Winner of the 2010 Facility of the Year Awards. For further information on this project, see “Case Study: Genentech’s ECP-1 Bacterial Manufacturing Facility, Overall Winner, 2010 Facility of the Year Awards” in the March/April 2011 issue of Pharmaceutical Engineering. Project Controls Systems Integration Background enentech is among the world’s leading biotech companies with multiple products on the market and a drive to discover, develop, manufacture, and commercialize new medicines to treat patients with serious or life-threatening medical conditions. In 2005, Genentech was ramping-up a build program due to increased demand for existing and new medicines about to come to market. By that time, Genentech had grown from a small biotech company with less than 3,000 employees in 1995 to more than 9,000 employees. It quickly became apparent that an ad hoc approach to project management of capital construction projects would no longer be sufficient. To keep pace with growth, an intensive effort was launched to investigate......

Words: 5656 - Pages: 23

Premium Essay

Cro Management

...Clinical Trials Portfolio By Indian CRO’s The field of biometrics studies and analysis can be described as a set of technologies and methods that are used to recognize humans, depending on a certain set of traits. Biometrics traits can be divided into two principal groups. First, the physiological traits that are associated with the body shape, where we can include face recognition, palm print, fingerprint, iris recognition, DNA, hand geometry and many more. Second, the behavioral traits that are related to an individual’s behavior, such as typing speed and style, walking gait, voice quality and many more. Clinical research organizations (CRO) in India today offer a complete range of data management services in bio-equivalence along with Phase I-IV clinical trials. The objective is to convert raw data into accurate, inconsistent and dependable trial output staying in compliance with regulatory services. The CRO’s have the ability to manage multi-centric studies for global and domestic needs in various therapeutic areas. The Biometric services provided by them are used by several biotechnology, device, and pharmaceutical and other medical research organization. Indian CRO’s (Clinical Research Organizations) that conduct various clinical trial have their own dedicated Biometrics teams capable of helping clients at multiple levels of the trails and medical studies. They assist the clients with their advanced technologies and skill to come up with study designs, analysis......

Words: 495 - Pages: 2

Premium Essay

Itil Foundation Guide

............................................................................................................ 5 General Exam Tips......................................................................................................................................... 6 What’s On the Exam ..................................................................................................................................... 7 ITIL Core Concepts ...................................................................................................................................... 12 Services ................................................................................................................................................... 12 Service Management .............................................................................................................................. 12 ITIL as a Good Practice Framework ......................................................................................................... 12 The Service Lifecycle ............................................................................................................................... 12 Processes................................................................................................................................................. 13 ITIL Processes by Lifecycle Phase...

Words: 9056 - Pages: 37

Premium Essay

Mountainview Itil V3 Process Poster

...ITIL ® V3 Processes IT Service Management Training, Courseware, Consultancy www.mountainview-itsm.com Goals, Activities, Inputs, Outputs and Roles To collect, analyze, process relevant metrics from a process in order to determine its weakness and establish an action plan to improve the process. Activities 1 Define what you should measure 2 Define what you can measure 3 Gathering the data 4 Processing the data 5 Analyzing the data 6 Presenting and using the information 7 Implementing corrective action Repeat the Process Inputs Each activity has inputs Outputs Each activity has outputs Roles Process Owner, Service Manager, CSI Manager, Service Owner Knowledge Management Process Owner Reporting Analyst Service Measurement and Reporting Goal To monitor services and report on improvement opportunities Activities Service Measurement •Objective (Availability, Reliability, Performance of the Service) •Developing a Service Measurement Framework •Different levels of measurement and reporting •Defining what to measure •Setting targets •Service management process measurement •Creating a measurement framework grid •Interpreting and using metrics •Interpreting metrics •Using measurement and metrics •Creating scorecards and reports •CSI policies Service Reporting •Reporting policy and rules Inputs SLA Targets, SLRs, OLAs, Contracts Outputs Service Improvement Program, SLAM Reports Roles Process Owner...

Words: 4361 - Pages: 18

Premium Essay

Rabby

...Alternative Systems-Building Approaches Traditional Systems Development Lifecycle Prototyping End-User Development Purchasing Solutions: Application Software Packages and Outsourcing Rapid Application Development for E-Business 11.3 Modeling and Designing Systems Structured Methodologies Object-Oriented Development Computer-Aided Software Engineering (CASE) 11.4 Project Management Project Management Objectives Selecting Projects: Making the Business Case for a New System Managing Project Risk and System-Related Change Managing Projects on a Global Scale 11.5 Hands-on MIS Key Terms The following alphabetical list identifies the key terms discussed in this chapter. The page number for each key term is provided. |Acceptance testing, 376 |PERT charts, 392 | |Component-based development, 385 |Phased approach, 376 | |Computer-aided software engineering (CASE), 385 |Portfolio analysis, 388...

Words: 9693 - Pages: 39

Free Essay

Web Portal for Freelance Photographers

...WEB PORTAL FOR FREELANCE PHOTOGRAPHERS: Connecting Freelance Photographers and Prospective Clients A Thesis Paper Presented to the Department of Information Technology Mapúa Institute of Technology School of Information Technology Buendia, Makati Philippines In Partial Fulfilment of the Requirements for the Degree Bachelor of Science in Computer Science and Bachelor of Science in Information Technology By: Ahmed Abdulrahim, Firas A. Peña, John Michael C. June 2012 APPROVAL SHEET This is to certify that we have supervised the preparation of and read the thesis paper prepared by (Firas A. Ahmed Abulrahim and John Michael C. Pena) entitled “Web Portal for Freelance Photographers: Connecting Freelance Photographers and Prospective Clients” and that the said paper has been submitted for final examination by the Oral Examination Committee. Mr. Ariel Kelly D. Balan | | Dr. William T. Torres | Thesis Adviser | | Thesis Instructor | As members of the Oral Examination Committee, we certify that we have examined this paper and hereby recommend that it be accepted as fulfillment of the thesis requirement for the Degree Bachelor of Science in Computer Science and Bachelor of Science in Information Technology. Ms. Ira Camus | | Mr. William Rey | Panel Member | | Panel Member | | | | | | | | Mr. Joel De Goma | | | Committee Chair | | This thesis paper is hereby approved and accepted by the School of Information......

Words: 13899 - Pages: 56

Premium Essay

Word of Mouth

...1982), Latitudes and Attitudes: An Atlas of American Tastes, Trends, Politics and Passions (Weiss, 1994) and Mastering Global Markets: Strategies for Today’s Trade Globalist (Czinkota et al., 2003). When reflecting on the nature of markets, consumer behaviour and competitive activities, it is obvious that no product or service appeals to all consumers and even those who purchase the same product may do so for diverse reasons. The Coca Cola Company, for example, varies levels of sweetness, effervescence and package size according to local tastes and conditions. Effective marketing and business strategy therefore requires a segmentation of the market into homogeneous segments, an understanding of the needs and wants of these segments, the design of products and services that meet those needs and development of marketing strategies, to effectively reach the target segments. Thus focusing on segments is at the core of organizations’ efforts to become customer driven; it is also the key to effective resource allocation and deployment. The level of segment aggregation is an increasingly important issue. In today’s global economy, the ability to customize products and services often calls for the most micro of segments: the segment of one. Following and implementing a market segmentation strategy allows the firm to increase its profitability, as suggested by the classic price discrimination model which provides the theoretical rationale for segmentation. Since the early 1960s,......

Words: 14313 - Pages: 58

Premium Essay

Training and Development

...School of Psychology 2013 Paper Outline  Faculty of Arts and Social Sciences   PSYC573-13A (HAM) Personnel Training & Development Lecture times/rooms: Thursdays, 09:00am – 10:50am. Room I1.08. Lecturer/Convenor: Donald Cable, Room K1.01. Extn: 8296. Email: dcable@waikato.ac.nz Student consultation hours: Thursdays 14:00-15:00. Other times by appointment. Paper Description The aim of this paper is for you to develop an understanding of the theory, research, and practice relating to training and development (including career development) in organizations. Upon successfully completing this course, you should be able to:     understand, and apply personnel training and development psychology theory and research, and bridge the gap between this and the practice, conduct training needs analyses and evaluate training and development (including career and professional development) initiatives, identify or develop training programs which incorporate sound principles of learning and training transfer, identify and develop the competencies that will support you in pursuing a career as an organizational psychology (or HR) practitioner with a focus on the training and development of individuals in organizations. Blending the exploratory learning aspect of Active Learning with proceduralized instruction, and creating a learning environment within which students are actively encouraged to construct knowledge, this paper includes lectures with associated readings, student......

Words: 2943 - Pages: 12

Free Essay

A Microfinance Mis

...A Microfinance MIS A Microfinance MIS Mifos is a database system that was designed specifically for countries that are developing microfinance institutions. This database system is intended to be use by institutions whose purpose is to “deal with the planning for, development, management, and use of information technology tools to help people perform all tasks related to information processing and management” (Rainer and Turban, 2008, p.24). The different types of analysis include: Business reporting and client management; it can also include the ability of savings and loan portfolio analysis report that can be run on Mifos. Some of the system advantages are easy, effectiveness, positive social and business impacts, growth and scalability. Some of the other important design features are: protection, data integrity, flexibility and quickness. A MySQL database is run under Mifos. (Grameen Foundation, 2008). This is used for the commonly known web applications. This is usually use to store and log user data (i.e. Facebook). Within the database you can find, account authentication, authorization and administration structures built within this database. These utilities are usually assemble as one application component, this makes it user friendly. The rest of the applications are designed for loan officers, branches and loan reviewers. Business logic is supported within the function through the use of tables for this data. This is believed to be the most......

Words: 278 - Pages: 2

Premium Essay

Mba Special Assignment

...|Statistics for Management |3 |1 |0 |4 | |BA9102 |Economic Analysis for Business |4 |0 |0 |4 | |BA9103 |Total Quality Management |3 |0 |0 |3 | |BA9104 |Organizational Behaviour |3 |0 |0 |3 | |BA9105 |Communication Skills |3 |0 |0 |3 | |BA9106 |Accounting for Management |3 |1 |0 |4 | |BA9107 |Legal Aspects of Business |3 |0 |0 |3 | |BA9108 |Seminar I – Management Concept |0 |0 |2 |1 | | |Total | | | |25 | SEMESTER – II |Code No. |Course Title |L |T |P |C | |BA9121 |Operations Management |3 |0 |0 |3 | |BA9122 |Financial Management ......

Words: 17609 - Pages: 71

Premium Essay

Online Course Registration

...Architecture Design Document for Online Course Registration 1. Overview 1.1. System Overview An Online Course Registration system for University is to be developed with a front-end web interface and a back-end database. An example of the system would be University of Mumbai Course Registration. Any database system can be chosen as the back-end such as Oracle, MySQL, Microsoft SQL Server, DB2, and Access. Any web server can be chosen for the front end such as Tomcat, Glassfish, JRun, etc. Any server side language can be chosen such as PHP, JSP, ASP, etc. 1.2. System Context The system context is defined clearly in the SRS. Basically, the user is the main sink of the information. The user is also a major source of information/data. The other source of data is a website from where data on current prices is obtained. 1.3. Stakeholders of Online Course Registration This section describes the users of the Online Course Registration System. There are 3 types of users of the C-Registration System; the Course Registrar, the Students, and the Professors. Name | Represents | Role | Administrator | Admin and College as whole. | Responsible for project funding approval. Monitors project progress. | Registrar | The office of the registrar, administrative and data entry personnel. | Ensures that the system will meet the needs of the registrar, who has to manage the course registration data, including professor and student databases. | Student | Students |...

Words: 1218 - Pages: 5

Premium Essay

Proj 587 Project Final

...Course Project Epsilon: Portfolio Management Plan Instructor: Stanley Mefford Oct 24, 2012 Table of Contents Introduction 3 Epsilon’s Strategic Plan 3 Strategic Capacity Plan 4 Portfolio Management Process 6 Project Selection Criteria 7 Program Management Plan 8 Quality 9 Scope 10 Internal Teams 10 External Teams 11 Scheduling 11 Conflict Resolution Plan 12 Change Management Plan 13 Resource Utilization 15 Conclusion 16 Resources 17 Introduction Deploying over 40 billion emails annually, Epsilon is ranked as the top database marketing services provider and is the world’s leading multi-channel marketing and technology organization (Palmer, 2012). Epsilon works with over 2,000 global clients that represent industries across many markets including financial services, customer packaged goods, retail, travel and pharmaceutical markets. Some of Epsilon’s service offerings include: database technology, email services, and reporting/analytics. As a leader in the market, an impressive 26 of the Fortune 100 companies trust them to provide marketing services (Epsilon, 2012). Since 2009, Epsilon had been experiencing unprecedented growth. In 2011, Direct Marketing News reported that Epsilon’s 2010 global revenues increased 19% as compared to the previous year and was expected to double its revenues (Gordon & Washkuck, 2011). From the outside, forecasts couldn’t be brighter for the company. Internally, however, it was a different......

Words: 4958 - Pages: 20

Premium Essay

High Fi

...Friday 25/06/2012, Monday 26/06/2012, Tuesday 27/06/2012, Wednesday I Sem. 9.30 a.m. - 12.30 p.m. – 10MBA11-Management & Behavioural Process – 10MBA12-Managerial Economics – 10MBA13-Statistics for Management – 10MBA14-Accounting for Managers II Sem. 9.30 a.m. - 12.30 p.m. 10MBA21 – Quantitative Techniques for Management – 10MBA22 – Indian Business Environment – 10MBA23 – Financial Management – 10MBA24 – Business Law – III Sem. 2.00 p.m. - 5.00 p.m. – – – 10MBA31 – Strategic Management – 10MBA32 – Management Accounting & Control Systems – 10MBA33 – Operations Management IV Sem. 2.00 p.m. - 5.00 p.m. – – 10MBA41 – Change and Knowledge Management – 10MBA42 – Entrepreneurial Development – 10MBA43 – Supply Chain Management – 10MBAMM415 – Rural Marketing 10MBAFM425 – Project Appraisal Planning & Control 10MBAIS435 – Multimedia Applications Programming Using VB 10MBAHR445/10MBAIB465 – International Human Resource Management 10MBAPM455 – Project Management 10MBABF475 – Treasury & Risk Management 28/06/2012, Thursday – 10MBA25 – Human Resource Management – 29/06/2012, 10MBA15-Management Information Systems Friday – 10MBAMM311– Business Marketing 10MBAFM321– Advanced Financial Management 10MBAIS331– Object Oriented Programming Systems Using Java 10MBAHR341– Organizations Design & Organization Development 10MBAPM351– Materials Management 10MBAIB361– International Business Environment 10MBABF371– Principles & Practice of Banking & Insurance – ...

Words: 1422 - Pages: 6

Free Essay

Math

...EMAIL SUBJECT: Website Database Programmer Position Application October 21, 2014 Mrs. Martha Stine Emergint Technologies Inc 4018 Jones Street Grapevine, TX 76051 or To whom this may concern: Position of Web Developer Your need for a top performing experienced graphic and web developer is an excellent match to my professional experience. The techniques and services provided by General Synthetics (or administration )range across a wide and impressive spectrum. Aside from the variety of services provided, I was also very impressed by the multitude of published projects which demonstrates how General Synthetics (or your firm) is a leader in custom web development in a standard of excellence. In June of 2014, I have worked as a graphic and web developer at Aviv Moon Productions in Charlotte, North Carolina. During my time with Aviv Moon Productions, I demonstrated my skills and techniques with WordPress, Site animation, Php coding, Server Management, E-commerce plugins, and responsive web and mobile development. I also took on responsibilities to include: updating and optimizing the online streaming video network and various departmental internal applications. Back in June of 2008, I have worked as a graphic and flash designer at New Way Media in Charlotte, North Carolina after I've received my Bachelor of Arts Degree in Graphic Design. I also worked with Artisan Blue, which is located in Washington, DC. as a full time graphic and web developer for...

Words: 607 - Pages: 3

Premium Essay

Abcd

...Documenting the roles and relationships of stakeholders in a process or activity b) Defining requirements for a new service or process c) Analyzing the business impact of an incident d) Creating a balanced scorecard showing the overall status of Service Management 3. What is the main reason for establishing a baseline? a) To standardize operation b) For knowing the cost of services provided c) For roles and responsibility to be clear d) For later comparison 4. Which of the following is NOT an objective of Service Operation? a) Through testing, to ensure that services are designed to meet business needs b) To deliver and support IT services c) To manage the technology used to deliver services d) To monitor the performance of technology and processes 5. Which of the following statements is CORRECT about patterns of demand generated by the customer’s business? a) They are driven by patterns of business activity b) It is impossible to predict how they behave c) It is impossible to influence demand patterns d) They are driven by the delivery schedule generated by capacity management 6. Which of the following is NOT one of the ITIL core publications? a) Service Optimization b) Service Transition c) Service Design d) Service Strategy 7. Which of the following statements is CORRECT? 1. Only one person can be responsible for an activity 2. Only one person can be accountable for an activity a) All of the above b) 1 only c) 2 only d)......

Words: 8836 - Pages: 36