Database for Bridge Asset Management
-
Hi everyone, I wanted to ask a question that was confusing me how to design the db.This bridge database that i was going to design has 3 different districts(Locations) say A,B and C.These districts have different road segments,sections.I temporarily designed the db using separate tables but having the same fields.As i said these tables only differ by the thing i mentioned. I know I'm not following the design rules,so i need you to help me on that. Thanks
-
Hi everyone, I wanted to ask a question that was confusing me how to design the db.This bridge database that i was going to design has 3 different districts(Locations) say A,B and C.These districts have different road segments,sections.I temporarily designed the db using separate tables but having the same fields.As i said these tables only differ by the thing i mentioned. I know I'm not following the design rules,so i need you to help me on that. Thanks
And when the next district is added, you add another table? No! Create a table for the districts, and then use "foreign keys" to connect to the sections table.
-
Hi everyone, I wanted to ask a question that was confusing me how to design the db.This bridge database that i was going to design has 3 different districts(Locations) say A,B and C.These districts have different road segments,sections.I temporarily designed the db using separate tables but having the same fields.As i said these tables only differ by the thing i mentioned. I know I'm not following the design rules,so i need you to help me on that. Thanks
Nebilo wrote:
I know I'm not following the design rules,so i need you to help me on that.
How? Yes, I could sum up some widely used constructs, but that's not a decent alternative for a good design. There's explanation on database-normalization in the wikipedia, and various articles on CodeProject. Alternatively, you could fake a design[^]. I'll gladly help with the normalization rules if you get stuck :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
And when the next district is added, you add another table? No! Create a table for the districts, and then use "foreign keys" to connect to the sections table.
Bernhard Hiller wrote:
foreign keys
What be these
foreign keysyou speak of!Never underestimate the power of human stupidity RAH
-
And when the next district is added, you add another table? No! Create a table for the districts, and then use "foreign keys" to connect to the sections table.
BTW there are fields that provide the bridge information,it's bridge number(p.k),name,design year,asset value and other fields. Now there are 3 different districts A,B and C.Under District A,there are different sections and road segments that correspond to A only.Same thing goes to B and C.These districts are not related in any way in other words. That's why i created 3 separate tables based on these districts.
