With this project, you will be required to apply the information that you acquired
from this Unit readings to assist you in designing a relational database.
For the purposes of this project, choose from one of the following agencies as your reference group for whom you will develop the proposal:
Ø a sheriff’s department with less than 75 employees,
Ø a municipal court in a county with a population of approximately 100,000,
Ø a medium-security transitional center with 500 beds, or
Ø a juvenile probation office in a large metropolitan community.
Once you have chosen your model agency, consider the following items.
Ø Your chosen agency has recently created a specialized unit within its information technology department.
Ø You are the database administrator (DBA) who supervises that specialized unit.
Ø 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.
Ø 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.
Ø Identify the agency you chose.
Ø Prepare a brief summary of the types of relations that are represented in the proposed database you are creating.
Ø 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.
§ Note: When using the diagram options in the Microsoft Office programs, you have to be careful to make sure that the diagram is not distorted as spacing changes throughout the document. Be sure to use a hard page break to prevent the graphic from moving from its own dedicated page. You may consider presenting this as an appendix in the document, but be sure in either case to review the relevant APA guidelines about proper formatting of tables, graphs, and appendices.
§ You may find it helpful to include the graphic among the narrative if the writing makes frequent reference to that graphic—explore the various options for positioning text around an image for the desired effect.
§ For conceptual guidance, you can refer to the Murthy “Project” chapter and the Teorey, Lightstone, and Nadeau reading in its entirety.
Ø Prepare a section that contains a discussion that identifies potential obstacles or challenges associated with implementation of the proposed database (e.g., end-user concerns, cost, and implementation timeframe). Be sure to include proposed measures to address these issues associated with implementation and proposed measures to ensure scalability or expandability of the database that address future organizational needs.
Ø All sources (including any images used) must be cited and referenced appropriately.
All components of this assignment should be composed in a seven page paper (not counting title page, reference page, graphics, and any appendices you may add). You must use a minimum of three scholarly sources beyond your textbook. All sources used, including the textbook, should be cited and referenced appropriately.