Case Background
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 non-profit 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 18 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 132 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 non-immigrant 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.
Problem 1 : Conceptual Data Model in UML
Express the data model in a UML Class Diagram using LucidChartLinks to an external site.. Label the relationships where useful. 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, e.g., 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 in-country expires
track eligibility for government assistance: while you do not need to address this, how would you manage eligibility for different programs, e.g., a person might be eligible for one program but not for another
legal representative(s) hired by or assigned to them
If there are unresolved questions from the notes, post your question on Teams and incorporate the new findings into your model. You may discuss the problem and share insights with your peers in the class but you must build and submit your own model. Keep your model to about 6-8 classes/entities.
Problem 2 : Logical Data Model as ERD
After you have built your conceptual data model as a UML Class Diagram, create (in a separate page/tab), an Entity-Relationship Digram (ERD) in the IE (Crow's Feet) Notation of the same entities, i.e., "translate" the UML to and ERD. This may not always be done in practice, but we want you to practice using both notations.
Drawing on my expertise in UML and ERD modeling, I am well-equipped to address the specific requirements outlined, such as tracking individual demographic information, familial relationships, shelter assignments, and government assistance eligibility. My meticulous approach will ensure a comprehensive data model, supporting the likely implementation of a small application or web app. I look forward to delivering a robust solution and welcome any collaboration to refine the models as needed.
Drawing from a year of experience in data science and my familiarity with MySQL, I am ideally positioned to tackle your project head-on. Building a conceptual data model, as well as a logical data model in the context of the requirements you've outlined, are tasks I am well-versed in. My proficiency in UML Class Diagram using LucidChart and Entity-Relationship Diagram will see me value-add by displaying meaningful relationships between the required entities, such as tracking demographic information of individuals registered, familial relationships, housing assignment details, and more.
As we delve deeper into your project needs, my strong background in Statistics and Data Science combined with my programming skills in Python and R will be incredibly advantageous. It will allow us to not only capture key attributes but also manage eligibility for different government assistance programs which is an integral part of your project requirements. Additionally, I'm experienced in working with large datasets and can use SQL effectively for streamlined database management.
In conclusion, hiring me would grant you not just superior technical skills but also the promise of diligent collaboration, an unwavering commitment to success, and adaptability to new techniques and technologies. I look forward to tackling this challenge together and fostering long-term success for Oakmont & Partners LP's endeavors with local non-profit organizations. Let's get started!
Combining my five years of experience as a Full Stack Web Developer with your need for a Conceptual and Logical Data Model, we can create something truly exceptional for Oakmont & Partners LP. My expertise in PHP, Laravel, WordPress, Cake PHP, and Codeignater makes me uniquely qualified to develop the necessary Custom Database backed by MySQL.
Moreover, my familiarity with Agile business analysis methodologies will prove beneficial in tailoring the data models to align perfectly with your Project Manager's expectations. Having worked on numerous web applications before specifically related to database management systems, I understand that user interface and database design are two integral components of software development. Thus, delivering not just a data model but also a roadmap for the likely implementation of this small application is well within my purview.
To add to your peace of mind, my 24 X 7 availability comes coupled with one year of customer support ensuring that even after our collaboration ends, I'm available for any understanding or minor tweaks that might be required. Moreover, quick turnarounds without compromising on quality is a strict policy I follow, so consider your project in safe hands. Let's get started and build an innovative UML Class Diagram using LucidChartLinks that will lay the foundation for Oakmont & Partners LP's new endeavor!
With over a decade's worth of experience in database programming, specifically specializing in MySQL, I am confident that I am the ideal fit for your project -- Database Management System. My proficiency spans across all aspects of data management from logical and conceptual modeling to database design. As a Bonus, I also bring substantial knowledge in utilizing UML and ERDs to map and construct schemas - skills that indeed resonate with this project.
Your project description underscores the need for a detailed understanding of individual's information like demographics, registration dates, asylum status & government program eligibility tracking - all requiring complex data structures and relationships. This is my forte. Having built numerous data models for projects (both small and large), I have fine-tuned the art of shaping complex and real-world conditions into efficient schema designs. I can guarantee a model that organizes your entities with precision, enhances easy retrieval of information while keeping it scalable enough to cater to your prospective web application requirements.