## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-06-18
2 | Jane | Smith | 2002-07-20
3 | Michael | Johnson | 2001-08-25
4 | Emily | Williams | 2000-09-10
5 | David | Brown | 1999-10-15

## Teachers

TeacherID | FirstName | LastName | Subject
--- | --- | --- | ---
1 | Mr. | Smith | Mathematics
2 | Ms. | Johnson | Physics
3 | Dr. | Williams | Biology
4 | Professor | Baker | History
5 | Miss | Thompson | English Literature

## Courses

CourseID | Title | Description | Credit
--- | --- | --- | ---
1 | Calculus I | Introduction to Calculus with focus on limits and derivatives. | 3
2 | General Physics I | Fundamental principles of physics including mechanics, heat, sound, light, and electricity. | 4
3 | Human Biology | An introduction to human biology covering cellular structure, genetics, physiological systems, and health issues. | 3
4 | World History II | Exploration and colonization from 15th century to present day. | 4
5 | American Literature | A survey of American literature from its beginnings through the early twentieth century. | 3

## Enrollments

EnrollmentID | StudentID | CourseID
--- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Grades

GradeID | EnrollmentID | FinalGrade
--- | --- | ---
| (→ Enrollments.EnrollmentID) |
1 | 1 | 92
2 | 2 | 88
3 | 3 | 95
4 | 4 | 90
5 | 5 | 85

## Programs

ProgramID | ProgramName | Core_Courses | Electives | Requirements
--- | --- | --- | --- | ---
1 | Computer Science | Introductory Computer Science, Data Structures, Algorithms, Operating Systems | Artificial Intelligence, Network Security, Human-Computer Interaction, Software Engineering | Minimum cumulative GPA of 2.5, Minimum 2 years of college work.
2 | Mechanical Engineering | Engineering Mechanics, Materials Science, Thermodynamics, Fluid Mechanics | Design of Machines, Control Systems, Manufacturing Processes, Robotics | Minimum cumulative GPA of 2.7, Minimum 2 years of college work.
3 | Electrical Engineering | Circuit Analysis, Digital Logic Design, Signals and Systems, Power Electronics | Communication Systems, Microprocessors, Analog Circuits, Control Systems | Minimum cumulative GPA of 2.6, Minimum 2 years of college work.
4 | Civil Engineering | Structural Analysis, Geotechnical Engineering, Transportation Engineering, Environmental Engineering | Water Resources, Construction Management, Surveying, Traffic Engineering | Minimum cumulative GPA of 2.8, Minimum 2 years of college work.
5 | Business Administration | Principles of Accounting, Principles of Marketing, Organizational Behavior, Finance | International Business, Supply Chain Management, Entrepreneurship, Strategic Management | Minimum cumulative GPA of 2.5, Minimum 2 years of college work.