Exam 2 Review

Match the following pre-implementation steps.

• Identifying user requirements

• Planning

• Identifying necessary resources

• Design

• Translating requirements to specifics

• Analysis

Match the following build & go-live and beyond steps

• Keeping the system operational

• Maintenance

• Creating the system

• Implementation

• Providing the system to users

• Testing

• Validating the system

• Development

Organize these options into the right categories from the pre-implementation stages

Groups:

(a) Planning

,

(b) Analysis

,

(c) Design

• Project plan

• Feasibility study

• Requirements

• Roles

• Conceptual Design

• System model

• Technical specifications

• Responsibilities

Reorder the steps from the pre-implementation stage

• Analysis

• Planning

• Design

Reorder the following from the build & go-live and beyond stage of the management framework.

• Development

• Maintenance

• Implementation

• Testing

Match the following types of JOIN Operations.

• Inner Join

• 
• Left Outer Join

• 
• Full Outer Join

• 
• Right Outer Join

• 

What is the first step of ERD?

• Concept: Identifies the entities, or tables, the database will need to capture.

• Logical: Adding field names for each table. All fields in a table must describe the appropriate records.

• Physical: the design blueprint of a relational database.

What does the SQL Language: Truncate command?

• Delete an existing table and all records it contains

• Deletes all the records contained in an existing table but does not delete the table

• Insert

• Removes one or more records from a table

What is data definition language (DDL)

• changes the structure of a database by adding or changing tables and relationships

• Modifies the data within a database

• interacts with DML commands when transactions are processed in the database

What is transaction control language? (TCL)

• changes the structure of a database by adding or changing tables and relationships

• modifies the data within a database

• grants access to or removes access from a database user

• interacts with DML commands when transactions are processed in the database