Draw a data flow diagram

Assignment Help Database Management System
Reference no: EM13781325

Problem/Situation

Kellogg State Bank provides car and home loans to its banking customers. Initially, a potential loan customer meets with a Kellogg loan officer, requests a loan for a certain amount and time frame, and completes a loan application.

Next, the loan officer determines the customer's credit standing, the type of loan required, and available interest rates. While the loan officer can authorize car loans for credit worthy customers, a loan committee must approve all home loans.

Directions:

You have been provided three diagrams - a Context Diagram (DFD), Level-0 Diagram, and the A-0 Diagram (IDEF). For this problem, you will be asked to re-draw or construct the following diagrams:

1) A Data Flow Diagram (DFD) - three levels

a) aContext-Level Diagram - provided for the exam - recreate the diagram for your exam

b) aLevel-0 Data Flow Diagram -- provided for the exam - recreate the diagram for your assignment

c) Decompose PRC 1, PRC 2, & PRC 3 into athreeLevel-1 Data Flow Diagrams

Total Points for DFDs = 60 points

2) An IDEF0 Diagram - two levels

a) A-0 Diagram - provided for the exam - recreate it for your assignment

b) A0 decomposition diagram

Total Points for IDEF = 20 points

3) Create a Kite-Level Use Case Diagram - Total Points for Use Case = 20 points

The DFD and IDEF diagrams must be drawn in BPWin in AllFusion Suite. The Use Case Diagram must be drawn in Visio 2013.

Reference no: EM13781325

Questions Cloud

What is the electric field due to the right ring : Two rings of radius 5 cm are 20 cm apart and concentric with a common horizontal x-axis. The ring on the left carries a uniformly distributed charge of +35 nC, and the ring on the right carries a uniformly distributed charge of -35 nC. What is the e..
What does a magnet attract : What does a magnet attract? Select one: a. Anything made of metal b. Aluminum foil c. Iron, steel, nickel and other magnets d. Some types of plasticsThe part of a magnet where the magnetic field and forces are strongest is called a magnetic _____. Se..
What is the variance for the data values : What is the variance for the data values - What is the median of data sample - The Empirical Rule can't be applied unless the frequency distribution is mound-shaped and symmetric. Chebyshev's Rule can?be applied to any data set, regardless of the s..
About project specification : E-R diagram: adherence to our standard, assumptions made, inclusion of correct primary
Draw a data flow diagram : You have been provided three diagrams - a Context Diagram (DFD), Level-0 Diagram, and the A-0 Diagram (IDEF). For this problem, you will be asked to re-draw or construct the following diagrams:
Principles of each religion belief systems : The US culture has a broad spectrum of religious affiliations and religiosity. As a result of interacting with people who share similarities, people seldom evaluate the main premises of other religions. This assignment will give you the opportunit..
Explain effective use of proposal argumentation strategies : Explain Effective use of proposal argumentation strategies, Evidence of final editing and proofreading and Evidence of revision from early drafts to final draft.
Create an application that manipulates a billboard sign : Create an application that manipulates a billboard sign. The program must include a Billboard class (separate from the main program class) that is capable of storing the text to display.
Short notes on develop an internet strategy : What Internet business model would be appropriate for the company to follow in creating a Web site and why?

Reviews

Write a Review

Database Management System Questions & Answers

  Identified in the system analysis report

An E-R diagram of your database that clearly shows the primary and foreign keys - Database has minimum number of records in each table as specified in assignment instructions.

  Criteria selecting a life-cycle model for the project

What criteria would you use in selecting a life-cycle model for the project?

  Creation of a data classification scheme

Creation of a data classification scheme. A discussion about the sensitivity and mapping of the data into the data classification scheme

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Identify the degree and cardinalities of the relationship

A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model.

  Describe the benefits of using microsoft access

Explain the usefulness of converting data currently held in Microsoft Excel spreadsheets into a relational database using Microsoft Access. Describe the benefits of using Microsoft Access in the work environment

  Google weka and find the homepage for wekawhen you install

google weka and find the homepage for weka.when you install it you may need to change your classpath to reference the

  Create an erd and relatioal schema

Create an ERD and relatioal schema in third normal form based upon the following business rules. (Hint: ensure that all attributes are FULLY DETERMINED by the primary key.) Don't forget to place your normalization arrows on your relational schema.

  Normalized erd-memo or and database file

Normalized ERD, Memo, and Database File

  Variation of activity-based costing

Product cost of product U86Y under the company's traditional costing system is closest to - product cost of product M91F under the activity-based costing system

  Examine use of database applications in organization

Prepare a memorandum examining use of databases in organization. Write database applications are used: Microsoft Access, DB2, Oracle, etc.

  Create naming conventions for each entity and attributes

Create naming conventions for each entity and attributes. Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form da..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd