Diagram characteristics(custom)

Question 1

What is this relationship cardinality called?

Answer 1

Mandatory one

Question 2

what is this relationship cardinality called?

Answer 2

Mandatory Many

Question 3

What is this relationship cardinality called?

Answer 3

Optional one

Question 4

What is this relationship cardinality called?

Answer 4

Optional Many

Question 5

Inside an entity box such as the one shown, how do we represent normal identifiers

Answer 5

with an underline and bolding

Question 6

Inside an entity box such as the one shown, how do we represent partial identifiers

Answer 6

we use bolding and double underlining

Question 7

Inside an entity box such as the one shown, how do we represent optional attributes

Answer 7

Most likely we apply no formatting

Question 8

Inside an entity box such as the one shown, how do we represent derived values?

Answer 8

An attribute that is calculated from other attributes, like “age” which can be calculated from a person’s “date of birth”.

with square brackets [ ]

Question 9

Inside an entity box such as the one shown, how do we represent multi-valued attributes?

Answer 9

An attribute that can hold multiple values for a single entity, like a “skills” attribute for an employee which could list several different skills.

with curly braces { }

Question 10

Inside an entity box such as the one shown, how do we represent composite values?

Answer 10

An attribute made up of multiple smaller attributes, like an “address” which can include “street”, “city”, and “state”.

with parenthesis ( )

Question 11

What does a weak entity look like?

Answer 11

A weak entity is an entity in a database that can’t be uniquely identified by its own attributes

Notice: has an outline