Project Features and Database Details Newspaper Management System

Project Features and Database Details Newspaper Management System Presented By: Md Tanvir Al Amin #0305012 Ishtiak Zaman Ayon #0305011

X Menu Motivation Features ER Diagram (Pub) ER Diagram (Adv) Table Schema Sequence of Action Implementation Plans Conclusion Newspaper Management System

X Motivation “Information is not knowledge. Knowledge is one kind of structured representation of information. ” News and advertises are published in newspaper. Process mostly manual. One can not search the news or articles. No knowledge base on the advertise or articles published. No Automation for ad management and publication process. . : : Solution : : . A distributed System employing RDBMS

X Features Can Search and View Ads and Publications Can submit reports Reporter Public Can review and accept Can Advertise Editor General Client Can Submit Articles Can Advertise at lower rate Con control database And get reports Admin Ad Firm Author

X ER Diagram (Publication) date sequence h lis ub _p ad m co nt ai ns parent_of m 1 pub_se ctions 1 s_ value literary_or_article Author details id News publishes m id m Admin Pending Art. Admin details Tags, Keywords, path type authorized_ order Editor Reporter details m 1 Reporter Pending_id Subm Details discount m Editor details m author Section Editor m m News Author m m Rptr_ section News Rptr type Authorized Advertiser m m name due Sections m pa irs ISA m details ISA m path subj pub_pairs name m ha m key level m 0 tags USER email id Publications Advertise User details price publishes title userid m 1 1 Newspaper year num npage m Types id tn Recognized_ Client

X ER Diagram (Publication) date sequence h lis ub _p ad m co nt ai ns 1 pub_se ctions m literary_or_article 1 due id News publishes m discount m Admin Reporter Pending_id type authorized_ order Editor Admin details Reporter details m 1 m Editor details m author Section Editor m m News Author m m Rptr_ section News Rptr type Authorized Advertiser Sections m m Author details ISA m name subj name parent_of m path ISA m level m 0 tags USER email id Publications Advertise User details price publishes title userid m 1 1 Newspaper year num npage Types id tn Tags, id Subm Details Pending Art. path m Recognized_ Client

X ER Diagram (Advertisement) Newspaper

X ER Diagram (Advertisement) Advertise m Ad_publish 1 Newspaper

X ER Diagram (Advertisement) page start. Y Advertise position start. X date m Ad_publish 1 Newspaper

X ER Diagram (Advertisement) date page start. Y Advertise m position 1 Ba se d on start. X Template m Ad_publish 1 Newspaper

X ER Diagram (Advertisement) date page start. Y Advertise m position 1 Ba se d on start. X path Template tags Temp_id m Ad_publish 1 Newspaper

X ER Diagram (Advertisement) date page start. Y Advertise Ad_publish 1 Newspaper m position m 1 Ba se d on start. X path Template tags Temp_id Client _id email Ad Clients

X ER Diagram (Advertisement) date page start. Y Advertise Ad_publish 1 Newspaper m position m 1 Ba se d on start. X path Template Order m tags ed ac Pl Temp_id by m email Ad Clients Client _id

X ER Diagram (Advertisement) date page start. Y Advertise Ad_publish 1 Newspaper m position m price Ba se d on start. X 1 discount path Template Order m date tags Order_id ed ac Pl Temp_id by m email Ad Clients Client _id

X ER Diagram (Advertisement) date page start. Y Advertise Ad_publish 1 Newspaper m position m price se d on start. X Ba Pending_id 1 discount path Template Order details Order m date tags Order_id ed ac Pl Temp_id Pending Ads by m email Ad Clients Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m position Ad_publish price se d on start. X Ba Pending_id 1 discount path Template 1 Temp_order 1 Order_id ed ac Pl Temp_id Pending Ads m date tags Order details Order by m email Ad Clients Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Ba 1 Template discount 1 path Pending_id ed se er d rd O on start. X 1 Temp_order 1 Order_id ed ac Pl Temp_id Pending Ads m date tags Order details Order by m email Ad Clients Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Ba 1 1 Temp_order 1 M by at c ed h Order_id ac Pl Temp_id 1 m email Ad Clients Ad_pairs key value Pending Ads m tags Order details Order date 1 Template discount 1 path Pending_id ed se er d rd O on start. X Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Pending_id Ba ed se er d rd O on start. X 1 1 path 1 Template Temp_order 1 1 h m fig rd er _c on 1 O 1 Ad Configuraton m value by M at c ed defined 1 key ac Pl Order_id m Pending Ads m Temp_id Order details Order date tags Ad_pairs discount email Ad Clients Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Pending_id Ba ed se er d rd O on start. X 1 1 path 1 Template Temp_order 1 1 h M fig rd er _c on 1 O 1 value Config _id rate color page Ad Configuration width height m 1 by m at c ed defined Ad_pairs desc ac Pl Order_id m Pending Ads m Temp_id Order details Order date tags key discount email Ad Clients Client _id Date_to _publish

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Pending_id Ba ed se er d rd O on start. X 1 1 discount path 1 Template Temp_order 1 1 M _c rd er value key Config _id rate color desc page Phone 1 1 Ad Configuration width height Client _id Ad Clients O defined Ad_pairs Date_to _publish email on 1 fig m m by m at c ed h Order_id ac Pl Temp_id Pending Ads m date tags Order details Order Address Unrecognized_ client ISA Third party details (opt) Recognized _client

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Pending_id Ba ed se er d rd O on start. X 1 1 discount path 1 Template Temp_order 1 ac Pl 1 Temp_id M by m at c ed h Order_id _c rd er value key Config _id rate color desc page Phone 1 1 ISA Address details ISA details width Individual Third party details (opt) Recognized _client Unrecognized_ client Ad Configuration height Client _id Ad Clients O defined Ad_pairs Date_to _publish email on 1 fig m m Pending Ads m date tags Order details Order Business

