Тopic 1 HT_ ID Date_Ceeated Approved Title Spec_ID (FK) TType_ID (FK) UserName (FK) Position PosID Pos_Name Pos_Description Specialty Spec_ID Spec_name Spec_Desc 1 1 N N 1 Topic_Type TType_ID T_Name...


Normalize your tables to the third normal form. Show your work in details. Is it in First, Second, or third? And explain why.
You don't need more info, you just need to explain why they are in the First, Second, or third normal form. There no coding.


Тopic<br>1<br>HT_ ID<br>Date_Ceeated<br>Approved<br>Title<br>Spec_ID (FK)<br>TType_ID (FK)<br>UserName (FK)<br>Position<br>PosID<br>Pos_Name<br>Pos_Description<br>Specialty<br>Spec_ID<br>Spec_name<br>Spec_Desc<br>1<br>1<br>N<br>N<br>1<br>Topic_Type<br>TType_ID<br>T_Name<br>T_Description<br>Doctor<br>Doc_ID<br>Doc_BIOData<br>PosID (FK)<br>Spec_ID (FK)<br>UserName (FK)<br>N<br>N<br>User<br>UserName<br>Password<br>1<br>1<br>1<br>Date_Created<br>FName<br>1<br>LName<br>User_Type<br>UserType_ID<br>UserType_Name<br>UserType_Description<br>N<br>Date_Created<br>UserType_ID (FK)<br>Reply<br>Rep_ID<br>N<br>Reply<br>Reply_Date<br>T_ID (FK)<br>UserName (FK)<br>Rating<br>Rat ID<br>Rat_Date<br>Rat_Rating<br>Rat Comment<br>Pat_ID (FK)<br>Doc_ID (FK)<br>N<br>N<br>N<br>Medicine<br>Patient_Medicine<br>(Start_Date<br>End_Date<br>Med_ID<br>Med_Name<br>Med_Description<br>Med_Price<br>1<br>Patient<br>1<br>+Pat_ID<br>Pat_Condition<br>UserName (FK)<br>N<br>Pat_ID (FK)<br>|Med_ID FK)<br>N<br>

Extracted text: Тopic 1 HT_ ID Date_Ceeated Approved Title Spec_ID (FK) TType_ID (FK) UserName (FK) Position PosID Pos_Name Pos_Description Specialty Spec_ID Spec_name Spec_Desc 1 1 N N 1 Topic_Type TType_ID T_Name T_Description Doctor Doc_ID Doc_BIOData PosID (FK) Spec_ID (FK) UserName (FK) N N User UserName Password 1 1 1 Date_Created FName 1 LName User_Type UserType_ID UserType_Name UserType_Description N Date_Created UserType_ID (FK) Reply Rep_ID N Reply Reply_Date T_ID (FK) UserName (FK) Rating Rat ID Rat_Date Rat_Rating Rat Comment Pat_ID (FK) Doc_ID (FK) N N N Medicine Patient_Medicine (Start_Date End_Date Med_ID Med_Name Med_Description Med_Price 1 Patient 1 +Pat_ID Pat_Condition UserName (FK) N Pat_ID (FK) |Med_ID FK) N

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here