Items related to DATABASE MANAGEMENT SYSTEM
Basic Concepts DBMS concepts and architecture introduction, Review of file organization techniques, Database approach v/s traditional file accessing approach, Advantages of database systems, Data models, Schemas and Instances, Data independence, Functions of DBA and Designer, Entities and Attributes, Entity types, Value, Sets, Key attributes, Relationships, Defining the E-R diagram of database. Data Models and Relational Databases Various data models, Basic concepts of hierarchical data model, Network data model and Relational data model, Comparison between the three types of models, Relational data models: Domains, Tuples, Attributes, Relations, Characteristics of relations, Keys, Key attributes of relation, Relational database, Schemas, Integrity constraints, Intension and Extension. Structured Query Language Relational query languages: Relational algebra and Relational calculus, Relational algebra operations like Select, Project, Join, Division, Outer union. SQL: Data definition in SQL, Update statements and views in SQL, QUEL and QBE: Data storage and definitions, Data retrieval queries and update statements. Database Design Database design: Introduction to Normalization, Normal forms, Functional dependency, Decomposition, Dependency preservation and lossless join, Problems with Null values and Dangling tuples, Multi-valued dependencies. Advance Concepts Introduction to Distributed databases, Protection, Security and integrity constraints, Concurrent operation on databases, Recovery and transaction processing, Basic concepts of Object-oriented database system and design.
"synopsis" may belong to another edition of this title.
- PublisherTechnical Publications
- Publication date2011
- ISBN 10 9350381524
- ISBN 13 9789350381526
- BindingPaperback
- Edition number2
- Number of pages384
(No Available Copies)
Search Books: Create a WantIf you know the book but cannot find it on AbeBooks, we can automatically search for it on your behalf as new inventory is added. If it is added to AbeBooks by one of our member booksellers, we will notify you!
Create a Want