Premium Essay

Advance Database

In:

Submitted By jojoa
Words 693
Pages 3
Requirements Analysis

Objectives
At the end of this exercise, the students are expected to:
 Create user requirements and specification.

 Computer Terminal
 Software installed on the terminal:
- Sybase SQL Anywhere 9
- Opening documents/reading – i.e. MS Word,
Acrobat Reader, etc.
 Software installed on the terminal
 Printer and Paper (as necessary)

Activity 1

FurniPointe Case Study

1. Read and analyze the FurniPointe case study presented below.
2. Using this case study acquire the following:
a. Create the mission statement for the FurniPointe database system.
b. Create the mission objective for the FurniPointe database system.
c. Define the system boundary for the FurniPointe database system.
d. Create a user’s requirements specification that describes in detail the data to be held in the database and how the data is to be used. To accomplish this, you need to:
 Gather more information on the user views of the FurniPointe database system.
 Gather information on the system requirements of the FurniPointe database system.
FurniPointe Case Study
The first branch office of FurniPointe was opened in 2001 in Taguig City. Since then, the Company has grown steadily and now has acquired several offices in Metro Manila. However, the Company is becoming large that more and more administrative staffs are being employed to cope with the everincreasing amount of paperwork. Furthermore, the communication and sharing of information between offices, even in the same city, is poor. The Director of the Company, Erika Dela Cruz feels that too many mistakes are being made and the success of the Company will be short-lived if she does not do something to address the issue. She knows that a database could be of help to solve the problem. She then requests that a database application should be developed to support the operations of

Similar Documents

Premium Essay

Islamic Financial Contracts

...durable assets and currencies Sharikah al Mufawadah Investment Auctioning Output sharing DP with Management DP without Management Profit sharing Musharakah-based DP Mudharabah-based DP Sharikah al Amwal Sharikah al Abdan Sharikah al Wujuh Profit Sharing Revenue sharing Durable Assets Participation Musaqa Muzara‘a Output (Revenue) Sharing Involuntary: e.g., due to inheritance Voluntary: e.g., jointly purchasing a building for renting Sharikah al milk (Partnership based on joint Ownership) Temporary or Ongoing Musharakah Temporary or Ongoing Mudharabah Sharing Principle Fees deferred Ijara: Rents deferred Financial Murabahah Installment sale Object deferred Sale (ODS) Pre-paid istisna‘ Fees paid in advance Rents paid in advance Pure Salam SHARIKAT: PARTNERSHIPS Qard/Service Charge Heeba (Donations) 'Ariyah (qard of assets) Qard: Interest Free Loans TABARU‘AT: GRANTS Hemish Jedheya-Sale:...

Words: 345 - Pages: 2

Premium Essay

Lighthouse Revenue Recognition

...Codification of Accounting Standards, a company should not recognize revenue until 1.“it has performed under the terms of the arrangement” and 2. “unless it will indeed receive and retain payment in a form that has value to the company,” (accountingresearchmanager.com) This means that the company has to perform the duty that they have agreed to in their contract and will receive a form of payment in return. The performance of the arrangement can be the delivery of goods, providing services, or providing information. Once a company performs the terms of the arrangement, the revenue is deemed as earned; however, at least part of the job must be fulfilled. In addition, the company should not recognize revenue even if their clients paid in advance to fulfillment of the agreement. Revenue is realized or realizable when “the seller receives cash or assets from the customer that is convertible into cash,” (accountingresearchmanager.com) This must occur before revenue is recognized. In the case, “Lighthouse”, the issue of how revenue should recognized for the sales of both Ship Finder devices and service arises. In this particular case, the company Lighthouse created a hardware unit which it installs in ships and provides the services for this unit. This device and service are utilized together in providing information to shipping companies on the ship location, speed, and current local weather. Lighthouse requires its customers to sign two separate contracts, one for the device...

Words: 722 - Pages: 3

Premium Essay

Walmart

...Wal-Mart leadership became successful due to the company’s effective leadership style, their organizational structure and its culture. Wal-Mart’s organization culture is recognized to be more of bonded organization between the employer and the employee. Sam Walton, the company’s owner, shared his vision for the company with his associates and made them partners in the success of his company, after Sam died, his legacy remained the same with new management and continued to grow successfully and still remain number one in retail today, because management recognized his vision and carried it out as Sam would have done. New management did not dismantle Sam’s vision but kept the success going unlike Times Picayune, this organization lacked a successful organizational structure and endured more of procedural issues. After Times Picayune owner, Ashton Phelps Jr. retired, his vision was not carried out as he intended. After 175 years, new owner Ricky Matthews, dismantled Phelps vision and emphasized his own vision that became more procedural and steep, which caused the culture of the business to miscommunicate. Workers in this environment are more focus on pleasing the boss, instead of their work performance due to the company’s rules and policies being procedural and controlled without any flexibility. This type of culture causes employee turnovers and a bad reputation for the business. Matthews not only changed the culture of Time Picayune, but he lay off all active employees without...

