Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Change this table to 1NF, 2NF and 3NF: Regno Name DOB Phone Gender CIDCName Ins_ID Ins_Name Ins_Office 14M01 Kumar 12-Jan-1996 12345 M C1 DBMS 11

Change this table to 1NF, 2NF and 3NF:

image text in transcribed

Regno Name DOB Phone Gender CIDCName Ins_ID Ins_Name Ins_Office 14M01 Kumar 12-Jan-1996 12345 M C1 DBMS 11 Kesav G123 14M05 Mary 10-Jun-1995 12367 F C1 DBMS 11 Kesav G123 14M07 Ram 10-May-1996 12898 C1 DBMS 12 Ragav G127 14M01 Kumar 12-Jan-1996 12345 M C3 DS 15 Mani G125 14B01 Revathi 10-Dec-1995 23456 F C3 DS 15 Mani G125 14M09 Steve 23-Oct-1995 34567 C4 OS 15 Mani G125 14B03 Ramya 20-Jul-1996 23456 F C4 OS 15 Mani G125

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

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions

Question

What is the most important part of any HCM Project Map and why?

Answered: 1 week ago