Relational Database Tutorials

3.1 Another example: Patient Database

Identify any repeating groups and functional dependences in the PATIENT relation. Show all the intermediate steps to derive the third normal form for PATIENT.

PATIENT(patno,patname,gpno,gpname,appdate,consultant,conaddr,sample)

patno	patname	gpno	gpname	appdate	consultant	conaddr	sample
01027	Grist	919	Robinson	3/9/2004	Farnes	Acadia Rd	blood
				20/12/2004	Farnes	Acadia Rd	none
				10/10/2004	Edwards	Beech Ave	urine
08023	Daniels	818	Seymour	3/9/2004	Farnes	Acadia Rd	none
08023	Daniels	818	Seymour	3/9/2004	Russ	Fir St	sputum
191146	Falken	717	Ibbotson	4/10/2004	Russ	Fir St	blood
001239	Burgess	818	Seymour	5/6/2004	Russ	Fir St	sputum
007249	Lynch	717	Ibbotson	9/11/2004	Edwards	Beach Ave	none

For this exercise, please, write down all steps in a text editor. Once you have the First Normal Form, click "next" to compare your results to the model answer.

Index