Data Modeling and Database Design, 2nd Edition by Dr. Narayan S. Umanath, Richard Scamell 1001 - AnsTutors.Com

(1) What is the difference between the conceptual world and the real world? Is it possible for a conceptual model to represent reality in total? Why or why not?

Comments 0 comment

QUESTION: What is the difference between the conceptual world and …

(2) Use examples to distinguish between: a. An object type and an entity type b. An object and an entity c. A property and an attribute d. An entity and an entity instance e. An association and a relationship f. An object class and an entity class

Comments 1 comment

QUESTION: Use examples to distinguish between: a. An object type …

(3) Describe various data types associated with attributes?

Comments 0 comment

QUESTION: Describe various data types associated with attributes? You …

(4) What is the difference between a stored attribute and a derived attribute?

Comments 0 comment

QUESTION: What is the difference between a stored attribute and …

(5) What would be the domain of the attribute County_name in the state of Texas?

Comments 0 comment

QUESTION: What would be the domain of the attribute County_name …

(6) Distinguish between a simple attribute, a single-valued attribute, a composite attribute, a multi-valued attribute, and a complex attribute. Develop an example similar to Figure 2.3 that illustrates the difference between each type of attribute?

Comments 0 comment

QUESTION: Distinguish between a simple attribute, a single-valued attribute, a …

(7) What is a unique identifier of an entity type? Is it possible for there to be more than one unique identifier for an entity type?

Comments 0 comment

QUESTION: What is a unique identifier of an entity type? …

(8) What is the difference between a key attribute and a non-key attribute?

Comments 0 comment

QUESTION: What is the difference between a key attribute and …

(9) Consider the EMPLOYEE entity type given below. a. List all key and non-key attributes. b. What is (are) the unique identifier(s)? c. Which attribute(s) is (are) derived attributes? d. Using the figure in Exercise 9 as a guide, develop sample data for four employees that illustrate the nature of the various mandatory and optional attributes in the EMPLOYEE entity. Be sure to illustrate the various ways the Name attribute might appear.

Comments 0 comment

QUESTION: Consider the EMPLOYEE entity type given below. a. List …

(10) Discuss how to distinguish between an entity type and an attribute?

Comments 0 comment

Question: Discuss how to distinguish between an entity type and …

1
2
…
10
>