Pillow Fight Club Database Design

The assignment content is about creating a database for a Pillow Fight Club. It includes traditional UML, executable UML, and table creation statements. The tables include 'pillow_fight_type' and 'Fight_Members', with constraints such as primary keys and foreign keys.

0 | P a g e
PILLOW FIGHT CLUB ASSIGNMENT
STUDENT
18 SEPTEMBER, 2016

Contents
TRADITIONAL UML................................................................................................................................2
EXECUTABLE UML..................................................................................................................................3
TABLE CREATION STATEMENTS.............................................................................................................4
1 | P a g e

TRADITIONAL UML
2 | P a g e

EXECUTABLE UML
3 | P a g e

TABLE CREATION STATEMENTS
Create table pillow_fight_type
( Type_Id int,
Type_name text,
CONSTRAINT pk_pfight PRIMARY KEY (Type_Id)
);
Create table Fight_Members
( Fight_Id VarChar(20),
Fight_Member_Id VarChar(20),
Food_Rating int,
Food_Bought text,
CONSTRAINT pk_fight_mem PRIMARY KEY ( Fight_id, Fight_Member_Id),
CONSTRAINT fk1_fight foreign key(Fight_Id) references pillow_fight(Fight_id),
CONSTRAINT fk2_mem foreign key(Member_Id) references Club_member(member_id)
);
4 | P a g e