N/APosted on - 10/18/2011
Hi, I want to design a relational database using four tables. The tables will relate with each other. Such that all records of the parent table will include into child table but the child table only contain those records which are included in the parent table.
How to design a Relational Database using four Tables?
Start by creating the two tables one for parent and children's table, then create the parents table with primary keys, In your case give the parent's, child's name as the primary key. Note that the primary key must be unique. create a foreign key using the primary key created above. This will create a link in the two tables. At this point you've got to test the relationship, you can do this by running a delete command on the parents table, the data should return an error that this command cannot be performed due to some constraints. By getting that message it means you have successfully created a relational database. This I hope will help you sort your relationship database.