Premium Essay

7000 Data Management

In: Computers and Technology

Submitted By audiq5
Words 1091
Pages 5
Create a memo describing your initial analysis of the situation at FAME as it relates to the design of the data base application. Write this as though you are writing a memo to Martin Forondo. Ensure that your memo addresses the following points:

a. Your approach to addressing the problem at hand (for example, specify the systems development life cycle or whatever approach you plan on taking).
Mr. Forondo, FAME (Forndo Artist Management Excellence) needs technology support to track the contracts of artists, a proposal for contracts to new artists, calendars of artist schedules and the performance shows, etc. In any event, music manager today have to be informed about a lot more things than they used to in the past including music licensing, merchandising, sponsorships, branding, crowdfunding, endorsements, social media, direct-to-fan strategies, and more; and putting together a winning strategy for your artists requires the right information in the right context. You also have to have to figure how to acquire financing, make the right connections, get bookings, break through barriers, enter into strategic alliances and joint ventures, generate income for your artists from multiple sources and get maximum exposure for your artist in an ever-changing music industry landscape.
This can be achieved by developing an application for your artist management and managing the artist data in the backend using SQL/DB2 database. The application can be managed by the admin, artist managers, and artists. They can login into the application and manage their events, marketing, and financial business prospectives. For instance, artist managers can log in and manage their artist's calenders to schedule their performance, annual contract renewals, marketing and financial management. This application development life cycle follows requirement gathering, analysis, design, development…...

Similar Documents

Premium Essay

The Indian Geek

...School of Information Technology & Electrical Engineering THE UNIVERSITY OF QUEENSLAND ENGG4000/ENGG7000 Introduction to SYSTEMS ENGINEERING Week 10: Interaction modelling & Sequence Diagrams ENGG 4000/7000 Systems Engineering 1 Housekeeping (1)   Assignment 3: – SRR sent back to analyst team for interest – Presentations in this week’s pracs » See last week’s Housekeeping for suggestions Next few prac Sessions cover SE tools: – Week 11: DOORS requirements management tool » needed for Assignment 4 – Week 12: CORE computer-aided systems modelling & engineering tool – Week 13: Microsoft Project project management tool ENGG 4000/7000 Systems Engineering 2 Assignment 4: System Design  Assignment 4: Develop a partial System Design Document (SDD) for your Development Application Project (DAP) – DAP = the 3rd of the 3 projects – Due 8pm Friday 27 May – based on SRS supplied by lecturer (aka Chief Systems Engineer) in consultation with the supercustomer – Operational concepts based on the assignment 2 rescoping document ENGG 4000/7000 Systems Engineering 3 Assignment 4 (2)  In your role as Developer, develop a system design for your Development Application Project, based on the supplied SRS – Give physical & logical architectures for your system – Describe the functionality of the components of your system, including their internal & external interfaces – Give Sequence Diagrams for 3 use cases defined......

Words: 1957 - Pages: 8

Free Essay


...HP 3PAR StoreServ Storage Concepts Guide HP 3PAR OS 3.1.2 MU2 Abstract This guide is for all levels of system and storage administrators who plan storage policies, configure storage resources, or monitor the storage usage of HP 3PAR storage systems. HP Part Number: QR482-96384 Published: June 2013 © Copyright 2007, 2013 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.21 and 12.212, Commercial 1 Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein. Acknowledgements Microsoft® and Windows® are U.S. registered trademarks of Microsoft Corporation. Oracle is a registered trademarks of Oracle and/or its affiliates. UNIX® is a registered trademark of The Open Group. Warranty To obtain a copy of the warranty for this product, see the warranty information website: Contents 1 Overview..............................................................

Words: 36581 - Pages: 147

Premium Essay

Training and Development


Words: 5172 - Pages: 21

Free Essay

Case Study

...You are a star consultant from "Databases R US" IT consulting and managing firm. You just got hired by "Home Solutions Inc" a construction and Parts Company to help them with their customer and parts data management. Unfortunately, the company has been depending on the owner's nephew for their data needs and Joe has done his best to come through for the family business. His lack of experience with data management is hurting the business as they have been unable to successfully keep track of their inventory system, customers and sales. Joe has put together a spreadsheet, see below, and they have been using it as a database of sorts, to track their customers and inventory. Your specific tasks to help the business are in parenthesis are the percentages that correspond to the per item payment (grade weight): 1) Review the existing spreadsheet, and their sample data and make any assumptions you need about the company. Make any comments about the approach that you are going to follow, as you see fit. (10%) 2) Redesign the spreadsheet into a database with tables, add any fields that you think could be useful, even though it is not absolutely necessary. Explain your actions as you go along. 3) Perform a functional dependency analysis, and include it as part of your deliverables, for every step of the normalization process (25%) 4) Clearly take the existing un - normalized structure through distinct 1NF, 2NF and finally 3NF stages, using the shorthand representation. All......

Words: 600 - Pages: 3

Premium Essay

Salary Guide

...should expect to increase employee pay rates or find other creative solutions in response to these talent dynamics, if employers are serious about attracting and retaining critical skill sets within the organization. Human capital is the most valuable asset in a fiercely competitive globalised world and employers must retain and attract talent to be able to compete on a regional and global scale. Organizations need to invest in the development of their human capital and put in place human capital management standards and practices that are on a par with some of the best global companies. Performance measurement systems with well structured key performance indicator (KPI) frameworks and competitive remuneration schemes will help the workforce to realise and develop their potential to contribute to the economy. Whilst, we hope this ‘Employment Outlook and Salary Guide 2012/2013’ will serve as a handy reference tool for you, we are always on hand to assist you with current data and also support you in developing recruiting strategies and programs to suit your specific needs. We trust you find this ‘Singapore Employment Outlook and Salary Guide 2012/2013’ from Kelly Services resourceful to your business. Mark Hall Country General Manager Disclaimer: Monthly salary ranges are subject to economic fluctuations. Monthly salary ranges exclude other bonuses, allowances and Employer CPF contributions.......

Words: 11189 - Pages: 45

Premium Essay

Service Marketing Strategy Project

...STEP I I want to gain marketing insights and learn about new marketing strategies from a data-driven company. I think marketing and strategy is an integral part of any business today, so it takes everything from the scratch to execution, without a marketing strategy, a product can never be a success. Also during my undergrad studies, I came across a course known as entrepreneurship management, which generated a spark in me to learn more about marketing management and strategy. Although having a limited internship experience in data driven marketing, it would be a great opportunity for me to learn something about strategies for different customer segments and analysis of various markets through the marketing courses in my MBA curriculum and apply it to real life situations. STEP II My dream industry would be a company which is dealing in data driven marketing strategies in the sectors of health care consulting and energy auditing. To be precise, I want a job in a data driven marketing industry. STEP III: The job titles for which I would be eligible after I graduate from IIT Stuart school of Business as an MBA in Marketing and Business Analytics would be-: * Marketing/ Marketing Research Analyst * Business Development Executive * Marketing sales Representative * Marketing Account Executive * Business Analyst All these job titles match up my field of interest i.e. marketing. Also When I visited networking events, specifically the ‘Microsoft......

Words: 778 - Pages: 4

Premium Essay

Project Charter

...accounting functions and payroll with system/data interfaces, tables, and codes. The project will provide planning, analysis, programming, data updates, testing, documentation, software quality assurance and implementation support to ensure that this software provides continued relevance to the accounting department of the organization (Horne, 2011). Objectives The objectives of the project include the following 1. Support and improve the current operations in the organization. 2. Improve efficiency of delivery systems, 3. Reduce product costs. 4. Improve the company’s market position and future prospects. Scope Statements The Project Management Plan (PMP) shows relevant information for the QuickBooks Enterprise Solution project. The scope of the PMP covers the project organizational structures in staffing, management processes to include dependencies and constraints as well as a high level description of technical processes that will be managed through the controls described in the PMP. It is used as a tool by the Project Team to plan the development process of the project and will be maintained with current information throughout the project’s life cycle. This PMP will be used and updated accordingly through the life-cycle of the QuickBooks Enterprise Solution. Users of Deliverables 1. Accounting team 2. Human Resource team 3. Information Technology team 4. Senior Management Key Project Stakeholders 1.......

Words: 3222 - Pages: 13

Premium Essay

Pricing of New Products

...INDIAN INSTITUTE OF MANAGEMENT, AHMEDABAD A report on PRICING NEW TO THE WORLD PRODUCTS: JACKET WITH TEMPERATURE CONTROL submitted in partial fulfilment of the course PRICING TERM IV (2013-2015) to INSTRUCTORS PROF. ARVIND SAHAY PROF. SANJEEV TRIPATHI ACADEMIC ASSOCIATE SHAGUFTA QURAISHI GROUP 1 ABHINAV GOEL, ADITI VERMA, ANAND K RAO, ANKUR SINHA, ARVIND JAIN, BHARAT K LAKSHMAN, SAURABH KOTHAWADE JULY 29, 2014 1. Introduction The product that we are planning to introduce into the market is not a derivative of any older product and has never been introduced in the market before. Considering the extreme weather conditions prevailing in India, we think there is a need for a jacket which will provide protection against sunburns in summer and cold in winter. The unique feature of the jacket is the SmartFabric which has been invented after years of research. The SmartFabric acts as a temperature regulator which works like an air cooling and heating system and the utility of the jacket, which is protection from extreme climate conditions, arises from this unique fabric. We want to gauge the potential of this new product in Indian market. Though the jacket has an unique value proposition, the correct pricing of the product is very important for ensuring the success of the new jacket.   2. Pricing Approach ‘jACket’ is a novelty product which doesn’t have any clear substitute in the market. The price of such products majorly depends on the......

