Introduction to Database Management Systems (DBMS)
- 3.8
Brief Introduction
Learn Fundamental Concepts of Database Management from scratchDescription
Information is not useful if not organized. In database, data is organized in a way that people find it meaningful and useful. Database Management System (DBMS) is used to input, sort, organize and store data.
Database Management System (DBMS) is a Software for data storage & retrieval, for creating user interface (forms), reports, and for administering a DB system (security, access, etc.). An implementation of a DBMS product to support various information needs in a company includes one or more databases, logic (business rules), backend code and user interface.
An information system that is built from “applying” a DBMS or a database to a specific domain, supports specific information needs.
Requirements
- Requirements
- Basic Computer knowledge
Knowledge
- Introduction to DBMS
- Why we need DBMS
- History of Database Systems
- Data abstraction and database languages
- Database schema and Instances
- Transaction Management
- Data independence
- Database Architecture
- Data Mining & Information Retrieval
- Database Design Process
- Database Design Process
- Basic Terms In Database Design
- Conceptual Design : Case Study
- Refining The Conceptual Design
- Additional Features of ER Model
- Constraints on Specialization & Generalization
- Specialization & Generalization Hierarchies & Lattices