Download - Project proposal final presentation2
PROJECT PROPOSAL(DATABASE LAYOUT DESIGN)
One of the most vexing problems of Enverga Lib.(RFS) is the unorganized collection of clippings known as vertical files.
As a LIS student I find this problem very interesting and it’s my pleasure to give some contribution in organizing our vertical files collection.
INTRODUCTION
As a student assistant in RFS I find it difficult to assist our clients especially when they are looking for the specific article in the newspaper, because not all the clippings are encoded in our system and take note that we have a newspaper daily. That is the reason why I ended up choosing this problem as my guide for making my database design.
INTRODUCTION
ADVANTAGESAnd
DISADVANTAGES
ADVANTAGES
•Power loss•Skills of the personnel•Changes in structures require changes in all data input.
DISADVANTAGES
•Easy access•Data access is more flexible than in a manual filing system.•Promotes easiest management and use
VERTICAL FILES DATABASE
VFC
VFC_ID No.
VFC_Name
VERTICAL FILE LIST
VFL_Id no.
VFL _ title
VFL_ author
VFL_ date
VFC_ ID no.
S_ id
S_ status
STUDENT
S_ Id
S_ name
S_ course
VFL_no.
STATUS
S_ status
FK
PK
DATES
D _dates
D_ returned
D_ borrowed
S_ statusFK
FK
ENTITIES
ATTRIBUTES
FK
RELATIONSHIPS
VERTICAL FILES DATABASE
LEGENDS:
PK
Previous
VFC
VFC_ID No.
VFC_Name
VERTICAL FILE LIST
VFL_Id no.
VFL _ title
VFL_ author
VFL_ date
VFC_ ID no.
S_ id
S_ status
STUDENT
S_ Id
S_ name
S_ course
VFL_no.
STATUS
S_ status
DATES
D _dates
D_ returned
D_ borrowed
S_ status
ENTITIES
ATTRIBUTES
FK
RELATIONSHIPS
VERTICAL FILES DATABASE
LEGENDS:
PK
Revise
PREPARED BY:
ROSELYN P. CEABLIS-III
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration. – Evan Esar