Read subject, course information from subject_course_data.csv file.
Then insert the subject and course data into these tables of database named university.sqlite. You must ensure not to duplicate subject entries.
Ask user enter a subject name, the program will print a list of courses belong to the subject. Otherwise, print "No course is belong to the subject".
Content of the input file subject_course_data.csv ":
SubjectName, CourseName
Mathematics, Calculus I
Mathematics, Algebra I
Physics, Classical Mechanics
Physics, Quantum Mechanics
Computer Science, Introduction to Programming
Computer Science, Data Structures
Literature, Modern Poetry
Literature, Shakespearean Drama
Biology, Cell Biology
Biology, Genetics
Result of the program:
Enter a subject name to find courses: Mathematics
Courses in Mathematics:
1- Calculus I
2- Algebra
+ 100%
Zoom
Close
