make UML and relational Schema of those tables $?$

create table students $($ 

 

ID int auto$\_$increment $,$

first$\_$name varchar$(50),$

last$\_$name varchar$(50),$

primary key $($ID$)$

$)$ ;

CREATE TABLE Marks $($

marks$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

student$\_$name VARCHAR$(50)$

student$\_$id INT,

subject VARCHAR$(50),$

marks$\_$obtained DECIMAL$(5,2),$

exam$\_$date DATE

$)$;

CREATE TABLE Fee $($

fee$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

student$\_$id INT,

first$\_$name varchar $(50),$

last$\_$name varchar $50),$

fee$\_$amount DECIMAL$(10,2),$

payment$\_$status VARCHAR$(20),$

due$\_$date DATE

$)$;

CREATE TABLE ConcessionScholarship $($

concession$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

student$\_$id INT,

student$\_$name VARCHAR$(50)$ ;

concession$\_$type VARCHAR$(50),$

percentage DECIMAL$(5,2)$

$)$;

CREATE TABLE faculty $($

faculty$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

student$\_$id INT;

student$\_$name VARCHAR$(50)$;

faculty$\_$name VARCHAR$(100)$ NOT NULL,

department VARCHAR$(50)$

$)$; Could some please make UML and relational Schema of those tables $?$