Is this database normalised?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
Yes.

The schema I showed would allow any number of parties to participate in any
number of contracts. This is called a many to many or M:M relationship.

What you describe below would allow any number of parties to participate ina
a single contract. This is called a one to many or 1:M relationship.
 
wzForms
-----------
You can do this yourself
1) Create a new mda file call it wzForms.mda
(See note below)
2) Go to the Tools menu and select Options
In the dialog
a) select the View tab
b) Tick "Hidden objects" and "System objects"
c) Click OK
3) Go to the File Menu and select "Get External Data/Import"
a) Navigate to and select the A97 version of wzForms.mda
b) On the Tables tab select all the tables except the ones that
start MSys
c) On the Queries, Forms, Reports, Macros and Modules tabs select
all
e) Click OK
4) Press Ctrl-G to go to the debug window
5) Enter the following in the debug window and hit the enter key
CodeDb.Properties.Append Codedb.CreateProperty("RevNo", dbText,
"1.0")
6) Choose the "Debug/Compile wzForms" menu option
7) Close the code window
8) In the database window choose "Tools/Database Utilities/Compact and
Repair" menu option
9) Close the add-in
10) Install the Add-In

Note: If you do not keep the name the same you will have to edit the
USysRegInfo table to get the Ad-In to register.
 
wzForms
-----------
You can do this yourself
1) Create a new mda file call it wzForms.mda
(See note below)
2) Go to the Tools menu and select Options
In the dialog
a) select the View tab
b) Tick "Hidden objects" and "System objects"
c) Click OK
3) Go to the File Menu and select "Get External Data/Import"
a) Navigate to and select the A97 version of wzForms.mda
b) On the Tables tab select all the tables except the ones that
start MSys
c) On the Queries, Forms, Reports, Macros and Modules tabs select
all
e) Click OK
4) Press Ctrl-G to go to the debug window
5) Enter the following in the debug window and hit the enter key
CodeDb.Properties.Append Codedb.CreateProperty("RevNo", dbText,
"1.0")
6) Choose the "Debug/Compile wzForms" menu option
7) Close the code window
8) In the database window choose "Tools/Database Utilities/Compact and
Repair" menu option
9) Close the add-in
10) Install the Add-In

Note: If you do not keep the name the same you will have to edit the
USysRegInfo table to get the Ad-In to register.
 
Close, you would create records in contracts and parties and then create
records in contractsparties to associate the contracts and the parties with
each other.
 
Close, you would create records in contracts and parties and then create
records in contractsparties to associate the contracts and the parties with
each other.
 
TK: I'm confused. You are one of the presenters of the 3-table solution,
but you answer "Yes" to the poster's question about whether he can do what
he wants with 2 tables. ???
 
TK: I'm confused. You are one of the presenters of the 3-table solution,
but you answer "Yes" to the poster's question about whether he can do what
he wants with 2 tables. ???
 
Rick,
If you re-read the OPs post where you answered No and I answered Yes <g>,
you'll see he's describing a 1:M relationship as the desired one.

I'm as surprised at this as you, I suspect, I would have expected a M:M, but
the OP should be better at assessing his needs than I am, if he says he
wants 1:M then I'm not going to argue.
 
Rick,
If you re-read the OPs post where you answered No and I answered Yes <g>,
you'll see he's describing a 1:M relationship as the desired one.

I'm as surprised at this as you, I suspect, I would have expected a M:M, but
the OP should be better at assessing his needs than I am, if he says he
wants 1:M then I'm not going to argue.
 
Thanks Terry
Tony
Terry Kreft said:
wzForms
-----------
You can do this yourself
1) Create a new mda file call it wzForms.mda
(See note below)
2) Go to the Tools menu and select Options
In the dialog
a) select the View tab
b) Tick "Hidden objects" and "System objects"
c) Click OK
3) Go to the File Menu and select "Get External Data/Import"
a) Navigate to and select the A97 version of wzForms.mda
b) On the Tables tab select all the tables except the ones that
start MSys
c) On the Queries, Forms, Reports, Macros and Modules tabs select
all
e) Click OK
4) Press Ctrl-G to go to the debug window
5) Enter the following in the debug window and hit the enter key
CodeDb.Properties.Append Codedb.CreateProperty("RevNo", dbText,
"1.0")
6) Choose the "Debug/Compile wzForms" menu option
7) Close the code window
8) In the database window choose "Tools/Database Utilities/Compact and
Repair" menu option
9) Close the add-in
10) Install the Add-In

Note: If you do not keep the name the same you will have to edit the
USysRegInfo table to get the Ad-In to register.
Click to expand...
 
Thanks Terry
Tony
Terry Kreft said:
wzForms
-----------
You can do this yourself
1) Create a new mda file call it wzForms.mda
(See note below)
2) Go to the Tools menu and select Options
In the dialog
a) select the View tab
b) Tick "Hidden objects" and "System objects"
c) Click OK
3) Go to the File Menu and select "Get External Data/Import"
a) Navigate to and select the A97 version of wzForms.mda
b) On the Tables tab select all the tables except the ones that
start MSys
c) On the Queries, Forms, Reports, Macros and Modules tabs select
all
e) Click OK
4) Press Ctrl-G to go to the debug window
5) Enter the following in the debug window and hit the enter key
CodeDb.Properties.Append Codedb.CreateProperty("RevNo", dbText,
"1.0")
6) Choose the "Debug/Compile wzForms" menu option
7) Close the code window
8) In the database window choose "Tools/Database Utilities/Compact and
Repair" menu option
9) Close the add-in
10) Install the Add-In

Note: If you do not keep the name the same you will have to edit the
USysRegInfo table to get the Ad-In to register.
Click to expand...
 
What we have is a set of contracts where there can be upto 3 parties to each
contract but we wouldn't have a party to any number of contracts so I think
yes I have a 1 to many relationship?
Thanks for your guidance Terry
Tony
 
What we have is a set of contracts where there can be upto 3 parties to each
contract but we wouldn't have a party to any number of contracts so I think
yes I have a 1 to many relationship?
Thanks for your guidance Terry
Tony
 
Got it.

Terry Kreft said:
Rick,
If you re-read the OPs post where you answered No and I answered Yes <g>,
you'll see he's describing a 1:M relationship as the desired one.

I'm as surprised at this as you, I suspect, I would have expected a M:M,
but
the OP should be better at assessing his needs than I am, if he says he
wants 1:M then I'm not going to argue.
Click to expand...
 
Got it.

Terry Kreft said:
Rick,
If you re-read the OPs post where you answered No and I answered Yes <g>,
you'll see he's describing a 1:M relationship as the desired one.

I'm as surprised at this as you, I suspect, I would have expected a M:M,
but
the OP should be better at assessing his needs than I am, if he says he
wants 1:M then I'm not going to argue.
Click to expand...
 
Back
Top