How to design a Relational Database using four Tables?

Asked By mozid 0 points N/A Posted 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.

• Status: Open
• Question Views: 758
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Lily4662 0 points N/A #93824

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.

 

About Lily4662

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/19/2011
• Question Category: Oracle Database