Access 2016 database system, System Analysis and Design (2 pages)

timer Asked: Oct 17th, 2018
account_balance_wallet $25

Question Description

Last time, you wrote me a paper about the Proposal of Process and System Investigation . Now, I need you write 1 page of the Executive and 1 page of the Introduction for System Analysis and Design. I have attached the paper that I completed for last time, you can read to understand more about this project. Then write me a paper (2pages) with Executive and Introduction. If you have any questions, feel free to ask me. I need an expert in Access, they know exactly what should do.

Unformatted Attachment Preview

Executive Summary This report is a project proposal for the Texas State Aquarium Wildlife Rescue Center where the staff intake and care for cold-stunned sea turtles. The proposal is aimed at providing details about the new proposed Microsoft Access 2016 database that will help the firm meet its objectives better. The firm needs an electronic system that will facilitate quick data entry and data look-up on the turtles and that also produces reports to aid in analysis. The firm is currently using a hand written paper form that is tedious and prone to errors. The proposal is targeted at the top level management of the Texas State Aquarium Wildlife Rescue Center. The proposal is divided into four major sections including introduction, process and system investigation, technology and finally implementation schedule and plan. 1 Introduction Every year the Texas State Aquarium Wildlife Rescue Center has been involved in rescuing ill and injured animals including Sea Turtles. The firm has put in several efforts to ensure protection of sea turtles when cold-stunning season is in effect and also to takes care of the injured turtles. To support this initiative, Texas State Aquarium Wildlife Rescue Center also collaborates with other people to help achieve their mission of saving as many sea turtles as they can. While the rescue center is doing a great job right now, they are currently looking to improve upon their recent success by updating their information system. The Texas State Aquarium Wildlife Rescue Center currently uses handwritten forms to collect and store all of their information on the sea turtles brought into their care. For instance, all details regarding the collected turtles are all fill out by hand on the forms and later entered into the system. It is a tedious process and also easy to get wet and soiled in the aquatic environment. As a result, this proposal aims to provide a solution to the Texas State Aquarium Wildlife Rescue Center in terms of handling its activities related to taking care of the different species of sea turtles. The proposal is about an electronic database system that will help facilitate automated capturing and processing of the collected data. An automatic system is essential to facilitate data entry and organization. Concerning the proposed system, this proposal seeks to fulfill the various objectives of the new system. The objectives are to facilitate a quicker intake of details and to produce reports concerning the analyzed information of the sea turtles. The need for the new system comes as result of a meteoric rise in the number of cold-stunned sea turtles. It is important to note the destruction is mainly due to increased human activities. The proposed system will facilitate easier retrieval of information thanks to the capability to produce reports and the data lookup function. This system should meet the current needs of the Texas State Aquarium Wildlife Rescue Center. The new proposed system will be created using Microsoft Office Access version 2016. Process and System Investigation Business Operations With the assistance of the National Park Service, the Texas State Aquarium Wildlife Rescue Center has been rescuing cold-stunned turtles that have been collected from the Gulf Coast shores between North Beach and Naval Air Station Corpus Christi. During the 2017-2018 cold-stun season, the Rescue Center received about 1,300 sea turtles, which was much more than the previous year. Currently, the staff receive each turtle with a partially filled Sea Turtle Stranding and Salvage Network Stranding Report (STSSN) paper form in which the staff begins the process of intaking the turtles. An STSSN form is unique to each turtle and will have the name and personal information that rescued the turtle. Each turtle is scanned for a Pit Tag; if one is not present, one is inserted into the turtle for future identification purposes. Each turtle is also assigned an internal intake number that is used to keep a 2 running total count of turtles that come through the center. This identifier, the TSA Identification accession number (TSA ID#), is created using year-turtle number (ex. 2018-003). The turtle is also assigned a Stranding number that consists of the stranding date beginning with the year, month, day, the rescuers first, middle and last initial, and the rescuers turtle number of that specific day which is located on the STSSN form. The turtle is then given a complete physical exam which includes measuring the size and weight, whether fibropapillomatosis (FP) is present, sex, and if any wounds or abnormalities are found. It is difficult at this point to determine whether the turtle is alive if there is lack of any movement or if the turtle has a blink or tail reflex. The staff will make a Dead on Arrival (DOA) decision after a period of about 12 hours has passed post intake of the turtle; rigamortis would more than likely have set in if the turtle was DOA. Once a number of turtles have been pit tag scanned, the file would then be exported to a CSV file. The exporting procedure has since been updated, and will be exported as an Microsoft Excel file. All the information is transferred to the STSSN form, including any notes of any minor procedures that were done during the exam. An Excel master spreadsheet is kept which is comprised of the pit tag #, TSA ID#, weight, temperature, FP status, critical status and if found in Texas; notes are entered on some turtles, if time permits. The weight and temperatures are only taken on 10% of the turtles that arrive within a group. Once the turtle has been examined, there are three main criteria that is used to determine which tank the turtle will be placed: ● Fibropapillomatosis (FP) status ● Size ● Swim test The criteria used for tank placement begins with the presence of FP since the center is separated into positive tanks and negative tanks to keep these turtles separated because the FP virus is contagious. It is very important that turtles that are FP positive remain separated from FP negative turtles during the rescue process. The next criteria that is used for placement is the size of the turtle. Turtles range in size from a frisbee to a tire (National Park Service, 2018). It is not advised to keep the smaller turtles with the larger to ensure a successful rescue. The swim test is used to determine whether the turtle is capable of swimming since some turtles have injuries, abnormalities, restrained by debris or are so cold-stunned that they cannot swim. Taking these criterias, an example of a rescued turtle can be as follows: FP positive, weighs 35 pounds and cannot swim. For numerous reasons, this turtle cannot not be placed into a tank that contains turtles the are FP negative, weigh 3 pounds and can swim. For any DOA turtles, a separate paper form must be manually completed with the Date, Time, Stranding Number and STSSN form fields. After the turtles have been rehabilitated, they must be released back into 3 the bay. Upon release, the Cooperative Marine Turtle Tagging Program (CMTTP) Tagging Data Form (release form) must be completed and mailed to two different addresses. Current System Analysis The analysis of the current system of the rehabilitation process of the cold-stunned turtles that are brought to the wildlife rescue lacks efficiency, accuracy, flexibility and use of available technology for producing reports. The first disadvantage the staff faces is the fact that most of the STSSN paper forms that are acquired with each turtle are wet and soiled because these sheets are started in the field by those that are rescuing the turtles from the Gulf Coast shores. A new, clean sheet must be created for each turtle after the intake process is done because of the aquatic environment since all the STSSN forms must be sent to the National Oceanic and Atmospheric Administration (NOAA) in order for the turtles to be recorded and tracked. In having minimal staff, having to handwrite forms for every turtle that comes into the facility requires much time and effort to ensure that all the correct information is filled for each turtle. It took approximately six months to complete all the STSSN paper forms to send to NOAA for the 2017-2018 cold-stun season because of the large number of rescued turtles. Unfortunately, a CMTTP release form was not completed for every turtle due to time restraints. Although the record of pit tag numbers scanned can be exported to an Excel spreadsheet, a staff member still has to manually enter data into the master Excel spreadsheet. The master spreadsheet only includes pit tag #, TSA ID #, weight, temperature, FP status, critical status, if found in Texas and notes on some turtles. The challenge is lack of accuracy of the information recorded into the master spreadsheet and the proper forms, making it prone to errors. After intaking large numbers of turtles, the staff found it difficult to record all appropriate information and notes due to fatigue. The current system also faces a challenge of rigidity. If a paper form is not properly filled, then another must be created. The simple lack of flexibility is frustrating and further complicates the rehabilitation process for the staff members. Report production is non-existent within the wildlife center since there is no software system in place at this time other than the master spreadsheet that only captures a few fields. A simple report to show turtles by tank or all the STSSN information by pit tag cannot be produced by the staff with the little information that is being entered into the master spreadsheet. Not knowing the efficiency of the rehabilitation process limits the decision making of making changes, which could directly impact the amount of released turtles back into the Gulf in the best rehabilitated condition possible. Proposed System Analysis 4 The proposed system, Turtle Management Number Tracker (TMNT), allows for collection of large amounts of information because it does not require doing the same work of entering the stranding data twice since the STSSN fields will be populated into the system and the form will be printed out once all the required fields are filled. Just by not having to redo an STSSN sheet for every turtle will make the rehabilitation process more efficient. All the data will be kept organized and secure where any staff member can look up specific data. The TMNT ensures accuracy because once errors are identified, the data can be changed at any time. The ease of use and understanding of the proposed system can be operated by staff after attending a training session of the system which incorporates the use of the training manual provided. If additional assistance is needed, one or more of the team members can be requested to be on site to ensure proper use of the system. The TMNT introduces flexibility to the rehabilitation process by saving all the data collected for the turtles in one location that can be manipulated to not only produce reports, but to produce ready-to-print pre-filled forms, such as the STSSN form, that must be mailed to several entities in paper form. Data manipulation and analysis capabilities allow for the production of customized reports that will allow the staff to evaluate the progress of their rehabilitation efforts. Another advantage of the new proposed system will be cost effective since the software needed, Microsoft Access 2016, comes with an affordable price shown in Exhibit 1. The system requirements on a pc are minimal also, which are shown in Exhibit 2. Another reason for cost effectiveness is the staff will minimize their work hours on paperwork, giving them more time to care for the cold-stunned turtles and other marine animals that come into the facility. The allocation of working hours must be shifted to the care of these animals, especially the turtles since the recovery efforts of all those involved in trying to remove the sea turtles off both the state and federal endangered species list have proven to be successful. This counts for the recent increase in numbers of cold-stunned turtles this past season. They are increasing because the juvenile population in Texas has increased, and they live here all year long and the severity and duration of winters in this area have also increased. (National Park Service, 2018). Technology ● ● ● Computer capable of running Microsoft Access and Microsoft Excel 2016 (System requirements below) Home Again Microchip scanning system for pit tags Pit tags 5 ● Printer for reports Implementation Plan and Schedule 09-18-2018: Phase I: System analysis and design 09-19-2018: DFD/ ERD Design 09-27-2018: Interface Design 10-02-2018: Interview with staff 10-08-2018: User Profiles 10-09-2018: Interview with staff 10-14-2018: System Analysis and Design final review 10-23-2018: Presentation of system analysis and design 10-24-2018: Phase II: System development 10-25-2018: Create tables in Access database 10-28-2018: Create relationships in the database 10-30-2018: Create forms to be used for Reports 11-04-2018: Development of switchboard begins 11-10-2018: Make final preparations for testing 11-20-2018: Internally test the system and debug 11-24-2018: Develop training manual for staff 11-27-2018: Phase III: Delivery 11-27-2018: System installation, final testing, and training for on-site staff Value Proposition Here at Tarpon Software Solutions our goal is not only to make a system that anyone can use, but will love to use because we want you to have the time and energy to focus on what matters most...the sea turtles. We are here to rekindle the passion in saving the turtles since the numbers are projected to rise every year according to the National Park Service. Appendix Exhibit 1: Cost of products Product Office 365 Business Price $99/yr or $8.25/mo. Services Included OneDrive 6 Office 365 Business Premium $150/yr or $12.5/mo. OneDrive, Exchange, SharePoint, Skype, Microsoft Teams *Licensing for 5 pc’s/5 tablets/5 phones Exhibit 2: PC standard requirements for Microsoft Access 2016 Required Processor 1 gigahertz (Ghz) or faster x86- or x64-bit processor with SSE2 Required Operating System Windows 7 or later, Windows 10 Server, Windows Server 2012 R2, Windows Server 2008 R2, or Windows Server 2012 Required Memory 1 GB RAM (32 bit); 2 GB RAM (64 bit) Required Hard Disk Space 3.0 GB available disk space Required Display 1024 x 768 resolution Graphics Graphics hardware acceleration requires a DirectX 10 graphics card. Multi-touch A touch-enabled device is required to use any multi-touch functionality. However, all features and functionality are always available by using a keyboard, mouse, or other standard or accessible input device. Note that new touch features are optimized for use with Windows 8 or later. Additional System Requirements Internet functionality requires an Internet connection. Microsoft account required. References Sea Turtle Rescue and Recovery. (n.d.). Retrieved from 7 Cold Stunned Sea Turtles. (n.d.). Retrieved from ...
Purchase answer to see full attachment

Tutor Answer

School: University of Virginia

Here you go! Let me know if you need any edits or have any questions.


System Analysis and Design
Name of the Student




Executive Summary
This report gives a discussion of the new proposed system for Texas State Aquarium Wildlife
Rescue Centre to adopt in managing the information about the turtles. The report is divided into
four sections including discussion of the general activities of the organization, existing and the
proposed system, technology to use and the implementation plan. The Texas State Aquarium
Wildlife Rescue Centre faces a significant challenge when it comes to recording information
about the cold-stunned sea turtles. Mainly, the staff workers face the challenge of tedious
recording of data about the collected turtles on paper and later transferring the data to the
computer system. The proposed new computerized information system is aimed at direct
capturing of information about the collected data. The new proposed system is based on
Microsoft Access 2016 which will be used to develop a database for storing information about
the injured sea turtles. The development process is quite extensive including the analysis and
design and also implementation plan to ensure a reliable system for the Texas State Aquarium
Wildlife Rescue Centre. Specifically, as per this report, the system analysis and design involves
critical evaluation of the current system and suggesting the look of the new system to meet the
organizational objectives in a more accurately and efficiently. The implementation phase implies
the actual act of developing the new proposed system and putting it to action by replacing the
current system. Generally, the current system is tedious, less accurate and also presents
challenges when it comes to retrieval of data about the sea turtles. The proposed MS Access
system will play an essential role in addressing the shortcomings of the existing system.



System Analysis and Design
System analysis and system design are the second and thirds stages respectively for the
system development life cycle. For the case of Texas State Aquarium Wildlife Rescue Centre,
the systems analysis will involve the examination of problems that the organization faces and
needs to be solved using the information system. The system analysis is a critical process
because it helps in defining the business problem, identification of the problems causes,
specifying the solutions, and identifying the information requirements for the system to satisfy.
The system analysis ...

flag Report DMCA

awesome work thanks

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors