To constuct a database system for a whole school based on a grade system what wo

Question

To constuct a database system for a whole school based on a grade system what would you reccomend?

What I have so far:

Business Rules

1. There can be many students in 1 enrollment.

2. There are many enrollments in 1 section.

3. There are many sections in 1 semester.

4. 1 instructor has many sections.

5. 1 student can have many assingments.

6. An enrollment has many assignments.

My entities:

STUDENT

ASSIGNMENTS

ENROLLMENTS

SECTIONS

SEMESTER

INSTRUCTOR

Atributes:

STUDENT, Stu_Number, F_Name, L_Name, Email

ENROLLMENT, Stu_Number, Section_ID, Grade

SECTION, Section_ID, Days,Times, Intructor_ID, Semester, Call_Number, Course,

SEMESTER, Semester ID, Term, Start_Date

INSTUCTOR, Instructor_ID, F_Name, L_Name, Email

I also have to make a relational model. Help

Explanation / Answer

Hi,

Below is the CREATE table statements that helps to create a relational model between the entities listed.

CREATE TABLE STUDENT(Stu_Number VARCHAR(10) PRIMARY KEY, F_Name VARCHAR(10), L_Name VARCHAR(10), Email VARCHAR(15));

CREATE TABLE ENROLLMENT(ENROLL_ID VARCHAR(10) PRIMARY KEY, Stu_Number VARCHAR(10) REFERENCES STUDENT(STU_NUMBER), Section_ID VARCHAR(5) REFERENCES SECTION(SECTION_ID), Grade VARCHAR(1));

CREATE TABLE SECTION(Section_ID VARCHAR(5) PRIMARY KEY, Days NUMBER(3),Times NUMBER(5), Intructor_ID VARCHAR(10) REFERENCES INSTRUCTOR(Intructor_ID), Semester NUMBER(2), Call_Number NUMBER(3), Course VARCHAR(20));

CREATE TABLE SEMESTER(Semester ID VARCHAR(10) PRIMARY KEY, Term VARCHAR(10), Start_Date DATE);

CREATE TABLE INSTUCTOR(Instructor_ID VARCHAR(10) PRIMARY KEY, F_Name VARCHAR(10), L_Name VARCHAR(10), Email VARCHAR(20));

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.