Free Download Database Management System Book PDF

Download and Read Database Management System Book PDF

ByAnupama Chowdhary

Total Download

11

“Read the best books first, or you may not have a chance to read them at all.” -Henry David Thoreau

Synopsis

Managing data is an important managerial task in any organisation. Accurate and relevant data is the source of valuable information. Sound management decisions can be made by managing data efficiently. For managing data effectively the traditional file environment is not appropriate choice so database management systems are used. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyse data. This book provides plenty of examples and pictorial diagrams to explain the concepts of DBMS in simplified method. Some key topics covered are: Data and information, Components of DBMS, Database administrators, designers, end users, Concepts on data abstraction, schemas, instances, and data independence, Data models: Hierarchical, Network, Entity-relationship, Relational, Object-relational, E-R diagrams, roles, Specialization, generalization, Binary and non-binary relationships, Concept of NULL, Keys: Primary key, Super key, Candidate key, Foreign key etc., Integrity constrains, Relational Algebra and Relational Calculus, Codd’s 12 rules, Anomalies in databases, Dependencies: functional, full, partial, transitive, multivalued, and join, Closure and its uses, Canonical cover, Extraneous attributes, Decomposition, Normalization: first to fifth normal forms and Boyce-Codd normal form, SQL*Plus commands: CREATE TABLE, ALTER TABLE, DROP TABLE, RENAME, INSERT, UPDATE, DELETE, TRUNCATE, COMMIT, ROLLBACK, SAVEPOINT, SELECT, GRANT and REVOKE, Storage media: Magnetic disk, RAID, File organization: Sequential, Indexed, B+-Tree, B-Tree, Hashing, PL/SQL: cursors, locks, error handling, triggers, package etc.