Does an Array (UUID[ ]) break 1NF?

Viewed 1050

My question is whether the inclusion of a field that contains an array of UUIDs breaks the Normal Form, in a table that before the inclusion of the array was in NF?

Original table:

CREATE TABLE Floor
(
    "Floor-ID" uuid NOT NULL,
    "Floor-Floor" smallint NOT NULL,
    "Floor-Desc" varchar(300),
    CONSTRAINT "Floor-PK" PRIMARY KEY ("Floor-ID")
);

New table, including UUID array:

CREATE TABLE Floor
(
    "Floor-ID" uuid NOT NULL,
    "Floor-Floor" smallint NOT NULL,
    "Floor-Desc" varchar(300),
    "Floor-Room-IDs" uuid[] NOT NULL,
    CONSTRAINT "Floor-PK" PRIMARY KEY ("Floor-ID")
);


Does the inclusion of uuid[] break Normal Form?
(The same UUID could theoretically exist in multiple UUID arrays on multiple rows.)

1 Answers
Related