Question 11.5 pts A rule that states that each foreign key value must match a pr

Question

Question 11.5 pts

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Flag this Question

Question 21.5 pts

A graphical representation of the logical structure of a database is:

Flag this Question

Question 31.5 pts

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a __________ relationship.

Flag this Question

Question 41.5 pts

Converting a one-to-many binary relationship into a relational database from an E-R diagram ____.

Flag this Question

Question 51.5 pts

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Flag this Question

Question 61.5 pts

Representing a unary one-to-many relationship in a relational database ____.

Flag this Question

Question 71.5 pts

The SQL statement to find the values in the following SQL statement would require at least ____ conditions after the WHERE.
SELECT S.SNAME, G.GRADE, T.CLASS FROM STUDENT S, GRADE G, SECTION T WHERE (conditions)

Flag this Question

Question 81.5 pts

A relationship where the minimum and maximum cardinality are both one is a(n) __________ relationship.

Flag this Question

Question 91.5 pts

The purposes of creating E-R diagrams include:

Flag this Question

Question 101.5 pts

A subquery can be used to replace the use of a(n) ____.

Flag this Question

Question 111.5 pts

The primary key of the additional relation added to accomplish the binary many-to-many relationship ____.

Flag this Question

Question 121.5 pts

A property or characteristic of an entity type that is of interest to the organization is called a(n):

Flag this Question

Question 131.5 pts

Representing a ternary relationship in a relational database ____.

Flag this Question

Question 141.5 pts

If you wish to perform an inner join based on only one common attribute, you might use the ____ clause.

Flag this Question

Question 151.5 pts

The entity integrity rule states that:

Flag this Question

Question 161.5 pts

Which statement about the normal forms is incorrect?

Flag this Question

Question 171.5 pts

Which statement is incorrect about identifiers?

Flag this Question

Question 181.5 pts

Converting a many-to-many unary relationship into a relational database from an E-R diagram ____.

Flag this Question

Question 191.5 pts

SQL character data format is/are ____.

Flag this Question

Question 201.5 pts

A relationship between the instances of a single entity type is called a(n) __________ relationship.

Explanation / Answer

11.5 referential integrity constraint.

21.5 E-R modeling

31.5 one-to-many

41.5 can be done by creating a single table that combines the attributes of the two entities

51.5 primary key.

61.5 requires adding a new column, the domain of values of which is the same as the relation’s primary key

71.5 3

81.5 mandatory one

91.5 All of the above.

101.5 ORDER BY

111.5 is the primary key of one of the two relations involved in the many-to-many relationship

121.5 attribute.

131.5 requires the creation of an additional relation

141.5 USING

151.5 no primary key attribute can be null.

161.5 In order to design a database that provides efficient and reliable responses to SQL queries, the database should be put into at least the 3rd Normal Form.

171.5 An identifier may consist of multiple attributes.

181.5 requires the creation of two additional tables beyond the one that represents the single entity in the relationship

191.5 CHAR and VARCHAR

201.5 primary

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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