fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

250 words

Error goes here

Students Who Viewed This Also Studied

37 Pages
ISIT312 Big Data Management

When finished, take the pictures ofthehand-written solutions, save the pictures in the files (jpeg, jpg,gif, bmp, png,pdfformats are all acceptable), and submit the files through Moodle. Usingmobile p ...

Course

ISIT312

Type

Home Work

Subject

Database

University

University of Wollongong

19 Pages
MIS602 Data Modelling and Database Design

Question: Instruction: You need to create the database tables as per below entities and complete the tasks listed in this instruction. Entities:   Task 1: Create three tables with re ...

Course

MIS602

Type

Programming

Subject

Database

University

Laureate International Universities

9 Pages
CIS5302 Professional Skills for Business Analysis

Metropolitan Car Service Bureau needs a system that keeps car service records. The company’s analyst has provided information about the problem domain in the form of notes. Your job is to use th ...

Type

Programming

Subject

Database

5 Pages
Systems Development and Procurement (ECM39IS)

Background of the assignment:This individual assignment is an opportunity for student to analyze the requirements, evaluate methodologies and tools and to apply the chosen methods and tools to design ...

Type

Programming

Subject

Database

Information Technology

Question

Answered

Objectives

•    To develop a conceptual data model diagram
•    To perform logical design

Assignment Specification

In this assignment, you need to perform the following tasks for the given case study:
•    Draw an Entity Relationship (ER) diagram
•    Perform logical design
•    Create 3NF Relations
Case Study
Many medical specialists offer their medical consultations and perform special medical procedures to the patients at CQ Specialist Medical Center (hereafter called as CQMC).  Patients generally book their appointments through a telephone call or by personal visits to the center.  Sometimes, the General Medical Practitioners (GPs) contact CQMC directly on behalf of their patients for the specialist appointments.
The patient details, such as name, gender, etc., are collected and stored at CQMC. Since the name of the patient is not going to be unique, each patient is identified by a unique patient ID.  The details of patient’s medical history (past surgeries undertaken), details of current medications (medicines and dosages) and other medication-allergies, if any, have to be maintained by CQMC. The referral letter from a GP is not a requirement at the time of booking for an appointment with the specialist but it is compulsory at the time of actual patient’s consultation.  Just prior to the consultation, CQMC collects the referral letter from the patient and notes down the details of date of referral and the GP (identified by unique Medical Provider Number) who issued that referral letter.  Based on the necessity, the same GP may refer the same patient to the same specialist many times over a period of time.  During the consultation, a specialist may conduct various medical tests and procedures on the patient; may prescribe multiple prescriptions to the patient.  After each appointment, the name of the standard tests and procedures performed along with the medical prescription details are stored and maintained by CQMC.
The following table provides the details of consultation and other charges applicable for the specialist’s appointments.   The charges can be assumed to be constant values.
Type    Fees/Charges
Consultation       $120
Biopsy    $75
Excision    $175
Laser    $250

After each appointment, the patient pays the entire appointment charges to CQMC.  Each appointment charges include the consultation fees and additionally may include multiple other charges from the above table.  Sometimes, some specialists offer discount amount to some appointments on special grounds such as Pensioner, Veteran etc.,  
Some GPs and patients often would like to know the details of qualifications and number of years of experience of the specialists.  Hence, CQMC maintains and updates those details periodically. You may note that a medical specialist may have multiple qualifications.
The attributes of the possible entities have not been mentioned clearly.  Hence, you need to assume at least three and at most seven relevant attributes for each of the entities that you will identify for your ER diagram.
Assignment Requirements

In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and perform logical design to produce appropriate 3NF Relations.
The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.
1    Draw an appropriate ER diagram
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.  
Your ERD must
•    show all necessary entities, attributes and relationships
•    show identifiers/identifying attributes as necessary
•    show multi-valued attributes, if any
•    show participation and cardinality
•    show associative entities, if appropriate
•    show weak entities, if any
•    use the notation described in the set text
•    use consistent and appropriate naming for entities and attributes  as specified in the unit text book
 

