User Account

All Pages

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

  In your opinion what are the three biggest challenges in

in your opinion what are the three biggest challenges in planning and designing a solution for a programming

  What tables and columns would you create in relational data

You need to store information on the business's employees, inventory, and completed sales. You also need to account for the fact that each salesperson receives a different percentage of their sales in commission. What tables and columns would you ..

  Discuss common input - output technologies

Create a Microsoft Word table that identifies the advantages, disadvantages, computer requirements, initial costs, and future savings for an organization considering an engagement in virtualization.

  Design a database schema

Design a Database schema

  Design a database for an insurance company

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game.

  Question 1 consider that you have been presented with the

question 1 consider that you have been presented with the subsequent relation for the baxter aviation database charters

  How to select the primary key from the candidate keys

A motor vehicle maintenance center wants to improve its services by using database management systems and data mining what tables are needed in such a database and how can it help improve their services

  List all the foreign key constraints among these relations

Give an example of a (plausible) constraint involving one or more of these relations that is not a primary key or foreign key constraint.

  Explain the content and user access methods

Find an example of an actual data warehouse. For this example, explain the content, user access methods, purpose, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) -

  Every professor must teach some course

Now suppose that certain courses can be taught by a team of professors jointly, but it is possible that no one professor in a team can teach the course. Model this situation, introducing additional entity sets and relationship sets if necessary.

  Design a database - what is the purpose of your database

Design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be organized.

  Determine the names of all tracks from table

All primary keys are underlined. All foreign keys have same name as primary key that they are referencing. Determine the names of all Tracks which are more than 10 minutes (600,000 ms) long.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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