Homework answers / question archive / Create the schema shown below (screenshot) in SQLite and populate it with data of at least 6 students, 4 courses, and 11 enrollments (at least one of the students should not be enrolled in any courses and at least one course should have zero current enrollments)

Create the schema shown below (screenshot) in SQLite and populate it with data of at least 6 students, 4 courses, and 11 enrollments (at least one of the students should not be enrolled in any courses and at least one course should have zero current enrollments)

Computer Science

Share With

Create the schema shown below (screenshot) in SQLite and populate

it with data of at least 6 students, 4 courses, and 11 enrollments (at least one of the students should not be enrolled in any courses and at least one course should have zero current enrollments).


a) Create view that pre-joins the three tables, including all of the records from student and course tables
b) Write python code that uses that view to export all data into a single .txt file (that is a "de-normalized" 1NF file with some redundancy present)
Include a screenshot of the output .txt file (in addition to the python code)