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
-
Economics & Finance
Big Data Analytics Articles
Page 119 of 135
What is instance and schema (DBMS)?
The overall design of the database is called database schema. Schema will not be changed frequently. It is the logical structure of a database. It does not show the data in the database.The schema is pictorially represented as follows −Types of SchemaThe different types of schemas are as follows −Physical schema − It is a database design at the physical level.It is hidden below the logical schema and can be changed easily without affecting the application programs.Logical schema − It is a database design at the logical level. Programmers construct applications using logical schema.External − It is schema at view ...
Read MoreExplain the evaluation of relational algebra expression(DBMS)
SQL queries are decomposed into query blocks. One query block contains a single SELECT-FROM-WHERE expression, as well as GROUP BY and HAVING clause (if any). Nested queries are split into separate query blocks.ExampleConsider an example given below −Select lastname, firstname from employee where salary>(select max(salary) from employee where deptname =CSE ; C=(select max(salary) from employee where deptname=CSE); // inner block Select lastname, firstname from employee where salary>c; //outer blockWhere C represents the result returned from the inner block.The relation algebra for the inner block is Ģmax(salary) (σdname=CSE(employee))The relation algebra for the outer blocks is Πlastname, firstname(σsalary>c(employee))The query optimizer would then ...
Read MoreWhat is a query language in DBMS?
Query is a question or requesting information. Query language is a language which is used to retrieve information from a database.Query language is divided into two types as follows −Procedural languageNon-procedural languageProcedural languageInformation is retrieved from the database by specifying the sequence of operations to be performed.For Example: Relational algebraStructure Query language (SQL) is based on relational algebra.Relational algebra consists of a set of operations that take one or two relations as an input and produces a new relation as output.The different types of relational algebra operations are −Select operationProject operationRename operationUnion operationIntersection operationDifference operationCartesian product operationJoin operationDivision operation.Select, project, ...
Read MoreExplain the design constraints on the generalization and specialization (DBMS)?
The different types which we need to consider while designing generalization and specialization in the Database Management System (DBMS) are as follows −Conditional definitionAttribute definedUser definedDisjoint definedOverlapping constraintCompleteness constraintLet us now understand them one by one.Conditional definitionCreate one database, and keep conditions on one attribute for example attendance. This type of constraint is defined on a single attribute which is further dividing an entity into two sub entity sets which will give information for the given attribute.ExampleGiven below is an example of the conditional definition database −Attribute definedThis refers to specifying conditions on more than one attribute.ExampleConsider a database for ...
Read MoreExplain join dependency in DBMS
Join dependency is a constraint which is similar to functional dependency or multivalued dependency. It is satisfied if and only if the relation concerned is the join of a certain number of projections. Such type of constraint is called join dependency.Let's consider a special class of join dependencies which help to capture data dependencies present in a hierarchical data structure.Example 1The above hierarchical organization informs regarding ward and patients currently admitted to a ward depend only on the hospital but not the facilities present in that hospital. Since hospitals have multiple wards, functional dependencies are not adequate to describe the ...
Read MoreCreate an example table that is in its first normal form(DBMS)
If a table has data redundancy and is not properly normalized then it will be difficult to handle and update. If a relation contains composite or multivalued attributes it violates the first normal form.A table is in 1Nf if the following conditions exist −There are only single valued attributes.Attribute domain does not change.There is a unique name for every attribute or column.The order in which data is stored does not matter.ExampleConsider the table given below −IdNameCourse1AC1, C22EC33BC2, C3The above table is in un normalized form, the course attribute is having multivalued attributes which violates 1NF.Now we represent the above table ...
Read MoreWhich normal form is the highest that satisfies the functional dependencies(DBMS)?
Let's take the dependencies F= {AB->CDEF, AF->ED, F->B} which ONE of the following is the highest normal form that a table R=ABCDEF could satisfy.Select any one from the following −No normal form would be satisfied.Boyce-Codd Normal Form1st Normal Form2nd Normal Form3rd Normal FormGiven Functional dependencies of F are as follows −AB ---> CDEFAF ---> EDF ---> BNow in R.H.S (Right Hand Side) of Functional dependencies of F, attributes B, C, D, E, F are all present but attribute A is missing. So, attribute A must be the part of Super Key.We have to find the closure of A (A+), A+ ...
Read MoreExplain how normal forms can be transformed from lower to higher(DBMS)
In the database management system there are several rules to manage the tables and do the changes like insertion, deletion, updatation and there are different stages at which the tables are organized and these stages are known as normal forms.It is a standard structure of relational databases in which a relation may be inserted in another relation.Five normal formsThere are five normal forms which are explained below −First normal formThe first normal form defines the definition of the table. The rules of the first normal form are as follows −Each column must have a single value.Each column has a unique ...
Read MoreWhat is multivalued dependency in DBMS?
Multivalued dependency (MVD) is having the presence of one or more rows in a table. It implies the presence of one or more other rows in that same table. A multivalued dependency prevents fourth normal form. A multivalued dependency involves at least three attributes of a table.It is represented with a symbol "->->" in DBMS.X->Y relates one value of X to one value of Y.X->->Y (read as X multidetermines Y) relates one value of X to many values of Y.A Nontrivial MVD occurs when X->->Y and X->->z where Y and Z are not dependent are independent to each other. Non-trivial ...
Read MoreCheck which FD violates 3NF in a given relation and decompose R into 3NF(DBMS)
A relation is in 3NF when it is in 2NF and there is no transitive dependency or a relation is in 3NF when it is in 2NF and all non-key attributes directly depend on candidate key.Third normal form (3NF) is the third step in normalizing a database and it builds on the first and second normal forms, 1NF and 2NF.3NF states that all column references in referenced data that are not dependent on the primary key should be removed. Another way of putting this is that only foreign key columns should be used to reference another table, and no other ...
Read More