Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Oakmont & Partners LP has been busy building data models for a number of new clients and Monica is excited to start a new modeling
Oakmont & Partners LP has been busy building data models for a number of new clients and Monica is excited to start a new modeling effort for a local nonprofit that provides assistance to homeless and others in need. She is keen on applying her UML and ERD modeling skills that she acquired while taking a corporate training class taught by Ars Doceo. She knows that the first step in building a conceptual data model is to conduct requirements analysis. So she sets up an interview with Kaileen Ormond, the Director of Social Pedagogy who has been with the organization for over years. To make sure she remembers what is being said, she decides to record the interview. The following is a transcription of part of that recording:
Let me give you a scenario. So last month we took in new homeless individuals and families. After we register them and determine their eligibility to shelters, we assign them to a bed in a common dormitory room in a shelter if they are by themselves or to a small family room if they are a family of five or fewer. If they are larger, then we generally cannot help them and we refer them to social services. Once we assign them to temporary housing we need to record the date of the intake, as they can only stay a maximum of six months we have to see if they can qualify for any government assistance programs such as WIC. Those programs are only accessible to US Citizens or permanent residents; they are not open to asylum seekers or anyone who is undocumented or is on a nonimmigrant visa."
Monica thinks she has enough to develop an initial data model but is reassigned to a new project where her skills in agile business analysis are needed. So you are being asked to jump in and build an initial data model. Your task is to develop a conceptual and then a logical data model for the entities and relationships within the context of the above requirements, along with a full definition of all entities. Be sure to list all your assumptions used in the construction of the data models.
Express the data model in a UML Class Diagram. Use directionality indicators on the labels Add key attributes as appropriate with the stereotype key
To narrow and focus the scope of the model, consider only the specific requirements below. Those are the ones that the conceptual data model expressed in UML must support you may omit any other considerations as this is clearly is very large project. The likely implementation will be a small application, perhaps a web app and this data model will help inform the database design and the user interface.
track the names and key demographic information birthday country of birth, citizenship or visa status of all individuals registered
track immediate familial relationships, eg children son daughter parents, grandparents
track the shelter to which they are assigned and the type of housing bed or family room including address
know when they were registered and when their permit to reside incountry expires
track eligibility for government assistance: while you do not need to address this, how would you manage eligibility for different programs, eg a person might be eligible for one program but not for another
legal representatives hired by or assigned to them. Keep your model to about classesentities
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started