computer science assignment

Q01: What two conditions must be met before any entity can be classified as a weak entity? Give an example of a weak entity.
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	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
Term Q08: Discuss the difference betwen a composite key and a composite attribute. How would each be indicated in an ERD?
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.
Term Q13: How is a composite entity represented in an ERD? What is its function? Illustrate the Crow's Foot notation.
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.
Term Q16: What are multivalued attributes? How can they be handled within the database design?
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.
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.
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