ISST 303

It refers to the technology for creating and managing databases.

• ER Diagram

• SQL

• DBMS

• Database

DBMS also has the following functionalities. Except

• Concurrency Control

• Data Independence

• Utility Services

• Security

Is one single point of reference for every uniquee ntity in the business.

• Master Data Management

• Data Warehouse

• DataIndependede

• Utility Services

Is the process of reorganizing data in a

database so that it meets two basic requirements..

• Stuctured Data

• Big Data

• Normalization

• Standardization

Is a theoretical and conceptual way of showing data relationships in software development.

• ER Diagram

• Hierarchical Model

• Network Model

• Entity Relationship Model

Symbols Used in ER Model

• Lines

• Diamond

• Ellipses

• Rectangle

Is a data modeling technique that graphically illustrates an information system’se ntities and the relationships between those entities.

• Relational Diagram

• Entity Relationship Diagram

• Hierarchical Diagram

• Networking Diagram

It is one of the elements of ER were can be written as an object with a physical existence – a particular person, car, house, or employee – or it may be an object with a conceptual existence – a company, a job, or a university course.

• Attributes

• Relationship

• Entities

• Decision

Steps involved in creating an ERD include: Except

• Use star model or cube dimensional model

• Determining all interactions between the entities

• Identifying and defining the entities

• Analyzing the nature of interactions/determining the cardinality of the relationships

Is an organizational process methodology designed for complete content life cycle management.

• SDLC

• 
  Enterprise Content Management

• Agile Methodology

• RAD