Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91976851
  • Price:- $70

Guranteed 36 Hours Delivery, In Price:- $70

Have any Question?


Related Questions in DBMS

Assignment question - write and run sql statements to

Assignment Question - Write and run SQL statements to complete the following tasks Part A - DML 1. Locate the record in the vendor table that does not have a value for the attribute V_STATE 2. Find the customers whose ba ...

Question sql injection is in the top 10 owasp and common

Question : SQL Injection is in the top 10 OWASP and Common Weakness Enumeration. Using MySQL and PHP, show your own very short and simple application that is vulnerable to this attack. Provide another version that mitiga ...

In sql developer onlydeliverables include sql scripts and

In SQL Developer ONLY! Deliverables Include SQL scripts and screenshot of the results: D1. Create the following three user-defined roles that are shown in the table below and assign them the specified permissions for the ...

Project outline and requirements provide a brief

Project Outline and Requirements Provide a brief description of the organization (can be hypothetical) that will be used as the basis for the projects in the course. Include company size, location(s), and other pertinent ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

Q1 given the following file for assignment workercom

Q1. Given the following file for assignment worker.com, identify data anomalies that must be removed before data can be loaded in data warehouse. Worker_assignment ← -----------------on course web site File is available ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

Sql assignmentin these exercises youll enter and run your

SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As