These are database management system questions. 1.A _______________________ uniq

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

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.