Week 9 UAS

Question 1

Stages of the Database System Development Lifecycle?

Answer 1

1. Database planning
2. System definition
3. Requirements collection and analysis
4. Database design
5. DBMS selection
6. Application design
7. Prototyping (optional)
8. Implementation
9. Data conversion and loading
10. Testing
11. Operational maintenance

Question 2

Criteria to produce an Optimal Data Model?

Answer 2

1. Structural validity
2. Simplicity
3. Expressibility
4. Nonredundancy
5. Shareability
6. Extensibility
7. Integrity
8. Diagrammatic representation

Question 3

Three phases of database design

Answer 3

1. conceptual database design, process of constructing a model of the data used in an enterprise, independent of all physical considerations.
2. logical database design, process of constructing a model of the data used in an enterprise based on a specific data model, but independent of a particular DBMS and other physical considerations.
3. physical database design, process of producing a description of the database implementation on secondary storage

Question 4

Database planning?

Answer 4

management activities that allow stages of database system development lifecycle to be realized as efficiently and effectively as possible

Question 5

System definition?

Answer 5

describes scope and boundaries of database system and the major user views.

Question 6

Requirements collection and analysis?

Answer 6

Process of collecting and analyzing information about the part of organization to be supported by the database system, and using this information to identify users’ requirements of new system.

3 main approaches:

1. centralized approach
2. view integration approach
3. combination of both approaches

Question 7

Database design?

Answer 7

Process of creating a design for a database that will support the enterprise’s mission statement and mission objectives for the required database system.

Main approaches include:

1. Top-down
2. Bottom-up
3. Inside-out
4. Mixed

Question 8

DBMS selection?

Answer 8

Selection of an appropriate DBMS to support the database system.

Question 9

Application design?

Answer 9

Design of user interface and application programs that use and process the database.

two important activities:

1. transaction design
2. user interface design

Question 10

Prototyping?

Answer 10

Building working model of a database system.

Question 11

Implementation?

Answer 11

The physical realization of the database and application designs.

Question 12

Data conversion and loading?

Answer 12

Transferring any existing data into new database and converting any existing applications to run on new database.

Question 13

Testing

Answer 13

The process of running the database system with intent of finding errors.

Question 14

Operational maintenance?

Answer 14

The process of monitoring and maintaining database system following installation.

Question 15

CASE tools benefits?

Answer 15

1. Standards;
2. Integration;
3. Support for standard methods;
4. Consistency;
5. Automation .

Question 16

The Difference between Data Administrator and Database Admisnistrator?

Answer 16

The Data Administrator (DA) and Database Administrator (DBA) are responsible for managing and controlling the corporate data and corporate database, respectively.

DA is more concerned with early stages of database system development lifecycle and DBA is more concerned with later stages.

Question 17

Tugas Data Administrator?

Answer 17

Management of data resource including:

• database planning,
• development and maintenance of standards, policies and procedures, and conceptual and logical database design.

Question 18

Tugas Database Administrator?

Answer 18

Management of physical realization of a database system including:

• physical database design and implementation,
• setting security and integrity controls,
• monitoring system performance, and reorganizing the database.

Question 19

several fact-finding techniques?

Answer 19

1. examining documentation
2. interviewing
3. observing the organization in operation
4. research
5. questionnaires

Question 20

Why using fact-finding techniques?

Answer 20

It is critical to capture the necessary facts to build the required database application.
Enables developer to learn about the terminology, problems, opportunities, constraints, requirements, and priorities of the organization and the users of the system.