INSY3402: Database Management

The University of Texas at Arlington

Professor Kirs

 

Database Design: Sample Problems and Exercises

 

1.      Simon listed three major activities which were involved in making any decision. What were they?

 

         SEE ANSWER

 

2.      Simon’s model neglected two additional activities, after a decision was made. What were they?

 

         SEE ANSWER

 

3.      Relate Simon’s Model (plus extensions) to the System’s Approach and the Text’s Terminology.

 

         SEE ANSWER

 

4.      What are the basic activities associated with ‘Investigation’?

 

         SEE ANSWER

 

5.      What are the basic activities associated with ‘Analysis’?

 

         SEE ANSWER

 

6.      What Activities are associated with ‘Design/System Specification’?

 

         SEE ANSWER

 

7.      What Activities are associated with ‘Implementation’?

 

         SEE ANSWER

 

8.      What Activities are associated with ‘Maintenance’?

 

         SEE ANSWER

 

9.      We went over five (5) basic stages involved in the Database Development Life Cycle. What were they? List AT LEAST one Activity involved in each of the stages.

 

         SEE ANSWER

 

10.    We went over five (5) basic stages involved in Prototyping. What were they? List AT LEAST one Activity involved in each of the stages.

 

         SEE ANSWER

 

11.    List three (3) Advantages and three (3) disadvantages of prototyping (vs. the SDLC). DO NOT simply make the disadvantages the opposites of the advantages.

 

         SEE ANSWER

 

12.    Explain (IN DETAIL), when and why prototyping might be preferred over the traditional SDLC approach.

 

         SEE ANSWER