...Pre-Requisite: Completion of 1st Year Courses Introduction: Systems Design is a central part of systems development. It comprises the process of turning a set of user requirements into an implementable system and encompasses various activities to achieve this end. Alternative models are challenging the traditional systems development life cycle. Alongside this, two approaches to systems development are emerging: the traditional structured approach; and the object oriented approach. The systems design activity will be studied in the context of these trends. Students should make themselves familiar with at least one traditional approach (e.g. SSADM) and one object oriented approach (e.g. UML). Aims: To understand the role of systems design within various systems development life cycles To develop awareness of the different approaches that may be taken to systems design To understand and apply the tools and techniques that are currently used by systems designers Formatted: Superscript Objectives: Describe different life cycle models and explain the contribution of systems design within them Discuss various systems development approaches and explain their strengths and weaknesses 1 30/09/1123/09/10 Evaluate the tools and techniques that may be used by a system designer in a given context Use appropriate methods to produce a system design for a given scenario Provide suitable systems documentation for a design Discuss the CASE tools currently available Content: Week...
Words: 2312 - Pages: 10
...Data Warehouse Design: Dimensional Modeling II Data Technology Chularat Tanprasert, Ph.D. Recap Dimensional modeling Popular, useful, and pragmatic approach Based on Kimball Fact table Dimension tables Design process in steps Database Schema Design Star Schema (With Attributes) Example Designs A useful way to learn about data warehouse design principles is by using examples – reuse. Kimball – Data warehouse lifecycle toolkit Adamson & Venerable – Data warehouse design solutions Let’s take a look at inventory, shipments, and financial services. Inventory An inventory system serves as a “middleman” between the manufacturer and the retailer – value adding process. There are threee types of inventory model Inventory snapshot Delivery status Transaction Inventory Snapshot Model For specific time periods, inventory levels are measured and recorded. Delivery Status Model Create one record for each complete shipment of a product to a warehouse. Transaction Model Record every transaction that affects the inventory. Shipments The shipments process is where the product leaves a company and is delivered to a customer. Typically, accompanying each shipment is a shipment invoice. Each line item on the shipment invoice corresponds to an SKU. Shipments Shipments Shipments Financial Services Typically a large bank. Services...
Words: 1220 - Pages: 5
...existing system leads to the designing of computerized system that will be compatible to the existing system with the system Which is more user friendly and more GUI oriented. We can improve the efficiency of the system, thus overcome the drawbacks of the existing system. Identification of the drawbacks of the existing system leads to the designing of computerized system that will be compatible to the existing system with the system Which is more user friendly and more GUI oriented. We can improve the efficiency of the system, thus overcome the drawbacks of the existing system. · Less human error · Strength and strain of manual labour can be reduced · High security · Data redundancy can be avoided to some extent · Data consistency · Easy to handle · Easy data updating · Easy record keeping · Backup data can be easily gener 1. INTRODUCTION PROBLEM STATEMENT This system is designed in favor of the hostel management which helps them to save the records of the students about their rooms and other things. It helps them from the manual work from which it is very difficult to find the record of the...
Words: 3589 - Pages: 15
...prepared by the Information Technology (IT) team describing a new information system required by our Advanced Services Network Consulting Engineers (NCEs). The information provided has been summarized and is intended to provide an overview of the proposed project. Executive Summary Within our organization we have a group of Network Consulting Engineers (NCEs) that provide Planning, Design, Implementation, and Operational (PDIO) services to contracted enterprise and service provider clients. On a number of recent occasions, it has come to light that one NCE is struggling with a design or planning issue that has already been addressed by another NCE. And in some cases, the solutions provided to our clients were not consistent between the NCEs. It has been determined a new system is needed that will provide an orderly and organized data repository that would be available to all NCEs. This system needs to provide an easy method for the NCEs to access and leverage previously defined design solutions. This system will provide several key benefits to the NCE team: ▪ NCE will be able to search for data related to the solution being considered ▪ NCE will save time in that we will not "reinvent the wheel" ▪ NCE provided solutions will be more standardized ▪ Using the same solution repeatedly simplifies supporting our solutions ▪ Allows our NCEs to be able to provide backup to one another ▪ With standard solutions we increase the probability that we will continually...
Words: 1688 - Pages: 7
...Integrative Network Design Project Part 1 NTC/362 May 5, 2014 Fernando Casafranca Integrative Network Design Project The Patton-Fuller Community Hospital looks to upgrade their Information Technology (IT) capability beginning with their networks. The characteristics, components, and topology are evaluated to properly identify the needs for the new network design. The plan includes converting to a Wireless Local Area Network (WLAN), installing a Voice over Internet Protocol (VoIP), and design a Wide Area Network (WAN). The plan also includes the hospital maintaining all Macintosh® computers. Administration/Clinical Overview * The administrative departments run off of a 1000 Base-T Ethernet provided by a CAT 6 cable which is also the entire hospital’s network backbone. Clinical department networks however are provided by a 1000 Base-F Ethernet provided by a single mode fiber. The clinics feed into a Cisco Catalyste 3560 Switch as the network bridge that links the two together. All workstations are Apple iMAC or MAC Pros with the executive management, senior managers, and the data center workstations as having a wireless communication card installed. * IT Data Center * The data center is comprised of the hospital HIS system. The mainframe of the HIS is connected by a 4 gigabit fiber link to a 10 terabyte Network Area Storage (NAS) device. The data center’s workstations are all Apple iMACs that run a MAC OS X from a remote desktop. Virtualization...
Words: 944 - Pages: 4
...------------------------------------------------- 1. Explain the main difference between a file-oriented system and a database system. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. DBMS stands for Database Management System. A DBMS is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database. A DBMS is made up of a DML (data manipulation language), Schema and subschemas, Physical data repository, and an Interface to allow access to the database from DBA’s, Users, and Related Information Systems. 3. Describe a primary key, candidate key, secondary key, foreign key, and common field. Primary Key – a field or combination of fields that uniquely and minimally identifies an entity. Candidate Key – Any field or combination of fields that can act as the primary key but are not. Secondary Key – Any field of combination of fields that can be use to identify a entity. Foreign Key – A field that exists in an entity that is the PK of another entity. Common Field – An attribute (field) that appears in more than one entity (record). 4. What are entity-relationship diagrams and how are they used? What symbol is used to represent and entity in an ERD? What symbol...
Words: 1096 - Pages: 5
... “Best Buy Co., Inc. today confirmed that it has, as part of its Renew Blue transformation efforts, eliminated approximately $150 million in costs, including an approximate 400 person reduction in employee headcount at its headquarters” (VonWalter, 2013). One measure of the restructuring effort is to research the Best Buy client base to determine what is working well, and what could be improved upon. Research Problem and Purpose The purpose of this paper is not to answer the best practices for a Best Buy restructure, but to facilitate an approach to understating a demographic of Best Buys’ customer base.. The portable communications industry (laptops, tablets, smart phones) infiltrated business communities and societies around the globe in the 1990s. The technological advances associated with these devices have affected almost every aspect of daily life; social media, news media, entertainment, war, photography, personal communication, and business communication. The purpose of this paper is to understand how Best Buy can gain a competitive edge in its cell phone department. Asking pertinent questions to the existing customer base offers an opportunity to recognize why people decide where they purchase their cell phones, and cell phone services. Significance, Scope,...
Words: 2453 - Pages: 10
...benefit analysis in data warehouse design” This research seeks to address the issue of identifying the set of data which has the potential for producing net value for the organization through a model that helps to perform the cost benefit analysis. Typical data warehouse store a set of data tables which are of 2 types: base table and materialized view that are generated from the existing data tables. Data warehouse is used to support a set of decision support views. There is a need to identify the set of DSV’s that provide the most net value to the organization and this will determine the set of data tables that should be stored in the data warehouse. DSV’s are used to perform particular tasks that are beneficial for the organization and also helps to achieve the organization goals. In the data warehouse formulation phase who needs what data has to be considered which is identifying the needs of the IT and business users of the DW. According to Kalfus et al, all data are essential and must be stored and interesting patterns can be extracted from it. But the disadvantage of this is if all the data is stored the space consumed by it will be very high. Data warehouse quality is also an important factor for those who design the use of systems that support decision makers. The cost for improving the quality is high. The cost benefit analysis can be used to identify the DSV’s that give the most net value to the organization, suitable quality levels and the data tables that are to be...
Words: 499 - Pages: 2
...concepts that are the basis for current computers. The computer lies at the heart of computing. Without it, most of the computing disciplines today would be a branch of theoretical mathematics. To be a professional in any field of computing today, one should not regard the computer as just black box that executes program by magic. We, students of computing should acquire some understanding and appreciation of a computer system’s functional components, their characteristics, their performance, and their instruction. There are practical implications as well. In describing computer systems, a distinguishing feature is frequently made between Computer Organization and Computer Architecture. Computer Organization explains the function and design of the various units of digital computers (displaying information as numbers rather than with hands and a dial) that store and process information. It also deals with the input units of the computer which receive information from external sources...
Words: 1348 - Pages: 6
...2010 System Development Phase I Kudler Fine Foods is committed on providing customer satisfaction to all customers that purchase products from all of affiliated stores. To better serve the customers, Kudler is interested in developing a system to track customer purchases through a Frequent Shopper Program to award loyalty points for redemption (Kudler Fine Foods). Scope To develop a Frequent Shopper Program (FSP) that will improve customer’s satisfaction, track purchasing activities from the customers, and offer high end product for redemption as a reward for shopping at their stores. Goal Under the new program, each customers purchase transactions will be recorded and reward points will be earned base on dollar amount spent per transaction. Once points are accumulated, the points can be redeemed for high end gifts, products, specialty foods (Kudler), or partnership services from vendor companies. With the new system implementation, Kudler Fine Foods will be able to add new value to customers; improve customer satisfaction, increase margin profits, customer loyalty, and have adequate management system to track customer’s spending habits at Kudler Fine Foods. The main key stakeholders evolved will be Marketing and Sales department, Vendors, and Customers. With the new system implementation, the Marketing and Sales department will be able to improve and provide customer satisfaction which in return generates customer’s loyalty and...
Words: 5143 - Pages: 21
...Module 5 Database Management using OpenOffice Base Module Overview Welcome to Module 5 - Database Management using OpenOffice Base. This module explores the building of a database using the OpenOffice 3.0 Base software application. The module is intended to be very hands-on and focus upon two primary areas: the how and why of designing and implementing a database, and to develop a basic understanding of relational database theory. This balance of practice and theory is intended to bring greater design strength and data integrity to your database applications. | Upon completion of this module you will be able to: * Describe a database and how it can be utilised * Discuss the difference between a database and the other applications * Understand how databases are organised and operated * Create a simple database and view database content in various modes * Create a table, define and modify fields and their properties; enter and edit data in a table * Sort and filter a table or form: create, modify and run queries to retrieve specific information from a database * Understand what a form is and create a form to enter, modify and delete records and data in records * Build queries to retrieve and sort data * Create routine reports * Build and print reports for regular and ad hoc reporting of data Terminology | | Database | A database is a collection of related information which is organised into a series of rows (called records) and columns (called...
Words: 20896 - Pages: 84
...Introduction This memorandum addresses our recommendation for Product Data Management and Visionary Design System employees. First, it states the principal and agent relationships. Second, it addresses the sources of problems with PDM. Third, it discusses solutions and recommendations for PDM and VDS employees. Finally, it discusses other organizational changes and concludes with a summary of our recommendations. Principal-Agent Relationships The PDM software provides organizational efficiency for VDS. As a result, the VDS executives serve as the principal and PDM is the agent. The executives of VDS pride themselves on working closely with the customers and departments as well, therefore, VDS serves as agents to customers. VDS has the greatest potential to achieve a great competitive advantage because it captured a large portion of the market from its previous services. As a result, VDS has the advantage of the opportunity to explain its extensive benefits for consumers’ design process during its consultations. PDM needs VDS’s respected brand in the market and it has the technological advances to bring in greater revenue for VDS as a whole. Sources of Problems with PDM VDS’s advantage develops from its consultation advice and the benefits and simplicity of the PDM software; however, without the cooperation and understanding from the Sales Representatives, this advantage fails. The consulting services were first cut to save money, but without them, the PDM service...
Words: 767 - Pages: 4
...components, and topology are evaluated to properly identify the needs for the new network design. The plan includes converting to a Wireless Local Area Network otherwise known as (WLAN), installing a Voice over Internet Protocol otherwise known as (VoIP), and design a Wide Area Network (WAN). The plan also includes the hospital maintaining all Macintosh® computers. Administration/Clinical Overview * The administrative departments run off of a 1000 Base-T Ethernet provided by a CAT 6 cable which is also the entire hospital’s network backbone. Clinical department networks however are provided by a 1000 Base-F Ethernet provided by a single mode fiber. The clinics feed into a Cisco Catalyste 3560 Switch as the network bridge that links the two together. All workstations are Apple iMAC or MAC Pros with the executive management, senior managers, and the data center workstations as having a wireless communication card installed. * IT Data Center * The data center is comprised of the hospital HIS system. The mainframe of the HIS is connected by a 4 gigabit fiber link to a 10 terabyte Network Area Storage (NAS) device. The data center’s workstations are all Apple iMACs that run a MAC OS X from a remote desktop. Virtualization allows for operating Windows and Linux OS or applications. The workstations also run a Picture Archiving and Communication System (PACS). The data center also host a Remote Access Server (RAS), Windows exchange, and Internet server bridged...
Words: 3457 - Pages: 14
...Sample Master Test Plan TEST PLAN IDENTIFIERRS-MTP01.3 REFERENCES None Identified. INTRODUCTION This is the Master Test Plan for the Reassigned Sales Re-write project. This plan will address only those items and elements that are related to the Reassigned Sales process, both directly and indirectly affected elements will be addressed. The primary focus of this plan is to ensure that the new Reassigned Sales application provides the same level of information and detail as the current system while allowing for improvements and increases in data acquisition and level of details available (granularity). The project will have three levels of testing, Unit, System/Integration and Acceptance. The details for each level are addressed in the approach section and will be further defined in the level specific plans. The estimated time line for this project is very aggressive (six (6) months), as such, any delays in the development process or in the installation and verification of the third party software could have significant effects on the test plan. The acceptance testing is expected to take one (1) month from the date of application delivery from system test and is to be done in parallel with the current application process. TEST ITEMS The following is a list, by version and release, of the items to be tested: A. EXTOL EDI package, Version 3.0 If a new release is available prior to roll-out it will not be used until after installation. It will be a separate upgrade/update...
Words: 3503 - Pages: 15
...SEMESTER Design and Implementation of a Data Warehouse Prototype for the University of Nairobi within the Context of Relational Online Analytical Processing (Data Analysis) PRESENTED BY: 1. JORAM KIPLIMO D61/68960/2013 0724431978 . PRESENTED TO: Dr. Muranga Njihia Word count: 2752 ABSTRACT Data ware housing is a booming industry with many interesting research problem. The data warehouse is concentrated on only few aspects. The discussion here is about the data warehouse design and usage in the case of the University of Nairobi Environment. Data warehouse can be built using a top-down approach, bottom – down approach or a combination of both. In this research paper we are discussing about the data warehouse design process. Data Warehouse (DWH) systems are used by decision makers for performance measurement and decision support. Currently the main focus of the DWH research field is not as much on the interaction of the DWH with the organization, its context and the way it supports the organization’s strategic goals, as on database issues. The aim of the study is to emphasize and describe the relationship between the DWH and the organization with conceptual models, and to use this knowledge to support data interpretation with business metadata. KEYWORDS Data Warehouse (DWH) Data Mart Extraction, Transformation and Loading (ETL); Software that is used to extract data from a data source like a operational system or data warehouse...
Words: 2816 - Pages: 12
