Data Modeling and Database Design, 2nd Edition by Dr. Narayan S. Umanath, Richard Scamell 1001
ISBN-10: 1285085256
ISBN-13: 9781285085258
QUESTION: What is the result of an attempt to add, subtract, multiply, or divide two number fields, one of which contains a null value?
QUESTION: Which comparison operators can be used when searching for null values? Which comparison operators cannot be used when searching for null values? What is…
QUESTION: What is the difference between a character field that contains a null value and a character field that contains a single blank space?
QUESTION: Why does the relation create a result of a Projection operation on a relation that includes the primary key not contain fewer tuples than…
QUESTION: With which of the four types of constraints in Exercise 4 is a requirement that an attribute did not contain a null value associated?
QUESTION: What are the minimum elements that must be included in the CREATE TABLE statement in defining the structure of a table?
QUESTION: What are the undesirable functional dependencies in the relation instance of the STUCLASS relation schema shown in Exercise 6?
QUESTION: Figures 5.4, 5.7, and 5.39 each show the decomposition of a ternary relationship. Explain why the entity types SCHEDULE and PRESCRIPTION in Figures 5.4…
QUESTION: Why can total participation of an entity type in a relationship type also be referred to as existence dependency of that entity type in…
QUESTION: Give an example of three entity types and accompanying attributes that might be associated with a database for a car rental agency?
