These online Database Management System notes cover basics to advance topics like DBMS architecture, data model, ER model diagram, relational calculus and algebra, concurrency control, keys, data independence, etc. to easily understand and learn DBMS for beginners. Let us start this DBMS tutorial by understanding,
Database Management System Course Syllabus
Introduction
Advanced Stuff
Must Know!
Real world entities Table creation based on relations Data isolation & protection Consistency Less redundancy Query processing
Banking: for storing customer information, account activities, deposits, payment details, loans, etc. Manufacturing: for supply chain management, production tracking and inventory management Finance: for storing information about stocks, sales, and purchases of financial instruments like stocks and bonds Universities: for student information, course registrations, payroll and grades Airlines: for reservations, ticket booking and schedule information
Full-Form: Database Management System DBMS: is an application designed especially to enable user interaction with the software application DBMS Users: Application Programmers, Database Administrators & End-users Applications: Banking, Finance, Education, Medical, Airlines, etc. Advantages: Data isolation, Data Security/Protection, Integrity, Consistency, Less redundancy Disadvantages: Higher cost of hardware/software & training, Complex system, Data loss, Can’t perform sophisticated calculations
