Question of the Day
Of these items, which are tables according to the relational model from Dr. Codd?
CREATE TABLE dbo.Customers_a
(
CustomerID INT IDENTITY(1, 1) NOT NULL,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
Email NVARCHAR(100) NOT NULL,
);
CREATE TABLE dbo.Customers_b
(
CustomerID INT IDENTITY(1, 1) PRIMARY KEY,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
Email NVARCHAR(100) NOT NULL,
);
CREATE TABLE dbo.Customers_c
(
CustomerID INT NULL IDENTITY(1, 1),
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
);
CREATE TABLE dbo.Customers_d
(
CustomerID INT NOT NULL ,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
Email NVARCHAR(100) NOT NULL,
);
See possible answers