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

  Discuss the serious data redundancy problems

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure and looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

  Different ways of implementing one-to-one relationships

Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices and faculty.

  Use of databases and data communication technologies

Discuss with your team how the bookstores use the Internet and if they use collaboration technology. The use of databases and data communication technologies

  Construct a diagram using rationale to map the arguments

Construct a diagram using Rationale to map the arguments about a moral claim that you have identified in the article/case study: Include all supporting and objecting claims.

  Create database db2game

LOAD FROM "C:\db2game\tutors.csv" of del insert into tutors (student_id, given_name, family_name, course_code, hourly_wage, status);

  Question 1 for each of the following tasks youll use the

question 1 for each of the following tasks youll use the xxxxxxxx database. you need only provide the query or command

  Who knows how to make an erd for database

Who knows how to make an ERD for database

  Evaluate a dbms in terms of lock granularity

Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.

  Oracle has many features for managing and tracking users we

oracle has many features for managing and tracking users. we have discussed user accounts with username password

  Systems analysis and database designyou should back up your

systems analysis and database designyou should back up your answers with theoryreferences from reliable sources - more

  Write query to perform inner join of grade and student

Write a query that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax (JOIN ON).

  Create a database schema that supports the companys business

Create a database schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure.

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