Click here to Skip to main content
15,918,742 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I wish to do a web based 'builders software' which helps to manage and schedule raw material and works of buiders. In this Software, Builders can create projects.
The projects may be Towers(Tower->Floors->Flats),Villas(Single or multiple),Building Complex,Airport etc.Firstly,we create master details of towers,floors,flats,contract
workers and materials for a single flat,villa,house,shop,airport terminals,runway etc.Shortly, we can create a project by choosing these single units. I have no idea about
the db structure suitable for it. Whether parent key method is suitable for web? Please help me...
Posted
Comments
Sergey Alexandrovich Kryukov 16-Dec-13 10:49am    
What is that "parent key method"?
—SA
JoCodes 22-Dec-13 22:30pm    
Parent key method???
JoCodes 22-Dec-13 22:33pm    
Is it that the Primary/Foreign key between relation with Master table and dependent tables?

I think you read 'parent key method' in a magazine and have no idea what it means. I sure have no idea what you mean. Databases use indexes and keys to join values between tables. Good database design is the same no matter what your project, and there's nothing about a web based presentation layer that should ever impact on what your database design is or should be.
 
Share this answer
 
 
Share this answer
 
You need the knowledge of relational database design. You may start your learning journey as follows:
A Quick-Start Tutorial on Relational Database Design

Relational Database Design
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900