Entity Relationship Diagram Worksheet

ERD stands for Entity Relationship Diagram.

• true

• false

A tree can have many apples. An apple can belong to only one tree. This is an example of a(n)

• one to many relationship

• one to one relationship

• many to many relationship

• one to optional relationship

The one to many relationship can best be described as a

• business relationship

• nuclear family relationship

• Parent - Child relationship

• Parent - Parent relationship

A tree can have many apples. An apple can belong to only one tree. These two statements are examples of ...

• business rules

• entity mapping

• presumptive modelling

• Horticulture database standardization(HDS)

If two tables have the same primary key then it is mostly likely

• one to one relationship

• one to many relationship

• many to many relationship

• a violation of referential integrity

When creating a new table that solves the many-to-many relationship issue, which option below is a good way to handle the primary key?

• use two or more fields to create a composite primary key

• use the first field to create the Primary Key

• use a non-key attribute as the primary key

• you don't need to have a primary key in this table

The many cardinality symbol always...

• comes off the table with the foreign key

• comes off the table with the primary key

• comes off either table at the discretion of the developer

• indicates the one side of the relationship

What dictates the kind of value that can be used for a specific column?

• data driven

• data scale

• data type

• data precision

All datatypes have the same name in all databases and therefore are always compatible.

• yes

• no

• As long as the option for "convert to other DBMS" is checked on the server.

The SET command is used in conjunction with which SQL command?

• DELETE

• UPDATE

• CREATE

• INSERT INTO