Explain data flow diagram

Assignment Help Database Management System
Reference no: EM13924218

Question 1:

Multiple Choice - Eliminate all but the correct answer.

Which is not a factor to consider in software evaluation?

A. Performance effectiveness

B. Performance efficiency

C. Ease of use

D. Quality of documentation

E. Target Operating System

In a database, Keys are:

A. Data items in a record used to identify the record

B. Normalized

C. The names of database tables

D. Used to identify the most important attribute of an Entity

In a relational database, Metadata:

A. Specifies the size in Bytes of the database tables

B. Describes the name given and the length assigned each data item

C. Describes the associative relationships between Entities

D. Provides the answers to queries

Peer reviewers are the key participants in which activity?

A. Structured walkthroughs

B. Top-down testing

C. Six-Sigma quality checks

D. Rapid Application Design (RAD)

5. All of the following are true about Modular Programming except:

A. Paying attention to the interfaces is important

B. Modules should be highly cohesive

C. Modules should contain Go-To statements

D. It facilitates breaking the programming into logical, manageable portions

Question 2:

A military information system on a base overseas tracks personnel on the base. Each military member is tracked by
ID#, name, rank, and address. Each military member belongs to an organization on the base which has an organizational name, located in a building on the base and has a primary function (e.g. Communications Squadron).

Each of these organizations is also commanded by one of the military members .

In tracking command sponsorship each military member may have one or more dependents. Each dependent has an ID#, name, age, and sex.

Each organization on the base is involved working issues or projects which may be of interest to the base commander. These projects are tracked by a serial number and an origination date.

The information system you are designing will also track descriptions of the projects and their close-out dates.

Build an entity relationship model for the above scenario.

Show all attributes and ndicate all of your key attributes in red.

Question 3:

Draw a logical data flow diagram (DFD: Context and Level 1) for placing an order based on the E-R diagram shown here.

System Requirements include the ability to do the following:

(1) Enter new order

(2) Read customer master

(3) Read item record

(4) Create item order record

(5) Add order record

Question 4:

Select the best answer for each of the multiple choice questions below about the Structure Chart shown here.

How many times does the top module call each subordinate module?

One Hundred Times

Three Times

The Check Credit Rating and Update Credit File Modules Once and the Dispatch Orders Module 100 Times

Which module actually contains the logic to call the Update Credit File Module?

Check Credit Rating

Process Orders

Dispatch Orders

In what order does the executive module call the subordinate modules?

Dispatch Orders, Update Credit File, Check Credit Rating

Check Credit Rating, Update Credit File, Dispatch Orders

Update Credit File, Check Credit Rating, Dispatch Orders

Process Orders, Check Credit Rating, Dispatch Orders

What tool would not be useful in preparing a Module Specification for a programmer to code "Get Exam From Assignments Folder"?

Structured English

Flow Chart

Data Flow Diagram

Pseudocode

Question 5:

In this class, we've stressed the importance of various system analysis and design tools and techniques.

By now you should have a "toolbox" full of useful design and analysis tools.

List the tools in your toolbox and then write one short paragraph on how you can/will apply them in your careers, lives, etc.

Reference no: EM13924218

Questions Cloud

What is the expected rate of return for cara assuming : Given Cara's beta of 1.75 and a risk-free rate of 7 percent, what is the expected rate of return for Cara assuming: a 15 percent market return? a 10 percent market return?
Determining the return on total assets : Question 1: Branch Corp.'s total assets at the end of last year were $315,000 and its net income after taxes was $22,750. What was its return on total assets?
Prepare a budgeted income statement : Prepare a budgeted income statement for May. Use the absorption costing income statement format as shown:
What is the difference between noise and sound : What is the difference between noise and sound? Describe the three main types of noise-control strategies, and give at least two examples of each type
Explain data flow diagram : Which module actually contains the logic to call the Update Credit File Module?
Prepare journal entries to record three security purchase : (a) Prepare the journal entries to record the above three security purchases. (b) Prepare the journal entry for the security sale on May 20. (c) Compute the unrealized gains or losses and prepare the adjusting entry for Arantxa on December 31, 2008.
What is the difference between a dump and sanitary landfill : What is the difference between a dump and a sanitary landfill? Describe how landfill gas and leachate can be successfully managed
Acute community-acquired pneumonia : Harry Smith, 70 years of age, is a male patient who is admitted to the medical-surgical unit with acute community-acquired pneumonia. He was diagnosed with paraseptal emphysema 3 years ago.
Discuss the basic elements of a professional code of ethics : Discuss the basic elements of a professional code of ethics. Compare these elements to the code of ethics for your employer or current profession

Reviews

Write a Review

Database Management System Questions & Answers

  Implement the pays auditing model

You have decided to push the envelope and implement the pays auditing model. Provide a step-by-step summary for imple¬menting this model.

  Machining activity cost pool

Determine the total amount of supervisory wages and factory utilities costs that would be allocated to the Machining activity cost pool.

  Produce an entity-relationship diagram

Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Find an example of an actual data warehouse

Find an example of an actual data warehouse. For this example, describe the content, purpose, user access methods, and sources of data

  Database management system create a database design

database management system create a database design specification enhanced entity relationship diagram eerd and

  Modifying a database design in visio

1. Use Microsoft Visio (or open source equivalent) in which you: a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

  Create a database with at least eight records

Create a database with at least eight records added to keep track of your favorite television shows. Each record should have at least five fields of your choice. Submit the following screen captures of your database design and functioning in a w..

  How to prepare queries to retrieve the information

How to prepare queries to retrieve the information you need from a database

  How data collection and data analysis can be overlapping

Summarize the process of coding, classifying, categorizing, and labeling primary patterns as it pertains to qualitative data analysis. Describe how data collection and data analysis can be overlapping activities in qualitative research.

  Highest average mark

Write a program to calculate and store the average obtained by 20 pupils in 7 subjects. Output the pupil that made the highest average mark in addition to those pupils making 50 marks and over.

  Design a high-level conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following: Integration layers and The data warehouse

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