Question: create table students ( ID int auto _ increment , first _ name varchar ( 5 0 ) , last _ name varchar ( 5

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_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,
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,
concession_type VARCHAR(50),
percentage DECIMAL(5,2)
);
CREATE TABLE faculty (
faculty_id INT AUTO_INCREMENT PRIMARY KEY,
faculty_name VARCHAR(100) NOT NULL,
department VARCHAR(50)
); 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!