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

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 2.12CP
icon
Related questions
Question

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
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
Transcribed Image 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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Data Modeling Concepts
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
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning