Welcome to Vikatu

Application Of Database management System   A database application is a computer software application that interacts with a database management system to perform various operations on the data stored in the database. Database applications can be classified into several categories based on their functionality and the type of database they interact with. Some common types of database applications include: Data Entry and Management Applications: These applications are used to enter, update, and manage data in a database. Examples of such applications include customer relationship management (CRM) systems, human resources management systems (HRMS), and inventory management systems. Business Intelligence (BI) Applications: BI applications are used to analyse and interpret data stored in a database to make business decisions. These applications can generate reports, graphs, and charts based on the data stored in the database. Examples of BI applications include financial reporting systems an

 What is Database  Management System? A database system is a software system designed to manage and store large amounts of structured data. It allows users to create, access, update and manage data efficiently and securely. A database consists of one or more tables, each of which contains columns and rows. A column represents a specific attribute or field in the table, while a row represents a single instance or record. There are several types of database systems, including relational databases, document-oriented databases, key-value databases, graph databases, and more. Relational databases are the most common type of database system used today. They store data in tables, where each table has a primary key that uniquely identifies each row in the table. Tables can be related to each other through foreign keys, allowing data to be organized and retrieved efficiently. Database systems provide many benefits, including data consistency, data security, data integrity, and the ability to ea

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 In