plz normalize this table for me

#1

plz break this table in 3-4 table and create relationship among them

Name
Father name
class
Roll number
address
city
country
province
post code
cell number
phone number
Religion
Gender

i will b very thank ful to you

#2

On 2 dec, 14:15, "M.Shariq" <shari... (AT) gmail (DOT) com> wrote:

Quote:

plz break this table in 3-4 table and create relationship among them

Name
Father name
class
Roll number
address
city
country
province
post code
cell number
phone number
Religion
Gender

i will b very thank ful to you

This group is not a home-work service. But some help will be provided
if you show that you have made serious effort to solve the problem
yourself and can make clear and explicit why you are now stuck. You
could start by saying which functional dependencies you think hold,
which normal form you would like to achieve, what you think the steps
of the normalization proces are and which of these steps you have
difficulties with.

-- Jan Hidders

#3

paul c wrote:

Quote:

Jan Hidders wrote:
...

This group is not a home-work service. But some help will be provided
if you show that you have made serious effort to solve the problem
yourself and can make clear and explicit why you are now stuck. You
could start by saying which functional dependencies you think hold,
which normal form you would like to achieve, what you think the steps
of the normalization proces are and which of these steps you have
difficulties with.

Right you are. Also, I remember being criticized by some pedant for
including a "post code" in the same base relation as the address. Often
the "business" purpose is sometimes more important to decide which FD's
to choose. Some people think the use of codes should always involve
an appeal to external authority, even for the simplest of systems. (I
usually read that technocrats as meaning higher authority. Ralston-Saul
calls technocrats the descendants of reason.)

The question looked like it had to do with Canada, where some postal
codes don't determine address, eg., H0H H0H determines a person (or
should I say entity?) named Santa Claus! Such a letter will get
delivered even to him even if his North Pole address is omitted. Even
if that weren't so I think it depends on the app whether one wants to
use FD's for integrity checking as opposed to structural normalization.

This might help demonstrate why it is always harder to explain a design!

There was a typo in the postal code: H0H 0H0

#4

"M.Shariq" <shariq2k (AT) gmail (DOT) com> wrote

Quote:

plz break this table in 3-4 table and create relationship among them

Name
Father name
class
Roll number
address
city
country
province
post code
cell number
phone number
Religion
Gender

i will b very thank ful to you

If you will tell us what the functional dependencies are, it will be much
easier to help you normalize. This comment can either be taken seriously or
dismissed as sarcasm. Your choice.

#5

On 2 dec, 14:15, "M.Shariq" <shari... (AT) gmail (DOT) com> wrote:

Quote:

plz break this table in 3-4 table and create relationship among them

Name
Father name
class
Roll number
address
city
country
province
post code
cell number
phone number
Religion
Gender

i will b very thank ful to you

Don't worry too much about 'Normal States'. Your table has 13 columns
or attributes.

Simply ask yourself 'does this atribute identify an item that exists
on its own?'
If the answer is 'yes' create a separate table for this item with the
attribute as its primary key.
Repeat until you have about four tables.

Decide to which item the remaining attributes belong, add attributes
to the relevant tables.

That's all

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

plz normalize this table for me

comp.databases.theory comp.databases.theory

plz normalize this table for me - 12-02-2007 , 07:15 AM

Re: plz normalize this table for me - 12-02-2007 , 08:11 AM

Re: plz normalize this table for me - 12-02-2007 , 09:49 AM

Re: plz normalize this table for me - 12-02-2007 , 06:12 PM

Re: plz normalize this table for me - 12-04-2007 , 07:31 AM