Assignment
Using Microsoft Access, create a database titled "Patients' Database" with three 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, Insurance Type, start date.
In addition to the "hands-on" Access assignment, include a response that explains the following:
A. What type of database is MS Access (Relational, Network, Hierarchical, flat file)?
B. What are the Primary Key and Secondary Key in relational databases?
C. 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?
D. What is the function of Database Management Systems (DBMS) in a relational database?
E. What underlying commands MS Access uses to accomplish the database manipulation (SQL, Oracle, IBM Db2)?