Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Plz i want the solution completely step by step And divided it to schedule with details by using method of 1NF & 2NF & 3NF

Plz i want the solution completely step by step
And divided it to schedule with details by using method of 1NF & 2NF & 3NF in manufacturing information system course and with a comments in each step plz
image text in transcribed
Apply normalization of the following data table showing all required details 1 2 3 4 5 6 7 patient number 7143 3421 7631 9629 4215 6342 2359 patient patient national patient date of name number birth Sara 5698563 14-Jul-2003 Ahmad 2946292 22 Aug 1943 Linda 7355028 5.Feb 1976 Karam 1737649 22. Aur 1984 Muna 8539475 2-Sep-2001 Fadi 9653674 7-Nov-1992 Samar 3372984 6-May 1998 patient address Amman Irbid Karak Amman Zarga Irbid Irbid patient phone 8787878 4545454 1212121 7676767 8989898 1234567 9876543 doctor number 12 32 12 45 76 76 18 doctor doctor medicine medicine name department name dose Rami 512 formet 2x2 Jana 402 surrat 3x2 Rami 512 rodofen 2x2 Sameer 601 rodofen 3x1 Hana 322 bedocy 23 Hana 322 rodofen 3x2 Salam 175 kalrasy 2x1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Factory Active Database For Enterprise Computing

Authors: Schur, Stephen

1st Edition

0471558443, 9780471558446

More Books

Students also viewed these Databases questions