DBMS - Database management system Full syllabus in detail.

Unit I

  • Introduction to database system: - database application, evolution of DB and DBMS,
  • Why need data management?
  • Introduction and application of DBMS
  • File system and various database system,
  • Data models, 
  • DBMS architecture, 
  • Data independence,
  • Data modelling using entity- relationship model,
  • Enhanced er modelling. 

Unit II

  • relationship database concept and design: introduction to relational database that means RDBMS. 
  • structure of relational database
  • relational model terminology
  • attributes 
  • tuples
  • relations
  • relational db schema
  • relational algebra
  • basic operation: selection and projection
  • set theoretic operation union
  • intersection 
  • set difference and division
  • join operation inner and outer
  • left outer 
  • right outer
  • full outer and join
  • relational database design
  • functional dependency
  • definition
  • trivial and nontrivial FD
  • 1NF
  • 2NF
  • 3NF
  • decomposition using fd preservation 
  • BCNF
  • Multivalued dependency
  • 4NF
  • Join Dependency and 5NF 

Unit III

  • Database storage and querying:- Basic concept of Indexing and Hashing Query Processing
  • Measure of query cost 
  • query processing for select
  • sort join operation
  • basic query of optimization 
  • Transformation of relational  expression estimating statistic of expression 
  • choice of evaluation plan

Unit IV

  • Concurrency 
  • Recovery and security concurrency control
  • Lost and Update
  • Dirty read and incorrect summary problems due to concurrency
  • Concurrency Control Techniques: Overview of Locking,
  • 2PL,
  • Timestamp ordering,
  • Multi-versioning, 
  • Validation Recovery concepts, 
  • Shadow paging, 
  • Log Based Recovery, 
  • Elementary concepts of Database security: system failure,
  • Backup and Recovery Techniques, 
  • Authorization and authentication.
Unit V

  • Introduction to Current Trends — Centralized and Client Server Architectures, 
  • Distributed Databases, 
  • Object Oriented Database, 
  • Spatial & Temporal Databases,
  • Data Mining & Warehousing,
  • Data Visualization, 
  • Mobile Databases,
  • OODB & XML Databases,
  • Multimedia & Web Databases. 

Please share this to your friends. and comment if you have any doubt about this topic. I will post tutorial of DBMS.




Comments

Post a Comment

Popular posts from this blog

Quick Revision for Multimedia and Animation - Vikatu

Image
Unit 1     Multimedia is a type of medium that allows information to be easily transferred from one location to another . Multimedia is the presentation of  text ,  pictures ,  audio , and  video  with links and tools that allow the user to navigate, engage, create, and communicate using a computer. Multimedia refers to the computer-assisted integration of text, drawings, still and moving images(videos) graphics, audio, animation, and any other media in which any type of information can be expressed, stored, communicated, and processed digitally. Multimedia is being employed in a variety of disciplines, including  education ,  training , and  business . Applications of Multimedia   Multimedia indicates that, in addition to  text ,  graphics / drawings , and  photographs ,  computer information  can be represented using audio, video, and animation. Multimedia is used in: 1. Education In the subject of education, multimedia is becoming so popular. It is often used to pr
Read more

Java Quick revision

Image
UNIT I Parameters Java C++ First Release The Java language came into existence on 23rd May 1995. The C++ language first came into existence in October 1985. A stable form of Release The JDK 14 or Java SE was finally released on 17th March 2020. The C++ 17 was released back in December 2017. Founder James Gosling developed Java at Sun Microsystems. Bjarne Stroustrup developed C++ at Bell Labs back in 1979 in the form of an extension to the C language. Platform Dependency The Java bytecode can easily work on any given OS (operating system). It is very much platform-independent. The C++ language is platform-dependent. It means that we need to compile it for a different platform. Official Website The official website for Java is oracle.com/java The official website for C++ is isocpp.org Influenced By The C#, C++, Pascal, Ada 83, and many more languages have an influence on the Java language. Smalltalk, Simula, ML, C, ALGOL 68, Ada, and many more languages have an influence on the C++ langu
Read more

Quick revision for software engineering by vikatu

Image
UNIT I Software characteristics refer to the qualities or attributes that define the behavior, functionality, and performance of a software system. These characteristics help in evaluating, understanding, and designing software effectively. Here are some common software characteristics: Functionality : It refers to the extent to which the software performs its intended tasks. A software system should meet the specified requirements and provide the desired features to users. Reliability : This characteristic indicates the ability of the software to perform consistently and predictably under various conditions. Reliable software should be robust and resilient to errors and failures. Usability : Usability measures how easy it is for users to interact with the software. It involves aspects such as user interface design, intuitiveness, simplicity, and accessibility. Efficiency : Efficiency relates to the optimal use of system resources (such as CPU, memory, and disk space) to achieve desire
Read more