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

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

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