Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Normal form voilations and fixing(Normalisation)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-12-09, 21:14
mahejaranga mahejaranga is offline
Registered User
  
Join Date: Oct 2009
Posts: 4
Normal form voilations and fixing(Normalisation)
Hello everyone,
This is something i have been stuck on for quite a while now.
Can you please help me following tables.

Normal forms violated in the following designs and fix them. There may be multiple normal form violations in the design.
1)PATIENT
patient_id
patient_fname
patient_lname
patient_street
patient_city
patient_state
patient_zip
patient_phone
doctor_id
doc_fname
doc_lname
doc_phone
doc_beeper
2)PATIENT
patient_id
insurance_company
patient_fname
patient_lname
patient_street
patient_city
patient_state
patient_zip
patient_phone
insurance_contact_first
insurance_contact_last
insurance_phone


Thank you
Maheja
Reply With Quote
  #2 (permalink)  
Old 10-12-09, 21:22
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
what is this, some kind of homework assignment?
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 10-12-09, 21:40
mahejaranga mahejaranga is offline
Registered User
  
Join Date: Oct 2009
Posts: 4
Quote:
Originally Posted by r937
what is this, some kind of homework assignment?
you are right, try to solve and help this issue.
Reply With Quote
  #4 (permalink)  
Old 10-13-09, 05:13
gvee gvee is offline
www.gvee.co.uk
  
Join Date: Jan 2007
Location: UK
Posts: 10,156
What is your question?
__________________
George
Twitter | Blog
Reply With Quote
  #5 (permalink)  
Old 10-13-09, 05:39
mike_bike_kite mike_bike_kite is offline
vaguely human
  
Join Date: Jun 2007
Location: London
Posts: 2,519
he just wants us to do his homework George
Reply With Quote
  #6 (permalink)  
Old 10-13-09, 05:41
healdem healdem is offline
Jaded Developer
  
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #7 (permalink)  
Old 10-13-09, 05:54
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
that article on r937.com is by Paul Litwin

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #8 (permalink)  
Old 10-13-09, 05:59
healdem healdem is offline
Jaded Developer
  
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
Quote:
Originally Posted by r937
that article on r937.com is by Paul Litwin

ok so I lied, if the site had been working when I posted the link I may have caught that
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #9 (permalink)  
Old 10-20-09, 10:24
mahejaranga mahejaranga is offline
Registered User
  
Join Date: Oct 2009
Posts: 4
hi
Thank you for your help.

Quote:
Originally Posted by healdem
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.