Scribd
Upload
16 views1 page

Database Normalization Overview

This document contains a table with doctor appointment information in first normal form, including doctor number, name, room number, appointment code, date, time, patient number and name. The information is denormalized with repeating values like doctor name and room number for each appointment.

Uploaded by

Shaira Bugayong
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
16 views1 page

Database Normalization Overview

This document contains a table with doctor appointment information in first normal form, including doctor number, name, room number, appointment code, date, time, patient number and name. The information is denormalized with repeating values like doctor name and room number for each appointment.

Uploaded by

Shaira Bugayong
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

First Normal Form

Doctor Doctor Name Doctor Appointment Appointment Appointment Patient Patient


No. Room No. Code Date Time No. Name
1 Smith J G5 2016/702 2/9/16 10.20 217 Jones J
1 Smith J G5 2016/717 3/9/16 9.40 357 Patel J
3 Mills D G2 2016/726 3/9/16 13.40 87 Brown G
4 Fitzgerald D G3 2016/705 2/9/16 11.20 412 Wilson P

Second Normal Form

You might also like