For this assignment you will design the database schema you will use in your web-based, computer vision pipeline. Your schema design should be modular and scalable. I suggest viewing the other programming assignments for this class. Each assignment will be storing or retrieving data from the database. Knowing what the other assignments entail may help you to design an efficient database schema.
In your computer vision pipeline, you will be extracting still images of each frame from your input video. For example, a video that is 10 seconds long encoded at 30 frames per second would yield 300 frames. You will need to do image analyis on each of those three-hundred frames (i.e. frame 1, frame 2, frame 3, etc.). Your database will thus need to hold OpenFace and Fabian Timm's eye pupil tracking data for each frame.
The computer vision pipeline will need to store the following data:
When submitting your assignment, give me a description of the actual tables you created in Postgres.
I expect you to list the names and datatypes for all the fields which comprise each table you will be using.
Example: Lets say I want to create a simple database for storing student grades in a university, I might create the following three tables:
Table name: Students
field name | data type |
---|---|
student_id | bigserial not null primary key |
first_name | varchar(100) not null |
last_name | varchar(100) not null |
Table name: Grades
field name | data type |
---|---|
student_id | bigint not null |
course_id | bigint not null |
grade | char(2) not null |
NOTE: For Grades table, the primary key is the student_id and course_id together.
Table name: Courses
field name | data type |
---|---|
course_id | bigserial not null primary key |
course_code | char(4) not null |
course_number | integer not null |
course_description | varchar(255) not null |
If you are unsure if you have a correct description, contact me or visit me in office hours or after class. I can show you more examples. Really, I want to see you are thinking about the structure of your database tables
1. Please submit your program as text, Portable Document format (Acrobat), OpenOffice/LibreOffice format, or Microsoft Word document format file labeled "Assignment 1" to the Canvas dropbox.
2. Please include the full names of all members of your team at the top of this assignment.
3. Please name your assignment with the following naming convention:
programming_project_1.txt (for text files)
programming_project_1.odt (for OpenOffice/LibreOffice format files)
programming_project_1.pdf (for portable document format files)
programming_project_1.doc (for older versons of Microsoft Word)
programming_project_1.docx (for modern versions of Microsoft Word)
Assignments submitted after the due date will be worth, at most, 2.5 points. Additional points will be deducted for programs not meeting the specification as outlined above.
Fall 2016, CS-160:
Lectures:
Assignments:
Handouts:
Programs: