Blog

In a company each Product belongs to exactly one ProductGroup and each ProductGroup might have zero or many Products. Select the figure that most aptly represents this statement.  Please be careful when you select your option. The radio button for the answer choice appears to the left and ABOVE the corresponding image.

A retail business allows customers to sign up for a LoyaltyAccount.Not every customer joins it.But each LoyaltyAccount must correspond to exactly one customer. Please be careful when you select your option. The radio button for the answer choice appears to the left and ABOVE the corresponding image.

        Given the ERD above, select all options that are acceptable ways of adding an associative entity type. Please be careful.  Please be careful when you select your options. The check box for each answer choice appears to the left and ABOVE the corresponding image.

How many required attributes does the following entity type have (including its primary key attribute(s)) anf foreign key attribute(s), if any? You can assume that there are no other entity types for you to consider while answering this question.

In a physical medicine and rehabilitation clinic, patients undergo treatments administered by therapists, and many treatments require specific equipment. A meaningful record of clinical activity must include all three: which patient, which therapist, and which piece of equipment. For example, Patient Alice Gomez might receive ultrasound therapy from Therapist Dr. Liao using the Equipment Ultrasound Machine #3 for 35 minutes. Or Patient Ravi Patel might undergo electrical stimulation therapy performed by Therapist Cynthia Moore using Equipment TENS Unit #12 for 15 minutes. Please be careful when you select your option. The radio button for the answer choice appears to the left and ABOVE the corresponding image.

The diagram below captures the situation where each employee can work on zero or several projects, and each project can have zero or many employees working for it. On the left are several attributes. Match each of them to appropriate entity type on the right. More than one attribute can map to a given entity type. Some items on the right might remain unmatched. 

Given the diagram below, fill in the blank below with the option consistent with the diagram:

Based on the ER diagram below, select the choice that correctly depicts the primary keys for the two entity types.

Given the ERD below, select the correct choice for the number of required attributes (including primary and foreign keys) for the two entity types on the diagram. Please note that the radio button for choosing an option is to the left and slightly above the corresponding diagram. Please be mindful of this as you choose.

 This is a timed test, so you will not have time to look up answers. Study before you take the test.