What are primary key and secondary key in relational databas


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)?

Request for Solution File

Ask an Expert for Answer!!
Database Management System: What are primary key and secondary key in relational databas
Reference No:- TGS03261303

Expected delivery within 24 Hours