Lots of problems here.
Kudzanai Victor wrote:
Select * from ABRASIVE_CUT_OFF_SAW
Problem 1 (most serious): The name of the tool should be kept IN a database column. It should NOT be a table. Design you are looking for is likely like this Table: Tool Columns: Id, Name, Description Table: Tool_Attribute Columns: Tool_Id, Name, Description If you need more detail for Attribute you might add one or two more columns. If more detail than that is added then you might need an additional third table. Once you do the above then getting a list of all tools consists of querying the first table. This includes name, description AND the id. Then detail for a single tool is gotten by using the id from the above list. ------------------------------------------
Kudzanai Victor wrote:
Select * from ABRASIVE_CUT_OFF_SAW
Problem 2: Don't use the asterisk. Rather explicitly name the columns that you want to retrieve.