Creating Relations in SQL

Creates the Students relation. Observe that the type (domain) of each field is specified, and enforced by the DBMS whenever tuples are added or modified.

As another example, the Enrolled table holds information about courses that students take.

CREATE TABLE Students

(sid: CHAR(20),

name: CHAR(20),

age: INTEGER,

gpa: REAL)

CREATE TABLE Enrolled

(sid: CHAR(20),

cid: CHAR(20),

grade: CHAR(2))

Creates the Students relation. Observe that the type (domain) of each field is specified, and enforced by the DBMS whenever tuples are added or modified.