Words: 1364 - Pages: 6

Premium Essay

Brief over View

... 10000 12500 2500 The advertising budget should be approved since it would lead to an increase in net operating income of 2500. 2 CHANGE IN VARIABLE COST AND SALES VOLUME According to the original data Shabbir corporation currently selling 250 calculators per month. The management is now considering the use of higher quality components which would increase variable cost and there by reduce the contribution margin by 12$ per calculator. However the manager predicts that it increases sales to 300 per month. The 12$ increase in the variable cost will decrease the unit contribution margin by 12$ from 100$ to 88$. Expected total contribution margin with higher quality components 350 tape recorders x 88$ per tape recorder = 30800 Present total contribution margin 250 calculator x 100$ per calculator = 25000 Increase in total contribution margin 5800 According to the analysis the higher quality component should be used. Since fixed cost will not change, 5800 increase in the contribution margin shown above resulted in increase in net income. 3 CHANGE IN FIXED COST, SALES PRICE AND SALES VOLUME According to original data the company is currently selling 250 calculators per month. To increase the sales, sales manager would like to cut the selling price by 30$ and increase the advertising budget by 10000. The sales manager thinks that the unit sales would increase by 60% (400). Would the...

Words: 686 - Pages: 3

Free Essay

Database Ist7000

...10:00 am-6:00 pm ------------------------------------------------- Saturday 8:30 am-12:30 pm ------------------------------------------------- Sunday Closed ------------------------------------------------- IST 7000 DIS B1T01 Data Management Alexander, Lisa K. N/A 00:00 AM - 00:00 AM Room-NoRm 3 Book title: MODERN DATABASE MGMT Ed:11 Yr:13 Author: HOFFER Publisher: PEARSON EDUCATION ISBN: 978-0-13-266225-3 Amazon New 142 Amazon Used 123 Wilmu : 207 Book title: MODERN DATABASE MGMT (E-BOOK) Ed:11 Yr:13 Author: HOFFER Publisher: PEARSON EDUCATION ISBN: 978-0-13-266226-0 ------------------------------------------------- IST 7020 DIS B2T01 Analysis, Modeling, and Design Youngs, Robert A. N/A 00:00 AM - 00:00 AM Room-NoRm 3 Book title: SYSTEMS ANALYSIS & DESIGN (BOOK ONLY) Ed:9 Yr:12 Author: SHELLY Publisher: CENGAGE ISBN: 978-1-133-27463-6 ------------------------------------------------- IST 7040 DIS B1T01 Data Communications and Networking Salb, James A. N/A 00:00 AM - 00:00 AM Room-NoRm 3 Book title: DATA COMMUNICATIONS & COMPUTER NETWORKS Ed:7 Yr:12 Author: WHITE Publisher: CENGAGE ISBN: 978-1-133-62646-6 ------------------------------------------------- Book title: DATA COMMUNICATIONS AND COMPUTER NETWORKS (E-BOOK) Yr:13 Author: WHITE Publisher: UNKNOWN ISBN: 978-1-133-82881-5 ------------------------------------------------- Amazon New......

Words: 276 - Pages: 2

Premium Essay

Maximize Profit in Incident Management Operations of It Service Company

...Assignment Of OR Maximize profit in Incident Management operations of IT service Company Akhil Gupta 6/16/2012 Batch – PGCBM-21 SMS ID – 110402 Faculty Name - Dr Supriya Kumar De Study Center – Grand Mall, Gurgaon   Contents Introduction 3 Problem Statement 3 Solution 4 Solution from Solver 4 Summary of attached excel 5 Sensitivity Report 5 Answer Report 6 Analysis and Answers 7   Introduction I am working in a project where we get 3 types of incidents and for each resolution we get some (dollar) amount. At high level, we have 3 teams Design, Build and Test . Analysis and assignment of incidents is done by client team so we don’t have any role to play there. Team size is also decided by clients based on number of incidents they assign to us. I am formulating that problem based on my project and will provide some analysis based on leanings in class. I have learnt a lot in OR classes and now in a position to suggest my findings to client team. Data shared below is not exactly same as that is confidential and cannot be shared having said that problem and scenario is exactly what I use in my day to day project work. Problem Statement There are three types of incidents say Type X incidents, Type Y incidents, Type Z Incidents. All 3 require Design, build and test efforts. It is mandatory to resolve minimum 10 incidents of each type on each working day. To resolve one incident of one type data is shown below - For type X -......

Words: 638 - Pages: 3

Premium Essay

Operations and Supply Chain Case Studies

