Shared Flashcard Set

Details

Database Systems: Design, Implementationa and Management; 04
Ch4
21
Computer Science
Undergraduate 1
04/30/2015

Additional Computer Science Flashcards

 


 

Cards

Term

Q01:

 

What two conditions must be met before any entity can be classified as a weak entity?

 

Give an example of a weak entity.

Definition
Term

Q02:

 

What is a strong (or identifying) relationship?

 

How is it depicted in Crow's Foot ERD?

 

Definition
Term

Q04:

 

What is a composite entity, and when is it used?

Definition
Term

Q05:

 

Suppose you are working within the framework of the conceptual model in Fig Q4.5.

 

Given the conceptual model:

a.) write the business rules that are reflected in it

b.) indetify all the cardinalities

Definition
Term

Q06:

 

What is a recursive relationship? Give an example.

Definition
Term

Q07:

 

How would you (graphically) identify each of the following ERM components in a Crow's Foot notation?

 

a.) an entity

b.) the cardinality (0,N)

c.) a weak relationship

d.) a strong relationship

 

Definition
Term

Q08:

 

Discuss the difference betwen a composite key and a composite attribute.

 

How would each be indicated in an ERD?

Definition
Term

Q09:

 

What two courses of action are available to a designer encountering a multivalued attribute?

Definition
Term

Q10:

 

What is a derived attribute? Give an example.

Definition
Term

Q11:

 

How is a relationship between entities indicated in an ERD?

 

Give an example using the Crow's Foot notation.

Definition
Term

Q12:

 

Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented.

 

Hint: Think about relationship strength.

Definition
Term

Q13:

 

How is a composite entity represented in an ERD?

 

What is its function?

 

Illustrate the Crow's Foot notation.

 

Definition
Term

Q14:

 

What three, often conflicting, database requirements must be addressed in database design?

 

Definition
Term

Q15:

 

Briefly, but percisely, explain the difference between single-valued attributes and simple attributes.

 

Give an example of each.

Definition
Term

Q16:

 

What are multivalued attributes?

 

How can they be handled within the database design?

 

Definition
Term

Q17:

 

Based on figQ4.17...

 

Write the 10 cardinalities that are appropriate for this ERD.

 

Definition
Term

Q18:

 

Based on figQ4.17...

 

Write the business rules reflected in this ERD.

Definition
Term

Q19:

 

Based on figQ4.17...

 

What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer.

Definition
Term

Q20:

 

Based on figQ4.17...

 

Describe precisely the composition of the DEPENDENT weak entity's primary key. Use proper terminology in your answer.

Definition
Term

Q21:

 

The local city youth league needs a database system to help track children who sign up to play soccer.

 

Data need to be kept on each team and the children who will be playing on each team and their parents.

 

Also, data need to be kept on the coaches for each team.

 

Draw the data model described below:

 

Entities required: Team, Player, Coach, Parent

 

Attributes required:

 

- Team:

Team ID number, Team name, Team colors

 

- Player:

Player ID number, Player first name, Player last name

 

- Coach:

Coach ID number, Coach first name, Coach last name, Coach home phone number

 

- Parent:

Parent ID number, Parent last name, Parent first name, Home phone number, and Home address (street, city, state, and zip code)

 

The following relationships must be defined:

- Team is related to Player

- Team is related to Coach

- Player is related to Parent

 

Connectivities and participants are also defined as follows:

- A Team may or may not have a Player

- A Player must have a Team

- A Team may have many Players

- A Player has only one Team

- A Team may or may not have a Coach

- A Coach must have a Team

- A Team may have many Coaches

- A Coach has only one Team

- A Player must have a Parent

- A Parent must have a Player

- A Player may have many Parents

- A Parent may have many Players 

Definition
Supporting users have an ad free experience!