2. A relation is a set of ordered tuples, by definition. On the other hand, according to the definition of set, it does not contain duplicate value. Thus, a collection of tuples will be called relation only when there is no duplicates. So, there is no duplicate tuple in a relation. Primary key is used in relations to maintain this property. (Elmasri, 2008)3. Candidate key can uniquely identify a tuple from a relation. Any candidate key can do the same task. On the other hand primary key is a candidate key that is designated as the same for a relation. There are other use of primary key, for example, in referencing to the foreign key, indexing to support searching etc. If there is two or more designated primary key, then referencing, indexing etc. will be problematic, more computational resources will be consumed to maintain properties of primary key for both. So, it is not used in practice. (Elmasri, 2008)
Elmasri, R. (2008). Fundamentals of Database Systems (6th ed.). Pearson.
MyAssignmenthelp.com is the perfect solution to render quality solution for all sort of academic issues. We have hired professionals from different fields of study to provide assistance with different subjects. We successfully have provided different types of assignment solutions on 100+ subjects. We have hired industry experts to deliver nursing assignment, hr assignment and finance assignment help. To offer quality content with IT assignments, we have hired IT professionals to render programming language assignment help and IT assignment help for other types of IT assignments as well.
You are required to write a researched argument essay that convinces persuades the reader of your position / stance. This is an academic, researched and referenced do...Read More
Executive Summary The purpose of this report is to elaborate the factors which are considered by individuals before selecting an occupation. Choosing an occupati...Read More
Introduction With the increase enhancement in the field of technology, it has been considered essential by the businesses to implement such technology in their b...Read More
Executive Summary In a merger & acquisition, role of an HR has emerged as a very critical function. At each stage of merger and acquisition process, HR plays a s...Read More
Introduction In this competitive business environment where every business organization is trying to attract the customers of each other, it becomes essential for ...Read More