Basics of Database Part 01
What is Database? A database is a collection of information organized for easy access, management, and maintenance. Exp: Customer data Product Inventory etc. Types of Data Models - Record-based logical model - Hierarchical Data Model - Network Data Model - Relational Data Model - Object-based logical model - Entity relationship model DBMS Operations - Adding new files - Inserting data - Retrieving data - Modifying data - Removing data - Removing files Advantages of DBMS - Sharing of data across applications - Enhanced security mechanism - Enforce integrity constraints - Better transaction support - Backup and recovery features Introduction to RDBMS - A relational database refers to a database that stores data in a structured format, using rows and columns. - This makes it easier to locate and access specific values within the database. - It is "relational" because the values within each table are related to each other. tables may also be re...