Using Microsoft Access, build your database. Be sure all the relationships work and all fields have appropriate
Fantastic news! We've Found the answer you've been seeking!
Question:
Using Microsoft Access, build your database. Be sure all the relationships work and all fields have
appropriate data types. Input some sample data and run the following queries:
Generate a list of patients who have appointments for today.
Determine which patients most frequently come to the office.
Determine which service is most widely used (i.e. surgery).
Which suppliers provide the most commonly used supplies.
Generate a schedule of appointments for each doctor for the week.
Transcribed Image Text:
Database Project You have been asked to develop a database system for a country doctor's office. As you might expect, the doctor in question is well trained in the medical profession, but has very little knowledge or experience in developing database systems. Using the concepts covered in this course, you must design and build a system to run the doctor's office. This project has three phases. Phase 1 This office has three doctors that serve approximately 100 patients. As a country doctor's office they are equipped to provide a wide variety of services to their patients. Since they are located so far from the nearest hospital they handle more than you might expect from a primary care physician. Minor surgeries, broken bones, and cuts requiring stitches are routinely performed in the office. For this phase of the project, you must develop an Entity Relationship Diagram (ERD) for the system. Entity types for this system include: Doctors, Patients, Services (i.e. physical exam, surgery), Supplies used (i.e. gauze, tape, needles), Suppliers (provide supplies), Appointments Be sure to design in the ability to record the cost to the patient. The purpose of this phase is to communicate with the doctor how you envision the relationships in the data generated by the office. Remember, the doctor is not a technical expert, so a simple way of communicating the design of the system is valuable. Phase 2 Once the ERD is complete, convert the diagram into tables with the associated fields. Identify primary keys for each table, data types, etc. Also, determine the relationships between tables and the fields that make up those relationships. The purpose of this phase is to communicate between the system designers and the programmers (you) as to the layout of the system. Phase 3 Using Microsoft Access, build your database. Be sure all the relationships work and all fields have appropriate data types. Input some sample data and run the following queries: Database Project You have been asked to develop a database system for a country doctor's office. As you might expect, the doctor in question is well trained in the medical profession, but has very little knowledge or experience in developing database systems. Using the concepts covered in this course, you must design and build a system to run the doctor's office. This project has three phases. Phase 1 This office has three doctors that serve approximately 100 patients. As a country doctor's office they are equipped to provide a wide variety of services to their patients. Since they are located so far from the nearest hospital they handle more than you might expect from a primary care physician. Minor surgeries, broken bones, and cuts requiring stitches are routinely performed in the office. For this phase of the project, you must develop an Entity Relationship Diagram (ERD) for the system. Entity types for this system include: Doctors, Patients, Services (i.e. physical exam, surgery), Supplies used (i.e. gauze, tape, needles), Suppliers (provide supplies), Appointments Be sure to design in the ability to record the cost to the patient. The purpose of this phase is to communicate with the doctor how you envision the relationships in the data generated by the office. Remember, the doctor is not a technical expert, so a simple way of communicating the design of the system is valuable. Phase 2 Once the ERD is complete, convert the diagram into tables with the associated fields. Identify primary keys for each table, data types, etc. Also, determine the relationships between tables and the fields that make up those relationships. The purpose of this phase is to communicate between the system designers and the programmers (you) as to the layout of the system. Phase 3 Using Microsoft Access, build your database. Be sure all the relationships work and all fields have appropriate data types. Input some sample data and run the following queries:
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
The payback period represents the time it takes for a project to recoup its initial investment. We'll use the incremental approach, which accumulates the annual cash savings until the total reaches...
-
Before you begin this assignment, be sure you have read the UMUC Family Clinic Case Study below and your Week 1 and Week2 syllabus readings, which discuss EHR functionality and Process...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
For nearly 50 years, Loganville Window Treatments (LWT) of Loganville, Georgia, has made interior shutters that are sold through decorating centers. Figure 3.20 shows some of the various styles of...
-
The can in Fig P2.104 floats in the position shown. What is its weight in newtons? 3 cm Water 8 cm
-
Serotta Corporation is planning to issue bonds with a face value of $300,000 and a coupon rate of 12 percent. The bonds mature in two years and pay interest quarterly every March 31, June 30,...
-
For the \(180^{\circ}\) elbow and nozzle flow shown in Fig. P5.102, determine the loss in available energy from section (1) to section (2). How much additional available energy is lost from section...
-
An examination of the cash activities during the year shows the following. GREAT ADVENTURES Cash Account Records July 1, 2024, to December 31, 2024 Date 7/1 7/15 7/22 7/30 8/1 8/10 8/17 9/21 10/17...
-
A commuter airplane starts from an airport located at the origin. First it flies to city A located 99 km away from the airport in a direction 34 North of East. Next it flies 58.8 km at 38 West of...
-
Maximum Streak A project manager wants to look at employee attendance data. Given that m employees are working on the project, and the manager has the record of the employees present on n days of the...
-
Given the differential equation ry" - 2ry'-10 y = 0 (a) Find two values of r such that y=r" is a solution of the equation. (b) Determine a fundamental set of solutions and give the general solution...
-
Your boss (Walt Disney Company, ) needs you to develop an employee assessment survey that consists of 10 questions and will be administered through email to all employees. She hands you the following...
-
The variation of pressure (P) as a function of change in elevation (z) is described by dP = - p g dz Note that the density p is a function of elevation z. The gravity of earth can be assumed to be...
-
Enterprise Resource Planning (ERP) supports operations large and small. They connect complex systems within an organization. While they are invaluable for automating functions, there are sometimes...
-
1) In your opinion, what are some of the qualities that make a good leader? 2) Name a leader from your experience who made you feel more powerful and raised your capabilities. What enabled him or her...
-
Based on an interest rate of 8 % with annual compounding, what quarterly interest rate is required with quarterly compounding to get to the same result? 4 b ) What monthly interest rate is required...
-
3. (10 pts) Solve the ode and state the method used. You only need to give and implicit solution but please isolate the constant term on the right-hand side of the equation, i.e. x + y = K. +(+ cx...
-
Use this circle graph to answer following Exercises. 1. What fraction of areas maintained by the National Park Service are designated as National Recreation Areas? 2. What fraction of areas...
-
Obtain a copy of an organizations mission statement. (One can typically be found in an organizations annual report. Such reports are often available in university libraries or in corporate marketing...
-
What is the degree of a relationship? Give an example of each of the relationship degrees illustrated in this chapter.
-
Describe what is meant by ISP and the steps involved in the process.
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
Study smarter with the SolutionInn App