You should select a data storage problem of your interest and identify the various pieces of data that;should be stored in a database.;Make sure that your Term Paper follows the following format/outline;1) Term Paper Abstract;2) Purpose and goal of the project;3) Users and administrators;4) How is this work being done now, without the database and how will the database specifically improve;the process;5) Data elements to be involved: entities, attributes - High Level;6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and;prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS;Access);7) Take the database through the normalization process and design the actual database tables.;8) Do include the functional dependency analysis;9) Do include any Primary and Foreign Key designation, as needed, as well as an explanation of why you;designated them as such.;10) Document the whole process and information in MS Word document. Especially make sure that you;include the description of the various entities, attributes in detail, their inter-relationship and the way the;database is going to be used.;You should submit your term project proposal in Week 6 for approval by the instructor and submit the;completed work in the final week in a Word Document (1,000 word minimum) Relevant parts of the;Project Proposal may be incorporated in the above outline, modified from earlier versions/submissios as;needed;Thanks and good luck!;Submission;To submit your assignment, enter text in the Submission Text box below and/or attach one or more;files and then click Submit. Save your work frequently.;An * designates a required field.;1) Name and main idea of the project ? Ticketing system for IT issues;2) Purpose and goal of the project ? to better organize data from current ticketing system;3) Possible users and administrators ? Helpdesk personnel run/manage the database;4) How is this work being done now, without the database and how will the database specifically;improve the process. The helpdesk uses an excel spreadsheet to capture IT tickets. Using a;database will clean up and organize the data used to track tickets;5) Data elements to be involved: entities, attributes;6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of;use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle;or remain in MS Access);Computer Ticket Growth;Today the topic that was chosen to write about was the computer ticketing growth of an;information technology company. This was chosen due to the company having issues with their;current in place ticket tracking system. The manager of the company would like to have a more;efficient way of collecting data for his workers on the helpdesk at his company. The manager;would like to move away from using Microsoft Excel and utilize Microsoft Access. He believes;this will speed up the process of manipulating data that is creating by his workers. It will also;help to search and find data that is already in the system.;The main project idea is the management of computer ticket data growth for companies;utilizing an excel spreadsheet to capture Information Technology tickets. Managing data growth;and at the same time improving administrative efficiency requires a lot of work on the help;desk?s part making initial inputs and updates to the database. The users would be the workers of;the organization and would have a database administrator solely managing the database.;This manager would ask for feedback from the database workers on issues with the;database, taking ideas that would make the database run faster and more resourcefully. The;database would improve the process by speeding up query times when the users need to pull;information for a customer or for statistical data on any tickets that were open or on hold. This;will speed up the process by converting the data to a Microsoft Access database to organize the;information within the database. This will increase productivity because the workers will have;the capability to search and find new and old tickets promptly. Then the workers can work on;the ticket that was found and help the customer and cut down on time that is normally wasted;searching for that specific ticket.;Entities would be one of the main data elements that would be used in the database. The;entities will be used to identify and describe all pertinent data, such as customer, what type;computer issue, and resolution used by the organization applications. It is important because the;resolution entity can be re-used with the different types of tickets or tickets with the same issue.;When using an entity with a ticket, it can create elements and use them within the data entity.;Attributes will help to make the database more efficient. This will alleviate any inconsistencies;in the table making it easier to search and find data concerning tickets.;Microsoft Excel is what the company is currently using to capture all of their work-related data.;Excel is causing a lot of inconsistencies when searching for tickets. Some workers have inputted;tickets incorrectly and it is causing erroneous data, make the task of searching for documents;very time consuming. The data will then be converted over to Microsoft Access. The database;could be transferred over to MS SQL, if a more hearty application is needed, but will try Access;first.
Paper#70359 | Written in 18-Jul-2015Price : $22