Answer
CREATE TABLE PET_OWNER(
OwnerID int NOT NULL,
OwnerLastName nvarchar(15) NOT NULL,
OwnerFirstName nvarchar (15) NOT NULL,
OwnerPhone nchar(14) NULL,
OwnerEmail nvarchar(50) NOT NULL
)
GO
ALTER TABLE PET_OWNER
ADD CONSTRAINT PK_OwnerID PRIMARY KEY(OwnerID);
GO
Justification
OwnerID is surrogate key and should be int
OwnerLastName, OwnerFirstName, OwnerEmail are characters with variable length, therefore, nvarchar is best choice
Phone num is of fix length, therefore, nchar is best choice
Work Step by Step
No steps involved
