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;

1 comment:

  1. very informative post for me as I am always looking for new content that can help me and my knowledge grow better.

    ReplyDelete