Part 1: Answer the Module Review Questions listed below. These questions were chosen to demonstrate your understanding and help you assess your progress.
1. Provide three different options that are available when selecting an identifier for a student entity. What are the pros and cons of each choice?
2. 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
3. Summarize the distinctions between the analysis phase and the design phase of the SDLC.
4. 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.