Which of the following represents a row in a table? a record
Which of the following defines a relationship in which each occurrence of data in one entity is represented by multiple occurrences of the data in the other entity? one-to-many An entity is represented in an E-R model as a(n):
Arrow
Which of the following is not an E-R model relationship? some-to-many Which of the following symbols represents a many-to-many relationship in an E-R model?
A straight line with a crow’s foot
Which of the following can contain repeating groups? unnormalized data
Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity? one-to-one Which of the following has no partial or transitive dependencies?
3NF
Which of the following symbols represents a one-to-many relationship in an E-R model? straight line with a crow’s foot at the “many” end
Which of the following has no partial dependencies but can contain transitive dependencies?
2NF
Which of the following has no repeating groups but can contain partial or transitive dependencies? 1NF
The unique identifier for a record is called the: primary key
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value? primary key
A unique identifier for a data row that consists of more than one field is commonly called a: foreign key
Which of the following symbols represents an optional relationship in an
E-R model?a dashed line
Which of the following, when used in an E-R model, indicates the need for an additional table? one-to-many relationship
Which of the following represents a field in a table? a column
Which of the following defines a relationship in which data can have multiple
References: ORDER Which of the following SQL statements returns all books published after March 20, 2005? SELECT * FROM books WHERE pubdate 4 '03–20–2005 '; Which of the following lists all books published before June 2, 2004 and all books published AND pubdate 5 '06–02–2004 '; Which of the following finds all orders placed before April 5, 2009 that haven’t yet shipped?