DCIT

It is a raw material & unorganized fact that need to be processed.

In raw or unorganized form (such as alphabets, numbers, or symbols) that refers to conditions, ideas, or objects.

Is unstructured if its elements cannot be stored in rows and columns, which makes it difficult to query and retrieve by applications

Organized in rows and columns in a rigidly defined format so that applications can retrieve and process it efficiently.

Management as a noun

Management as Process

Management as a discipline

Tis a cycle of processes that support the organization's learning activities.

An organized collection of logically related data.

DBMS stands for?

A set of software programs that controls the organization, storage, management, and retrieval of data in a database.

A database involves specifying the data types, structures, and constraints of the data to be stored in the database

The database is the process of storing the data on some storage medium that is controlled by the DBMS

A database includes functions such as querying the database to retrieve specific data.

a database allows multiple users and programs to access the data simultaneously.

The conversion from a manual file system to a matching computer file system tended to be technically complex and a new kind of professiona

The first computer application focused on clerical tasks: order/entry processing, payroll, work schedule, and so on.

A graphical system used to capture the nature and relationships among data

Is a collection of application programs that perform tasks where each program defines and manages its own data.

Limitations of File-Based Systems?

Advantages/Characteristics of Database Approach

a graphical model that shows the high-level entities for the organization and the relationships among those entities.

more detailed view, matching data structure in database or data warehouse

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Between entities; usually one-to-many (1:M) or many-to-many (M:M)

A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables

Disadvantages of a DBMS

Is responsible for the management of the data resource.

Is responsible for the physical realization of the database.

Is concerned with identifying the data (that is, the entities and attributes), the relationships between the data, and the constraints on the data that is to be stored in the database.

Decides how the logical database design Is to be physically realized.

Once the database has been implemented, the application programs that provide the required functionality for the end-users must be implemented. This is the responsibility of the application developers.

- the end-users are the “clients” of the database, which has been designed and implemented and is being maintained to serve their information needs.

Are familiar with the structure of the DB and the facilities offered by the DBMS

Are typically unaware of the DBMS.