The entity integrity is a constraint on primary key value. It states that any attriburte of a primary key cannot contain null value. If primary key contains null value, it is not possible to uniguely identify a record in a relation.
The above relation is in 2NF because the primary key consists of single attribute. A SALESMAN and SALESMAN is functionally dependent on CUSTNO. It means that REGION is transitively dependent on CUSTNO.
The above relation is in 2NF because the primary key consists of single attribute. A transitive dependency exists in the relation. The REGION is functionally dependent on SALESMAN and SALESMAN is functionally dependent on CUSTNO. It means that REGION IS TRANSITIVELY DEPENDENT ON CUSTNO.
I am sure that you know very well about Hazrat Israfeel Alaihissalam, the angle who will breathe into a megaphone for the whole humanity to call them on the Day of Judgment.
What are the database anomalies? Briefly discuss insertion, deletion and modification anomalies. Database Anomalies Database anomalies are the problems in relations that occur due to redundancy in the relations. These anomalies affect the process...
Fearless optimist Anna teams up with Kristoff in an epic journey, encountering Everest-like conditions, and a hilarious snowman named Olaf in a race to find Anna’s sister Elsa, whose icy powers have trapped the...
When is a relation in first normal form? Explain with example. A relation is in first normal form (1NF) if every intersection of row and column contains atomic values only. It means that the...
What is functional dependency? Explain with Example. Function Dependency A functional dependency is a relationship between two attributes. It means that if the value of one attribute is known, it is possible to...
Microsoft Surface updates out now, make apps load faster Microsoft’s Surface tablet has now got its first firmware update, and it’s good news if you’re short of time. Apps load around two seconds faster...
What is normalization? How it can be used to bring the database in a consistent state? Express graphically. The process of producing a simpler and more reliable database structure is called normalization. It is...
BA/BSc / Computer & IT / Education / FA/Fsc / MA/MSc
Two Table are Design and Datasheet View
21 Jan, 2014
