Create the actual database using SQL syntax. This is completed using a Database Application (i.e Microsoft Access, Oracle, or MySQL) as indicated by your professor. After creating the database populate it with some data (data is posted below)

*Make sure to submit the completed database in the correct format (i.e Access file, Oracle, MySQL, etc.), dont forget to include the SQL commands used to create the tables in the database.

Personal Information:

Name: John Smith

Address: 12451 Waterway Dr, Alexandria, VA 22206

Home: (703) 545 6589

Cell: (703) 878 9636

Work: (703) 789 4780

Email: Johnsmith05@email.com

Emergency Contact:

Chad Smith

Relationship: Brother

Address: 12451 Waterway Dr, Alexandria, VA 22206

Home: (703) 545 6589

Cell: (703) 125 6321

Doctor: Charles Bradley, M.D.

INSURANCE INFORMATION

Patient Name: John Smith DOB 02/25/1987

Primary Insurance: Kaiser Permanente Phone # (703) 585 6987

Address: 12451 Waterway Dr, Alexandria, VA 22206

Policy ID # 12345678 Group # 04GAP9NBR3 Effective Date: 09/18/2017

Phone # (800) 235 7841

Name: Malory Givens

Address: 10580 Arrowhead Dr, Fairfax, VA 22030

Home: (703) 432 2600

Cell: (571) 765 4344

Work: (703) 889 5286

Email: M.Gavens26@mail.com

Emergency Contact: David Givens

Relationship: Husband

Address: 10580 Arrowhead Dr, Fairfax, VA 22030

Home: (703) 336 6703

Cell: (571) 224 6529

Doctor: Stephanie Torez, M.D.

INSURANCE INFORMATION

Patient Name: Malory Givens DOB 06/03/1976

Primary Insurance: CareFirst Blue Cross BlueShield Phone # (703) 432 2600

Address: 10580 Arrowhead Dr, Fairfax, VA 22030

Policy ID # R34956720 Group # 30495283 Effective Date: 09/01/2017

Phone # (800) 456 8609

Personal Information:

Name: Diane Harrison

Address: 10125 Colvin Run Rd, Great Falls, VA 22066

Home: (703) 333 7653

Cell: (703) 567 7688

Work: (703) 660 357

Email: Dianeh_81@Yahoo.com

Emergency Contact: Samantha Reed

Relationship: Sister

Address: 24856 Walker Rd, Great Falls, VA 22066

Home: (703) 378 9843

Cell: (571) 345 6732

Doctor: Stephanie Torez, M.D.

INSURANCE INFORMATION

Patient Name: Diane Harrison DOB 12/18/1981

Primary Insurance: Optima Health Phone # (703) 333 7653

Address: 10125 Colvin Run Rd, Great Falls, VA 22066

Policy ID # 8456793.01 Group # NDG Effective Date: 08/11/2017

Phone # (800) 330 8765

Personal Information:

Name: Kevin Gonzales

Address: 8375 Sudley Rd, Manassas, VA 20109

Home: (703) 409 6632

Cell: (703) 098 0085

Work: (703) 530 3284

Email: Kevin_G@aol.com

Emergency Contact:

Giovani Lopez

Relationship: Cousin

Address: 4598 Gateway Dr, Manassas, VA 20109

Home: (703) 567 1113

Cell: (571) 526 4367

Doctor: Charles Bradley, M.D.

INSURANCE INFORMATION

Patient Name: Kevin Gonzales DOB 10/02/1971

Primary Insurance: Kaiser Permanente Phone # (703) 585 6987

Address: 12451 Waterway Dr, Alexandria, VA 22206

Policy ID # 15745779 Group # 01HNAY0NYT4 Effective Date: 08/13/2017

Phone # (800) 333 6218

Personal Information:

Name: Alexa Warrington

Address: 45367 Watson Dr, Alexandria, VA 22206

Home: (703) 667 8742

Cell: (571) 878 8034

Work: (703) 889 1123

Email: Lexi.w95@mail.com

Emergency Contact:

Mary Warrington

Relationship: Mother

Address: 45367 Watson Dr, Alexandria, VA 22206

Home: (703) 667 8742

Cell: (703) 382 7634

Doctor: Stephanie Torez, M.D.

INSURANCE INFORMATION

Patient Name: Alexa Warrington DOB 11/21/1995

Primary Insurance: CareFirst Blue Cross Blue Shield Phone # (571) 878 8034

Address: 45367 Watson Dr, Alexandria, VA 22206

Policy ID # N99934678 Group # 74926394 Effective Date: 08/10/2017

Phone # (800) 653 8952

Personal Information:

Name: Avery Johnson

Address: 13745 Elden St, Herndon VA, 20170

Home: (703) 543 7783

Cell: (571) 603 4592

Work: (703) 880 2516

Email: Johnson_92@Yahoo.com

Emergency Contact:

David Johnson

Relationship: Father

Address: 13745 Elden St, Herndon VA, 20170

Home: (703) 543 7783

Cell: (703) 745 1183

Doctor: Charles Bradley, M.D.

INSURANCE INFORMATION

Patient Name: Avery Johnson DOB 03/29/1992

Primary Insurance: Kaiser Permanente Phone # (571) 603 4592

Address: 13745 Elden St, Herndon VA, 20170

Policy ID # 11041676 Group # 02TAO9BEY2 Effective Date: 09/01/2017

Phone # (800) 558 9023

Personal Information:

Name: Ayesha Abbas

Address: 1839 Sunrise Valley Dr, Reston, VA 20190

Home: (703) 482 0035

Cell: (703) 646 0281

Work: (703) 023 4452

Email: Abbas.A@mail.com

Emergency Contact:

Mustafa Abbas

Relationship: Husband

Address: 1839 Sunrise Valley Dr, Reston, VA 20190

Home: (703) 482 0035

Cell: (703) 335 9230

Doctor: Stephanie Torez, M.D.

INSURANCE INFORMATION

Patient Name: Ayesha Abbas DOB 01/05/1985

Primary Insurance: Kaiser Permanente Phone # (703) 482 0035

Address: 1839 Sunrise Valley Dr, Reston, VA 20190

Policy ID # 18555018 Group # 01EOD2MBE7 Effective Date: 09/01/2017

Phone # (800) 664 8890

Doctor Information:

Name: Stephanie Torez, M.D.

Home: (703) 236 7103

Cell: (571) 330 8920

Specialty: General Internal Medicine

Name: Charles Bradley, M.D.

Home: (703) 384 9903

Cell: (571) 349 0384

Specialty: General Internal Medicine