Normalization - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Normalization

Author

Topic

Nhad29
Starting Member

4 Posts

Posted - 2009-04-13 : 12:53:13

Hi, i have the following table to normalize to 3NF can i please be assisted thanks

Admissions (PatientId, RoomId, AdmitDate, PatientName, RoomCostPerNight, DischargeDate)

N. Gittens

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-13 : 13:01:54

[code]Patients:
PatientID (PK)
PatientName

Rooms:
RoomID (PK)
RoomCostPerNight

PatientRoom:
PatientID (PK)(FK)
RoomID (PK) (FK)
AdmitDate
Dischargedate[/code]

Nhad29
Starting Member

4 Posts

Posted - 2009-04-13 : 13:09:40

Thank you very much sodeep

N. Gittens

Nhad29
Starting Member

4 Posts

Posted - 2009-04-13 : 13:12:27

Hey sodeep you have been a great help but am new to the steps can you please clarify what firm it is for me please whether 1NF or 2NF or 3NF
thanks

N. Gittens

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-13 : 13:12:54

You are welcome. That will remove delete and update anamoly.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-04-13 : 14:04:17

http://databases.about.com/od/specificproducts/a/normalization.htm

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Nhad29
Starting Member

4 Posts

Posted - 2009-04-13 : 15:31:06

Thanks all you all have been a great help

N. Gittens

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources