Build an entity relationship model

Assignment Help Database Management System
Reference no: EM13924093

Question 1:

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

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

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

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

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

A.One Hundred Times
B.Three Times
C.The Check Credit Rating and Update Credit File Modules Once and the Dispatch Orders Module 100 Times

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

A.Check Credit Rating
B.Process Orders
C.Dispatch Orders

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

A.Dispatch Orders, Update Credit File, Check Credit Rating
B.Check Credit Rating, Update Credit File, Dispatch Orders
C.Update Credit File, Check Credit Rating, Dispatch Orders
D.Process Orders, Check Credit Rating, Dispatch Orders

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

A.Structured English
B.Flow Chart
C.Data Flow Diagram
D.Pseudocode

Reference no: EM13924093

Questions Cloud

Inverse-converse and contrapositive : Give the inverse, converse and contrapositive for the following statement: If the patient takes the medication, then he will have some side effects.
Maintenance department will be able to reduce : If Product C is discontinued, the maintenance department will be able to reduce monthly expenses from $3,720 to $2,600.Elimination of Product C will make it possible to cut two persons from the administrative staff; their combined salaries total $3,6..
Implement a basic parser : Implement a basic parser for our dj2dism compiler. You will use bison to generate the parser - Precedence and Associativity of Operators
Explain center for writing excellence : I will definitely be using the Center for Writing Excellence (CWE).
Build an entity relationship model : Build an entity relationship model for the above scenario. Show all attributes and ndicate all of your key attributes in red.
Preparing for a company-wide migration to windows 8 : Crescent Manufacturing Inc. (CMI) is a luxury leader in crafted and customized home furnishings. The corporate headquarters and a production facility are located in Texas, with additional manufacturing facilities located in Nebraska and Maryland.
Provide teenagers with unrestricted freedom : To provide teenagers with unrestricted freedom, they may easily go astray and fall prey to undesirable situation such as underage drug abuse, pregnancy or driving under peer pressure.
Determine cash flow statement : If a parent company has two wholly owned subsidiaries, how many legal and economic entities are there from the viewpoint of the shareholders of the parent company?
Ever-widening array of coworkers : Workplace trends within and outside health care require employees to connect with an ever-widening array of coworkers, consultants, off-site employees, and other resources. Sharing knowledge is critical to any organization's success, especially in..

Reviews

Write a Review

Database Management System Questions & Answers

  Advantages and disadvantages of working with multiple tables

Write down the advantages and disadvantages of working with multiple tables? Write an example of situation where multiple tables would be suitable in the application.

  Explain the advantages of fifo and lifo inventory methods

Explain the advantages and disadvantages of FIFO and LIFO inventory methods

  Describe the components of a dbms

Describe a primary key, candidate key, secondary key, foreign key, and a combination key. Use your imagination to provide an example of each key that is not in the textbook.

  Physical schema created for a database

At this point in the design process, you would have a detailed physical schema created for a database. How would you approach converting your schema into a database, complete with sample data? Explain your approach in two to three paragraphs.

  Show the functional dependencies

Draw a dependency diagram to show the functional dependencies in the relation and Decompose GRADE REPORT into a set of 3NF relations

  Create a project that displays information from the products

Create a project that displays information from the Products table in the Northwind database. Fill a drop-down list with the product names. When the user selects a product, display these fields: ProductiD, UnitPrice, and UnitsInStock.

  Location information for dui checkpoints

let's consider location information for DUI checkpoints. If law enforcement agencies publish this information, is it okay to have law an app for drivers

  Discuss iterative design as it relates to databases overall

Discuss iterative design as it relates to databases overall. Determine whether one must design a database iteratively or design the entire database all at once. Provide a rationale for your answer

  Write names-e-mail addresses for customers by foreign key

Illustrate all data in each of the four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  1 construct a scenario leading to the worst-case

1. construct a scenario leading to the worst-case performance of the fifo buffer replacement policy.2. is it possible

  Construct a relational schema for the er-diagram

Construct a relational schema for the ER-diagram. Make sure that you correctly translate Specialization and Many-to-Many relationships. Please follow carefully the following guidelines when you ?nish this question.

  Write a program that keeps an employee database

Write a program that keeps an employee database in a random-access file. Implement functions for adding and removing employees. You need not keep employees in sorted order.

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