Transcript NMS - 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
4/27/2020
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
4/27/2020
Newspaper Management System
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
4/27/2020
Newspaper Management System
X
ER Diagram (Publication)
date
sequence
npage
Newspaper
userid
User
details
price
USER
1
level
num
email
year
publishes
parent_of
1
0
tags
name
id
Publications
Advertise
pub_se
ctions
m
1
id
value
m
m
Pending_id
Subm
Details
m
Admin
Admin
details
Pending Art.
Newspaper Management System
Tags,
Keywords,
path
type
authorized_
order
Editor
Reporter
details
m
1
Reporter
News
Author
author
discount
m
Editor
details
Rptr
m
Section
Editor
m
News
type
publishes
id
4/27/2020
m
m
name
Author
details
News
m
Rptr_
section
key
literary_or_article
Authorized
Advertiser
m
subj
m
due
Sections
path
ISA
pub_pairs
details
ISA
m
m
title
name
m
Types
id
tn
Recognized
_Client
X
ER Diagram (Publication)
date
sequence
npage
Newspaper
userid
User
details
price
USER
1
level
num
email
year
publishes
parent_of
1
0
tags
name
id
Publications
Advertise
pub_se
ctions
m
1
literary_or_article
id
News
m
publishes
m
Admin
Admin
details
Subm
Details
Pending Art.
Newspaper Management System
path
m
Types
id
tn
Tags,
id
4/27/2020
Pending_id
type
authorized_
order
Editor
Reporter
details
m
1
Reporter
m
author
discount
m
Editor
details
m
News
Author
m
Section
Editor
m
Rptr
m
Author
details
m
Rptr_
section
News
type
Authorized
Advertiser
m
subj
name
due
Sections
path
ISA
m
details
ISA
m
m
title
name
Recognized
_Client
X
ER Diagram (Advertisement)
Newspaper
4/27/2020
Newspaper Management System
X
ER Diagram (Advertisement)
Advertise
4/27/2020
m
Ad_publish
1
Newspaper Management System
Newspaper
X
ER Diagram (Advertisement)
page
startY
date
Advertise
m
Ad_publish
1
position
startX
4/27/2020
Newspaper Management System
Newspaper
X
ER Diagram (Advertisement)
page
startY
date
Advertise
m
Ad_publish
1
position
startX
Template
4/27/2020
Newspaper Management System
Newspaper
X
ER Diagram (Advertisement)
page
startY
date
Advertise
m
Ad_publish
1
position
startX
path
Template
tags
Temp_id
4/27/2020
Newspaper Management System
Newspaper
X
ER Diagram (Advertisement)
page
startY
date
Advertise
m
Ad_publish
1
Newspaper
position
startX
path
Template
tags
Temp_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
X
ER Diagram (Advertisement)
page
startY
date
Advertise
m
Ad_publish
1
Newspaper
position
startX
path
Template
Order
tags
Temp_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
X
ER Diagram (Advertisement)
date
page
startY
Advertise
m
Ad_publish
1
Newspaper
position
price
startX
discount
path
Template
Order
date
tags
Temp_id
Order_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
X
ER Diagram (Advertisement)
date
page
startY
Advertise
m
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
Template
Order
Order
details
Pending Ads
date
tags
Temp_id
Order_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
Template
1
Temp_order
1
Order
Order
details
Pending Ads
date
tags
Temp_id
Order_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
Template
1
Temp_order
1
Order
Order
details
Pending Ads
date
tags
Temp_id
Order_id
Client
_id
email
Ad Clients
4/27/2020
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
Template
1
Temp_order
1
Order
Order
details
Pending Ads
date
tags
Temp_id
Order_id
Client
_id
email
Ad Clients
Ad_pairs
key
4/27/2020
value
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
Template
1
Temp_order
1
Order
Order
details
date
tags
Temp_id
Order_id
Client
_id
m
email
Ad Clients
defined
Ad_pairs
1
key
value
Ad Configuraton
4/27/2020
Pending Ads
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
1
Template
Temp_order
1
Order
Order
details
date
tags
Temp_id
Order_id
Client
_id
m
email
Ad Clients
defined
Ad_pairs
1
value
key
Config
_id
rate
color
desc
4/27/2020
Pending Ads
page
Ad Configuration
width
height
Newspaper Management System
Date_to
_publish
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
1
Template
Temp_order
1
Order
Order
details
Pending Ads
date
tags
Temp_id
Order_id
Date_to
_publish
Client
_id
m
email
Ad Clients
defined
Ad_pairs
Phone
1
value
key
Config
_id
rate
color
desc
4/27/2020
page
Address
Unrecognized_
client
Ad Configuration
width
height
Newspaper Management System
ISA
Third party
details (opt)
Recognized
_client
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
1
Template
Temp_order
1
Order
details
Order
Pending Ads
date
tags
Temp_id
Order_id
Date_to
_publish
Client
_id
m
email
Ad Clients
defined
Ad_pairs
Phone
1
value
key
Config
_id
rate
color
desc
4/27/2020
page
ISA
Address
Unrecognized_
client
Recognized
_client
Ad Configuration
details
details
ISA
width
height
Individual
Business
Newspaper Management System
Third party
details (opt)
X
ER Diagram (Advertisement)
date
page
startY
m
Advertise
Ad_publish
1
Newspaper
position
price
startX
Pending_id
discount
path
1
Template
Temp_order
1
Order
details
Order
Pending Ads
date
tags
Temp_id
Order_id
Date_to
_publish
Client
_id
m
email
Ad Clients
defined
Phone
1
Config
_id
rate
color
desc
4/27/2020
page
ISA
Address
Unrecognized_
client
Recognized
_client
Ad Configuration
details
details
ISA
m
authorized_
order
1
width
height
Third party
details (opt)
Individual
Business
Newspaper Management System
Authorized_
advertiser
X
Table Schema
Newspaper
Contains_Sections
Sections
Publication
Year
Number
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)
Pub_id (FK)
Keyname
Tag
Value
4/27/2020
Newspaper Management System
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
user_id (FK)
Author_id (FK)
Level
Birthdate
Pub_id (FK)
Name
Gender
Telephone
Address
4/27/2020
Newspaper Management System
X
Table Schema
Editors
Admin
Section_Editors
User_id (FK)
User_id
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
Keyword_and_Tag_and_path
Discount
4/27/2020
Newspaper Management System
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
COMPANY
ORDER
ADVERTISE
Value
BUSINESS
Contact_pers
on
startX
startY
INDIVIDUAL
Client_id
Foreign Key
Client_id
Foreign Key
details
TEMPLATE
Temp_id
Primary Key
Config_id
Foreign Key
Path
Tags
details
4/27/2020
Discount
Price
Page
Date
Date
Newspaper Management System
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
4/27/2020
Newspaper Management System
X
Sequence of Action – Ordering Ad
Ad_Client
Application
BackEnd
sendIdentity()
authorizeClient()
authenticate()
sendResult()
sendQueryInterface
requestForSpace()
queryForAdSpace()
getResultandCost()
resultOfRequest()
placeOrder()
updatePendingOrder()
getResult()
sendConfirmation
4/27/2020
Newspaper Management System
calculateCost()
X
Scenario – Search Article
Ad_Client
Application
BackEnd
sendCriteriaAndTags
searchAccordingToTags()
sendResult()
search(tags)
showResult()
requestForArticle()
queryForArticle()
search(criteria)
sendArticlePath()
sendArticleFile()
4/27/2020
Newspaper Management System
X
Implementation Plan
Development
Platform
Windows
Tools
Microsoft Visual Studio 2005
Oracle 9i
Deployment
Client Side
HTML, JS,CSS
Back End
Front End
Oracle
ASP.NET
4/27/2020
Newspaper Management System
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
4/27/2020
Newspaper Management System