Question 211.5 pts In which of the following situations would one have to use an

Question

Question 211.5 pts

In which of the following situations would one have to use an outer join in order to obtain the desired results?

Flag this Question

Question 221.5 pts

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Flag this Question

Question 231.5 pts

Customers, cars, and parts are examples of :

Flag this Question

Question 241.5 pts

Which of the following are logical database design techniques?

Flag this Question

Question 251.5 pts

An entity that associates two instances of other entities with one another:

Flag this Question

Question 261.5 pts

An entity instance refers to:

Flag this Question

Question 271.5 pts

If a table has columns which are functionally dependent on a nonkey attribute, the table is not in its

Flag this Question

Question 281.5 pts

The SQL command __________ adds one or more new columns to a table.

Flag this Question

Question 291.5 pts

If a table has an attribute dependent on only part of a multi-valued key, it may be in its

Flag this Question

Question 301.5 pts

Which statement about attributes is incorrect?

Flag this Question

Question 311.5 pts

A large retailing company has many local stores. It wants to keep track of which customer buys which product from which store. This has to be captured by a _____ relationship.

Flag this Question

Question 321.5 pts

A(n) __________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Flag this Question

Question 331.5 pts

In the SQL language, the __________ statement is used to make table definitions.

Flag this Question

Question 341.5 pts

The number of entity types that participate in a relationship is called the:

Flag this Question

Question 351.5 pts

A ternary relationship involves ____ entity type(s).

Flag this Question

Question 361.5 pts

Which statement about the associative entity is incorrect?

Flag this Question

Question 371.5 pts

Which of the following are anomalies that can be caused by redundancies in tables?

Flag this Question

Question 381.5 pts

An attribute that uniquely identifies an entity, and consists of a composite attribute is called a(n):

Flag this Question

Question 391.5 pts

An associative entity is an alternate way of expressing a(n) _____.

Flag this Question

Question 401.5 pts

Which statement about relationships is incorrect?

A report is desired that lists all customers and the total of their orders.

Explanation / Answer

211.5 A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).

221.5 foreign key.

231.5 entities.

241.5 Conversion of E-R diagrams to relational tables.

251.5 associative entity.

261.5 a single data value that describes a characteristic of an entity.

271.5 third normal form

281.5 create view

291.5 second normal form

301.5 Attributes and fields are essentially the same thing.

311.5 a one-to-many unary

321.5 cardinality constraint

331.5 create table

341.5 degree.

351.5 three

361.5 An associative entity may have a composite primary key.

371.5 All of the above

381.5 relationship identifier.

391.5 one-to-many binary relationship

401.5 The minimum cardinality of a relationship can be zero or one.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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