Part 1: Answer the Module Review Questions listed below. These questions were chosen to demonstrate your understanding and help you assess your progress.
- Provide three different options that are available when selecting an identifier for a student entity. What are the pros and cons of each choice?
- Define what is meant by an entity, attribute, and relationship in a data model. How should they be named? What information about them should be stored in the CASE repository? You may use a table to report your answer, or break it down into entity, attribute, and relationship
- Summarize the distinctions between the analysis phase and the design phase of the SDLC.
- Describe the primary activities of the design phase of the SDLC.
Part 2: Module Practice:
Design a database structure that captures/tracks information of researchers within all universities in a given state. Information of interest includes researcher name, title, position; university name, location, enrollments; and research interest. Each researcher can only be associated with one university, and each researcher may have one or more research interest.