- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 6702 Articles for Database
349 Views
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 More
929 Views
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 More
314 Views
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 More
9K+ Views
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 More
53K+ Views
BCNF (Boyce Codd Normal Form) is the advanced version of 3NF. A table is in BCNF if every functional dependency X->Y, X is the super key of the table. For BCNF, the table should be in 3NF, and for every FD. LHS is super key.ExampleConsider a relation R with attributes (student, subject, teacher).StudentTeacherSubjectJhansiP.NareshDatabasejhansiK.DasCsubbuP.NareshDatabasesubbuR.PrasadCF: { (student, Teacher) -> subject (student, subject) -> Teacher Teacher -> subject}Candidate keys are (student, teacher) and (student, subject).The above relation is in 3NF [since there is no transitive dependency]. A relation R is in BCNF if for every non-trivial FD X->Y, X must be a key.The ... Read More
4K+ Views
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
12K+ Views
Let us begin by understanding what a functional dependency is in the database management system (DBMS).Functional DependencyFunctional dependency refers to the relation of one attribute of the database to another. With the help of functional dependency, the quality of the data in the database can be maintained.The symbol for representing functional dependency is -> (arrow).Example of Functional DependencyConsider the following table.Employee NumberNameCitySalary1bobBangalore250002LuckyDelhi40000The details of the name of the employee, salary and city are obtained by the value of the number of Employee (or id of an employee). So, it can be said that the city, salary and the name attributes ... Read More
22K+ Views
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 More
11K+ Views
ProblemDraw of ER model for company considering the following constraints −In a company, an employee works on many projects which are controlled by one department.One employee supervises many employees.An employee has one or more dependents.One employee manages one department.SolutionFollow the steps given below to draw an ER model for the company −Step 1 − Identify the entity setsThe entity set has multiple instances in a given business scenario.As per the given constraints the entity sets are as follows:EmployeeDepartmentProjectDependentStep 2 − Identify the attributes for the given entitiesEmployee − The relevant attributes are name, ssn, sex, address, salary.Department − The relevant ... Read More
10K+ Views
ProblemDraw an ER model for library management application considering the following constraints −In a library multiple students can enroll.Students can become a member by paying an appropriate fee.The books in the library are identified by a unique ID.Students can borrow multiple books from subscribed libraries.SolutionFollow the steps given below to draw an ER model for the library management application −Step 1 − Identify the entity setsThe entity set has multiple instances in a given business scenario.As per the given constraints the entity sets are as follows −BookPublisherMemberSectionGranterStep 2 − Identify the attributes for the given entitiesBook − The relevant attributes ... Read More