Question: create table students ( ID int auto _ increment , first _ name varchar ( 5 0 ) , last _ name varchar ( 5
create table students
ID int autoincrement
firstname varchar
lastname varchar
primary key ID
;
CREATE TABLE Marks
marksid INT AUTOINCREMENT PRIMARY KEY,
studentid INT,
subject VARCHAR
marksobtained DECIMAL
examdate DATE
;
CREATE TABLE Fee
feeid INT AUTOINCREMENT PRIMARY KEY,
studentid INT,
feeamount DECIMAL
paymentstatus VARCHAR
duedate DATE
;
CREATE TABLE ConcessionScholarship
concessionid INT AUTOINCREMENT PRIMARY KEY,
studentid INT,
concessiontype VARCHAR
percentage DECIMAL
;
CREATE TABLE faculty
facultyid INT AUTOINCREMENT PRIMARY KEY,
facultyname VARCHAR NOT NULL,
department VARCHAR
; Could someone make UML and relational Schema of those tables
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
