“Patients’ Database

Using Microsoft Access, or Excel spreadsheet 

titled “Patients’ Database” with three (3) tables titled below for 10 fictitious patients with patient IDs 1 – 10 and include the specified information in each table. Link these tables using patient ID as the Primary Key. Then design MS Access query to locate Patients with ID 5 and 8 and their all information in the three tables.

Table 1 – Patient’s demographics: First name, last name, gender, age, address, zip code, phone, email.

Table 2 – patients’ clinical information: Diagnosis, medications, procedures, date of visits, Physicians, consultants. 

Table 3 – patients’ billing information: Health Insurance, Endurance Type, start date.

Include a response that explains the following:

What type of database is MS Access (Relational, Network, Hierarchical, flat file)?

What are the Primary Key and Secondary Key in relational databases?

Is MS Access, a single user or multiuser database i.e. can it be accessed only by one user at a time or more than one user simultaneously?

What is the function of Database Management Systems (DBMS) in a relational database?

What underlying commands MS Access uses to accomplish the database manipulation (SQL, Oracle, IBM Db2) ?