Advanced Data Modeling

The Extended Entity-Relationship Model is a more complex high-level model that extends an E-R diagram to include more types of abstraction, and more clearly express constraints. All of the concepts contained within an E-R diagram are included in the EE-R model, along with additional concepts that cove more semantic information. These additional concepts include generalization/specialization, […]

read more

NORMALIZATION OF DATABASE TABLES

Creating a good database requires a good database design plus a good database structure. If the database contains a good table structures then the database will work well. A good database should avoid data redundancy or data anomalies which can be prevented through a well-defined table structures. The process is called normalization. Table is the […]

read more

Data Models and Database Environment

Databases and database systems are an essential component of everyday life in this modern society. In a daily life of an organization, most encounter several activities that involve some interaction with a database. Databases play a critical role in almost all areas where computers are used, including business, electronic commerce, engineering, medicine, law, education, and […]

read more

Database Development Process

Good decisions require good information that is derived from raw facts known as data. Data are likely to managed most efficiently when they are stored in a database. Databases evolved from computer file systems. Although file system data management is now largely outmoded, understanding the characteristics of file systems is important because they are the source […]

read more

DEPICTING SYSTEMS GRAPHICALLY

A system or subsystem as it exists within the corporate organization may be graphically depicted in several ways. The various graphical models show no boundaries of the system and the information used in the system.   Systems and the Context-Level Data Flow Diagram The first model is the context-level data flow diagram (also called an […]

read more

INTEGRATING TECHNOLOGIES FOR SYSTEMS

As users adopt new technologies, some of the systems analyst’s work will be devoted to integrating traditional systems with new ones to ensure a useful context. E-commerce Applications and Web Systems       Many of the systems can be imbued with greater functionality if they are migrated to the World Wide Web or if they are […]

read more

TYPES OF SYSTEMS

1. Transaction Processing Systems (TPS) It is a computerized information systems that were developed to process large amounts of data for routine business transactions. TPS eliminates the tedium/tediousness of necessary operational transactions and reduces the time once required to perform them manually. TPS are boundary-spanning systems that permit the organization to interact with external environments. […]

read more