04 - MVC Design and Model Layer

04 - MVC Design and Model Layer - 1 CSE 135 Discussion...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 CSE 135 Discussion Section #3 MVC Design and Model Layer Registered User submit paper Chair see paper Registered User see review paper context Chair see avg{rev} paper context Chairs Registered Users Registered User see feedback paper context Chair see paper Registered User see paper 1 Chair submit reviewer Chair Assign paper reviewer context Chair see review paper context Chair submit decision paper context Chair see feedback paper context Chair see reviewer 2 3 Reviewer submit review paper context Author see review paper context Reviewers Authors invited to feedback Reviewer see paper Reviewer Invite paper context Author submit feedback paper context Author see paper 4 2 SQL Schema (ddl.sql) CREATE TABLE assignments ( assignment_id SERIAL PRIMARY KEY, paper INTEGER REFERENCES papers(paper_id), chair INTEGER REFERENCES chairs(chair_id), reviewer INTEGER REFERENCES reviewers(reviewer_id), Reviewers Email Due Assignment Chairs Ema due date ); Email Papers Title CREATE TABLE papers ( paper_id...
View Full Document

This note was uploaded on 08/31/2011 for the course CSE 135 taught by Professor Papakonstantinou during the Fall '10 term at UCSD.

Page1 / 5

04 - MVC Design and Model Layer - 1 CSE 135 Discussion...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online