Last answered:

10 Dec 2022

Posted on:

07 Nov 2022

0

Resolved: Non null values

Why, in the solution, there's no NOT NULL included in each column? Are we supposed to not have information of customers included?

4 answers ( 2 marked as helpful)
Instructor
Posted on:

07 Nov 2022

2

Hi Ana!
Thanks for reaching out.

You are correct if we talk about a real database. You have to think that this is not a real database and for now the NULL for customer_id will work.

Hope this helps.
Best,
Tsvetelin

Posted on:

07 Nov 2022

0

Thanks! It's more clear now :)

Posted on:

10 Nov 2022

0

yeah there should be not null clause for customer_id since it will act as primary key in relationship schema

Posted on:

10 Dec 2022

0

I would recommend that the solution file be corrected. On the one hand, we are learning that the primary key MUST be given as NOT NULL values, while on the other hand, you are claiming that we are not working with real data! It's a little odd. Whether it is or not, we need a proper schema in place; aren't we expected to do it here?

Submit an answer