Database Design Project

choose from one of the following agencies as your reference group for whom you will develop the proposal, g a sheriffs department with less than 75 employees, g a municipal court in a county with a population of approximately 100,000, g a medium-security transitional center with 500 beds, or g a juvenile probation office in a large metropolitan community. Once you have chosen your model agency, consider the following items. 03 Your chosen agency has recently created a specialized unit within its information technology department. 03 You are the database administrator (DBA) who supervises that specialized unit. 03 The sole purpose of the newly created unit is to organize the numerous types of data that are utilized by the agency into one database. 03 The secondary objectives of the new unit are to ensure that the created database meets the needs of the agency, is user friendly, is expandable, and is capable of addressing future organizational needs. Your assignment is to develop a proposal for a database system that will include the following components. g Identify the agency you chose. 03 Prepare a brief summary of the types of relations that are represented in the proposed database you are creating. 03 Prepare a visual representation (graphical depiction or flow chart of the information pathways) of the proposed database design. This can be accomplished by using the drawing or diagram options provided in programs such as Microsoft Word, Excel, and PowerPoint.