RE: Sufficient reason to de-normalize a field?

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 09:31:00 GMT

Hi Earl,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know how to design the
database structure without redundant data in a senario that payee is
automatically added into database. If there is any misunderstanding, please
feel free to let me know.

Based on my experience, you can also keep your database from redundant data
in this case. When adding payee to the database table, we can first check
for existence in the subordinate table to see if this name has been added.
If it hasn't been added, add it. The insert procedure returns the ID for
the payee. Then we use this ID to update the payee's ID in the main table
and insert the payment transaction into database.

HTH. If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Database design
    ... If you've done any database design at all you know the 'correct' database ... lot of typos, eliminates redundant data ... - Easier to select entries by Season and League because you will use numbers ...
    (microsoft.public.inetserver.asp.db)
  • Re: Sufficient reason to de-normalize a field?
    ... Great solution Kevin. ... > database structure without redundant data in a senario that payee is ... > automatically added into database. ... When adding payee to the database table, ...
    (microsoft.public.vb.database)
  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)
  • Re: O/R Mapper
    ... | - create E/R model from niam model ... classes that contain, not only data, but also functionality as OO design is ... a database where they do not exist in the object model is corrupting the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)