CDB101 Database Design and Management

Assessment Rubric

Assignment: 30%

Exam: 70%

From 2018 onward, this unit will use the IT211 SQL study guide.

Here's an example of a database:

*Note: the parent tables are the Product and the Manufacturer.

Here's an example of a CREATE TABLE statement.

CREATE TABLE PLAYERS

(PLAYERNO INTEGER NOT NULL,

PNAME CHAR(15) NOT NULL,

INITIALS CHAR(3) NOT NULL,

BIRTH_DATE DATE,

SEX CHAR(1) NOT NULL,

JOINED SMALLINT NOT NULL,

STREET VARCHAR(30) NOT NULL,

HOUSENO CHAR(4),

POSTCODE CHAR(6),

TOWN VARCHAR(30) NOT NULL,

PHONENO CHAR(13),

LEAGUENO CHAR(4),

PRIMARY KEY (PLAYERNO) );

Additional Note:

Best Regards,