To create a new table Faculty with FID auto_increment To create a relationship table called course with ON DELETE CASCADE integrity constraint