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
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
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 2.12CP
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4555fdce-652f-4c2c-80f0-9af6fd21833b%2F00f7eeb5-60ea-40af-8d6d-089e119dbf54%2Fyl0ubv_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning