ment Agency 2s3jv

ment Agency Project work submitted in partial fulfillment of the requirements for the award of the degree of M.Sc Information Technology

By Baskar K Enrolment no:1390800107

Project Guide R.K.Indumathy

2008-2010

ANNAMALAI

UNIVERSITY

DIRECTORATE OF DISTANCE EDUCATION

-1-

ANNAMALAI

UNIVERSITY

DIRECTORATE OF DISTANCE EDUCATION

BONAFIDE CERTIFICATE Name of the Student

:

Baskar K

Enrolment No

:

1390800107

No

:

Title

:

MENT AGENCY

This is to certify that the project work entitled MENT AGENCY is to bonafide work done by Name: K. BASKAR REGNO: is partial fulfillment of the requirements for the M.Sc Information Technology during the academic year 2009-2010 is the original work of the candidate.

GUIDE

INTERNAL EXAMINER

EXTERNAL EXAMINER

Place : Chennai Date :

-2-

ACKNOWLEDGMENT

I express my sincere thanks to Dr. S.B. NAGASHWARA RAO, the Director, Directorate of Distance Education, Annamalai University who has given me the opportunity to pursue my M.Sc Information Technology. I also express my thanks to Mr. M. LETCHUMANAN, Co-ordinator of the Training Center.

I would like to thank my Guide Ms. R.K. INDUMATHY for the encouragement and guidance, which helped me in completing the project.

Finally I would like to thank my colleagues and friends who helped me in completing the project successfully.

Student Signature

-3-

ABSTRACT ment Agency The project entitled “ment Agency” the main aim of the project is to provide live ments with the s selected images and content. s are allowed to give their company info and navigation links to make available on the main website home page that is linked over the Internet. Though which we can increase the number of s to catching the domain for their transaction. The main theme is to provide ment in form of text, images, story, animations, Banners and all for the kids as well as for the company’s. Customers can choose the media types for the ments to be ed. 1.

Television

2.

News paper

3.

Magazines

4.

Billboard (Banners) with location map.

5.

Radio

6.

Internet

The process of making the ment is little because we are going to provide the execution environment for the end s to select the available templates in which the s can easily create their ment based on the Media Types (News Paper, Radio, Television, Banners etc). This project deals with the multi level ad generating and content linking of the specific company’s and their overall products demonstration. In this project we are going to provide the istration capability’s like web monitoring which helps the website management to control the amount of space need for the each s for the purpose of story animations and distributed ments generation.

-4-

The process of animations can be done with the help of flash, ad rotator, content linker component. These animated files can be stored as a template in the web space. All the story content is arranged in the temporary buffer area and they are transferred to the . In level ing and ing service for the story files, each is allowed to the contents from their local machine to the server machine with the help of the ing block service which is usually named as FTP operation. ing option are enabled to use the log reports and transaction key information in from of encoded xml format. Dynamic ment generations services for generating the ment based on the selected template for displaying their content on the home page based on the scheduling polices. The istration capabilities to the website management with the Enhancive of previewing the overall s and their web space and controlling the security by changing their web space folder attributes.

-5-

TABLE OF CONTENTS Chapter No

Description

Page

I

List of Tables

7

II

List of Figures

8

III

List of Abbreviations

9

1

Introduction

10

2

Need of Online ment Agency

12

3

System Analysis

15

4

System Design

19

5

Output Design

27

6

Conclusion

41

7

Bibliography

42

-6-

LIST OF TABLES

NO

DESCRIPTION

1



2

Banner

3

Internet

4

Magazine

5

Newspaper

6

Radio

7

Television

8

Banner

9

Internet

10

Magazine

11

NewsPaper

12

Radio

13

Television

-7-

PAGE

LIST OF FIGURES NO

DESCRIPTION

1

Data Flow Diagram

2

Entity Relationship Diagram

3

System Flow Chart

-8-

PAGE

LIST OF ABBREVIATIONS Variable Prefix: Data Type

Prefix

Boolean

Bln

Integer(without decimal)

Int

Numeric(with decimal)

Num

String

Str

Date and/ or time

Dtd

Dataset

Ds

Command

Cmd

Data column

Dc

Data Row

Dw

Collections

Cln

Control Prefix: Object Type

Prefix

Combo Box

Cbo

Button

Btn

Grid

Grd

Label

Lbl

List Box

Lst

Option Button

Opt

Text Box

Txt

CheckBoxList

Chk

-9-

INTRODUCTION

- 10 -

