DBMS | MYSQL | DATATYPES | SINGNED | UNSIGNED | HINDI |
INSTALLING GUID - • DBMS | MYSQL | INSTALL | HINDI | #001
Need for a Database Management System
The file based system
Limitations of file based system
The Database Approach
The Logical DBMS Architecture
Three level architecture of DBMS or logical DBMS architecture
Mappings between levels and data independence
The need for three level architecture
Physical DBMS Architecture
DML Precompiler
DDL Compiler
File Manager
Database Manager
Query Processor
Database Administrator
Data files indices and Data Dictionary
Commercial Database Architecture
Data Models
RELATIONAL AND E-R MODELS
The Relational Model
Domains, Attributes Tuple and Relation
Super keys Candidate keys and Primary keys for the Relations
Relational Constraints
Domain Constraint
Key Constraint
Integrity Constraint
Update Operations and Dealing with Constraint Violations
Relational Algebra
Basic Set Operation
Cartesian Product
Relational Operations
Entity Relationship (ER) Model
Entities
Attributes
Relationships
More about Entities and Relationships
Defining Relationship for College Database
E-R Diagram
Conversion of E-R Diagram to Relational Database
DATABASE INTEGRITY AND NORMALISATION
Relational Database Integrity
The Keys
Referential Integrity
Entity Integrity
Redundancy and Associated Problems
Single-Valued Dependencies
Single-Valued Normalisation
First Normal Form
Second Normal Form
Third Normal Form
Boyce Codd Normal Form
Desirable Properties of Decomposition
Attribute Preservation
Lossless-join Decomposition
Dependency Preservation
Lack of redundancy
Rules of Data Normalisation
Eliminate Repeating Groups
Eliminate Redundant Data
Eliminate Columns Not Dependent on Key
FILE ORGANISATION IN DBMS
Physical Database Design Issues
Storage of Database on Hard Disks
File ORG and Its Types
Heap files (Unordered files)
Sequential File ORG
Indexed (Indexed Sequential) File ORGANIZATION
Hashed File Organisation
Types of Indexes
Index and Tree Structure
Multi-key File Organisation
Need for Multiple Access Paths
Multi-list File Organisation
Inverted File Organisation
Importance of File Organisation in Databases
THE STRUCTURED QUERY LANGUAGE
What is SQL?
Data Definition Language
Data Manipulation Language
Data Control
Database Objects: Views, Sequences, Indexes and Synonyms
Views
Sequences
Indexes and Synonyms
Table Handling
Nested Queries
TRANSACTIONS AND CONCURRENCY MANAGEMENT
The Transactions
The Concurrent Transactions
The Locking Protocol
Serialisable Schedules
Locks
Two Phase Locking (2PL)
Deadlock and its Prevention
Optimistic Concurrency Control
DATABASE RECOVERY AND SECURITY
What is Recovery?
Kinds of failures
Failure controlling methods
Database errors
Recovery Techniques
Security & Integrity
Relationship between Security and Integrity
Difference between Operating System and Database Security
Authorisation
DISTRIBUTED AND CLIENT SERVER DATABASES
Need for Distributed Database Systems
Structure of Distributed Database
Advantages and Disadvantages of DDBMS
Advantages of Data Distribution
Disadvantages of Data Distribution
Design of Distributed Databases
Data Replication
Data Fragmentation
Client Server Databases
Emergence of Client Server Architecture
Need for Client Server Computing
Structure of Client Server Systems
Advantages of Client Server Systems
DEVELOPMENT OF A
HOSPITAL MANAGEMENT SYSTEM (An HMS)
Need to Develop the Hospital Management System (An HMS)
Advantages of Hospital Management System
ER diagram for HMS
The Software Development Tools required
Creating a Database for HMS
Creating a Database using Ms-Access
Table Relationships
Developing Front End Forms
Reports
Creating a Report using the Wizard
Creating Mail Merge Labels using a Wizard
Creating a Report using the Access Report Wizard
Creating Report using Design View
Using Queries and Record set
Using the Simple Query Wizard
Creating a Query in Design View
Opening a Query
Adding Features in Query
Conditional Queries
Advanced Query Features
STUDY CENTRE MANAGEMENT SYSTEM: A CASE STUDY
Executive Summary
Brief Overview of Study Centre
Brief Overview of the Software
Long-term model for study centre
Aim of the software development project
Present working system
Proposed working
Software Life Cycle
Different Models
Used Model and its Justification
Software Development Process: Analysis
Preliminary Investigation
Request clarification
Feasibility Study
Request Approval
Requirements Determination
Study of Existing Documentation
Completed Forms
Reports (Manual and Computerized)
Research and Site Visits
Observation of Work Area
Questionnaires
Personal Interview
System Designing
Data Flow Diagram for System
Entity- Relationship Diagram for the system
Data Dictionary
Few Input Designs (Rough layout)
A Few Output Designs (Rough layout)
Software Development, Testing and Maintenance
Software Development
Some Validation Checks
Reports Screen Shots
System Testing
Test Plan