Question: Create a database in ms access that includes the following: What should my database do? Search patient record Add new patient record Update patient record

Create a database in ms access that includes the following:

What should my database do?

Search patient record

Add new patient record

Update patient record

Delete patient record

Save patient record

Print patient record

Get Dr info

Get prescription info

Get drug info

Patient visit list

Visit details

Form1: Patient

Search patient record

Add new patient record

Update patient record

Delete patient record

Save patient record

Print patient record

Form2: Visit Info

Attending Doctor

Patient no.

Patient name

Patient history

Diagnosis

What date

Form3: Prescription

Attending Doctor

Patient no.

Drug name

Prescription

Drug price

Prescription date

Form4: Dr Info

Name

Faculty id

Specialty

Degree

Contact

Address

Tables

Doctor details

Patient details

Prescription

Drug

Visit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are a small database consulting company who designs and develops databases for small to medium sized businesses. You have now been hired to design and implement a database system for the dream...

Coursework Specification Please read the entire coursework specification before starting work. This is a group project development coursework. The overall task for this project is to design and...

Pitt Fitness is selling a line of exercise clothing at their three locations. At the beginning of this venture, they decide to sell only three types of t-shirts with the Pitt Fitness logo: two womens...

Open the file SC_AC19_3b_ FirstLastName _1.accdb , available for download from the SAM website. Save the file as SC_AC19_3b_ FirstLastName _2.accdb by changing the 1 to a 2. If you do not see the...

Figure Question This is the question CASE ONE Pequa Gallery (PG) is an art management company that manages and tracks antique and valuable art collectibles across the globe. Generally they track and...

YO16_AC_BU01_GRADER_PS1_HW - Group Reservations Database Project Description: Patti Rochelle, corporate event planner, wants to be able to track group reservations with the conference rooms that are...

DOCTOR DocID 101 102 103 FirstName Muhammad Maryam Sumayyah LastName Fatch Mazlan Idris Specialization Surgery Neurology Dermatology HireDate 15/05/2000 21/03/2001 07/02/2003 PATIENT Patient ID...

Can someone please make a relational Schema of the Hospital and also please share the data dictionary. The Hospital Administrator's Database NARRATIVE The hospital administrator wants to create a...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

What rights of ownership are given up by preferred shareholders? What additional protections are enjoyed by preferred shareholders?

Pretend that you have just met an immigrant from another nation who is not familiar with American laws or political traditions. Explain our founding story to the immigrant in a way that will make...

A customer is given a quote for ABC as: 1 7 . 0 0 1 7 . 2 5 6 1 2 . This quote indicates the customer can A ) sell 1 , 2 0 0 shares at $ 1 7 . 2 5 per share. B ) purchase 1 , 2 0 0 shares for $ 1 7...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What is the difference between Needs and GAP Analyses?

What are ERP suites? Are HCMSs part of ERPs?

An economy is operating with output $400 billion below its natural rate, and fiscal policymakers want to close this recessionary gap. The central bank agrees to adjust the money supply to hold the...