Good day to all, please tell me how to make the correct connection of tables in Oracle. I study just the web so this screen, do not swear. enter image description here

  • Do you mean how to set the foreign key? Those. for the integrity of the entire database schema? - Chubatiy
  • @Chubatiy and foreign key, didn’t quite understand the second question, what does the integrity of the entire database schema mean? - Ethernets
  • four
  • @Chubatiy When changing / deleting a column from the Role table, it is necessary that all the rows of the UserRole and User tables associated with this row should be changed or deleted. - Ethernets
  • Read the article that @Mike recommended to you. + Change the question to what you want to end up with. Like, there is such a table, how to do it ..... - Chubatiy

0