Scribd
Upload
7 views2 pages

Relational Model English Course Database

The document outlines a relational database model for an English course, detailing four main entities: Student, Course, Teachers, and Enrollment. Each entity includes specific fields, data types, and descriptions, such as student identifiers, course details, and teacher specialties. The Enrollment entity connects students to courses and teachers, tracking their enrollment status and dates.

Uploaded by

cheraghalisalihi4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Relational Model English Course Database

The document outlines a relational database model for an English course, detailing four main entities: Student, Course, Teachers, and Enrollment. Each entity includes specific fields, data types, and descriptions, such as student identifiers, course details, and teacher specialties. The Enrollment entity connects students to courses and teachers, tracking their enrollment status and dates.

Uploaded by

cheraghalisalihi4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Relational Model - English Course

Database
1. Student
Field Name Data Type Length Key Description
student_id INT - Primary Key Student
identifier
full_name VARCHAR 100 - Full name of
the student
email VARCHAR 100 - Email address
phone VARCHAR 20 - Phone number
gender ENUM 'male','female','other' - Gender
registration_date DATE - - Date of
registration

2. Course
Field Name Data Length Key Description
Type
course_id INT - Primary Course
Key identifier
course_name VARCHAR 100 - Name of the
course
description TEXT - - Course
description
duration_weeks INT - - Duration in
weeks
level ENUM 'beginner','intermediate','advanced - Course level
'

3. Teachers
Field Name Data Type Length Key Description
teacher_id INT - Primary Key Teacher identifier
full_name VARCHAR 100 - Full name of the
teacher
specialty VARCHAR 100 - Specialty/Expertise
email VARCHAR 100 - Email address
phone VARCHAR 20 - Phone number
4. Enrollment
Field Name Data Length Key Description
Type
enrollment_id INT - Primary Enrollment identifier
Key
student_id INT - Foreign References
Key Student(student_id)
course_id INT - Foreign References
Key Course(course_id)
teacher_id INT - Foreign References
Key Teachers(teacher_id)
enroll_date DATE - - Date of enrollment
status ENUM 'active','completed','dropped - Enrollment status
'

You might also like