Free Essay

Data Flow Diagrams and Decision Tables

In: Computers and Technology

Submitted By Cheychey
Words 452
Pages 2
Requirements and Data Flow Diagrams

Ocean Sound College

Ocean Sound College is a liberal arts college in need of new system to manage housing opportunities for students, faculty and staff. Presently, they are using an outdated method of storing and managing this information. With this new system, Ocean Sound will ultimately save time and money. This system will implement an application that is able to accept, sort and display available housing options based on the user’s needs. The user will be able to select from a variety of options, including but not limited to: type of housing, size of living space, bedrooms, bathrooms, pets, utilities, and student/staff housing. In addition, this system will be capable of allowing the owner of the listing to edit or delete their post as needed. This will assist in the maintenance of the system as it will negate the previous need for private landlords to call once a property is rented. This system will also be capable of regularly checking postings for age and status. Once a listing from a private landlord is over 2 months old, the system will recognize it and delete it. Additionally, users will be able to flag if they have found a listing that is still posted when it has already been rented. This information will be forwarded on to the housing office staff along with contact information for the poster so that they can contact them to verify.

Structured English Statements for OLD LISTINGS process:

Input data flows: LISTING, LISTING OWNER, LISTING AGE
Output data flows: DELETE LISTING, KEEP LISTING

For each LISTING
If LISTING OWNER = PRIVATE and if LISTING AGE >= 2 MONTHS
Output DELETE LISTING Else Output KEEP LISTING

Decision Table:

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 2 Months or older | Y | Y | Y | Y | N | N | N | N | Private listing | Y | Y | N | N | Y | Y | N | N | Flagged by users as rented | Y | N | Y | N | Y | N | Y | N | Keep listing | | | | X | | X | | X | Remove listing | X | X | | | | | | | Notify to call owner of listing | | | X | | X | | X | |

Updated Decision Table (With Rules Marked for Combination):

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 2 Months or older | Y | Y | - | Y | - | N | - | N | Private listing | Y | Y | - | N | - | - | - | N | Flagged by users as rented | - | - | Y | N | Y | N | Y | N | Keep listing | | | | X | | X | | X | Remove listing | X | X | | | | | | | Notify to call owner of listing | | | X | | X | | X | |

Simplified Decision Table: | 1 | 2 | 3 | 4 | 5 | 2 Months or older | Y | - | Y | N | N | Private listing | Y | - | N | - | N | Flagged by users as rented | - | Y | N | N | N | Keep listing | | | X | X | X | Remove listing | X | | | | | Notify to call owner of listing | | X | | | |…...

Similar Documents

Premium Essay

Kudler Foods Data Tables

...Kudler Foods Data Tables Kudler Fine Foods was founded in 1998 by Kathy Kudler as an upscale specialty food store. The first location of Kudler was in La Jolla, CA, followed by stores opened in Del Mar and Encinitas. Kudler Fine Foods offers its customers selections in bakery and pastry products, fresh produce, fresh meat and seafood, condiments and packaged foods, as well as cheese and specialty dairy products. This brief will evaluate the design of Kudler’s current inventory data table, make recommendations for improvements to the current tables, and provide information for effectively using pivot tables. Design Element Evaluation Analysis of Kudler’s data tables by end users is essential to Kudler’s inventory control. End users should be able to use inventory data tables to determine the amount of inventory on hand in each location, which in turn will assist end users in determining the amount of inventory to be ordered to replenish each location. Kudler’s current inventory data table provides its end users with general ledger coding, inventory items, store locations and departments, and the value of each inventory on hand. Users of Kudler’s current inventory data table are able to quickly identify the products store location and department by viewing the general ledger code. The first two numbers of the general ledger code indicate the store location of the inventory, while the third number indicates the department the inventory belongs to, and the last two......

Words: 599 - Pages: 3

Premium Essay

Kudler Data Table Analysis

...is necessary to show the transactions and movements of various items through flow charts or in a similar illustrative way so that it can get its user understood the scheme in no time, but the existing table does not possess this type of quality for accounts receivable sales and payments etcetera. All of this should be in a complete manner that may prove to be a complete manual for the business conduct. Data table on their web site and below Entity Relationship diagram are clearly in support of the process of decision making and pertinent improvement thereto. Based on accounting records the table makes the management up on decision making process. How is the table pertinent to that of accounting records containing the information? Clearly it depicts first off the cost centre namely Department 10 and codifies the items in turn, well sum and quantity direct one on the respective amounts given. Pivot Table also shows total quantity on hand and total amount in a given period Entity Relationship Diagram of Kudler Fine Food Data Table Kudler Database Diagram The above diagram is constructed in such a way that links various items through Variable Characters numbered in a particular way, starting with the table designed for customer data is followed by a table stating information for orders duly codified and assigned a particular ID. The table is adroitly linked with Tax table and Tender that prettily is lin...

