Unit 4.1

Question 1

What is information System?

Answer 1

Resources that enable collection…dissemination of info throughout an organization.

Question 2

SDLC?

Answer 2

structured project management model that outlines the phases required to build an IS.

Question 3

Phases of SDLC

Answer 3

planning, system analysis, system design ,development/ implement, integration and testing, operation and maintenance.

Question 4

Database DLC

Answer 4

Plan, study, design, implement and load, test and eval, operate and maintain.

Question 5

Specification?

Answer 5

Formal representation of what a system should do,in terms independent of how it may be realized.

Question 6

Database initial study

Answer 6

collect requirements, define problems and objectives, define scope and boundaries

Question 7

Methods used in database initial study:

Answer 7

Interviewing end users individually and in a group

Questionnaire survey

Direct observation

Examining different documents like forms, reports, receipts, invoices

Question 8

How do you analyze a company’s situation

Answer 8

Database designer examines its operational components, organizational structure, mission, and their interactions.

Question 9

What are the requirements in the analyzing stage ?

Answer 9

Functional: desired functionality of the database, including
data entry, storage, retrieval, and reporting.

Non- functional: specify any constraints or performance expectations, such as security, scalability, and response time

Question 10

What is a problem? Problem definition? Problem statement?

Answer 10

difference between actual and desired situation.

Definition is when there is a summarized problem statement followed by a series of issues.

Statement outlines the negative points and why it matters.

Question 11

In which stage should initial objective be addressed along with system interface sharing data with other existing or future systems be addressed?

Answer 11

Defining objectives: help solve at least the major problems

Question 12

Scope/boundary definition means

Answer 12

extent of the design and its requirements or the conceptual line that divides the system under study from ‘everything else’.

Question 13

Database Designing phases

Answer 13

Conceptual: constructing a model of the data used in an enterprise,
independent of all Technical /physical considerations.

Logical: constructing a model of the data used in an enterprise based on a specific data model (e.g. relational), but independent of a particular DBMS and other physical considerations.

Physical: producing a description of the implementation of the database on secondary storage; it describes the base relations, file organizations, and indexes
design used to achieve efficient access to the data, and any associated integrity constraints and security measures

Question 14

Implementing database:

Answer 14

Select and Install the DBMS
Create the Database(s)
Load or Convert the Data

Question 15

Testing a database:

Answer 15

Does it preform as expected.
Integrity, physical and password security, access rights, data encryption, backup and recovery plans are tested.