Reference no: EM133217599
Part A: Database Research Discussion Forum
You need to conduct research about "big data" and participate in the online interact discussion forum. Copy time, date and content of your response to this post and include it as part of the assessment document. You should make at least two posts on the forum.
Post Topic: Big data
Quality of engagement
Part B: Data Modelling
Overview of Gardens Medical Group Case:
Gardens Medical Group (GMG) in Albury asks you to design a database for supporting medical practices. Electronic medical records, patient billing, insurance claims processing and prescription submissions, and other typical aspects of medical practices are needed to be automated. Your assignment is to draw an ERD to represent the development of an insurance claims processing database and to answer questions that clients might raise about the capabilities of the application the database supports.
Draw an ERD to represent the situations described by the following:
A patient is assigned a patient ID, and you need to keep track of a patient's gender, date of birth, name, current address, and list of allergies.
A staff member (doctor, nurse, physician's assistant, etc.) has a staff ID, job title, gender, name, address, and list of degrees or qualifications.
A patient may be included in the database even if no staff member has ever seen the patient (e.g., family member of another patient or a transfer from another medical practice). Similarly, some staff members never have a patient contact that requires a claim to be processed (e.g., a receptionist greeting a patient does not generate a claim).
A patient sees a staff member via an appointment. An appointment has an appointment ID, a date and time of when the appointment is scheduled or when it occurred as well as a date and time when the appointment was made, and a list of reasons for the appointment.
Your task
Make an ERD for the above scenario that describes the current business rules.
Use Crow's Foot notations and make sure to include all of the following:
All entities correctly identified with the Primary key and any foreign key attributes
All relationships between entities correctly identified
All N: M relationships identified and resolved,
ERD is according to the Crow's Foot notation.