Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Match the following terms and definitions, -composite attribute a uniquely identifies entity instances associative entity b. relates instances of a single entity type _unary

image text in transcribed
image text in transcribed
2. Match the following terms and definitions, -composite attribute a uniquely identifies entity instances associative entity b. relates instances of a single entity type _unary relationship c. specifies maximum and minimum number of _weak entity instances attribute d. relationship modeled as an entity type _entity e association between entity types relationship type f. collection of similar entities cardinality 8. number of participating entity types in relationship constraint h. property of an entity degree i can be broken into component parts identifier depends on the existence of another entity type Lentity type k relationship of degree 3 temary many-to-many unary relationship _bill-of-materials m person, place, object, concept, event 4. Give three reasons why many system designers believe that data modeling is the most important part of the systems development process 6. Explain where you can find business rules in an organization 12. Give an example, other than those described in this chapter, of a weak entity type. Why is it necessary to indicate an identifying relationship? 13. What is the degree of a relationship? List the three types of relationship degrees described in the chapter and give an example of each 4. Consider the two E-R diagrams in Figure 2-24, which repre- sent a database of community service agencies and volun- teers in two different cities (A and B). For each of the following three questions, place a check mark under City A, City B, or Can't Tell for the choice that is the best answer. FIGURE 2-24 Diagram for Problem and Exercise 4 City B VOLUNTEER Assists 0-4 VOLUNTEER AGENCY AGENCY City B City A Can't Tell a. Which city maintains data about only those volunteers who currently asist agencies? b. In which city would it be possible for a volunteer to assist more than one agency? c. In which city would it be possible for a volunteer to change which agency or agendes he or she assists? 5. The entity type STUDENT has the following attributes Student Name Address, Phone, Age, Activity, and No of Years Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity Draw an ERD for this situ ationWhat attribute or attributes did you designate as the Identifier for the STUDENT entity? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

10 ACT Practice Tests

Authors: Steven Dulan

2nd Edition

978-0071591461, 007159146X

More Books

Students also viewed these Finance questions

Question

What is the difference between outlay cost and opportunity cost?

Answered: 1 week ago