Tag: DBMS
SQL Interview Questions: A Comprehensive Guide for Job Seekers
Last updated on 6th April 2023 by H Sayyed | Category: Sponsored Post
Are you preparing for a SQL interview and feeling overwhelmed by the number of questions you need to answer? Worry not, we’ve got you covered. In this article, we will cover everything you need to know to ace your SQL interview. From basic concepts to complex queries, we will provide you with a comprehensive guide […]
How to Manage SQLite Database in VS code
Last updated on 26th September 2022 by Madderla Saikumar | Category: DBMS, Django Tutorial
we face some problems while working and some among them are Handling SQLite databases and managing the database. In managing database the common problems are switching between tabs and because of complexity databases it become difficult to manage the database. The advantages of the SQLite in VS code is in the following link https://www.sqlite.org/index.html For […]
How To Migrate File In Django
Last updated on 25th September 2022 by Madderla Saikumar | Category: Django Tutorial
Python’s Django web framework Django abstracts away much of the complexity when building web applications. One of its key features is to dynamically interact with a given database on a user’s behalf and takes care of many low-level functions that can slow the development process . What is migrations in Django Migrations are Django’s way of propagating […]
Indexing in DBMS
Last updated on 9th May 2022 by [email protected] | Category: DBMS
Indexing is a technique for improving database efficiency by reducing the number of disk accesses necessary while a query is completed. It is a data structure strategy for fast locating and accessing data in a database. A few database columns are useful to generate indexes. The first column is the Search key, which contains a […]
Concurrency Control in DBMS
Last updated on 7th May 2022 by [email protected] | Category: DBMS
Concurrency Control is concerned with the interleaved execution of several transactions. In the following article, we will define transaction and schedules in Concurrency Control. Transaction in Concurrency Control A set of logically related operations is basically the transaction. The main operations of a transaction are , read, write, commit and rollback.Basic properties of a transaction […]
Normalization in DBMS
Last updated on 4th May 2022 by [email protected] | Category: DBMS
In this tutorial we are going to learn about normalization in DBMS. Data duplication may occur in a big database defined as a single relation. This data repetition may result in:Increasing the size of relationships.It is difficult to manage and update data because it requires searching through several records in relation.Wastage and inefficient use of […]
Functional Dependencies in DBMS
Last updated on 1st May 2022 by [email protected] | Category: DBMS
Functional dependencies are relationship between two qualities. Within a table, it is often found between the primary key and a non-key property.X -> Y. The left side of FD is a determinant, while the right side of the production is the dependent. Types of Functional Dependencie Trivial functional dependencies If B is a subset of […]
Relational Model in DBMS
Last updated on 25th April 2022 by [email protected] | Category: DBMS
E.F. Codd proposed the Relational Model to model data in the form of relations or tables. After creating the database conceptual model using an ER diagram, we must transform it to a relational model. We can implement using any RDBMS language ,for example, Oracle SQL or MySQL. What is a Relational Model and how does […]
Generalization, Specialization and Aggregation in ER Model
Last updated on 5th August 2022 by [email protected] | Category: DBMS
Generalization, Specialization and Aggregation, are data abstraction mechanisms in the ER model. They are useful to hide specifics of a set of objects. Generalization in ER Model This is similar to a bottom-up method. Here, generally two or more lower-level entities unite to generate a higher-level object. But they must share some features. In principle, […]
Entity Relationship Model in DBMS
Last updated on 18th April 2022 by [email protected] | Category: DBMS
Entity Relationship model (ER model) is a high-level data model. This model is useful to specify the data items and relationships for a specific system. It creates the conceptual architecture of a database. It also generates a data view that is relatively simple to construct. In ER modeling, the database structure is represented by an […]
