DBMS remains for Database Management System. We can break it like this DBMS = Database + Management System. Database is an accumulation of information and Management System is an arrangement of projects to store and recover those information. In view of this we can characterize DBMS like this: DBMS is a gathering of between related information and set of projects to store and access those information in a simple and powerful way. Here are the DBMS notes to enable you to learn database frameworks in a Systematic way.
- Introduction to DBMS
- DBMS Applications
- Advantages of DBMS over file processing system
- View of Data
- Data Abstraction
- Instances and Schemas
- Data Models in DBMS
- E-R Model in DBMS
- Relational Model in DBMS
- RDBMS concepts
- Hierarchical data Model in DBMS
- Network Model in DBMS
- Database languages
- Keys in DBMS
- Primary key
- Super key
- Candidate key
- Alternate key
- Composite key
- Foreign key
- Constraints in DBMS
- Domain constraints
- Mapping constraints
- Cardinality in DBMS
- Functional dependencies in DBMS
- Trivial functional dependency
- non-trivial functional dependency
- Multivalued dependency
- Transitive dependency
- Normalization – This covers all the normal forms: First Normal Form(1NF), Second Normal Form(2NF), Third Normal Form(3NF), Boyce–Codd Normal Form(BCNF)
0 comments:
Post a Comment