Virtual university Of Pakistan

#CS403 Query Create Database Bs140201235 use database Bs140201235 CREATE   TABLE   Role ( Role_id   int   not   null   PRIMARY   KEY , name   varchar   not   null ); CREATE   TABLE   Users ( User_id   int   not   null   PRIMARY   KEY , name   varchar   not   null, Role_id   int   FOREIGN   KEY   REFERENCES   dbo . Role ( Role_id ) ); Create   Table   Task ( Task_id   nvarchar ( 50 )   not   null   PRIMARY   KEY , title   varchar ( max )   not   null, creation_date   date , deadline   date , assigned_to   varchar ( max ) ); Create   Table   DiscussionThread ( Thread_id   int   not   null   PRIMARY   KEY , title   varchar   not   null, Task_id   int   FOREIGN   KEY   REFERENCES   dbo . Task ( Task_id ) ); create   table   Messages ( Msg_id    int   not   null   PRIMARY   KEY , message_body   varchar   not   null, sender_id   varchar   not   null, Thread_id   int   FOREIGN   KEY   REFERENCES   dbo . DiscussionThread (