General Overview Advertising System

BY IN ITGS - Social Ethical Issues Comments Off on General Overview Advertising System

Online advertising company is not a new issue over the internet nowadays. There are a lot of advertising company that provide services for the communities to advertise their product and the people all over the world can see it through their website and can contact directly to the people that advertised it.

The stakeholders
For online advertisement system, the stakeholder will be:
1. The owner of the website
This stakeholder stands as the one that provide media for advertising product.
2. The seller / member
People that advertise their product can be considered as seller. Before they can do that, they have to registered first as a member and there will be some offering for different services that they have to pay some amount of money as member’s fee.
3. The buyer
This stakeholder is the communities. They can contact the seller directly, once they wish to buy product from seller.

The Flow

1. Register as Member
2. Start to advertise the product
3. Contacted from Buyer
4. Transaction successful

The Member table
When the people start to join Online Advertising System, there are some data that they should enter for registration process. The table that need to setup as follows:
IDMember
Fullname
Address
City
Phone
HandPhone
Email
Username
Password
Register
Type (Platinum, Gold, Silver)
Credit
~note:
Username and Password are required for authorization process.
Register is a field that save the date when people registered.
Type defines the differences among services that member will have.
Credit is the amount that member should refill periodically.

The Category table
This table will create a list of category that people can choose for their convenience.
IDCategory
Name

The Advertising table
This table is used to store advertising information. This will has a relationship with the previous table.
IDIklan
IDMember
IDCategory
Description
Price
Picture
PostingDate
EndDate

The Credit Refill table
When people registered for the first time, they will obtain credit, so they will be able to post advertisement. This credit will reduce when they post, however they can refill the credit and we need to record the transaction. Here are the fields:
IDMember
TransactionDate
Amount

The member’s Control Panel

As a member of Online Advertisement Company, member should gain access to do the following:
* Edit their profile, including change their password
* Add the advertisement
* Edit the advertisement that still valid.

The owner’s Control Panel

As the owner of the website, he has to gain full priviledges. He can do:
* Administrating data of members
* Administrating data of advertisement
* Administrating data of category
* Add credit for specified member
* Updating news on the website
* Updating banner advertising




Comments are closed.