Exam 5: Understanding Entity Relations

-No two books in the database:

In Crow's Foot notation,a circle means a cardinality of ______________.

-The number of administrators is:

-Born-in is:

Identification dependency is a type of existence dependency.

-Volume on Consists-of is:

-Any md practices in:

-Written-by is:

-If we want to add the relationship "Published-in" between Book and Country and indicate the number of copies of the book sold (copies-sold)in the countries,copies-sold would be:

A(n)_____________________ relationship represents an association between members of the same set.

Generalization hierarchies must have both disjointness and completeness constraints.

-If there was no requirement to include the areas of countries in the database,cname (country name)could be made:

The relationship(s)that provides the components of a weak entity's primary key is known as a(n)___________________.

To depict a hierarchical chart of accounts in an ERD,you would probably have to use a(n)__________________ relationship.

In Crow's Foot notation,the Crow's Foot (two angled lines and one straight line)means a cardinality of ______________.

In an ERD,a property of an entity type or relationship is known as a(n)___________________.

In Crow's Foot notation,a line perpendicular to the relationship line means a cardinality of ______________.

With regards to a generalization hierarchy,the __________________ constraint means that every entity of a supertype must be an entity in one of the subtypes.

In Crow's Foot notation,the maximum cardinality symbol is placed toward the relationship name,and the minimum cardinality symbol is placed toward the entity type.

In Crow's Foot and most other notations,entity types are denoted by a triangle.