I need to know how to create this database

This database is being created for a veterinarian to help her keep track of her patients. While a real database would contain a lot more information (like the owners name and address), this database has been simplified to allow you to concentrate on its construction. It will contain the following information.

Table: tblAnimals		Table: tblCondition		Table: tblOfficeVisits
Animal ID (autonumber)		Condition ID (autonumber)		Visit ID (autonumber)
Animal Name		Condition Name		Date of Visit (input mask)
Animal Type (dog, cat, hamster, etc.)		Treatment Fee (currency)		Animal ID (Foreign key)
Animal Age (integer)				Condition ID (foreign key)
				Overtime visit fee ($8-$40; currency)
				Paid (yes/no)
Be sure that you set relationships, referential integrity, cascade up and cascade delete options.

Step by Step Description:

1.Use all of the naming conventions discussed in this course.

2.Set the database to compact on close.

3.Create three tables as per specifications with the fields properly formatted.

4.Set table relationships and referential integrity (including cascade update and cascade delete if applicable)

5.Enter the data into the tables so as not to violate referential integrity.

In the tblAnimals table enter a minimum of 10 animals with at least 3 of them dogs, and two of them cats.

In the tblCondition table enter at least eight different conditions (fleas, broken bone, poison, spay, arthritis, check-up, etc.) that the doctor frequently sees and each condition should have a specific fee associated with it.

Note: The fee charged above takes into account supplies (flea medication), time, and cost of additional personnel (spaying overnight care), etc. These fees should be realistic.

In the tblOfficeVisits table enter a minimum of 15 office visits

Note: An office visit that requires the vet to come into the office on a weekend or after hours has an overtime charge ($8-$40). This charge may vary according to the time (5pm on a Wednesday may cost less than a visit at 2am on a Saturday). You decide and set the fees accordingly. At least three office visits should have an overtime fee.

6.Create Queries

One that computes the amount due for each visit and the fee was paid or not. Name this Query: qry:AmtDue

The fee for each visit is defined as:

Fee = $15 for the office visit + Treatment Fee + Overtime fee

A query that lists all office visits (ID and date) and the amounts charged for each visit. Name thisqryCharges

One that will show the sum of all of the charges grouped by type of animal. Name this query: qryTypeSum

7.Create the following forms:

One that allows the receptionist to enter the data into the tblAnimals table. Name this: frmNewAnimal

One that allows the receptionist to enter data into the tblCondition table. Name this form:frm:NewCondition

One that allows the receptionist to enter data into the office visit table. This last one assumes that the animal being treated is already listed in the database. Name this form: frmNewVisit

A form that lists all of the animals names and their types with a subform that lists the conditions for which that animal was treated. If an animal has no office visits, it should not appear on this form. Name this form: frmTreatments. Name the subform: fsubCondition

8.Create Reports

One that lists all animals treated (grouped by animal ID) and conditions (condition name) for which they were treated. Name this report: rptAnimalsTreated

One that lists the dogs who have been treated and include the name of the condition for which each was treated. Name this report: rptDogs

A report that shows the total outstanding amount (not paid by owners). This report should return a single value that is the sum of all outstanding amounts. Name this report: rptOutstanding

A Report that lists visits (with the animals name) that involved an overtime fee and the total amount charged for each visit. Name this report: rptOvertime

9.Include at least one graphic in your database on one or more of your forms.