Preview

A1 Database Mgmt

Satisfactory Essays
Open Document
Open Document
260 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
A1 Database Mgmt
1. Create the following tables: Patient, Physician and treatment
2. Deploy the data in the table
3. Design the PK and FK
PATIENT
Patient_ID
F_Name
L_Name
Sex
StreetAddress
City
Province
PostalCode
PhoneNumber
2
Yannick
McEachern
M
2 Sharar Drive
1
1
K3Y6B8
(613)822-5410
3
James
Gilchrist
M
89 Larrond Drive
1
1
K2W8N5
(613)822-1110
4
Wanda
Jackson
F
17 Hassan Drive
1
1
K2D8M7
(613)822-6126
5
Adam
McMullen
M
25 Friendly Lane
2
1
K2E7V5
(613)828-7815
6
Krystian
Luong
F
78 Orr Drive
4
1
K1Y6F4
(613)828-7451

PHYSICIAN
Physician_ID
F_Name
L_Name
StreetAddress
City
Province
PostalCode
PhoneNumber
1
Dr. James
Brown
17 Ellery Cres.
1
1
K2C3B3
(613)823-7765
2
Dr. Eric
Buschlen
23 Anna Drive
1
1
K2X8S2
(613)878=9945
3
Dr. Paul
Southern
5 Stinson Avenue
1
1
K2C5B5
(613)821-7781
4
Dr. Tyler
Molyneaux
3 Virgil Cresent
5
2
J2W1D7
(613)998-7485
5
Dr. Peter
Roden
12 Horner Drive
1
1
K1G7B3
(613)448-7513
6
Dr. Wong
Chapman
45 Horse Dr.
2
3
H1H8J9
(613)787-0956

Treatment table:
Patient_ID
Physician_ID
TreatmentName
2
1
Treatment C
3
2
Treatment K
4
3
Treatment A
5
2
Treatment B
6
5
Treatment E
7
6
Treatment C

4. Design the following SQL
Query1: find the treatment given to Jackson, and who is his doctor with his address?
Query2: Find the patient(s) with treatment C
Query 3: find the Phone number of Dr. Paul
Query 4: list the patients who treated by Dr. Eric?
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Jackson Memorial Hospital Research Paper
    • 163 Words
    • 1 Page

    Jackson Memorial Hospital Research Paper

    Jackson Memorial Hospital was founded in 1918, it was known as the Miami City Hospital Jackson Memorial Hospital was named as after Dr. James M. Jackson in honor of his death. Jackson Memorial Hospital is the main Hospital in the Jackson Health System. Jackson Memorial Hospital provides and specializes in many traumatic cares, in addition to the various programs. Jackson Memorial grew tremendously over the years. Jackson Memorial Hospital is known for some of the major and most critical surgeries performed at the facility. Over the years Jackson memorial faced many obstacles. The hospital faced many lawsuits, and has been in the spot light for the type of treatments being rendered to their patients. In addition, Jackson Memorial Hospital experienced…

    • 163 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Good Essays

    Applied business AS ao2 and ao3 tables
    • 9832 Words
    • 27 Pages

    Applied business AS ao2 and ao3 tables

    There a various methods of job advertisement these include that Greggs could use to advertise the position of Team member, they could advertise it internally by using the staff intranet for example, sending an email to all staff or advertising it on the staff notice board, this is simple cheap and very time efficient to do as Greggs can get an employee to write an advertisement up and post it on the same day. There are external ways to advertise the vacancy at Greggs like through their website www.greggs.co.uk this way the public can apply for their jobs all through the same process and it is easier to access and easier to use for the Greggs itself as they are in direct control of the recruitment process and seeing who is applying. Greggs could also advertise through the Job centre, this is government a based programme which means it is free to use, it can also be used nationally or locally this means that Greggs have can choose to have a very large recruitment pool if they wanted. They could advertise through a Recruitment Agency, it does cost however they have specialist staff to find the best person for the job which means Greggs can be very specific over who they choose to recruit, They could also advertise in a newspaper, locally or nationally, this will give the job vacancy plenty of candidates as it will be advertised to a big audience. A job advert should contain: the name of the position that is vacant, this is to show people exactly what they may apply for, it should also contain basic information about the job role for example a team member will be required to serve customers and prepare food, If the person looking to apply cannot fulfil those tasks they will not apply and Greggs won't have to waste time looking at their application, The advert will also have the location and address of the vacancy, it will also contain the wage or salary information it will also tell the candidate whether any bonuses can be earned and the…

    • 9832 Words
    • 27 Pages
    Good Essays
    Read More
  • Good Essays

    ADMS 2511: Management Information System
    • 1051 Words
    • 5 Pages

    ADMS 2511: Management Information System

    This practice exam is structured to take 180 minutes. Since it is worth 50 marks, you would allocate 3.6 minutes for each mark.…

    • 1051 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Case Study 6: Heart Disease
    • 1272 Words
    • 6 Pages

    Case Study 6: Heart Disease

    2. Knowing his history and seeing his condition this AM, what further questions are you going to ask J.M and his daughter?…

    • 1272 Words
    • 6 Pages
    Good Essays
    Read More
  • Good Essays

    Complications In Thomas Jonathan Jackson's Life
    • 325 Words
    • 2 Pages

    Complications In Thomas Jonathan Jackson's Life

    There was many complications in Thomas Jonathan Jackson’s life. First he was born on January 21, 1824, in Clarksburg, West Virginia. His family was poor and never stayed in one home. His sister caught typhoid fever and died, than Jonathan, and 5 years later his mom died. Years later, he experiences what war was like in 1846-1848. Along with being in that war, he experienced religion while in the military. He later developed a strong faith that would help him with the grieving of his family members. In war, it also gave him a lot of confidence. Thomas’s first wife died in October of 1854. This was after she gave birth to her dead baby boy. After that, he married Mary Anna 3 years later. On the day of July of 1861, Jackson looked like a stone…

    • 325 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    MGM316 International Business Communications Phase 2 DB Autosaved

    • 747 Words
    • 3 Pages

    MGM316 International Business Communications Phase 2 DB Autosaved

    When opening a franchise in a new countries, you must consider a language, and cultural training, this would be for all the staff that would be hired or transferred to a new country for work. The training program would need to focus on how intercultural business communication would affect your business. My training program would be comprehensive and well-rounded. You would want to create a lesson plan to include High and low- context language, nonverbal communication and what could be taboo in some countries. There are over 311 languages, and dialect that are spoken currently in the United States today (Course Smart, 2015). To be successful in communication, you must keep the language diversity in mind and try to eliminate the confusing communication as much as portable with your employees.…

    • 747 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Elizabeth Blackwell Changes the World
    • 1839 Words
    • 8 Pages

    Elizabeth Blackwell Changes the World

    Wellness Dictionary of Minnesota. “The History of Medicine 1800 – 1850.” 2003. 6 mar. 2010…

    • 1839 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Data base administrator
    • 529 Words
    • 3 Pages

    Data base administrator

    (10) Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.…

    • 529 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    module 6 dba

    • 3227 Words
    • 11 Pages

    module 6 dba

    Provide a detailed description of the historical importance of each of the famous people, key terms and places listed below. Focus on explaining what is most important to know about each including information that helps explain who, what, when, where and why. Use the lessons listed in parentheses to find the necessary information and avoid using Google, Wikipedia or other internet sources.…

    • 3227 Words
    • 11 Pages
    Good Essays
    Read More
  • Good Essays

    Defining Characteristics Of Andrew Jackson's Life
    • 1232 Words
    • 5 Pages

    Defining Characteristics Of Andrew Jackson's Life

    Although Andrew Jackson is known for many defining characteristics such as his anger, courageousness, and fierceness, his perseverance was always more dominant. From a very young age, Jackson experienced numerous hardships which transformed him into the icon he is. For example in the 1970’s, Jackson and his brother were sold out by a neighbor and taken as prisoners by the British (Remini, 8). In the prisoner of war camps, many of the prisoners fell ill and caught smallpox. Jackson and his brother were two of the victims (Remini,8).…

    • 1232 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Andrew Jackson: the 7th President of the United States of America
    • 738 Words
    • 3 Pages

    Andrew Jackson: the 7th President of the United States of America

    During the American Revolutionary War, Jackson was teenager when he joined a local militia. His oldest brother, Hugh, died from heat exhaustion during the Battle of Stono Ferry. Jackson and Robert (his brother) were captured by the British and held as prisoners; they almost died in captivity. When Jackson refused to clean the boots of a British soldier, the soldier slashed at Andrew with a sword, leaving him with scars on his left hand and head, in a result to that he had an intense hatred for the British. While in prison, the brothers had got smallpox. Robert died a couple days after their mother allowed them to leave. After his mother was assured Andrew would recover, she volunteered to nurse POW (prisoners of war) on board two ships in Charleston, where there had been an outbreak of cholera. She died from the disease on November 1781, and was buried in an unmarked grave, leaving Jackson an orphan at the age of fourteen. Jackson's entire immediate family–aside from his father, who had died earlier–died from hardships during the war, Jackson blamed the British.…

    • 738 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Andrew Jackson: No Hearted Villain
    • 626 Words
    • 3 Pages

    Andrew Jackson: No Hearted Villain

    In Jackson’s early years he was poor and an orphan after his mom died. He suffered a sword injury on his hand when a British officer swung a sword at this head. Him and his brother were caught and were sent to a British prison. Their mother released…

    • 626 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Andrew Jackson Vindication
    • 662 Words
    • 3 Pages

    Andrew Jackson Vindication

    “Andre Jackson was more than a symbol, he was a vital force. As the force was rarely at rest, so the man was rarely at peace” (Curtis IX) The book Andrew Jackson and the Search for Vindication, written in 1976 by James C. Curtis, winner of the University of Delaware Excellence in Teaching Award. The author focuses on Jackson’s stormy life, and the impact his experiences had on his gaining of power. As well as the influence, he made on the War of 1812, achievement and his two-term presidency.…

    • 662 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Transcription
    • 320 Words
    • 2 Pages

    Transcription

    3. The internist wanted him to have meprobamate, so he wrote a prescription for Miltown.…

    • 320 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Analysis of WP Kinsella's Shoeless Joe Jackson Comes to Iowa: A Man Who Loves Iowa, His Wife and Daughter, and Baseball
    • 1378 Words
    • 6 Pages

    Analysis of WP Kinsella's Shoeless Joe Jackson Comes to Iowa: A Man Who Loves Iowa, His Wife and Daughter, and Baseball

    Cited: Fleitz, David L. Shoeless The Life and Times of Joe Jackson. Jefferson, North Carolina:…

    • 1378 Words
    • 6 Pages
    Better Essays
    Read More

Related Topics