...Operations and Supply Chain Case Studies In today’s environment of global shopping where the demand for products is as wide as the number of firms offering them, orders can be placed in advance or at a moment’s notice from across the globe. The question of the manufacturer or reseller is how to best manage production across the supply chain. This paper will have two parts to it; part one will review the case study of the Realco Breadmaster. It will provide analysis on the current supply chain management and will make recommendations for a more strategic approach. Part two will focus on a case study for Toyota. This case will focus on quality and the Lean philosophy. First, it is important to provide some foundation support of what operations and supply chain management entail. Every firm or organization must make a product or provide a service to someone that is needed or valued. Operations are the collection of people, technology, and systems that are in a firm whose primary responsibility is to provide the company’s products or services (Bozarth & Handfield, 2008). “Supply chain is the network of manufacturers and service providers that convert and move good from the raw materials state through to the end user” (Bozarth & Handfield, 2008, p.4). Planning and controlling operations and supply chains are critical to the strategic plan of an organization, and so is the coordination and communication with other functional areas of the firm’s supply chain partners....

Words: 2333 - Pages: 10

Free Essay

Case Study Mcdonalds

...Case Study: McDonald’s With intense domestic and intentional competition in the Filipino fast-food market, McDonald’s needs accurate demographic and geographic data in order to understand the current market situation. Challenge With intense domestic and intentional competition in the Filipino fast-food market, McDonald’s needs accurate demographic and geographic data in order to understand the current market situation. Summary Company McDonald’s Philippines is a subsidiary of the Filipino-owned Golden Arches Development Corporation. The first Filipino McDonald’s to open for business was in the Morayta university districts in Manila during 1981. These days McDonald’s is operating over 150 restaurants throughout the islands of the Philippines. Being a 100% Filipino-owned franchise allows McDonald’s Philippines to be more agile and take quicker actions, making them an even more competitive force in the Filipino fast-food market. Challenge Accurate and timely demographic data is difficult to obtain in western economies; the ability to collect this precise data is even further strained when the survey is of a developing country. With a land area of 300,000 km2 spread over 7000 islands and a domestic population of nearly 100 million people, timely and accurate demographic data requires in-depth, thorough, but quick market surveying. McDonald’s Philippines has been operating in an incredibly competitive market for over 25 years. Domestic competition from the leading......

Words: 614 - Pages: 3

Premium Essay

Put Call Parity

...Study……………………………………………………….………………………..6 Research Methodology ………………………………………………………………………………..7 Properties of Data…………………………………………………………………………………………7 4.1 Analysis of different contracts…..………………………………………………………………………….9 4.2 Comparison between Call and Put Trade Volume ….……………………………………..……10 4.3 Speculation ratio…………………………………………………………………………………………………11 4.4 Estimation of NIFTY spot Price using Put-Call Parity……………………………………………13 Conclusion………………………………………………………………………………………………….15 Appendix…………………………………………………………………………………………………….16 1 Executive Summary Futures and options markets in India are relatively new. The National Stock Exchange (NSE) introduced trading in Index Options (also based on Nifty) on June 4, 2001. The Futures and Options on individual securities are available on only 223 securities. In developed markets, derivatives play a very important role in price discovery and information dissemination. However, in emerging markets where the derivatives markets are not very liquid, it is very important to understand their role. This paper attempts to understand and estimates the information content of Indian option market. Firstly, spot prices are calculated using Call-Put Parity and then we compare estimated spot prices with the actual data. We also try to understand the information superiority of near month option and At–the–Money options. We use4 months daily NIFTY options data of different strike prices ranging from 1 August, 2011 to 30November 2011.......

Words: 5711 - Pages: 23

Premium Essay

The Toy Factory Network Design

...the vendors went out of business, eliminating the possibility of support. The only IT person at the manufacturing facility may be an expert on keeping this old system running, but they do not have any experience with new technology. Needless to say, the system is slow and when a problem arise the downtime can go on for hours and sometimes even days at a time. The Toy Factory management wants to address these issues through an upgrade to their system, but they are also looking to positively affect productivity and improve security of the network overall. The proposed network will require significant changes to The Toy Factory's systems. The current hardware is in dire need of an upgrade, which will be implemented with the new physical network architecture. The implementation of this new architecture will provide higher speeds, reliability, and easier maintenance of network (Dennis, 2009). The upgraded hardware will come with better software that will facilitate troubleshooting and maintenance as well as resolve the long down times that are currently happening. The new network will interconnect the management and the manufacturing facilities in Dallas, Texas with the distribution centers located in Los Angeles, California and Pittsburgh, Pennsylvania. In addition, the proposed network will have some changes in its configuration. These changes not only will provide reliability and security for all users of The Toy Factory's network, it will also exposed The Toy Factory to a......

Words: 3448 - Pages: 14