Words: 281 - Pages: 2

Premium Essay

Data Flow Diagram

...Data Flow Diagram Tutorial Objectives After completion of study of this unit you should be able to: Describe the use of data flow diagrams Produce a data flow diagram from a given case study including different levels Distinguish between the different categories of data flow diagrams 1. Introduction 1.1 CASE tools 1.2 Development and purpose of Data Flow Diagrams 2. Components of Data Flow Diagrams 2.1 Components 2.2 Hints on drawing 2.3 Data flows 3. Developing Data Flow Diagrams 3.1 Introduction 3.2 Context diagram 3.3 Level 1 Data Flow Diagram 3.4 Lower levels of Data Flow Diagrams 3.5 Check list 4. Categories of Data Flow Diagrams 4.1 Physical 4.2 Logical 4.3 The relationship between logical and physical Data Flow Diagrams 5. An example of the development of a Data Flow Diagram 6. Process models 7. Summary 8. Activities 9. Bibliography 10. Commentary on activities 1. Introduction This unit deals with one of the major techniques for recording the requirements of a user for a new computer application. An initial diagram is constructed to show the processes which are being implemented in an existing system. The diagram helps to show how information is used to produce the functions that are required by the current system. It also shows what information is provided to the system and what......

Words: 6419 - Pages: 26

Free Essay

Data Flow Diagrams

...5-3 Short Answer/Essay Questions: Data Flow Diagrams IT-510-X2879Advanced Info Technology 14TW2 1. Data flow diagrams show the flow of data through systems and are used during problem analysis. Systems do not transform input to a desired output in a single step. DFD's capture the information about the transformations and the movement of data through a system with bubbles and arrows to show relationships (Freetutes.) One of the four common mistakes often made when using data flow diagrams is an illegal data flow. All flows begin or end at a processing step, in which data is changed into a form of the final output. This way, mistakes can be identified and followed back to their source in order to be fixed. That is why it is important to ensure that there are no diagramming mistakes. The following are four descriptions of common diagramming mistakes that should be kept in mind when using a data flow diagram: A source or a sink cannot provide data to another source or sink without some processing occurring Data cannot move directly from a source to a data store without being processed Data cannot move directly from a data store to a sink without being processed Data cannot move directly from one data store to another without being processed (Whitten;Bentley;Barlow, 360.) Black holes, grey holes and miracles are a second class of mistakes when using data flow diagrams. These mistakes arise when the outputs from processing steps do not match their inputs....

Words: 921 - Pages: 4

Premium Essay

Data Table Analysis

...Data Table Analysis ACC/542 May 19, 2014 Data Table Analysis Kudler Fine Foods is an upscale specialty store that is located in the San Diego area. There are three locations: La Jolla, Del Mar, and Encinitas. KFF carries the best domestic and imported fare ranging from bakery and pastry products to cheese and specialty dairy products. The purpose of this paper is to evaluate the design elements of the data tables from an accounting perspective and to recommend improvements to the existing data tables. The paper will also explain how the information in the pivot table may improve decision making for management at KFF. When glancing at KFF’s data tables they seem to be easy to understand by someone with or without an accounting background. The inventory table consists of the components that make up an inventory item. This table is used for managing the inventory and determining the availability of all ingredients that are needed to prepare items. The inventory items are displayed according to the following description items: item ID, inventory ID, perishable, nonperishable, department, category, description, unit of measure, quantity on hand, unit cost, master pack quantity, supplier ID, assembly line, substitute item, and tagalong item. There are changes that can be made to further develop the inventory data at KFF. Entity diagrams are used to illustrate the relationship between entities and their corresponding associations. The different shapes are used to signify...

Words: 654 - Pages: 3

Premium Essay

Data Table Analysis

...Evaluation Data Tables Data Table analysis is essential to the success of Kudler, the information provided in these tables is available for the end user to determine inventory levels and when ordering is needed. The design of data tables organizes the financial data into department, financial codes, items and then sums of total amount of transaction. Data tables maximize the visual and informational presentation for the financial data. The user can easily identify information about each item as belonging to certain department, and how many items were received at the given cost for a certain period. It allows finding total amount and quantity on hand for an item and calculating average price for an item. Entity relationship diagram illustrates the hierarchy of how information reviewed by end users. The data represented in entity relation diagrams (E-R) includes the business entities and the relationship among them. E-R diagrams use four symbols: rectangles to represent entities, diamonds to describe relationship, ovals describe the entity, characteristics, and connecting lines depicts relationships. Recommendation for improvements to the Data Tables The Pivot Table is two-dimensional statistical summay of database information and can be improved by arranging the codes chronologically and sorting the data by compiling the list of product inventory levels. This will facilitate monitoring items for a department that has different items to sell. Data sorting will......

