Last answered:

30 Jul 2021

Posted on:

25 Jul 2021

0

Primary Key for customer ID.

Hi All,

Just wanted to double check in the solution it shows "customer_id INT,". But in the relationship Schema it's underlined meaning it's a primary key. Would it be more accurate if it's "customer_id INT PRIMARY KEY"? Wanted to know if there's a difference with or without hte PRIMARY KEY attached to the end.

Kind regards,

Alan

1 answers ( 0 marked as helpful)
Instructor
Posted on:

30 Jul 2021

0

Hi Alan!

Thanks for reaching out.

I suppose your question also relates to the particular lecture you are at during the SQL course. Adding PRIMARY KEY will ensure the relevant field is a primary key for the given table. Nevertheless, this is something that may not be required at the relevant stage of that course. Can you please post the question under the relevant SQL lecture? This will help us assist you better.
In fact, is there any particular reason why you are asking an SQL-course-related question in the Data Visualization Course Q&A? Your response may help us improve our Q&A support. Thank you!

Hope this helps.
Best,
Martin

Submit an answer