title: What Kind of Relationship is Between These Tables?
body: <p>I have two tables that have foreign keys to each other's primary key. This DB is in French. I will translate the two tables that I want to you to understand.</p>
  
  <ul>
  <li>Atelier Cuisine ==> Kitchen</li>
  <li>Cuisinier == > Cooking chef</li>
  </ul>
  
  <p>So in this picture we see that in the <code>Kitchen</code> table we have a PK referenced by the FK from the <code>Cooking chef</code> table; in the <code>Cooking chef</code> table we have a PK referenced by the FK from the <code>Kitchen</code> table. So I am confused. I don't understand this kind of relationship between these tables.</p>
  
  <p><strong>And I hope to check my query that I did to create these two tables if its correct</strong> </p>
  
  <pre><code>CREATE TABLE [ATELIER CUISINE] ( 
  
  NumCuisine INT NOT NULL PRIMARY KEY,
  TelCuisine VARCHAR(50) NOT NULL
  )
  
  CREATE TABLE CUISINIER (
  
  NumCuisinier  INT NOT NULL PRIMARY KEY,
  NomCuis  VARCHAR(50) NOT NULL,
  DateEmb DATE NOT NULL,
  NumCuisine INT NOT NULL CONSTRAINT FK_CUISINIER_NumCuisine FOREIGN KEY REFERENCES [ATELIER CUISINE](NumCuisine)
  </code></pre>
  
  <p>See the Image here:<br>
  <a href="https://i.stack.imgur.com/sOeAp.png" rel="nofollow noreferrer">Relationship model of the restaurant database</a></p>
  
  <p>See the Image here:<br>
  <a href="https://i.stack.imgur.com/vAPkc.png" rel="nofollow noreferrer">Example records for some tables</a></p>