Words: 411 - Pages: 2

Premium Essay

Data Table Analysis

... Data Table Analysis Sonya Cunningham University Of Phoenix Accounting Information System ACC/542 Eva King May 25, 2015 Data Table Analysis Kudler Fine Foods, established in 1998 is a specialty food store. The products at Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design elements of the data tables from an accounting perspective, recommend improvements to the data tables and explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data. It will also include an entity relationship diagram illustrating the existing data tables and a pivot table on Kudler inventory data from the company intranet. Evaluation of the design elements of the data tables from an accounting perspective Data Table is very basic but yet play a very big role in the achievement of Kudler Fine food. The company uses this data to decide when to order more inventory and also to manage inventory. The design of data tables categorizes the financial information into financial codes, items, department and the sums of total amount of transaction. It contains four columns: the GL Code, Inventory Item, Summary Line Item, and Amount. The GL codes consist of six numbers. The first two are store numbers and the last four numbers represent the department the item is......

Words: 769 - Pages: 4

Free Essay

Decision Table

...the check as well as the signature of two accounting clerks. Payments that are not covered by a purchase order that are under $5,000 must be approved by the accounting manager and a departmental manager that will absorb the cost of the payment into that department’s budget. Such checks can be signed by a single accounting clerk. Payments that are not covered by a purchase order that are between $5,000 and $10,000 must be approved by the accounting manager and a departmental manager, and the check must have two signatures. Finally, payments exceeding $10,000 that are not covered by a purchase order must be approved by a department manager, the accounting manager, and the chief financial officer. Such checks require two signatures. Use a decision table to represent the logic in this process. Write down any assumptions you have to make. SOLUTION Conditions/Courses of action | Rules | | 1 | 2 | 3 | 4 | 5 | 6 | Purchase Order | Y | Y | Y | N | N | N | Purchase Amount | S | M | L | S | M | L | | | | | | | | One Accounting Clerk Signature | X | | | X | | | Two Accounting Clerk Signatures | | X | X | | X | X | Accounting Manager’s Approval | | | X | X | X | X | Departmental Manager’s Approval | | | | X | X | X | Chief Financial Officer’s Approval | | | | | | X | Where Y is for Purchase orders that has been approved and N is for Purchase orders yet to be approved. Purchase Amount Rules: S = <$5000; M = $5000 – $10000; L = >$10000 ...

Words: 329 - Pages: 2

Free Essay

Data Flow Diagrams and Bis

...process health-care, dependent-care FSA claims andtrack and view claim and payment date. As- In Process As-In Data Flow Diagram. Overview of “As-is” System This type of benefit program happens in events where family status events changes. For eg.- Divorces. Such type of programs may also run when job related changes are done for eg- payments of dues. Also for events like retirement such systems are followed. Also for hiring and termination the benefits administration follows the above mentioned procedure. This is a cyclical process which happens at the beginning of every assessment year. In the beginning of the business administration system we require open enrollment/event maintenance of all the systems in the workspace. We need to determine the participants who are eligible for the benefits in the benefits administrations system. This is done with respect to the three departments i.e. finance, third party and the payroll department. If the 3 departments find the person missing the minimum threshold then the person is not eligible to the benefits program. We need to create and develop enrollment forms and deliver the forms to the participants of the program. Data has to be entered by the participants showing their elections choices. Validation of the employee election is done by the system. Now the analysis of the processing, enrollment and enrollment data is collected by the finance, payroll and the third party management. These three parties now calculate the......

Words: 703 - Pages: 3

Free Essay

Data Flow Diagram

...ASSIGNMENT IN COMPUTER LECTURE What is a DFD? Data Flow Diagramming is a means of representing a system at any level of detail with a graphic network of symbols showing data flows, data stores, data processes, and data sources/destinations. When it comes to conveying how information data flows through systems (and how that data is transformed in the process), data flow diagrams (DFDs) are the method of choice over technical descriptions for three principal reasons. * DFDs are easier to understand by technical and nontechnical audiences * DFDs can provide a high level system overview, complete with boundaries and connections to other systems * DFDs can provide a detailed representation of system components DFDs help system designers and others during initial analysis stages visualize a current system or one that may be necessary to meet new requirements. Systems analysts prefer working with DFDs, particularly when they require a clear understanding of the boundary between existing systems and postulated systems. DFDs represent the following: * External devices sending and receiving data * Processes that change that data * Data flows themselves * Data storage locations The hierarchical DFD typically consists of a top-level diagram (Level 0) underlain by cascading lower level diagrams (Level 1, Level 2…) that represent different parts of the system. What are the symbols used in DFD? DFDs......

