CIS SQL Project and Research for Article Business

Class topic covered or search term/keyword: Advertisements

Article Title: Public Service Advertisements: Emotions and Empathy Guide Prosocial Behavior

Authors: Richard Bagozzi and David Moore

Publication: Journal of Marketing

Edition: Vol. 58, No. 1 (Jan., 1994), pp. 56-70

Publisher: American Marketing Association

Problem: Public Service Advertisements play on our emotions.

Synopsis: There are two different types of Public Service Advertisements. One type is aimed at individuals who need help, and the other is aimed at getting the public to help those that might be in need. When Public Service Advertisements are played, they generally do seem to have that frame of reference to them. An ad might have a man that had smoked cigarettes his whole life in a wheelchair because his health has diminished since he got sick from something caused by the cigarettes.

Conclusion:

Compelling Quote from the Article:

Table 1.1

Create Table Employee01 (SSNnumber char(9) Not Null primary key, FirstName Varchar(15) not null, MidName Char, LastName Varchar(15) Not Null, Birthday date, Address varchar(50), Sex Char, Salary decimal(10,2) Default '800', SupervisorSSN Char(9), DepNum Int);

TABLE 1 ALTER

Alter Table Empolyee01 add Constraint SupervisorSSN Foreign Key (SupervisorSSN) References Empolyee01 (SSNnumber) ON DELETE SET NULL;

Table 1 Alter 1.1

alter table Employee01 add constraint SSNnumber Foreign key (SupervisorSSN) References Employee01 (SSNnumber) on delete set null;