Words: 461 - Pages: 2

Premium Essay

Database Theories

...Modern Database Applications | [Type the document title] | | | Contents 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery 2 2. Rowley, J. (2007). Wisdom hierarchy: Representations of the DIKW hierarchy. Journal of Information Science 3 3. Goldman, N. (2013). Towards practical, high-capacity, low-maintenance information storage in synthesized DNA. 4 4. Gray, J. (1981). The transaction concept: virtues and limitations. In: VLDB '81: Proceedings of the seventh international conference on Very Large Data Bases 5 5. Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 7 6. Chen, P. (1976). The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems 8 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery Gray states that there is need to distinguish data-intensive science from computational science; he defines an emerging fourth paradigm for scientific exploration. This paradigm is derived from the deluge of data being produced within scientific research fields, and the necessity for tools which can be utilised within the whole research cycle; data capture, curation, analysis and visualisation. He identified that currently the data being produced is not being organised, or published in a systematic...

Words: 3050 - Pages: 13

Free Essay

Riordan Web Based Plan

...Riordan’s products and business systems, interviewed Riordan’s employees, and have determined the best course of action to implement the plan. Riordan Manufacturing is a plastics manufacturer based in several locations across the world. With three plants based in the continental US, which are located in Albany, Georgia; Pontiac Michigan; and in San Jose, California, which is the company headquarters. A fourth plant is located in Hangzhou, China will not be part of the plan as they purchase materials locally. This where we explain how the database will be set up. Refer to the ERD, Sequence diagram, Use Case diagram, and Class Diagram that followThe following paragraphs will describe the considerations that Riordan Manufacturing will need to make in implementing the database plan. Where ever it is possible to for our firm to do so, LTB and Associates will make a recommendation on the choice to make. In order to implement the database properly, these recommendations should be implemented in order to offer the tightest amount of security that will be possible. Type of Online ProcessingRiordan Manufacturing will need to decide between real-time asynchronous processing and batch processing. Real-time asynchronous processing is applicable when the processing must be performed immediately or when the results must eventually be communicated back to an on-line user. One of the problems with real-time processing is that real-time timers and events are required; they are expensive...

Words: 2477 - Pages: 10

Premium Essay

Sofware Applications and Information Systems

...general, information systems and software application are used to accomplish the most vital of a business’s financial needs. hardware, communications devices, network, people, and specific tasks. The form of operation is very similar to any other systems, which requires the inputs from users by keying in commands and instructions, scanning and typing. These date information inputs are processed by calculating, reporting, and using technological devices such as computers. In addition to information systems, application software also helps business to process and operate daily tasks more accurately allowing for more advance and secure methods than the more traditional methods used in the past. Software applications provide the user with diverse programs used to operate computers and related devices. For example, spreadsheets, word processors and database management systems fall under software applications. Software applications and information systems are relate to the organizational departments. Examples of these departments are accounting, human resources and marketing. According to Answers.com (2011) Accounting Information Systems (AIS) “is the collection, storage and processing of financial and accounting data that is used by decision makers. AIS is generally a computer-based method for tracking accounting activities in conjunction with information technology resources. The resulting...

Words: 638 - Pages: 3

Free Essay

Abc Markets

...Downloaded By: [Schmelich, Volker] At: 10:58 11 March 2010 Focus THEME COMPETITIVESTRATEGY FOR ELECTRONIC COMMERCE In many respects, Korean economy has been coordinated by the visible hand of the government. The world economy is becoming a borderless one, which directly affects the Korean economy driving it into an open economy. The rising cost of production factors, wage rates, interest rates, and land costs stalls economic growth. Both internal and external economic environment casts doubt over the prospects of the Korean economy. Both public and private sectors are looking for ways to maintain their competitive edge by improving economic efficiency, and one of those efforts is the use of IT. They are making an utmost effort to build the information-communication infrastructure, and promoting EC to explore new business opportunities. Various efforts are being made to facilitate the diffusion of the EC in Korea. The diffusion of proprietary EC within a conglomerate may be made quickly with little trouble. The IOS or EC within a conglomerate is highly likely to be a closed one, which is not unusual among Korean conglomerates. This may result in a situation that goes against global technological future: an open EC system. Korean corporates have recently devoted a vast amount of effort to business process reengineering using IT to improve efficiency. In contrasts, SMEs lack appropriate IT skills requirrd for such innovative movements. This may result...

Words: 2647 - Pages: 11

Premium Essay

Big Data (Mongodb, Hbase and Casandra)

