Reference no: EM133244552
Question - 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:
1. What type of database is MS Access (Relational, Network, Hierarchical, flat file)?
2. What are the Primary Key and Secondary Key in relational databases?
3. 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?
4. What is the function of Database Management Systems (DBMS) in a relational database?
5. What underlying commands MS Access uses to accomplish the database manipulation (SQL, Oracle, IBM Db2)?