DATABASE CONCEPTS

Description

Mind Map on DATABASE CONCEPTS, created by Aparna Dhirde on 17/03/2020.
Aparna Dhirde
Mind Map by Aparna Dhirde, updated more than 1 year ago
Aparna Dhirde
Created by Aparna Dhirde almost 6 years ago
62
0

Resource summary

DATABASE CONCEPTS
  1. File System
    1. Limitations of a File System
      1. Difficulty in Access
        1. Data Redundancy
          1. Data Inconsistency
            1. Data Isolation
              1. Data Dependence
                1. Controlled Data Sharing
              2. Database Management System
                1. File System to DBMS
                  1. Key Concepts in DBMS
                    1. Database Schema
                      1. Data Constraint
                        1. Meta-data or Data Dictionary
                          1. Database Instance
                            1. Query
                              1. Data Manipulation
                                1. Database Engine
                              2. Relational Data Model
                                1. Terminology
                                  1. ATTRIBUTE
                                    1. TUPLE
                                      1. DOMAIN
                                        1. DEGREE
                                          1. CARDINALITY
                                        2. Important Properties of a Relation
                                          1. Keys in a Relational Database
                                            1. Candidate Key
                                              1. Primary Key
                                                1. Composite Primary Key
                                                  1. Foreign Key
                                                  Show full summary Hide full summary

                                                  Similar

                                                  Database Concepts
                                                  Connor Begg#