# data[].attributes.headline
I have confusion in number data type in oracle.If Number(4,1), what would be 123.1 or 12.10 or 12.1?

# data[].attributes.subject
I have confusion in number data type in oracle.If Number(4,1), what would be 123.1 or 12.10 or 12.1?

# data[].attributes.body
I'm still not sure when to add NOT NULL and when is not. Sometimes there's a PK and FK that has it, sometimes not. The same with UNIQUE.

# data[].attributes.body
Sir, for NUMBER(1,1) I feel 0.1 will be accepted, 1.0 will not be accepted and 1 will be undertaken as 1.0 hence will not be accepted.

Could you please correct me if I have mistaken ?

# data[].attributes.headline
What is the role of primary key constraints? Are there any rules for naming it?

# data[].attributes.subject
What is the role of primary key constraints? Are there any rules for naming it?

# data[].attributes.headline
Cannot access the quiz for the Gallery Physical Model

# data[].attributes.subject
Cannot access the quiz for the Gallery Physical Model

# data[].attributes.body
This action is prohibited. Only enrolled users can access this resource.

I am receiving this error.

# data[].attributes.headline
Translating from Conceptual Design to Logical Design

# data[].attributes.subject
Translating from Conceptual Design to Logical Design

# data[].attributes.body
Hello, Dr. Stordy

These were the instructions given to assemble a logical design from a conceptual diagram, in the video on physical design the gallery database was designed differently from these instructions, I find myself being confused between the instructions given and what to implement actually.

Are we creating the painting table because it is a more elegant solution?

If so, does that mean that these instructions are not a hard and fast rule?

# data[].attributes.body
Hello, Dr. Stordy,

Regarding this slide with the example of look up, I'd like to ask you why the foreign key for reference (THAMES_YACHT_TYPE_LU) is not included in the table (THAMES_YACHT) as an additional column. Is it because values in look-up table don't need to be added as an additional column unlike other foreign keys we learned?

# data[].attributes.body
What's the difference between Oracle's VARCHAR and VARCHAR2?