I need a help about this database design with tables and keys 1. The college has

Question

I need a help about this database design with tables and keys 1. The college has some different majors, for example, computer science, software engineering, digital media, network engineering, etc. Each major has several classes and each class has about 30 students. The information about a student involves student ID, name, sex, age, hometown, province, total credits, etc. The information about the course involves course ID, course name, major, credits, etc. One course often has several sections, and one section is taught by one teacher in a semester. The information about the section involves course ID, section ID, semester, year, teaching location, etc. The information about the teacher involves teacher ID, name, sex, age, title, contact phone, office, email, etc. The information about a student’s marks involves student ID, course ID, semester, course marks, etc. Note that: One major has more than one class. One course in a semester needs more than one teacher. And one teacher can take more than one course in a semester

Explanation / Answer

Table name – Faculty

Faculty_ID                varchar(10)    

Faculty_Name           varchar2(10)  

Age                            number

Sex                            varchar(5)

Title                           varchar2(10)

Phone                        number

Office                        number

Email                         varchar2(25)

Department               varchar(10)

Course_ID                varchar(10)

Subject_Handling    varchar2(10)

Faculty_ID                        PK

Course_ID                         FK

Table name – Students

Student_ID                varchar(10)    

Student_Name           varchar2(10)  

Age                            number

Sex                            varchar(5)

Hometown                 varchar2(10)

Phone                        number

Course_ID                varchar(10)

Total_credits               decimal(3,2)

Student_ID                        PK

Course_ID                         FK

Table name – Student_Marks

Student_ID                varchar(10)    

Course_ID                  varchar2(10)  

Semester                      number                         Course_Marks              decimal(3,2)

Student_ID                    PK

Course_ID                        FK

Table name – Course

Course_ID                varchar(10)    

Course_Name           varchar2(10)  

Major                         varchar(10)

Credits                       decimal(2,1)

Subject_Handling    varchar2(10)

Course_ID                        PK

Subject_Handling              FK

Table name – Faculty

Faculty_ID                varchar(10)    

Faculty_Name           varchar2(10)  

Age                            number

Sex                            varchar(5)

Title                           varchar2(10)

Phone                        number

Office                        number

Email                         varchar2(25)

Department               varchar(10)

Course_ID                varchar(10)

Subject_Handling    varchar2(10)

Faculty_ID                        PK

Course_ID                         FK

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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