Database OptionsAs you start to think about how the One-Stop Center is going to develop a new data management system (as described in the multimedia piece in the Studies for this unit), the first things you have to consider are databases and database design. You have been learning more about different data models for databases: relational models, entity relationship models, object-oriented and extended relational models, and NoSQL models.After all of this research, for this assignment, describe the data model you think would be the most appropriate for the One-Stop Center.Justify your decision by responding to the following:Explain why the flat file currently being used is not effective.Describe the differences between the various data models. Which differences matter for the One-Stop Center’s needs?Explain why you think the data model you selected is most appropriate for the One-Stop Center. In your explanation:Describe the data that could be used.Describe how a database would store that data.Support your position by citing scholarly articles or textbooks.Assignment RequirementsWritten communication: Written communication should be free of errors that detract from the overall message.Writing style: Present the content of this assignment in a paragraph format that includes transitional phrases, headings to define document sections, appropriate subheadings, and references.References: Make sure to include references for all information that is not your personal idea. en things out.The piece on KCCO last week was troubling; they talked to several of our program participants who’d had very bad experiences with our case managers. Several of the CMs just weren’t familiar with the clients and their needs or cases. And that was on top of the troublesome high turnover rate we see in CMs.That hews pretty closely to the stories that ran in the Trib— they found a couple of participants who said their CMs weren’t letting them know about available services or even jobs. And then the guy from Vang Fabrication saying a big part of why they moved their whole business out of Riverbend City was because they couldn’t find enough workers who were English-Spanish bilingual!!! We’re in a Latino neighborhood and ESL classes are one of our primary offerings! That should have been an easy win, not a source of egg on our faces.It seems to me like everything went to hell after we switched to our new participant management system; I know you expected that to make everything better, but it seems to have dropped us off a cliff. I need you to get to the bottom of this. There has to be a deeper problem here. Oh, and by the way — adding to the fun, the state department of economic development has asked for a demonstration of the effectiveness of the case management program as a stipulation before renewal of their grant funding.Could you get out on the floor and talk to some CMs, see if you can get a handle on what’s going on? Looking forward to hearing your results.ThanksScene 2One-Stop Center Board RoomNow you should talk to some case managers to hear about the problems they’re having.Kim CohenCase ManagerAs a case manager, I think things have gotten a lot worse since we’ve started these half-baked efforts to modernize our participant files. I think that’s where it all went wrong. I’ve been here since the early ‘90s, and we always used to just have a paper file for each participant. And it worked great! You’d just walk over to the filing cabinet, pull their file, and know everything you needed to know. Sure, sometimes a file would get buried on someone’s desk or wind up in the wrong drawer… but it didn’t happen often, and for the most part the system worked.I know that now everything has to be on computers. But ugh, I hate having to mess with the system now. I have all kinds of problems finding participants’ files! Say their name’s “James” and the file’s under “Jim,” the search won’t pick it up. Or it’s a Latino name with an accent mark, that throws the search all the time. And then a bunch of the time you search the system and find like six files for the same person, and they all have bits of info in them that don’t quite match up.Or you get into the file, and you know it’s the right file, but it’s still like digging around through a junk drawer! All the information is just kind of dumped into there as text, just jumbled up. Job skills, work history, client notes, all just on top of each other until it feels like you need to read a 15-page document just to find the right info. It’s a mess, and I don’t know how it would ever not be a mess. No wonder people are falling through the cracks here, we can barely do our jobs! Honestly, some days I think about retiring early.Lydia RobbinsCase ManagerOh, geez, I’m glad you asked. Things have gotten really bad this year, I feel like we’re all just dropping the ball left and right, participants just seem like they’re walking out of here with steam shooting out of their ears.Time after time, somebody will come in for a consultation and just sit there looking upset while I fumble around trying to find their file in the system. They come in for intake and we get all their info, and then when they come back for later appointments we end up having to ask for it all again because we can’t find it or it’s in the system wrong. And if you’re talking through someone’s skills and work history, that takes a while! They get frustrated, we get flustered, stuff just slips through the cracks all the time. It’s awful.And that’s when the system works! It’s not too rare for me to lose a whole day of work to just ticky-tacky little tech problems. I get locked out of the system for some reason and need to have Bob log into his admin console and reset me. It can take forever! Or some days I just keep getting these messages telling me that the database connection got dropped. I don’t know what that means, or what I can do to stop it. I think a system like this might make sense at a bigger place with a full-on IT department. Us, well, Bob’s good with computers, but there’s a big difference between having one guy on staff who kind of knows what’s up and having an actual IT department.Nathan WilliamsCase ManagerYou know what? I can tell you a story that’s a perfect encapsulation of everything that’s been going wrong. Does the name Jose Gomez ring a bell? He registered late last year, I think Kara Watson did his intake and was assigned as his case worker. Then she left for another job and his file just sat unassigned in the system. He came in again to check in—Kara had told him to— and he got a second file that didn’t list his skills or anything.We had this standing request from Vang Fabrication for bilingual employees with machine press experience, *exactly* what Jose had. But the file people were seeing when he came in the second time didn’t show any of that, and nobody really bothered to double-check, so nobody ever told him about it. Or did anything, really, but tell him to come back again later and maybe sign up for a coaching class. Poor guy ended up losing his house! I found him when I was doing a different search in the system and stumbled across his first record, the complete one; I called him to see how he was doing, he told me he and his wife and kids were staying with his brother while they were wait-listed for public housing. Man, did he tell me off. And he had a right to! I couldn’t even try to link him up with the Vang job, since they’d relocated their entire plant by then.It’s just no good.