create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),primary key (ownerID:));Choose the correct option regarding the above statement

• A. The statement is syntactically wrong
• B. It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
• C. It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
• D. It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.