Chapter questions

User Generated

Bf__33

Computer Science

Description

please answer any five questions from the attachment







Unformatted Attachment Preview

QUESTIONS 1. Provide three different options that are available for select- ing an identifier for a student entity. What are the pros and cons of each option? 2. What is the purpose of developing an identifier for an entity? 3. What type of high-level business rule can be stated by an ERD? Give two examples. 4. Define what is meant by an entity in a data model. How should an entity be named? What information about an entity should be stored in the CASE repository? 5. Define what is meant by an attribute in a data model. How should an attribute be named? What information about an attribute should be stored in the CASE repository? 6. Define what is meant by a relationship in a data model. How should a relationship be named? What information about a relationship should be stored in the CASE repository? 7. A team of developers is considering including 'warehouse" as an entity in its data model. The company for whom they are developing the system has just one warehouse location. Should "warehouse" be included? Why or why not? 8. What is meant by a concatenated identifier? 9. Describe, in terms a businessperson could understand, what are meant by the cardinality and modality of a rela- tionship between two entities. 10. What are metadata? Why are they important to system developers? 11. What is an independent entity? What is a dependent entity? How are the two types of entities differentiated on the data model? 12. Explain the distinction between identifying and noniden- tifying relationships. 13. What is the purpose of an intersection entity? How do you know whether one is needed in an ERD? 14. Describe the three-step process of creating an intersec- tion entity. 15. Is an intersection entity dependent or independent? Explain your answer. 16. What is the purpose of normalization? 17. Describe the analysis that is applied to a data model in order to place it in first normal form (INF). 18. Describe the analysis that is applied to a data model in order to place it in second normal form (2NF). 19. Describe the analysis that is applied to a data model in order to place it in third normal form (3NF). 20. Describe how the data model and process model should be balanced against each other. 21. What is a CRUD matrix? How does it relate to process models and data models?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello buddy, see the attached assignment. I...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags