INFORMATION MANAGEMENT LESSON 3

The processing is distributed about the network, typically a LAN. It holds the files required by the applications and the DBMS.

• Teleprocessing

• File server architecture

• DBMS architecture

Refers to the way in which software components interact to form a system.

• Teleprocessing

• File server architecture

• Client server architecture

A program that controls data transfer between clients and servers in order to provide a consistent environment, particularly for OLTP.

• Teleprocessing

• Transaction processing monitors

• File server architecture

It is usually the result of systematic analysis to define and describe what is important to processes in an area of a business.

• Entity Relationship Model

• ER Diagram

• Relationship

It helps to explain the logical structure of database.

• ER Diagram

• ER Model

• Relationship Model

What are the 3 basic concepts of ERD.

• Entities

• Attributes

• Relationship

• Entity

• Entity instance

An object or concept that is

identified by the enterprise as

having independent existence. It is

represented with rectangle.

• Entity

• Relationship

• ERD

Collection of entities of a particular

type

• Each instance becomes a record or a

row in a table.

• Entity instance

• Entities

• Entity

A property or the characteristics of

an entity. It is presented as circle

• Indicate that each of an entity

may have a relationship with

instances of the connected entity

and vice versa

• Attribute

• Attribute types

• Simple attribute

An attribute whose value can be inferred

from the value of the other attributes is called

• Simple attribute

• Stored attribute

• Derived attribute