locked
Stand-alone tables for populating dropdown lists only RRS feed

  • Question

  • Hello All,

    I have researched for best practices regarding the use of database tables which are only used for populating dropdown lists, with no relationship to other database tables, but have been unable to find information relative to this design. I wish to follow best practices of industry standards, so I am posing my question here.

    My application is an Auto Maintenance application to track vehicle maintenance. My database design consists of tables which participate in the ERD, however, I want to add several other 'stand-alone' tables which do not interact with other tables. Is this a valid database design? For example, as part of my ASP.Net/C# app, I want the user to be able to select a vehicle, and during page_load(), I will invoke database access to read from several tables to fill several textboxes on the form. These tables include, Vehicle Manufactured Year, Make, Model, VIN. These tables have no relationship to the other tables in my database.

    Thank You, and any help is appreciated.

    Saturday, January 19, 2019 3:31 PM

Answers

All replies

  • I would ask here:

    https://forums.asp.net/37.aspx/1?C+


    Richard Mueller - MVP Enterprise Mobility (Identity and Access)

    Saturday, January 19, 2019 3:34 PM
  • Hi Richard,

    Thank you for the quick response. I think this is a Database design issue, and not a C# issue. Would you agree? Or are you saying I should post the question in the link you provided even though it is a DB issue?

    Thanks again, and sorry for any confusion on my part.

    Saturday, January 19, 2019 3:38 PM
  • I don't know what database you are using. I find that ERD is now DaRT, part of MDOP. If that specifies the database, then perhaps ask here:

    https://social.technet.microsoft.com/Forums/en-US/home?category=MDOP


    Richard Mueller - MVP Enterprise Mobility (Identity and Access)

    Saturday, January 19, 2019 3:47 PM
  • Thank You Richard. I am using Microsoft SQL Server 2012 Management System. I have always referred to the relationship between tables as an ERD (Entity Relationship Diagram).
    Saturday, January 19, 2019 3:59 PM
  • SQL Server forums are over here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Marked as answer by NeedToKnowMore Saturday, January 19, 2019 5:17 PM
    Saturday, January 19, 2019 4:19 PM
  • Thank You Dave.
    Saturday, January 19, 2019 5:02 PM
  • You're welcome.

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Saturday, January 19, 2019 5:07 PM