Dcit 24 Information Management

Front 1

are individual facts, statistics, or items of information, often numeric, that are collected through. observation.

Back 1

Data

Front 2

in a general sense, is processed, organized and structured data.

Back 2

Information

Front 3

is information that is set up for easy access, management and updating

Back 3

Database

Front 4

is software that permits the organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.

Back 4

DBMS

Front 5

A type of database that contains a single database located at one location in the network.

Back 5

Centralized database

Front 6

A type of database that contains two or more database files located at different locations in the network.

Back 6

Distributed database

Front 7

data is organized in form of tables. A table contains rows and columns of data. Table has a unique key to identify each row of the table.

Back 7

Relational database

Front 8

data is not organized in form of tables. Data is stored in form of key and value pairs.

Back 8

Non-Relational database

Front 9

models information and data into a set of tables with rows and columns

Back 9

RDD

Front 10

way to visually present the architecture and design of complex software systems complex software systems.

Back 10

UML

Front 11

shows the relationships of entity sets stored in a database. An entity in this context is an object, a component of data.

Back 11

ERD

Front 12

basic database concepts

Back 12

E

A

R

Front 13

is an object or component of data. are represented by rectangles that are named

Back 13

Entity

Front 14

describes the property of an entity. is represented as oval or ellipses.

Back 14

Attributes

Front 15

Kinds of attributes

Back 15

1. Composite - are further divided in a tree like structure. 2. Multivalued - are depicted by double ellipse. (Phone number)3. Derived - are depicted by dashed ellipse. (Age, changing)

Front 16

is represented by a diamond-shaped box.

Back 16

Relationship

One to one

One to many

Many to one

Many to many

Front 17

Processing of data consisted of reading data from one or more tapes and writing data to a new tape

Back 17

Magnetic tapee

Front 18

worked for International Business machines; invented the relational model for database management

Back 18

Edgar F. Codd

Front 19

language was designed primarily for decision support applications, which are query-intensive, yet the mainstay of databases in the 1980s was transaction-processing applications, which are update-intensive.

Back 19

SQL

Structured query Language

Front 20

is the process of collecting, sorting, organizing maintaining and analyzing data.

Back 20

Database management

Front 21

Types of database

Back 21

Centralized and distributed

Front 22

Types of DBMS

Back 22

Relational and non relational

Front 23

design of the database. Or we can say that it is a skeleton of the database that is used to represent the structure

Back 23

Database schema

Front 24

In a database, sometimes we put some restrictions on the table that what type of data can be stored

Back 24

Data constraints

Front 25

data about the data. dictionary is known as.

Back 25

Data dictionary or metadata

Front 26

used to define the complete database environment and its components. a set of memory structures and background processes that are used to access the database files.

Back 26

Database instance

Front 27

used to access data from the database/ retrieve or manipulate data from the database.

Back 27

Query

Front 28

three main operations that is Insertion, Deletion, and updation.

Back 28

Data manipulation

Front 29

It is an underlying component that is used to create and manage various database queries.

Back 29

Data engine

Front 30

Ur reminder to stretch and drink water! Stay hydrated bestiieee!!

Back 30

You got thisss!! Never back down, never WHAT?!? NEVER GIVE UP!!