Jump to content

normalizing a relationship


dmaxj
 Share

This topic is 6501 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am trying to reduce a relationship from an inherited database. I think I have an idea, but I wanted to see what others thought.

I have table A, with two fields. The fields are E and S [A:E and A:S]. Field E has redundant names. Field S is dependent on field E, meaning that I can't have S without E. As it stands now, each record is composed of a single E and a single S. Therefore, i could say that the combination of E and S give me a primary key.

Would it be wise to break the E field into its own table (forcing a new Primiary key) and creating new tables for S. I assume that this would mean that I would have to make new relationships for S. But, I would reduce the current one table.

An I making sense?

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

This topic is 6501 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.