M1 Part 2

Question 1

Analyze requirements. Develop preliminary data model.

Answer 1

Conceptual data modeling

Question 2

Analyze requirements in detail. Integrate database views into conceptual data model.

Answer 2

Logical database design

Question 3

Define new database contents to DBMS. Decide on physical organization for new data. Design database processing programs.

Answer 3

Physical database design and definition

Question 4

Code database processing. Install new database contents, usually from existing data sources.

Answer 4

Database implementataion

Question 5

Analyze database to ensure it meets application needs. Fix errors in database.

Answer 5

Database maintenance

Question 6

Tune database for improved performance. Fix errors in database.

Answer 6

Database maintenance

Question 7

• User Views
• Subsets of Conceptual Schema
• Can be determined from business-function/data entity matrices
• DBA determines schema for different users

Answer 7

External Schema

Question 8

E-R Models

Answer 8

Conceptual Schema

Question 9

• Logical structures

* Physical structures

Answer 9

Internal Schema

Question 10

a planned undertaking of related activities to reach an objective that has a beginning and an end

Answer 10

Project–

Question 11

• Initiated and planned in planning stage of SDLC
• Executed during analysis, design, and implementation
• Closed at the end of implementation

Answer 11

Managing Projects