make UML and relational Schema of those tables ? create table students ( ID int
Fantastic news! We've Found the answer you've been seeking!
Question:
make UML and relational Schema of those tables
create table students
ID int autoincrement
firstname varchar
lastname varchar
primary key ID
;
CREATE TABLE Marks
marksid INT AUTOINCREMENT PRIMARY KEY,
studentname VARCHAR
studentid INT,
subject VARCHAR
marksobtained DECIMAL
examdate DATE
;
CREATE TABLE Fee
feeid INT AUTOINCREMENT PRIMARY KEY,
studentid INT,
firstname varchar
lastname varchar
feeamount DECIMAL
paymentstatus VARCHAR
duedate DATE
;
CREATE TABLE ConcessionScholarship
concessionid INT AUTOINCREMENT PRIMARY KEY,
studentid INT,
studentname VARCHAR ;
concessiontype VARCHAR
percentage DECIMAL
;
CREATE TABLE faculty
facultyid INT AUTOINCREMENT PRIMARY KEY,
studentid INT;
studentname VARCHAR;
facultyname VARCHAR NOT NULL,
department VARCHAR
; Could some please make UML and relational Schema of those tables
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: