Overview
We meet three times this week, and we will use the opportunity to do a group database project that will allow us to develop our skills with SQLite.
Friday, March 1st
Today's main task is to get the crowd sourced data from Anapuma and distribute
it among the groups. Then the data needs to be cleaned and used to create
the teachers and classes tables.
Have fun!
Wednesday, February 28th
Thanks to the excellent initiative of our 4th period students, we have Anupama's form to use to gather data from each of you on your course schedules.
Database Project
In your groups, design and implement an SQLite database that has each of the following tables:
- students
- teachers
- classes
You will need to:
- decide which fields belong in each entity (table).
- create the tables.
- populate the tables with information on each of the 32 students in our CSC 221 classes.
You will have all of this week to work on thie project (there is a lot to do!), and groups will present their results in class on Thursday, March 7th (the only day we meet next week).
Classwork / Homework
Plan, distribute, and execute all the required tasks to be able to complete this project in time to present to class next week.
Evaluation
An A project will be a database that can provide results to the following queries:
- How many CSC 221 students also have Ms. Brasfield for chemistry?
- What is the largest number of classes two or more students in CSC 221 have in common?
- Which students share this number of classes?
- Which are the classes they share?