What type of database is ms access

Assignment Help Other Subject

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

Reference no: EM133244552

Questions Cloud

Describe the evidence-based guidelines for safe pt handling : Due to muscle weakness and fatigue, M.T. has been bedridden for 5 days. Describe the evidence-based guidelines for safe pt. handling when assisting M.T.

Describe the potential consequence of each mistake : Create a 10- to 15-slide Microsoft PowerPoint presentation highlighting one common mistake for each of the 10 steps of the Revenue Cycle

What is the gross food cost for the month : The dietary manager is attempting to calculate her food costs for the most recent month. What is the gross food cost for the month

Where doug would be protected under the constitution : The Constitution often protects individual rights to freedom of speech, is this a scenario where Doug would be protected under the constitution

What type of database is ms access : What type of database is MS Access (Relational, Network, Hierarchical, flat file)? What are the Primary Key and Secondary Key in relational databases

Compute prevalence of the disease in population : In a population study comprised of 20,000 individuals. Compute for Prevalence of the disease in population with exposure

Inventory management by using artificial intelligence : Work on Enhancing carrefour inventory management by using artificial intelligence and Define an issue whichcan be solved or enhance

What are the legal implications of the gna actions : What are the legal implications of the GNA actions and inactions? What are the administrative implications of the GNA's actions and inactions

What is clinical variation and why is it such a big problem : What is clinical variation and why is it such a big problem? What are the causes of clinical variation? How much does clinical variation cost Americans

User Account

All Pages