Objectives

 

·         To develop a conceptual data model diagram

·         To perform logical design

 

Assignment Specification

 

In this assignment, you need to perform the following tasks for the given case study:

·         Draw an Entity Relationship (ER) diagram

·         Perform logical design

·         Create 3NF Relations

Case Study

Many medical specialists offer their medical consultations and perform special medical procedures to the patients at CQ Specialist Medical Center (hereafter called as CQMC).  Patients generally book their appointments through a telephone call or by personal visits to the center.  Sometimes, the General Medical Practitioners (GPs) contact CQMC directly on behalf of their patients for the specialist appointments.

The patient details, such as name, gender, etc., are collected and stored at CQMC. Since the name of the patient is not going to be unique, each patient is identified by a unique patient ID.  The details of patient’s medical history (past surgeries undertaken), details of current medications (medicines and dosages) and other medication-allergies, if any, have to be maintained by CQMC. The referral letter from a GP is not a requirement at the time of booking for an appointment with the specialist but it is compulsory at the time of actual patient’s consultation.  Just prior to the consultation, CQMC collects the referral letter from the patient and notes down the details of date of referral and the GP (identified by unique Medical Provider Number) who issued that referral letter.  Based on the necessity, the same GP may refer the same patient to the same specialist many times over a period of time.  During the consultation, a specialist may conduct various medical tests and procedures on the patient; may prescribe multiple prescriptions to the patient.  After each appointment, the name of the standard tests and procedures performed along with the medical prescription details are stored and maintained by CQMC.

The following table provides the details of consultation and other charges applicable for the specialist’s appointments.   The charges can be assumed to be constant values.

Type
    

Fees/Charges

Consultation  
    

$120

Biopsy
    

$75

Excision
    

$175

Laser
    

$250

 

After each appointment, the patient pays the entire appointment charges to CQMC.  Each appointment charges include the consultation fees and additionally may include multiple other charges from the above table.  Sometimes, some specialists offer discount amount to some appointments on special grounds such as Pensioner, Veteran etc.,

Some GPs and patients often would like to know the details of qualifications and number of years of experience of the specialists.  Hence, CQMC maintains and updates those details periodically. You may note that a medical specialist may have multiple qualifications.

The attributes of the possible entities have not been mentioned clearly.  Hence, you need to assume at least three and at most seven relevant attributes for each of the entities that you will identify for your ER diagram.

Assignment Requirements

 

In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and perform logical design to produce appropriate 3NF Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

1       Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.

Your ERD must

•             show all necessary entities, attributes and relationships

•             show identifiers/identifying attributes as necessary

•             show multi-valued attributes, if any

•             show participation and cardinality

•             show associative entities, if appropriate

•             show weak entities, if any

•             use the notation described in the set text

•             use consistent and appropriate naming for entities and attributes  as specified in the unit text book


Information Technology

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

41 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com boasts a team of talented and highly skilled coursework writers based in UK who assist students in the best possible manner. Students, who need coursework help, find our services fulfilling and effective because we provide high quality help at affordable price. So, students who often search can someone do my coursework cheap or can experts Write my coursework for cheap get perfect solution at MyAssignmenthelp.com. They pay for best coursework and get it from us.

More Information Technology: Questions & Answers

Q
icon

We aren't endorsed by this University

When finished, take the pictures ofthehand-written solutions, save the pictures in the files (jpeg, jpg,gif, bmp, png,pdfformats are all acceptable), and submit the files through Moodle. Usingmobile phone cameras is all right. It is possible to take more than one picture per answerto assure the good ...

View Answer
Q
icon

We aren't endorsed by this University

Question: Instruction: You need to create the database tables as per below entities and complete the tasks listed in this instruction. Entities:   Task 1: Create three tables with relevant keys as suggested in the above diagram Task 2: Insert record of 10 employees in the employe ...

View Answer
Q

Metropolitan Car Service Bureau needs a system that keeps car service records. The company’s analyst has provided information about the problem domain in the form of notes. Your job is to use those notes to draw the domain model class diagram. The analyst’s notes are as follows:The Owner ...

View Answer
Q

Background of the assignment:This individual assignment is an opportunity for student to analyze the requirements, evaluate methodologies and tools and to apply the chosen methods and tools to design a software system for a realistic scenario provided. This assignment requires the compilation and pr ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Robert Grant

PhD in Electrical and Electronic Engineering

2078 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Aidenv Michael

PhD in Applied Chemistry

349 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Marcus Hayes

Pursuing PhD in Geography

2677 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Goodwin Kemp

Ph.D. in Chemistry from Washington State University.

450 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
08 Dec 2021

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 20 Pages, Deadline: 9 days

thank you, I scored 97/100. Thank you to all of the writers who help me get a good score.

flag User ID: 7***60 Germany

student rating student rating student rating student rating student rating
08 Dec 2021

It Write Up

Assignment: 5.2 Pages, Deadline: 13 days

Fine. Im okay with your work i have passed the subjrct thanks thabks for your help

flag User ID: 6***01 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Healthcare

Home Work: 10 Pages, Deadline: 6 days

Got the great grade. Thank you the expert. Will still use this service, but if the expert can give more real life example is better.

flag User ID: 4***0 Central District, Hong Kong

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Home Work: 2.4 Pages, Deadline: 3 days

perfect and well done . I enjoy working and trusting my assignment. I recommend it to all students

flag User ID: 8***51 Offenburg, Germany

student rating student rating student rating student rating student rating
08 Dec 2021

Healthcare

Assignment: 1.2 Pages, Deadline: 16 hours

I am happy with this good work, I like to deal with my assignment group every time

flag User ID: 5***45 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 11 Pages, Deadline: 11 days

It was great assignment , i have got very high score on this course . many thanks

flag User ID: 7***78 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 12 Pages, Deadline: 17 days

Thank you for another fantastic assignment help, i very pleased on this work i must say once again thank you

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 3 Pages, Deadline: 2 days

I am happy with the result. The paper is concise and ideas are well presented. Key details needed to respond to the task are evident.

flag User ID: 7***73 Indonesia

student rating student rating student rating student rating student rating
08 Dec 2021

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 20 Pages, Deadline: 9 days

thank you, I scored 97/100. Thank you to all of the writers who help me get a good score.

flag User ID: 7***60 Germany

student rating student rating student rating student rating student rating
08 Dec 2021

It Write Up

Assignment: 5.2 Pages, Deadline: 13 days

Fine. Im okay with your work i have passed the subjrct thanks thabks for your help

flag User ID: 6***01 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Healthcare

Home Work: 10 Pages, Deadline: 6 days

Got the great grade. Thank you the expert. Will still use this service, but if the expert can give more real life example is better.

flag User ID: 4***0 Central District, Hong Kong

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Home Work: 2.4 Pages, Deadline: 3 days

perfect and well done . I enjoy working and trusting my assignment. I recommend it to all students

flag User ID: 8***51 Offenburg, Germany

student rating student rating student rating student rating student rating
08 Dec 2021

Healthcare

Assignment: 1.2 Pages, Deadline: 16 hours

I am happy with this good work, I like to deal with my assignment group every time

flag User ID: 5***45 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 11 Pages, Deadline: 11 days

It was great assignment , i have got very high score on this course . many thanks

flag User ID: 7***78 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 12 Pages, Deadline: 17 days

Thank you for another fantastic assignment help, i very pleased on this work i must say once again thank you

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 3 Pages, Deadline: 2 days

I am happy with the result. The paper is concise and ideas are well presented. Key details needed to respond to the task are evident.

flag User ID: 7***73 Indonesia

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?