Question

Do a queries batch 1 (QB1): queries requiring a single table for the following project idea:

Description:

This is a solution that saves student records for an educational institution. I will keep their information, subjects, fees, and their academic progress. My DBMS based solution will allow the client to save a lot of time and effort. My design goal is to separate files for each student where the data will store information about the student.

Schema:

Student's Information

Fees

Subjects

Grades

Student’s Information (ID, Firstname, Lastname, DOB);

Fees (ID, Orientationfees, Campusfees, Labfees, Commencementfees);

Subjects (ID, Subject1, Subject2, Subject3, Subject4);

Grades (ID, Quizzes, Classwork, Homework, Exams, Finalgrade);

Student's Information

ID	Firstname	Lastname	DOB

Fees

ID	Orientationfees	Campusfees	Labfees	Commencementfees

Subjects

ID	Subject1	Subject2	Subject3	Subject4

Grades

ID	Quizzes	Classwork	Homework	Exams	Finalgrade

Here is my DDL:

• create table Student_Information(StudentID integer primary key,FirstName char(20),LastName char(20),DOM date);
• create table Fees(FeeID integer primary key,OrientationFee integer,CampusFee integer,LabFee integer,CommencementsFee integer);

• create table Subjects(SubjectID integer primary key,Subject1 char(20),Subject2 char(20),Subject3 char(20),Subject4 char(20));

• create table Grades(GradeID integer primary key,Quizzes integer,Classwork integer,Homework integer,Exmas integer,Finalgrade char(1));

Answer 1