INTRODUCTION Chapter I : Need of Online ment Agency This chapter describes why the Web based ment agency needed.

Chapter II : System Analysis This chapter contains about the System Description with each individual process in detail. Also it contains the Data Flow Diagram (DFD)

of the system which explains a pictorial

representation of the data input and data output which flows end to end system.

Chapter III : System Design This chapter contains the data structure of the system with their field name, data type, size, constraints attached to the table in detail. It also explains a graphical representation of the data structure with

the relationship to other data structure of the system as Entity

Relationship Diagram(ER Diagram). Also the data input/output has been discussed here.

Chapter IV : File Structure The List of Files and description and the detailed explanations of each file are given in this chapter. The source of input and output is also described in this chapter.

Chapter V : Output Design This chapter explains about the complete system flow in detail. It also contains the menu navigation, individual data entry screens and reports are listed here.

- 11 -

NEED OF ONLINE MENT AGENCY CHAPTER - II ment Agency An advertising agency or ad agency is a service business dedicated to creating, planning and handling advertising (and sometimes other forms of promotion) for its clients. An ad agency is independent from the client and provides an outside point of view to the effort of selling the client's products or services. An agency can also handle overall marketing and branding strategies and sales promotions for its clients. Typical ad agency clients include businesses and corporations, non-profit organizations and government agencies. Agencies may be hired to produce an advertising campaign. Offline vs. Online Advertising Agency If you are a marketer you may want to consider the differences between online vs offline advertising. The main reason for this is that we are so conditioned by offline advertising for example television, radio, newspapers, magazines and flyers. Also with big companies launching their internet businesses they usually use offline media on a very big scale. So it is hard to believe one can run a successful internet business using only online advertising. Well this is exactly what I do. I have been running my internet business using only free methods of online advertising and earning a full time income for many years. Let me go through the differences between online and offline advertising. There are many different methods of online advertising to produce good quality leads. However, I have found that since there is nothing physical associated with your advert people are a lot more likely to forget about it soon after. I have found the three methods of online advertising that produces the highest quality lead to be the following. Ezine advertising in targeted ezines related to your product or service. Search engine traffic related to keywords which represent your product or service. The last of these methods is article marketing where you write articles related to your niche and create the credibility of an expert. Offline advertising works very well because there is something physical attached to your advert. People it very well and it usually produces a high quality lead. I have found the following

- 12 -

offline advertising methods to work very well. You can in a large amount of newspapers at the same time. Usually you receive a significant discount. If you look around on the internet you will find a lot of these deals where you can in 100 newspapers at the same time. The key being to consistently. Advertising in a magazine related to your niche also works very well. You can also use sizzle cards with an enticing marketing message and leave them wherever you go. Flyers also work well and is very low cost, but the disadvantage is that you need to physically hand them out. Having a balanced mix of advertising is very good for your business. If for some reason Google goes through a major algorithm change and you lose a lot of rankings you will still be attracting visitors from your offline methods. So when deciding between online vs offline advertising it is always good to spread your methods to even out your risk Advantages of Online Advertisment Agency Cheaper - If you weigh up the difference between offline and online advertising, online advertising is usually much cheaper than offline advertising. A decent cost per click budget or website advert is generally much cheaper than a series or run of offline or newspaper advertising and is often much more targeted and rewarding. This is not always the case, especially if you get deals for long term advertising offline, but on the whole you normally find that online advertising works out to be more cost effective and controllable in the long run. Target Audience - A major advantage of online advertising is that you can target your audience much more efficiently. For example, if you in a newspaper, although you can choose the newspaper that you consider being nearer your perfect audience, you will still have many more people who do not fit your criteria. With online advertising you can select who your advert is seen by, by niche, age, location and many other factors, especially when using cost per click or other social media types of advertising. More Options - When you consider the types of offline advertising there is, you will normally be able to name the top three, which are newspaper advertising, flyers and television. But when you look at online advertising the options seem to be much more, with cost per click, banner advertising, email marketing, site sponsorship, directory advertising and many more. Online advertising also has more flexibility using these options, as they can easily be turned on and off, changed or re-written and republished to take advantage of any related news that might be relevant to the advert.

- 13 -

Quicker - One of the biggest advantages of advertising online is how quick it can be. From the second you publish your new advert, news story or pay per click advert, it will be live on the internet and have the potential to be viewed by thousands of people. With offline advertising, especially newspaper adverts, you could be waiting up to a week for your advert to go to press and then be delivered to all of the possible readers, meaning you have to plan well in advance to capture time critical or seasonal advertising opportunities.

- 14 -

SYSTEM ANALYSIS CHAPTER - III V. System Description: The following process have been involved in the Web Based Processing System.







Registration







us



Carrier



Media Selection



Newspaper



Magazine



Television



Banner



Radio



Internet







Newspaper Ad-report



Magazine Ad-report



Television Ad-report



Banner Ad-report



Radio Ad-report



Internet Ad-report

Process: In is the process by which individual access to a computer system is controlled by identification of the using credentials provided by the A can to a system to post new ment request and can then log out or log off (perform a / logoff) when the access is no longer needed. - 15 -

Validation: If the uses the valid id and , he can access the data. Registration In this module the new will submit their personal details and details all the details will be stored in database. This module the deals about the ment agency us In this module the address of the ment agency will be displayed and option will be displayed Carrier This is used to display the vacancies in the agency Media Selection In which the can select what type to ment to be submit that is Newspaper, Magazine, Television, Banner, Radio, Internet Newspaper Which is used to submit the newspaper adds, that is name of the paper, pages, size etc Magazine This is used to submit the Magazine adds, that is name of the magazine, pages, issue 6+etc Television Which is used to submit the Television adds, by choosing tv name and timings Banner It is used to submit the Banner adds on which place, size, color etc. Radio Which is used to submit the Radio adds on which FM, pogram, and time Internet This is used to submit the Internet adds, on which site, positions, and price

- 16 -

Data Flow Diagram

Star t

Validatio n

Page

Show media selection screen

Exit from Web page

Banner Ad

TV Ad

Load project main page

Internet Ad

Magazin Ad

Post ments

- 17 -

Rights

Radio Ad

All Media Ad Reports

Entity Relationship Diagram

Banner

Interne t

locatio n nam e

uid

magazine nam e

uid

price upconten t

magazi ne

uid

website

price

price

advpag e issue

Belong s to

Belong s to

Belong s to

radio uid

uid Table

station

Belong s to

na me

price progra m

uid

wor d emai l addre ss

time

Newspape r Belong s to

papername issue

uid

price Television Tv name program price time

- 18 -

page

SYSTEM FLOW CHART

Start

A

Enter

Already Registe red

Yes

No

Correct ?

No

B

Yes

Media Selection

Banner

Banner Ad Details

Internet

Interne t Ad Details

Radio

Televisio n

Radio Ad Details

Televisi on Ad Details

- 19 -

Magazin e

Banner Ad Details

A

Corre ct?

No

Yes

View Posted Add Reports

B Regis. Form

All Details are correct Yes

Store Profile

Media Selection Page

- 20 -

No

SYSTEM DESIGN CHAPTER - IV VII. Data Base Design: Table No: 1.1 Table Name: Field Name uid name email name addr mobile phone designation

Data Type varchar varchar varchar varchar varchar varchar numeric numeric varchar

Size 10 20 20 40 20 50 12 20 20

Constraint PRIMARY KEY

Table No: 1.2 Table Name: Banner Field Name

Data Type

Size

cid

varchar

50

name

varchar

50

state

varchar

50

location

varchar

50

place

varchar

50

dfrom

varchar

50

dto

varchar

50

btype

varchar

50

bsize

varchar

50 - 21 -

Constraint PRIMARY KEY

Not Null

price

varchar

50

content

Image

2147483647

content

varchar

50

Table No: 1.3 Table Name: Internet Field Name

Data Type

Size

cid

varchar

50

name website dfrom dto adsize pattern price content content

varchar

50 50 50 50 50 50 50 2147483647 50

varchar varchar varchar varchar varchar varchar

Image varchar

Constraint PRIMARY KEY Not Null

Table No: 1.4 Table Name: Magazine Field Name cid name magazinename dfrom dto advertisingpage adsize issues pattern price content

Data Type varchar varchar varchar varchar

varchar varchar varchar varchar

varchar varchar Image

Size 50 50 50 50 50 50 50 50 50 50 2147483647

- 22 -

Constraint PRIMARY KEY Not Null

content

varchar

50

Table No: 1.5 Table Name: NewsPaper Field Name cid name papername dfrom dto advertisingpage edition adsize issues pattern price content content

Data Type varchar varchar

varchar varchar varchar varchar varchar

varchar varchar varchar

varchar varchar varchar

Size 50 50 50 50 50 50 50 50 50 50 50 2147483647 50

