Quick Order

mysql -u praktikan

show databases;

use <database_name>;

create table Me(my_id int(6), first_name varchar(15), last_name varchar(15), other_details varchar(15), CONSTRAINT my_id_pk PRIMARY KEY (my_id));

create table Social_Networks(network_code varchar(12), network_name varchar(15), network_description varchar(15), CONSTRAINT network_code_pk PRIMARY KEY (network_code));

create table My_Email_Logins(my_login varchar(15), my_id int(6), network_code varchar(12), date_signed_up varchar(20), my_email_name varchar(30), my_email_password varchar(20), other_details varchar(20), CONSTRAINT my_login_pk PRIMARY KEY (my_login), CONSTRAINT my_id_fk FOREIGN KEY REFERENCES Me(my_id), CONSTRAINT network_code_fk FOREIGN KEY REFERENCES Social_Networks(network_code));

create table Mail_Boxes(mail_id int(10), my_login varchar(15), date_received varchar(20), from_email_address varchar(30), from_name varchar(30), subject varchar(20), message varchar(500), other_details varchar(20), CONSTRAINT mail_id_pk PRIMARY KEY (mail_id), CONSTRAINT my_login_fk FOREIGN KEY REFERENCES My_Email_Logins(my_login));

create table Sent_Messages(message_id int(10), my_login varchar(15), date_sent varchar(20), to_email_address varchar(30), subject varchar(20), message varchar(500), other_details varchar(20), CONSTRAINT message_id_pk PRIMARY KEY (message_id) ,CONSTRAINT my_login_fk FOREIGN KEY REFERENCES My_Email_Logins(my_login));

create table Notifications(notification_id int(10), my_login varchar(15), date_received varchar(20), subject varchar(20), message varchar(500), other_details(20), CONSTRAINT notification_id_pk PRIMARY KEY (my_id), CONSTRAINT my_login_fk FOREIGN KEY REFERENCES My_Email_Logins(my_login));

create table Updates(update_id int(10), my_login varchar(15), date_received varchar(20), subject varchar(20), message varchar(500), other_details varchar(20), CONSTRAINT update_id_pk PRIMARY KEY (update_id), CONSTRAINT my_login_fk FOREIGN KEY REFERENCES My_Email_Logins(my_login));