video test 2

video test

canvas script

CREATE TABLE canvas.artist(

   artist_id    INTEGER  NOT NULL PRIMARY KEY 

  ,full_name    VARCHAR(29) NOT NULL

  ,first_name   VARCHAR(12) NOT NULL

  ,middle_names VARCHAR(16)

  ,last_name    VARCHAR(16) NOT NULL

  ,nationality  VARCHAR(9) NOT NULL

  ,style        VARCHAR(20) NOT NULL

  ,birth        INTEGER  NOT NULL

  ,death        INTEGER  NOT NULL

);

CREATE TABLE canvas.work(

   work_id   INTEGER  NOT NULL PRIMARY KEY 

  ,name      VARCHAR(55) NOT NULL

  ,artist_id INTEGER  NOT NULL

  ,style     VARCHAR(18)

  ,museum_id INTEGER  NOT NULL

);

CREATE TABLE canvas.subject(

   work_id INTEGER  NOT NULL

  ,subject VARCHAR(24) NOT NULL

  ,PRIMARY KEY(work_id, subject)

);

CREATE TABLE canvas.museum(

   museum_id INTEGER  NOT NULL PRIMARY KEY 

  ,Name      VARCHAR(50) 

  ,address   VARCHAR(31) 

  ,city      VARCHAR(15) 

  ,state     VARCHAR(20)

  ,postal    VARCHAR(9)

  ,country   VARCHAR(14) 

  ,phone     VARCHAR(20) 

  ,url       VARCHAR(61) 

);

CREATE TABLE canvas.museum_hours(

   museum_id INTEGER  NOT NULL

  ,day       VARCHAR(9) NOT NULL

  ,open      VARCHAR(8) NOT NULL

  ,close     VARCHAR(9) NOT NULL

  ,PRIMARY KEY(museum_id,day)

);

create view work_link as SELECT work.*, '<a href="https://classic-paintings.blogspot.com/2022/02/'||artist_id||'.html?id='||work_id||'" target="_blank">show image</a>' as image_link from work;

grant select on canvas.artist to public;

grant select on canvas.work to public;

grant select on canvas.subject to public;

grant select on canvas.museum to public;

grant select on canvas.museum_hours to public;

grant select on canvas.work_link to public;

 

Color Psychology

I wrote for 15 minutes today.

We know something of the way the colors affect the human body--psychologically and phisiologically. There has been a considerable amount of research in the marketing area about what colors different groups of people appreciate. There has also been some research in the interior design area on the subject. However, most of the research in IS is about 20 years old. It has been conducted long before screens got very capible of great color represenation and before the web came on strong as a channel for commerce. The research needs to be examined and looked at and some needs to be done again in the context of web design. Can we tell the gender and income levels of people based on the color scheme they choose for their customized interface?

Introduction for Reuse/Anchoring

I wrote for 15 minutes today

Today I wrote about Tulane's problems after Hurricane Katrina shut it down in August '05. The university needed to meet payroll, but its HR systems were off line. The system administrators wrote queries against the backup data to process payroll; however, an error in a query resulted in the incorrect issuance of more than one hundred thousand dollars of payroll checks being issued.

Response to WSW99, What should it look like?

I wrote for 3.5 hours today.

It was all painful. I'm afraid that the paper in its current format will not read well unless the reader has the Wand et al 99 paper in hand. I'm especially troubled by our differing interpretations of Bunge's work. How can we keep this from becoming a he said/she said argument?

Multivalued Attribues

I wrote fro three hours today.

I spent my time mostly editing text and cleaning up figures. I'm struggling with issues surrounding how Bunge represents intrinsic properties.