Constraint PRIMARY KEY Not Null

Table No: 1.6 Table Name: Radio Field Name cid name station dfrom dto program btime bduration adduration repeat

Data Type varchar varchar

varchar varchar varchar varchar varchar

varchar varchar varchar

Size 50 50 50 50 50 50 50 50 50 50

- 23 -

Constraint PRIMARY KEY Not Null

price content content

varchar Image varchar

50 2147483647 50

Table No: 1.7 Table Name: Television Field Name cid name station dfrom dto program btime bduration adduration repeat price content content

Data Type varchar varchar

varchar varchar varchar varchar varchar

varchar varchar varchar

varchar Image varchar

Size 50 50 50 50 50 50 50 50 50 50 50 2147483647 50

Constraint PRIMARY KEY Not Null

Table No: 1.8 Table Name: Banner Field Name state Location place

Data Type Varchar Varchar Varchar

Size 50 50 50

Table No: 1.9 Table Name: Internet - 24 -

Constraint

Field Name Website

Data Type varchar

Size

Constraint

Size

Constraint

Size

Constraint

Size

Constraint

Size

Constraint

50

Table No: 1.10 Table Name: magazine Field Name magazine

Data Type varchar

50

Table No: 1.11 Table Name: newspaper Field Name newspaper

Data Type Varchar

50

Table No: 1.12 Table Name: radio Field Name Station program ptime pduration

Data Type Varchar varchar datetime varchar

50 50 16 50

Table No: 1.13 Table Name: tv Field Name

Data Type

- 25 -

Station program ptime pduration

Varchar varchar datetime varchar

50 50 16 50

- 26 -

FILE STRUCTURE

1. Source of Input: Once the ed in to the site he can submit his ments on different medias and their inputs will be stored in the respective database table as given below

Table: The inputs of the table is name, , email, name of the , address, phone number, and designation of the these are the primary inputs given by the at the registration stage.

Banner Table: This is one of the media type to by the . In this the will give their ment details like name of add, state and location and place of the ment to be placed, and how log it should be displayed that is date from and to, size of the ment and the content of the ment.

Internet Table: In this the input will be, name of the ment, on which website it should be displayed, duration to display the ment, size of the ment, and content of the ment.

Magazine Table: This is also like internet table the input will be, name of the ment, on which magazine it should be displayed, on which page it should placed and duration to display the ment, size of the ment, and content of the ment.

Newspaper Table:

- 27 -

This is very similar to magazine table the input will be, name of the ment, on which Paper like thinamalar, thinathanthi, Hindu etc, it should be displayed, on which page it should placed, size of the ment, and content of the ment.

Radio Table: In this table the input will be, on which station it should relayed and duration and on which program it should displayed number of repeats, and content of the ment

Television Table: This is very similar to Radio table the input will be, on which station it should relayed and duration and on which program it should displayed number of repeats, and content of the ment

banner, Internet, newspaper, magazine, radio, tv Tables These are the tables used by the to view the ment given by the in different Medias. This is just like a report and control of the ments by the .

- 28 -

OUTPUT DESIGN CHAPTER -V

Home/ page

- 29 -

Registration Page

- 30 -

Media Selection page

- 31 -

Newspaper ment page

- 32 -

Magazine ment page

- 33 -

Television ment page

- 34 -

Banner ment page

- 35 -

Radio ment page

- 36 -

Internet ment page

- 37 -



- 38 -

Report Views

- 39 -

us

- 40 -

CONCLUSION CHAPTER - VI

Based on the usage of the application, need for enhancements may occur which the application should and should have the easy up gradation. The application should be easy to use and should very soon replace the existing manual system without any difficulty or data loss. The management should have enough and accurate information from the system to analyze. The accuracy of the system should be dependable and reduce and down time of the system. An advertising agency or ad agency is a service business dedicated to creating, planning and handling advertising (and sometimes other forms of promotion) for its clients. An ad agency is independent from the client and provides an outside point of view to the effort of selling the client's products or services. An agency can also handle overall marketing and branding strategies and sales promotions for its clients. Typical ad agency clients include businesses and corporations, non-profit organizations and government agencies. Agencies may be hired to produce an advertising campaign.

- 41 -

BIBLIOGRAPHY CHAPTER - VII

 O'Reilly publication ASP.NET , C#, SQL SERVER

 Wrox publication ASP.NET  http://www.msdn.com/official Microsoft site  www.codehaven.com

- 42 -