CREATE TABLE sc (
    
                    studentno INT,
                courseid INT,
    
                    score INT,
    
                    PRIMARY KEY (studentno , courseid)
);

alter table sc add primary key (studentno,courseid);