Build an entity relationship model for the above scenario

Assignment Help Database Management System
Reference no: EM13325217

Question 1:

Which is not a factor to consider in software evaluation?
A. Performance effectiveness
B. Performance efficiency
C. Target Operating System
D. Ease of use
E. Quality of documentation

In a database, Keys are:
A. Normalized
B. The names of database tables
C. Used to identify the most important attribute of an Entity
D. Data items in a record used to identify the record

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)

All of the following are true about Modular Programming except:
A. Modules should contain Go-To statements
B. Paying attention to the interfaces is important
C. Modules should be highly cohesive
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. Each organization also belongs to a command which has a location and a unique numerical designation. The Organization's 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 indicate all of your key attributes in red.

Question 3:

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

635_er diagram.png

Some recommended major processes are:

(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.

344_er diagram1.png

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

Three times

The Set Up Claimant Record and Calculate Claim Amount and Provide Claim Summary Modules once and the Update Account Module many times until the Last Claim Flag is returned C. As many times as it takes to process all the claims (Until Last Claim Flag is Returned)

Which module actually contains the logic to call the Update Account Module?

Set Up Claimant Record

Calculate Claim Amount and Provide Claim Summary

Process Medical Claims

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

Update Account, Set Up Claimant Record, Calculate Claim Amount and Provide Claim Summary

Set Up Claimant Record, Update Account, Calculate Claim Amount and Provide Claim Summary

Set Up Claimant Record, Calculate Claim Amount and Provide Claim Summary, Update Account

Calculate Claim Amount and Provide Claim Summary, Update Account, Set Up Claimant Record

What tool would not be useful in preparing a Module Specification for a programmer to code the Update Account Module
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: EM13325217

Questions Cloud

Calculate the horizontal component of the acceleration : A simple and common technique for accelerating electrons is shown in the figure, where there is a uniform electric field between two plates. Calculate the horizontal component of the acceleration
Explain force across the inner mitochondrial membrane : Calculate the proton motive force across the inner mitochondrial membrane a 25 degrees C when theelectrical difference is -0.18 V (inside negative), pH outside us 6.7, and pH inside is 7.5.
What is the total time the hare is moving : A tortoise and hare start from rest and have a race. As the race begins, both accelerate forward. What is the total time the hare is moving
Which is not a factor to consider in software evaluation : Which is not a factor to consider in software evaluation?
Build an entity relationship model for the above scenario : Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.
Find the location of the place along the axis : A positive point charge Q1 = 2.8×10?5C is fixed at the origin of coordinates, and a negative charge Q2 = ?5.5×10?6C is fixed to the xaxis at x=+1.5m. Find the location of the place(s) along the x axis
Explain what is the pka of the weak acid : A 0.24ml sample of a weak acid with an unknown pKa was combined with 12.0ml of a 3.20M KOH and the resulting was diluted to 1.500L. The measured pH of the solution was 3.75. What is the pKa of the weak acid
Depict major organic products for the sn1 reaction : Select the correct IUPAC name for the following organic substrate, including the R or S designation where appropriate, and draw the major organic product(s) for the SN1 reaction.
What is the speed of the plane in still air : An inexperience novice pilot was taking his brand new Cessna Skyhawk-172R plane for a trip from Tallahassee to Atlanta, which is 375 km due north. What is the speed of the plane in still air

Reviews

Write a Review

Database Management System Questions & Answers

  Explain how big is a single interval in volts

How big is a single interval in volts. Receivers have no choice but to decode the the binary sample value at the center of the interval. So, what would the received voltage of the sample be

  Explain data for each candidate of eight constituencies

supplies % of votes each candidate is likely to receive, based on popularity rating. Actual number of votes received is that percentage of General votes. You should enter data for each candidate in each of the eight constituencies.

  Create a decision table that describes movement of inventory

Name four attributes that you can use to define a data flow in the grocery inventory information system.

  Represent data for sales of individual stores

Explain how you will visually represent the data for the sales of the individual stores and for the time period shown. You want to show the change in sales for each store over time for the past three years.

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Access values through queries to databases

However, the only way you can access values is through queries to the databases. In single query, you can specify value k to one of two databases.

  How referential integrity constraint prevent data

In physical database design, referential integrity constraints can be defined. What actions does referential integrity constraint prevent from happening when data is inserted in table which contains this constraint?

  Find that the data structure holds redundant data

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks..

  Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  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.

  Analyse a set of data and write a memo

To analyse a set of data, and write a memo, identifying and explaining your insights into the operation of Todd Restaurants.

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