Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Bhanu Priya
Page 86 of 106
What are constraints on ER model in DBMS?
Constraints are used for modeling limitations on the relations between entities.There are two types of constraints on the Entity Relationship (ER) model −Mapping cardinality or cardinality ratio.Participation constraints.Mapping CardinalityIt is expressed as the number of entities to which another entity can be associated via a relationship set.For the binary relationship set there are entity set A and B then the mapping cardinality can be one of the following −One-to-oneOne-to-manyMany-to-oneMany-to-manyOne-to-one relationshipAn entity set A is associated with at most one entity in B and an entity in B is associated with at most one entity in A.One-to-many relationshipAn entity set A ...
Read MoreDifferentiate between the three models on the basis of features and operations(DBMS)?
A database model is a logical structure of a database, which contains the relationships and constraints that determine about how data is stored and accessed. The individual database models are designed based on the rules and concepts. Most data models can be represented by an accompanying database diagram.Types of database modelsThere are so many database models, but most used database models are −Hierarchical database modelRelational modelNetwork modelObject-oriented database modelThe major differences between the hierarchical, network and the relational models are as follows −Hierarchical ModelNetwork ModelRelational ModelOne to many or one to one relationship.Allowed the network mode to support many to ...
Read MoreWhat are the User friendly interfaces provided by DBMS?
The different user-friendly interfaces provided by the database management system (DBMS) are as follows −Menu-Based interfaces.Forms-based interfaces.Graphical user interfaces.Natural language interfaces.Speech input and output interfaces.Interfaces for parametric users.Interfaces for the database administrator (DBA).User friendly interfacesLet’s discuss the user-friendly interfaces provided by the DBMS in detail.Menu-based interfacesThese interfaces contain the lists of options through which the user is able to send the request.The Pull-down menus are a very popular technique in web-based user interfaces.These types of interfaces are mainly used by the web browsing users and web clients.Forms-based interfacesThese types of interfaces are displaying a form to each user. The user ...
Read MoreWhat are the TCL commands in DBMS?
Transaction Control language is a language that manages transactions within the database.It is used to execute the changes made by the DML statements.TCL CommandsTransaction Control Language (TCL) Commands are:Commit − It is used to save the transactions in the database.Rollback − It is used to restore the database to that state which was last committed.Begin − It is used at the beginning of a transaction.Savepoint − The changes done till savpoint will be unchanged and all the transactions after savepoint will be rolled back.ExampleGiven below is an example of the usage of the TCL commands in the database management system ...
Read MoreWhat are the DDL commands in DBMS?
Data definition language (DDL) is a language that allows the user to define the data and their relationship to other types of data.Data Definition language statements work with the structure of the database table.Various data types used in defining columns in a database tableIntegrity and value constraintsViewing, modifying and removing a table structureDDL CommandsThe Data Definition Languages (DDL) Commands are as follows −Create − It is used to create a new table or a new database.Alter − It is used to alter or change the structure of the database table.Drop − It is used to delete a table, index, or ...
Read MoreWhat is the procedure to access database users in DBMS?
Let’s see the procedure to access database users in DBMS step by step.Step 1 − The request from the user is passed to the DBMS user interface, where oracle engine locates the files for the given relation.The relation is nothing but − table schemaLinking between the recordsStep 2 − The file manager will generate the particular file for the given table and process this request to the disk manager.Step 3 − The disk manager will give the offset address for the given table where the records are stored.Step 4 − The displacement of a particular block is done from hard ...
Read MoreDescribe the College Management system in three layer architecture?
The three-schema architecture divides the database into three-level used to create a separation between the physical database and the user application. In simple terms, this architecture hides the details of physical storage from the user.The database administrator (DBA) responsible is to change the structure of database storage without affecting the user’s view. It deals with the data, the relationship between them and the different access methods implemented on the database. The logical design of a database is called a schema.This architecture contains three layers of database management system (DBMS) −External levelConceptual levelInternal levelThe three layers of the DBMS are pictorially ...
Read MoreExplain the Network Model in DBMS?
The network model was created to represent complex data relationships more effectively when compared to hierarchical models, to improve database performance and standards.It has entities which are organized in a graphical representation and some entities are accessed through several paths. A User perceives the network model as a collection of records in 1:M relationships.Given below is the pictorial representation of the network model in DBMS −FeaturesThe features of a Network Model are as follows −Ability to Merge Relationships − In this model, because of more relationships the data is more related. It has an ability to manage one-to-one relationships as ...
Read MoreCheck which FD violates 2NF in the given relation and decompose R into 2NF
Normalization is the process of organizing the data in a database. It helps in removing the duplicate values in the database. Normalization divides the large table into smaller tables and links them using relationships.The normal form is used to reduce redundancy from the database table. Normalization is the name given to the process of simplifying the relationship among data elements in a record.In simple words we can say, Normalization is the process of organizing data to minimize.Redundancy/duplication/repetition.Insertion, deletion, updating anomalies.Normal formsThere are six Normal forms which are as follows −First Normal Form (1NF)Second Normal Form (2NF)Third Normal Form (3NF)Boyce-Codd Normal ...
Read MoreExplain about triggers and active databases in DBMS
A trigger is a procedure which is automatically invoked by the DBMS in response to changes to the database, and is specified by the database administrator (DBA). A database with a set of associated triggers is generally called an active database.Parts of triggerA triggers description contains three parts, which are as follows −Event − An event is a change to the database which activates the trigger.Condition − A query that is run when the trigger is activated is called as a condition.Action −A procedure which is executed when the trigger is activated and its condition is true.Use of triggerTriggers may ...
Read More