1 / 12

Veterinary Practice Database Design: A Case Study in Rapid Prototyping

This project by Rob Christensen explores the design of a database tailored for a veterinarian practice focusing on small animals. The mini-world consists of entities such as PET_OWNER, PET, and BREED, with defined relationships and attributes. It employs logical design principles to structure data effectively, generating queries using SQL for practical applications. The project emphasizes the importance of rapid prototyping in understanding database functionalities and reflects on the learning process involved in mastering Microsoft Access.

preston-byrd
Télécharger la présentation

Veterinary Practice Database Design: A Case Study in Rapid Prototyping

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Project: Type I Rob Christensen

  2. Introduction • Miniworld • Logical Design • Rapid Prototyping • Summary and Reflections

  3. Miniworld • A database that could be used in an veterinarian practice specializing in small animals • Entities - PET_OWNER - PET - BREED

  4. Miniworld

  5. Miniworld – Selected Attributes

  6. Miniworld – Selected Attributes

  7. Miniworld – Relationship List

  8. Logical Design • PET_OWNER (OwnerID, FName, LName, Address, City, State, Zip, AreaCode, Phone, Email) • PET (PetID, PetName, Type, Breed, Weight, OwnerID) • BREED (BreedName, MinWeight, MaxWeight, AverageLifeExpectancy) Note: Bold and Underline indicates Primary Key and Non-bold and underline indicates Foreign Key

  9. Rapid Prototyping Query 3 – This query was to determine the following. Which pet owners in the veterinarian practice are associated with which pets in the veterinarian practice by using a parameter search based on OwnerID? When the parameter search box labelled OwnerID appeared, I entered “5001” into the text area of the parameter search box to yield the output below. The name of the query in the Microsoft Access database is “OwnerID_Parameter_Search”. SQL Language SELECT PET_OWNER.OwnerID, PET_OWNER.FName, PET_OWNER.LName, PET.PetName FROM PET_OWNER INNER JOIN PET ON PET_OWNER.OwnerID = PET.OwnerID WHERE PET_OWNER.OwnerID LIKE [*OwnerID*];

  10. Rapid Prototyping

  11. Summary and Reflections • After running the queries, the database worked by providing output on the macro and micro levels • Experience and skills related to other database products (e. g. FileMaker Pro) sometimes are and are not transferable to learning MS Access • Learning how to use a database program is a procedural learning activity • Had issues with running parameter search queries but resolved issues by taking two steps back to move four steps forward

  12. Thank You! Any Questions ???

More Related