Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2003-06-18
2JaneSmith2002-07-20
3MichaelJohnson2001-08-25
4EmilyWilliams2000-09-10
5DavidBrown1999-10-15

Teachers

TeacherIDFirstNameLastNameSubject
1Mr.SmithMathematics
2Ms.JohnsonPhysics
3Dr.WilliamsBiology
4ProfessorBakerHistory
5MissThompsonEnglish Literature

Courses

CourseIDTitleDescriptionCredit
1Calculus IIntroduction to Calculus with focus on limits and derivatives.3
2General Physics IFundamental principles of physics including mechanics, heat, sound, light, and electricity.4
3Human BiologyAn introduction to human biology covering cellular structure, genetics, physiological systems, and health issues.3
4World History IIExploration and colonization from 15th century to present day.4
5American LiteratureA survey of American literature from its beginnings through the early twentieth century.3

Enrollments

EnrollmentIDStudentIDCourseID
(→ Students.StudentID)(→ Courses.CourseID)
111
222
333
444
555

Grades

GradeIDEnrollmentIDFinalGrade
(→ Enrollments.EnrollmentID)
1192
2288
3395
4490
5585

Programs

ProgramIDProgramNameCore_CoursesElectivesRequirements
1Computer ScienceIntroductory Computer Science, Data Structures, Algorithms, Operating SystemsArtificial Intelligence, Network Security, Human-Computer Interaction, Software EngineeringMinimum cumulative GPA of 2.5, Minimum 2 years of college work.
2Mechanical EngineeringEngineering Mechanics, Materials Science, Thermodynamics, Fluid MechanicsDesign of Machines, Control Systems, Manufacturing Processes, RoboticsMinimum cumulative GPA of 2.7, Minimum 2 years of college work.
3Electrical EngineeringCircuit Analysis, Digital Logic Design, Signals and Systems, Power ElectronicsCommunication Systems, Microprocessors, Analog Circuits, Control SystemsMinimum cumulative GPA of 2.6, Minimum 2 years of college work.
4Civil EngineeringStructural Analysis, Geotechnical Engineering, Transportation Engineering, Environmental EngineeringWater Resources, Construction Management, Surveying, Traffic EngineeringMinimum cumulative GPA of 2.8, Minimum 2 years of college work.
5Business AdministrationPrinciples of Accounting, Principles of Marketing, Organizational Behavior, FinanceInternational Business, Supply Chain Management, Entrepreneurship, Strategic ManagementMinimum cumulative GPA of 2.5, Minimum 2 years of college work.