Words: 553 - Pages: 3

Premium Essay

Data Table Analysis

...Data Table Analysis Accounting 542 November 6, 2015 Data Table Analysis Organizations rely heavily on receiving accurate data and information to make strategic business decisions. The concept is a critical aspect for modern commerce, since technological advances allows any business to track, trace, and predict inventory usage up to the moment. Each diagram in an analyses alludes to how accurate an organization’s methodology for operations is. Data tables are a useful tool for organizations to determine a cost-effective method for improving inventory control and for creating methods to improve business processes. Evaluate Data Table Design Elements from an Accounting Perspective Kudler’s Fine Foods’ requires the use of data tables for management to perform an accurate analysis for controlling inventory. Personnel must possess information with little effort to perform daily operations. A data table’s ability to organize information is a large contributor in management’s ability to order adequate inventory. The information available also helps management calculate the Just in Time (JIT) inventory method. Supplemental, the inventory information is crucial to determine when to order more inventory and the amount to order as well. The grocery store’s current inventory data table illustrates critical information such as, item codes, inventory items, locations, and the total value of the inventory (and each......

Words: 673 - Pages: 3

Free Essay

Flow Diagram

...editing to ensure the integrity of data before it is entered into the system’s files and databases. This control will check for presence, format, consistency, and reasonableness of data, as well as allowable values. When invalid data is entered into the system, the application will be rejected and providers are required to change their input data. If the control does not detect any errors, the system will accept the claim which will then be reviewed by an employee of Nyguard. Controls C2, C3, C4, and C5 are access control. Since each claim is reviewed by Nyguard’s employees to validate provider, recipient and reference information, these controls ensure that the system provides two-factor authentication that authenticate responsible employees based on a unique identifier and a confidential password for each employee. The system makes sure that non-authorized employees are not allowed to access any sensitive customers’ information and/or data without first being authorized by the system’s security mechanism. The data on the claims continue to be validated against a series of rules, edits, and audits. All these processes are also conducted by authorized employees. Edits and audits processes ensure that claims are processed in accordance with state policies. All claims in process are checked if the service being billed has any policy restrictions based on other claims in history. Data of a claim in process are compared with paid claims history data to determine the......

Words: 470 - Pages: 2

Premium Essay

Data Table Analysis

...Data Table Analysis Crystal Spencer ACC/542 February 27, 2012 Christy Countryman Kudler Fine Food is the fast growing fine food specialty business that was established in 1998, and at each of their stores the company first initially selected Microsoft Access as their AIS to track employees, customer, inventory, orders, and sales. Kudler’s products have perishable inventory that must be properly tracked. This brief will evaluate database tables from an accounting perspective. In addition, gives recommendations for improvement, pivot table, and entity relationship diagram will help the company have a better decision-making process. Assessment of the design elements of the data tables from an accounting perspective. Data Table analysis is vital to the success of the business, the data given in these tables is available for the end user to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables will arranges the financial data into department, financial codes, items, and sums of total amount of transaction. Data table get the most out of the informational and visual presentation for the financial data. The user of the data can easily to identify the item belongs to certain department and how many items were received at the given cost for a certain period. In addition, the data allows in finding quantity and total amount on hand for an item and calculating average price of the item. ...

Words: 874 - Pages: 4

Free Essay

Data Table Analysis

...Data Table Analysis University of Phoenix Accounting Information Systems ACC/542 Anita Rodriguez April 2, 2012 Data Table Analysis Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process. Evaluate the design elements of the data tables from an accounting perspective The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table......

Words: 903 - Pages: 4

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...CSCI 1507 (1903) "Enterprise level data work flows and Data Warehousing" Professor Rajni Palikhey University of Northern Virginia Acknowledgement This Research Paper would not have been possible without the guidance and the help of my co-students and respected Professor who in one way or the other contributed and extended their valuable assistance in the preparation and completion of this research paper. I would to like to convey my sense of gratitude to Professor.Rajni Palikhey who helped and supported us right throughout the semester. This paper would not have been possible without her cooperation and technical assistance. We would also thank our Institution and our faculty members without whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days......

Words: 6349 - Pages: 26