Goal: Practice using your new database commands as you build out the To do app with relationships, and become familiar with PostgreSQL documentation and adding/removing tables and columns in your database. This week is a good time to really practice using objects within other objects. Use WWW SQL Designer to help you plan out your tables and columns.
Follow along with the example of building a to do list. Here are the requirements for the project (finish one at a time):
getTasksmethod on the class
Categorythat returns all the tasks in a particular category.
ORDER BY- let the database do the sorting, not PHP.
If you made it this far, awesome! If you have time, keep going.
If you finish the two projects above, make a program for an animal shelter to track the animals they currently have needing homes based on type (ex. cat/dog/bunny). Build out the following features that let a shelter worker:
Our next program is for office administrators to track patients in a doctor's office. Ultimately you will have a doctor's office database with tables for doctor, patient, etc. Build out the following features that let an administrator:
Patientwill be its own class, so make sure to build the relationship between a
Doctorobject and a
Now the doctor's office has been grown to include many doctors with the same specialty. The doctors have organized themselves into specialty groups. So when a user wants to enter a doctor, they must first select a specialty and then add a doctor from there.
specialtyas a column to giving it its own table with a relationship to a
COUNTfunction; practice your online search skills to figure out how it works.