Diagram of the veterinary hospital registration system

Assignment Help Database Management System
Reference no: EM131220909 , Length: 3

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and appointments (open, closed, denied, cancelled and missed). The clients are owners of domestic animals such as cats, dogs, caged birds and so on. Some of the veterinarians at the hospital are specialists in particular types of animals but the majority can treat most types of animal.

All first-time clients of the hospital must register using the hospital's online registration system over the internet. For registration, the client must provide the following information: name and address, national ID number, date of birth and an email address. Once registered, a client will be given a username and password to be used to log into the system to make appointments in the future. The username and password will always be emailed to the client at the email address provided. The client will also be assigned a unique account number which will identify the client for the life of the system.

A record is kept of the pets belonging to the clients who have registered with the hospital. Details of all pets are recorded online during the client's registration. These details include the pet's name, animal type (for example: dog, cat), pet's date of birth, date registered with the hospital and the number of the insurance plan covering the pet. The pet will also be assigned a unique pet ID number which will identify the animal for the life of the system. All clients must register their pets in advance of them ever needing to see a vet at the hospital for treatment.

The hospital, in association with an insurance company, offers insurance coverage for pets belonging to clients. All clients must have an insurance plan for their pets to get treatment at the hospital. During the registration process, the system will access the insurance company's Computer System and allow the client to select a plan from a list of available insurance coverage plans. The selected plan can be for one or more pets and the plan can cover all or part of the cost of treatment. Details are kept of the plans taken up by clients including the insurance plan number, the date it was taken out, whether the plan covers one or more pet, the level of coverage and the treatments which the plan will cover.

Registered clients must make appointments for their pets in advance over the internet or by calling in to the hospital in an emergency. If a client is desirous of bringing two or more animals to the surgery each is treated as a separate appointment. For appointments to be made, clients will be prompted to provide their username and password to get access to the appointments module. Once the username and password is authenticated, clients will be prompted to provide their national ID number, the pet's ID number and the date requested for the appointment. The system will access the Vets database and the Appointments database and allow the client to choose from a vet from list of available vets and a time slot from the list of available time slots for each vet on the particular day requested. Once a vet and a time slot is selected, a record is created in the Appointments database. The record will contain client ID, pet ID, vet ID, the date, time slot, the status of the appointment (open) and the plan number of the insurance plan covering the pet. The client will then be allowed to print an appointment ticket with an appointment number and the details of the confirmed appointment. This printed appointment ticket is to be presented when clients present themselves at the hospital with their pets.

On the day of the appointment, the client must present the attendant at the hospital with the printed appointment ticket which the attendant will use to query the Appointments database to verify that the appointment is legitimate. The client will then provide ID documents to support all the information given over the Internet (name, address, national ID number). The system will automatically interface with the National Registration System to authenticate the client's national identification number. The system will also automatically interface with the insurance company's Computer System to query whether the insurance premiums for the insurance plan covering the particular pet are up-to-date. If the client's identification is not authenticated or the insurance premiums are not up-to-date, the appointment is denied. The appointment ticket is returned to the client stamped as "denied". The status field on the appointment record is updated to "denied".

After attending each appointment, the appointment ticket is stamped as "closed" by the attendant and returned to the client. The hospital attendant will also update the database with information concerning the treatment administered to the particular pet. A client sometimes makes an appointment and then either cancels it or does not turn up for the appointment. The hospital attendant will update the status field of the particular appointment record as "cancelled', or "missed" accordingly.

The management of the hospital must be able to identify clients who regularly make appointments that they do not keep and to provide reports and make ad hoc queries from all the data stored in the database of the hospital registration system.

a) Draw a Context Diagram of the Veterinary Hospital Registration system from the perspective of the personnel at the Veterinary Hospital.

b) Draw a High-Level DFD of the Veterinary Hospital Registration system from the perspective of the personnel at the Veterinary Hospital. Include at least FOUR (4) sub-processes in your diagram.

Reference no: EM131220909

Questions Cloud

Describe the graphs that model the following problems : The grouping and aggregation on the relation R(A, B), where A is the grouping attribute and B is aggregated by the MAX operation. Assume A and B have domains of size a and b, respectively.
Modes of transportation used primarily the intermodal proces : Both FedEx and UPS are companies involved in intermodal transport. Choose one of the two companies to investigate. List/describe the following:
How given developments affect banks desired equity ratios : How does each of the given developments affect banks' desired equity ratios?- An increase in OBS activities- A shift from C&I lending to real estate lending.
Create an app inventor app that converts temperatures : Create an App Inventor app that converts temperatures from degrees Fahrenheit to degrees Celsius. Ask users for the temperature in degrees Fahrenheit, and use the following formula for the conversion: C = 5/9(F - 32).
Diagram of the veterinary hospital registration system : Draw a Context Diagram of the Veterinary Hospital Registration system from the perspective of the personnel at the Veterinary Hospital - Draw a High-Level DFD of the Veterinary Hospital Registration system from the perspective of the personnel at t..
Newspaper or newspaper type publication : 1) What newspaper or newspaper type publication do you read? Why do you like to read it, and what does it feature to compel you to continue reading it regularly? This includes The Inquirer or other tabloid papers....which most of us at least look ..
Estimate the jaccard similarity correctly : However, these permutations are not sufficient to estimate the Jaccard similarity correctly. Give an example of a two-column matrix where averaging over all the cyclic permutations does not give the Jaccard similarity.
Determine the change implementation methods : Consider the budget concerns, timeline, and measurement of success/metrics. Recommend a follow-up plan to review impact on the human resources function, additional personnel required, organizational alignment, and cost changes.
Unprofitable and dysfunctional division : A new company has just hired you to turn-around an unprofitable and dysfunctional division. Outline the first series of steps you would take to develop an understanding of the operations.

Reviews

len1220909

9/26/2016 8:18:50 AM

General Presentation MS Word file with Context Diagram uploaded, the Dia file uploaded with proper symbols used and stipulated filename format for all files. Any one of the three conditions mentioned above not satisfied. More than one of the three conditions mentioned above not satisfied.

len1220909

9/26/2016 8:18:28 AM

Data Stores All data stores from the case with correct names and labels. 75% or more of all data stores from the case with correct names and labels. 50% or more of all data stores from the case with correct names and labels. 25% or more of all data stores from the case with correct names and labels. No data stores from the case with correct names and labels. Deduct 2 marks for each incorrect data store given over the maximum number of data stores.

len1220909

9/26/2016 8:18:12 AM

Data Flows New data flows appropriately named as nouns (phrases with directional arrows. 75% or more of new data flows appropriately named as nouns (phrases) with directional arrows. 50% or more of new data flows appropriately named as nouns (phrases) with directional arrows. 25% or more of new data flows appropriately named as nouns (phrases) with directional arrows. No new data flows appropriately named as nouns (phrases) with directional arrows. Deduct 2 marks for each incorrect data flow given over the maximum number of data flows.

len1220909

9/26/2016 8:17:58 AM

Processes At least 4 processes, with correct process symbols, process IDs, and appropriate names. 3 or more processes, with correct process symbols, process IDs, and appropriate names. 2 or more processes, with correct process symbols, process IDs, and appropriate names. 1 or more process with correct process symbols, process IDs, and appropriate names. All processes, with incorrect process symbols, incorrect process IDs, and inappropriate names. Deduct 2 marks for each incorrect process given over the maximum number of processes.

len1220909

9/26/2016 8:17:37 AM

Assignment should be done using the three symbols of dataflow; Process, entity, data flow and data stores. Preferably the DIA software. http://dia-installer.de/download/index.html.en Balancing Context Diagram submitted and all EE and data flow from CD on HLD. Context Diagram submitted and 75 % or more of all EE and data flow from CD on HLD. Context Diagram submitted and 50 % or more of all EE and data flow from CD on HLD. Context Diagram submitted and 25 % or more of all EE and data flow from CD on HLD. No Context Diagram submitted.

Write a Review

Database Management System Questions & Answers

  Need a system that networks its 3 campuses in the us and

need a system that networks its 3 campuses in the us and one campus in singapore. transaction data for all campuses

  Gap is developing its database using object-oriented methods

Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next page. Specifically, they want to make ProductItem an abstract parent clas..

  Find pairs of sids such that the supplier with the ?rst sid

Find pairs of sids such that the supplier with the ?rst sid charges more for some part than the supplier with the second sid.

  Develop a flowchart and provide a brief explanation for it

Develop a flowchart and provide a brief explanation for it

  Making a simple xml tree out of the given data

Making a simple XML tree out of the given data and using Xpath to navigate through it

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

  Knowledge and data warehousing

Knowledge and Data Warehousing

  What are four oracle system processes that run for database

What is an Oracle Instance? What are the four Oracle system processes that must always be up and running for the database to be useable.

  Describe the basic features of the rdb model

Describe the basic features of the RDB model and discuss their importance to the end-user and the designer.

  Product in traditional costing system - bullie manufacturing

Determine the manufacturing overhead cost per unit of each of the company's two products under the traditional costing system.

  What is denormalization, and why can it be desirable

When is it important to denormalize a database? Can you provide an example/examples?

  Create a schema that supports the company business

Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure

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!

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