Normalized the information mention in form into 3NF

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question

Normalized the information mention in form into 3NF

plz solve in 70 minutes.

Attock Hospital
Patient form
Patient No:
Name:
Patient
Ward Name:
Ward No:
Bed No:
Medicine Medicine Medicine
No
Unit Start date Finish
Dosage
Туре
Name
Description
per
date
day
1234
Panadol Pain killer 15mg/ml
Oral
8/12/2020
20/12/2020
3
Extra
2568
Voren
Antibiotic 100mg/ml IV(injection) 2
18/12/2020 28/12/2020
1234
Panadol
Pain killer 15mg/ml
Oral
20/1/2021
28/1/2021
Extra
2
Transcribed Image Text:Attock Hospital Patient form Patient No: Name: Patient Ward Name: Ward No: Bed No: Medicine Medicine Medicine No Unit Start date Finish Dosage Туре Name Description per date day 1234 Panadol Pain killer 15mg/ml Oral 8/12/2020 20/12/2020 3 Extra 2568 Voren Antibiotic 100mg/ml IV(injection) 2 18/12/2020 28/12/2020 1234 Panadol Pain killer 15mg/ml Oral 20/1/2021 28/1/2021 Extra 2
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Computing Algorithms
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr