User Account

All Pages

Licensed animal rescue group is looking to digitize record

Assignment Help Basic Computer Science
Reference no: EM133218214

Background

A local, non-profit, licensed animal rescue group is looking to digitize record-keeping within the organization. Georgia Department of Agriculture (GDA) requires licensed animal rescue groups to follow certain record-keeping requirements to maintain compliance. Review the supplied Information Sheet and Record-Keeping PDF forms supplied by the GDA for the scope of data gathering requirements.

Goal

The goal is to make web-based application to help the volunteers at the animal rescue group in day-to-day operations and annual reporting to the GDA. On the organization's Intranet it will provide flexibility of being accessed from a variety of devices. For this deliverable you will need to formulate an Entity Relationship Diagram (ERD) to model the data required, develop a database, implement CRUD functionality on the data, and derive business intelligence from the application.

Deliverables

Entity Relationship Diagram

Make an ERD that fulfills at least First Normal Form (1NF) to the data required on the Record-Keeping Form supplied by GDA about a Pet. Identify which attributes might be worth creating separate entities with if we wanted our database in Third Normal Form (3NF). You can use Visio, hand-draw it, or use another ERD-type tool and attach it with ZIP file of code solution.

Database Development

Make database in Microsoft SQL Server that implements your data model. Populate test data to demonstrate its usage with at least 10 different examples of Pets.

CRUD Functionality

Implement Create, Read, Update, and Delete functionality with respect to a Pet. This will allow volunteers to add new pets to the database, view the inventory, update and delete Pet records in the database.

Business Intelligence

Implementing a reporting page that can answer these questions for volunteers and admins.

1. How many animals are currently in the facility?

2. How many animals by pet type (cats, dogs, etc) has the rescue group helped?

3. How many adoptions have occurred?

4. What are the establishments/persons we commonly deal with?

Reference no: EM133218214

Questions Cloud

What is the population you would like to address : Locate at least one article related to your topic. What was the research question in the study? What is the population you would like to address
Identify the public policy that interests you most : Identify the public policy that interests you most. At this point, you may begin with a general policy area, for example, education or health care
Layers pattern structures software apps and infrastructure : Which of the following are ways in which the Layers pattern structures software apps and infrastructure
Career advising website : Advising Center at University would like "Career Advising Website" to be created so they can better manage the student requests for career advising appointments
Licensed animal rescue group is looking to digitize record : A local, non-profit, licensed animal rescue group is looking to digitize record-keeping within the organization. How many animals are currently in the facility?
How activation levels are calculated in neural network : Explain how activation levels are calculated in neural network, name the components, functions and calculations involved.
Explain the identified drug half-life : Psychiatric Treatment Drug Latuda Discussion - Explain the identified drug's half-life. Explain the importance of knowing about the drug's therapeutic index
Discuss role of language in cultural and ethnic diversity : Discuss the role of language in cultural and ethnic diversity. Identify terms or phrases that were "acceptable" when you were younger
Why is a conductor of an orchestra an appropriate metaphor : Why is a conductor of an orchestra an appropriate metaphor for being a project manager? What aspects of project management are not reflected by this metaphor

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Parameter and returns a float number

Need an example for: Create your own function in C that accepts one input parameter and returns a float number. You decide the theme.

  What is scalable clustering algorithm

What are the characteristics of data? What is a scalable clustering algorithm? How do you choose the right algorithm?

  Section-governance and ethics

Discuss the role and effect of corporate governance on publicly listed companies. Illustrate your answer with examples of aspects of corporate governance practices that have been mentioned in the annual report, analyst reports and or recently repor..

  Develop an algorithm for an m x m median filter

an M x 1 separable median filter that minimizes the number of operations required for filtering N x N images, where N >> M. Compare the operation counts for M = 3, 5, 7

  Display the list of names and phone numbers

Display the list of names and phone numbers of the departments for those employees with salaries more than salary of Matt Joe. (Use SYS.EMPLOYEE).

  Names and majors of students

Print the names and majors of students who are taking one of the College Geometry courses. (Hint: You'll need to use the "like" predicate and the string matching character in your query.)

  What is big data analytics

How does prescriptive analytics relate to descriptive and predictive analytics? What is Big Data analytics? How does it differ from regular analytics?

  Information governance principles

The word that matters most is accountability." The root of many problems with managing information is the "fact that there is no accountability for information"

  Pdl what function is used to change

Still referencing the PDL what function is used to change the valued used by the Timer peripheral with regards to how often the Timer triggers an interrupt?

  Rodger got a weekly raise

Mrs. Rodger got a weekly raise of $145. If she gets paid every other week, write an integer describing how the raise will affect her paycheck

  Vulnerability pairs with associated threat action

Provide a description of a project and identify the threat/vulnerability pairs with the associated threat action.

  Write function named prompt open that prompts for file name

Write a function named prompt open that prompts for a file name and repeatedly attempts to read the specified file until a correctly specified file.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd