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

  Problem 1suppose you have a relation schema about teaching

problem 1suppose you have a relation schema about teaching classes that has the following attributes class instructor

  Design a database schema

Design a Database schema

  Explain efficient algorithm for edge-labeled graph

Explain efficient algorithm that, provided edge-labeled graph G with distinguished vertex v0 and sequence s = σ1, σ2, ..., σk of characters from Σ, returns path in G which begins at v0.

  Identify a relational algebra tree

Identify a relational algebra tree (or a relational algebra expression if you prefer) that reflects the order of operations a decent query optimizer would choose.

  Draw decision tree to represent the big state university

A student who completes either one of these prerequisites and obtains the instructor's permission, however, will be allowed to take MIS 260.

  What is a conceptual design process

When designing and developing a database, it is imperative that we utilize a conceptual design process. What is a conceptual design process

  Produce different final database state than using trigger

Assume that relation Employee has no tuples in it initially. You are to show the simplest example you can think of where using trigger T1 will produce a different final database state than using trigger T2.

  Create dependency diagrams for all entities in your database

Create dependency diagrams for all entities (tables) in your database. Be sure that each entity (table) is in 3NF and includes a relational. These cannot be hand-written/drawn; use Word, PowerPoint, or MS Visio via the XenDesktop to accomplish thi..

  Solve the serious data redundancy problems

One of the many problems with data redundancy is the likely occurrence of data inconsistencies-two different initials have been entered for the teacher named Maria Cordon.)

  Same name to attributes which are in different tables

What about giving same name to attributes which are in different tables but are not same? For instance, "Description" in both a Course table and a Classroom table.

  Knowledge and data warehouse hi there i need to start the

hi there i need to start the assignment for data warehouse where i need to define assignmentyou are required to design

  Imagine that you have been hired as the database

imagine that you have been hired as the database administrator for a local department store. the department store has

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