X ER Diagram (Advertisement) date page start. Y m Advertise 1 Newspaper m m position Ad_publish price Pending_id Ba ed se er d rd O on start. X 1 1 discount path 1 Template Temp_order 1 ac Pl Temp_id Order_id by m ed fig m m on _c rd er rate color desc page Phone Config _id ISA Address details ISA Third party details (opt) Recognized _client Unrecognized_ client Ad Configuration details m authorized_ order 1 width height Client _id Ad Clients 1 1 Date_to _publish email O defined Pending Ads m date tags Order details Order Individual Business Authorized_ advertiser

X Table Schema Newspaper Contains_Sections Publication Year Number (FK) Section_id Pub_id Name Page_number Date Section_id (FK) Parent_id (FK) Title number_of_pages Payment Price Path Year Number (FK) Publication_Keywords Publication_Tags Pub_id (FK) Keyname Tag Value Section_id (FK)

X Table Schema Article_Literary Authors Section_Reporters News_Reporter Pub_id Author_id user_id (FK) user_id Type Name Section_id (FK) Pub_id (FK) Telephone News Pub_id News_Authors Address Author_id (FK) Email_address Pub_id (FK) Subject User Reporters Aritcle_Literary_Authors user_id (FK) Author_id (FK) Level Birthdate Pub_id (FK) Name Gender Telephone Address

X Table Schema Editors Admin Section_Editors User_id (FK) details Section_id details Authorized_Company User_id (FK) Due Default_discount AUTHORIZED_ ADVERTISER User_id Foreign Key PENDING_ART author_id Foreign Key Submission_id Partial Key Due Discount Keyword_and_Tag_and_path

X Table Schema KEYWORDS Ad_id Primary key Temp_id Foreign key Client_id Foreign Key Order_id Primary Key Temp_id Foreign key Key Company_na me Temp_id Foreign key Order_id Foreign Key Value BUSINESS COMPANY ORDER ADVERTISE Contact_pers on start. X start. Y INDIVIDUAL Client_id Foreign Key details Discount Price Page Date TEMPLATE Temp_id Primary Key Config_id Foreign Key Path Tags Ad_Tags temp_id (FK) Tag

X Table Schema AD_CONFIGURATION RECOGNIZED_CLIENT Config_id Primary Key Client_id Foreign Key Ad_Client(Client_id) Third_Party_Phone Third_Party_Address RECOGNIZED_ TYPES Type_id Primary Key Name Width Color Pending_id Page Partial Key Rate Date_to_publish RECOGNIZED_CLIENT Client_id User_id Foreign Key Details Address PENDING_ADS Order_id Foreign Key Order(Order_id) Height Third_party_name ORDER_CLIENT Order_id Foreign Key Order(Order_id) Client_id Foreign Key Ad_Client(Client_id) UNRECOGNIZED_CLIENT Client_id Foreign Key Ad_Client(Client_id) AD_CLIENT Client_id Primary Key Email Phone Address TYPE type_id Primary Key details

Sequence of Action – Ordering Ad X

Scenario – Search Article X

X Implementation Plan Development Platform Windows Tools Microsoft Visual Studio 2005 Oracle 9 i Deployment Client Side HTML, JS, CSS Back End Front End ASP. NET Oracle

X Conclusion Presently we are working actively on this project. We hope to build a runnable interface by next few weeks. and complete the project by this term. Thank you. Tools Used to prepare this presentation : Microsoft Powerpoint XP Adobe Photoshop CS Google Picasa 2. 0 Microsoft Visio 2002 ACD See 4. 0