...Big Data [Name of Writer] [Name of Institution] Introduction The term Big Data is gaining more followers and popularity. However, despite this trend, not all organizations are clear about how to face the challenge to store, organize, display and analyze large volumes of data. The term Big Data is gaining more followers and popularity. However, despite this trend so evident, not all organizations are clear about how to face the challenge to store, organize, display and analyze large volumes of data. There are multiple techniques in terms of huge database storing approaches that can store petabytes, exabytes and may be zetabytes data. These options are Cassendara, Mongodb and HBase. We will discuss about them one by one and in a proper research method and will compare them in order to contrast their difference and efficiency. Research Background One problem in understanding the phenomenon is that the size of these data sets the volume greatly exceeds the Data warehouse. A plane collects 10 terabytes of information from sensors every 30 minutes flight, while the Stock Exchange of New York collects structured information 1 TB per day. In the context of Big Data, volumes are reaching peta bytes, exa bytes and then soon to zeta bytes. For instance, Apple has just announced that 7 trillion send daily notifications to iOS devices. The explosion of information in social networks, blogs, and emails is characterized the presence of data key...

Words: 3463 - Pages: 14

Premium Essay

Sms311 A1

...1. Before using ACCPAC we create two types of databases, System database and Company database. a. System database stores information on users, passwords, security groups, security settings, currency for the companies that are linked to it. b. Company database stores information that is used by all the accounting applications for a single company. All information entered in the modules is stored in the company database. 2. We create company and system databases in Sage Accpac, but before we create system and database we must create the folders that will hold the sage Accpac databases in Windows Explorer after we set up system and company database in Microsoft SQL Server. 3. The directory in which your data files will be located is determined in the folder field of the database setup window. When you enter a new database, folder field is entered on the second screen of the database setup window. If the folder you enter has not already been created. You will be prompted to create it. 4. Once the company has been created, the functional currency selection cannot be changed. In order to change it company database files have to be deleted and created from the beginning. 5. Administrative Services and Common Services are part of the system manager. a. Common Service manager the data shared by all accounting modules for the company. (Company profile, Currency, Schedules, Reminder List,Fiscal Calendar etc.) b. Administrative Services contains icons that are used only by system...

Words: 851 - Pages: 4

Premium Essay

Flix2You

...Summary 3 Scope of Work 4 Project Management 5 Project Resources and Budget 8 User Analysis 10 Organization of Data 14 Database Administration 17 Database Backup and Recovery 19 Legal Issues 22 Works Cited 25 Appendix A – DDL Script 26 Appendix B – Sample Reporting 37 Executive Summary Illuminated Communications offers this solution to meet the growing demands of Flix2You. We understand the limitations of the existing database design and have proposed a new design that will provide Flix2You a more robust database environment intended to capture more customer data.  This will address the primary concerns of Flix2You and allow for the understanding of its customer’s habits that it seeks to gain. Included in this document you will find our scope of work, as it has been determined based on the requirements that have been provided. With that we developed a project plan highlight the major milestones from project start to final sign off. Please note that Illuminated Communications will provide comprehensive testing, training, and support past go live to ensure our solution meet the demands of Flix2You. Understanding Flix2You users is important to our design process. We have included an in-depth user analysis to help us build our system to support the needs of all Flix2You user from upper management personnel to database administrators. Illuminated Communications has several modifications to the infrastructure of the existing systems so Flix2You will...

Words: 5807 - Pages: 24

Premium Essay

Statement of Need

...tasked with overseeing the acquisition of a proprietary database program for the entire Research and Development department. * Explain how you would go about developing the statement of need? Give examples of the information required and factors to be considered. To begin the process of acquiring the new program, I would first develop a Statement of Need (SoN). Once the database program that we were currently using had been determined to be obsolete or no longer suitable for our needs (or, even better, if we had made this determination well in advance of the program actually failing to meet our requirements), a new proprietary database program would have to be developed (or purchased) and then phased in to replace our current system. In order to spend any of our precious government funds, I would have to make a case for why we wanted to buy a new program. One of the first things that I would do would be to speak to the users of the system to determine what exactly the current program was being used for, and how it was being used. Besides speaking with the individuals within the Department of Energy who used the program the most, I would also speak to the vendors (or developers) of the program to get their input as well. I would then find out what (beyond our current uses) it was capable of doing, and if any of these additional features could be utilized to enhance the usefulness and extend the life of the current database program. In addition to finding out what it could do...

Words: 1396 - Pages: 6

Premium Essay

Wildwood

