I have Database project I made the tables and some of the required.I need to complete the following:I. An…

I have Database project I made the tables and some of the required. I need to complete the following: I. An E-R Diagram (hand drawn or using MS-Visio) II. An MS Access 2010 database including the following “special features” 1. Create a database with multiple normalized tables with the necessary design to support your application and sufficient data to demonstrate the following (data may be real or fictional). 2. Examples of the use of validation rules and input masks for data fields 3. At least two forms, one of which must be a multi-table form (form with a subform). 4. At least two reports, one of which must be a multi-table report 5. At least five queries including examples of each of the following a. Select queries b. Sorting queries c. Calculation field queries (Field created by another field or fields) d. Function queries using By Group (counts,totals, averages) 6. At least two examples of advanced reporting techniques (design mode) 7. At least two examples of advanced form techniques (report mode) 8. A switchboard or button/macro interface for form, reporting navigation.

0/99

						AppointmentID	Patient ID	Doctor ID	Date	Time	AppointmentTakerInitials
4				1				2	10/7/12	12/		3	TAL

AppointmentID

	ChargeID	Quantity

ChargeID

Description	Fee
5586	fever	¤ 50.00
6675	allergy	¤ 80.00
8680	headache	¤ 70.00
9869	flu	¤ 56.00

1

2

ER

DoctorID		LastName		FirstName		Email		PhoneNumber		Department		Current	LicenseNumber
Alotabi	Karen	Kal.us@hotmail.com	315676953					ER	5678
Alshmmari	Sarah	Sa99@hotmail.com	314666558	8875

1

2

3

InsuranceID	InsuranceCompany	InsuranceNumber	InsuredLastName	ExpirationDate		PatientID	CopyOfInsuranceCard
Aetna	34957		Alharbi	1/16/13
Anthem	90574		Alshammari	3/11/13
AARP	57690		Jone	4/22/13

PatientID LastName FirstName Email PhoneNumber Department

Current

1 Alharbi

ER

2 Alshammari

ER

3 Jone

ER

Address	History
Turk	ttt_403@hotmail.com	31454058	Rue la cheel	allergies
Hsive	HS_@hotmail.com	31578979	Main St.	high blood pressure
Mike	Mj07@live.com	79756478	Olive St.	cancer

SELECT [PATIENTS].[PatientID], [PATIENTS].[LastName] AS PATIENTS_LastName, [PATIENTS].[FirstName] AS PATIENTS_FirstName, [PATIENTS].[Email], [PATIENTS].[PhoneNumber] AS PATIENTS_PhoneNumber, [APPOINTMENT].[Doctor ID], [APPOINTMENT].[Time], [DOCTORS].[LastName] AS DOCTORS_LastName, [DOCTORS].[FirstName] AS DOCTORS_FirstName, [DOCTORS].[PhoneNumber] AS DOCTORS_PhoneNumber, [APPOINTMENT].[AppointmentID]
FROM PATIENTS INNER JOIN (DOCTORS INNER JOIN APPOINTMENT ON [DOCTORS].[DoctorID] =[APPOINTMENT].[Doctor ID]) ON [PATIENTS].[PatientID] =[APPOINTMENT].[Patient ID];
SELECT DISTINCTROW *
FROM DOCTORS;

Hospital Database.accdb

AppointmentID Patient ID Doctor ID Date Time AppointmentTakerInitials

4 1 2 10/7/12 12/30/99 TAL

AppointmentID ChargeID Quantity

ChargeID Description Fee

5586 fever ¤ 50.00
6675 allergy ¤ 80.00
8680 headache ¤ 70.00
9869 flu ¤ 56.00

DoctorID LastName FirstName Email PhoneNumber Department Current LicenseNumber

1 Alotabi Karen Kal.us@hotmail.com 315676953 ER 5678
2 Alshmmari Sarah Sa99@hotmail.com 314666558 ER 8875

InsuranceID InsuranceCompany InsuranceNumber InsuredLastName ExpirationDate PatientID CopyOfInsuranceCard

1 Aetna 34957 Alharbi 1/16/13
2 Anthem 90574 Alshammari 3/11/13
3 AARP 57690 Jone 4/22/13

PatientID LastName FirstName Email PhoneNumber Department Address History Current

1 Alharbi Turk ttt_403@hotmail.com 31454058 ER Rue la cheel allergies
2 Alshammari Hsive HS_@hotmail.com 31578979 ER Main St. high blood pressure
3 Jone Mike Mj07@live.com 79756478 ER Olive St. cancer

SELECT [PATIENTS].[PatientID], [PATIENTS].[LastName] AS PATIENTS_LastName, [PATIENTS].[FirstName] AS PATIENTS_FirstName, [PATIENTS].[Email], [PATIENTS].[PhoneNumber] AS PATIENTS_PhoneNumber, [APPOINTMENT].[Doctor ID], [APPOINTMENT].[Time], [DOCTORS].[LastName] AS DOCTORS_LastName, [DOCTORS].[FirstName] AS DOCTORS_FirstName, [DOCTORS].[PhoneNumber] AS DOCTORS_PhoneNumber, [APPOINTMENT].[AppointmentID]
FROM PATIENTS INNER JOIN (DOCTORS INNER JOIN APPOINTMENT ON [DOCTORS].[DoctorID] =[APPOINTMENT].[Doctor ID]) ON [PATIENTS].[PatientID] =[APPOINTMENT].[Patient ID];
SELECT DISTINCTROW *
FROM DOCTORS;