These are database management system questions. 1.A _______________________ uniq
ID: 3688034 • Letter: T
Question
These are database management system questions.
1.A _______________________ uniquely identifies the row or tuple in the relation.
2.In a 1-1 relationship the primary key of one of the two entities involved in the relationship is inserted into the other entity’s relation as a _____________________________.
3.The _____________ command integrates data from two tables.
4.Multiple attributes or combinations of attributes which have the uniqueness property within a relation are called ___________________________________.
5.A collection of relations that contain data describing a business environment is called ______________________________.
6.The bill of materials problem is an example of this type of special relationship (2 terms) ______________________________________.
7.A relationship that involves 3 or more different entity types is a _________________________________ relationship.
8._______________________ is the concept of referring to data in one relation based on values in another relation.
9.Three ways of handling deletions keeping in mind the concept in #8 are
___________________________________________,
___________________________________________,
___________________________________________
10. True or False? A one-to-many unary relationship requires the addition of one column to the relation that represents the single entity involved in the relationship.
Explanation / Answer
1.key
2.Foreign key or refference key
3.join
4.key attribute
5.relational database
6.one to many relationship
7.entity relationship
8.reference fields
9.using delete keyword and also on delete cascade
10.false