...discover relevant entities and attributes for database * Prepare interview questions and follow up * Prepare questionnaires * Observe work flow for process and exceptions Outline I. Gathering Information A. Initial Interviews with Chief Stakeholders B. Review of Business Documents C. Interviews with Stakeholders D. Questionnaires E. Job Shadowing II. Review of Business Documents A. Reasons for Review B. Forms C. Reports D. Other Business Documents III. Types of Databases A. Transaction Database B. Management Information Systems C. Business Intelligence Systems D. Cloud Databases IV. Interviews with Stakeholders A. Preparing for the Interview B. Conducting the Interview C. Note Taking and Evaluating the Interview V. Questionnaires A. When to Use Questionnaires B. Advantages and Disadvantages C. Comparison with Interviews VI. Work Shadowing A. Reasons to Observe Stakeholders at Work B. Looking for Exceptions VII. Documentation A. Business Documents B. Interview Questions and Answer Summaries C. Questionnaires and Summaries Vocabulary 1. Closed-Ended Question | g. A multiple choice question | 2. Domain | o. The purpose or subject of a database | 3. Business Intelligence | g. A Set of tools for analyzing business trends | 4. Exception | j. An Alternate way of doing a process | 5. Form | b. A document for gathering input | 6. Transaction Database | m. A database optimized for storing and processing real...

Words: 6806 - Pages: 28

Free Essay

Computerized Inventory System Not Complete

...Chapter I INTRODUCTION Background of the Study Technology advances as it changes through the times. However, despite this advancement in technology, Ding-Dong Hardware in Glan, Sarangani Province still uses the manual process in their inventory. The Ding-Dong Hardware finds it hard; hence, the database of a systematic inventory was conceived. The researcher conducted interviews and surveys in developing a database computerized inventory system. Using the System Development Life Cycle (SDLC) Method, this Ding-Dong Hardware Computerized Inventory System was successfully attained. It could generate the derived data that would greatly help the personnel in preparing inventory and to speed up the process. Objectives of the Study Generally, this study aimed to create a database system for the Ding-Dong Hardware in Poblacion, Glan, Sarangani Province. Specifically, this was geared to: 1. Lessen the time spent in preparing inventory; 2. Ensured hardware records of data and information; and 3. Improve track of information about the business status. Significance of the Study The study was conceptualized to solve problems occurring in preparing inventory (daily, monthly and yearly inventory), keeping records of information and in keeping track of the business status in Ding-Dong Hardware in Glan, Sarangani Province. The researcher computerized the manual process to provide assistance to the personnel in charge of generating, regulating and ensuring...

Words: 2373 - Pages: 10

Premium Essay

4tq4g

...Business Information Systems Elizabeth Hardcastle Download free books at Elizabeth Hardcastle Business Information Systems Download free eBooks at bookboon.com 2 Business Information Systems © 2011 Elizabeth Hardcastle & bookboon.com ISBN 978-87-7681-463-2 Download free eBooks at bookboon.com 3 Business Information Systems Contents Contents 1 Defining Information Systems 7 1.1 Defining Data and Information 7 1.2 Defining Systems 8 1.3 Defining Information Systems 8 1.4 Business Information Systems 8 1.5 Types of business information system 9 2 Hardware 10 2.1 Input devices 10 2.2 Central Processing Unit (CPU) 10 2.3 Internal and External Memory 10 2.4 Output devices 10 2.5 Major categories of computers 11 3 Software 12 3.1 Systems software 12 3.2 Application software 13 The next step for top-performing graduates Masters in Management Designed for high-achieving graduates across all disciplines, London Business School’s Masters in Management provides specific and tangible foundations for a successful career in business. This 12-month, full-time programme is a business qualification with impact. In 2010, our MiM employment rate was 95% within 3 months of graduation*; the majority of graduates choosing to work in consulting or financial services. As well as a renowned qualification...

Words: 20690 - Pages: 83

Premium Essay

It for Sports Management

...IT for Sports Management Introduction This article will address the topic of information technology for sports management and will attempt to provide an overview of how information technology (called IT) is changing the nature of management practices in sport. The discussion of IT applications in the profession can be done in a few broad areas: 1st How the tools of today's "technological revolution" can be applied to the administration of sport. 2nd How developments such as the Internet and world wide web help in specific management functions such as training and marketing 3rd How e-commerce can make participation in sports more available through lower priced equipment and lastly, 4th The digital divide: and underlying condition that keeps some from participating fully in the benefits in the IT revolution. The Technological Revolution We are living in the midst of one of those very unusual occurrences that come along once every few generations: a society wide paradigm shift. The close of the last millennium has seen a fundamental change that is moving society the age of industry to the age of information. The currency in this new society that is being formed is information and the medium of exchange is called IT (and sometimes computer technology - CT). IT is simply the tools and methods used for the identification, organization and manipulation of facts that we call data. IT has become the engine that is driving all sectors of today's economy be it industry, government...

Words: 2958 - Pages: 12