Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This presentation is for final year project to complete degree in Computer Science. It emphasis on Applications of Computer Sciences. It was supervised by Ambalika Virochan at Bengal Engineering and Science University. It includes: Project, Introduction, File, Tracking, System, FTS, Processing, Timeline, Architectural, Design
Typology: Slides
1 / 37
This page cannot be seen from the preview
Don't miss anything!
1
File Tracking System (FTS) is a software being developed to
computerize the process of “File Processing” within an organization.
It is an information system that allow files to be stored, processed and tracked within an organization.
2
Project Timeline
4
Architectural Design Business Logic Design Database Design Database Implementation
5
In architecture design phase, following diagrams were drawn to show the architecture of File Tracking System:
Context Diagram Diagram 0 Detailed Diagram Architectural Diagram
FTS architecture is based on Call and Return Architecture Style****.
7
In this phase, business rules were identified. Some of them are given below:
File Name must be unique. File ID must be unique. Format of File ID: Organization - Department ID - Date Time or Department ID - Date Time Office format: (Block/Section – Room Number)
8
The Database was designed in following steps:
E-R Diagram Relational Schema Normalized Relational Schema
The E R diagram was drawn using MS VISIO.
The Relational Schema was normalized till BCNF.
10
Following tables have been implemented in database:
department employee dept_emp file mark reference_attachment
11
13
Work Progress
After 7th^ semester Mid Term
Till
End of 7th^ semester
14
After mid of 7th^ semester, Design and implementation of following functionalities is complete:
Login FTS Home Page Create New File Mark File Close File Add Comments Attach Reference File
16
Try To open connection by using connection string Using command text and Execute the reader Loop while Records not end Compare password with password entered by user If password match Redirect the user to "Home Page" and Pass User ID in URL Else Display message "Incorrect Employee ID or Password" End If Close the reader and connection
17
19
20
Enter File NameSubject& Select File typeFile Category& Enter File text
Click at “Attach” Button
“AddAttachment”^ Redirect to & Pass User ID in URL
Back to “Create New File”Add Attachment&
Select Department ID
Compare Dept. ID
Names and Designations,belong to Particular Dept.Display all Employees ID, in the List
Select Employee to whichNew File Marked
Yes
Click at “Create & Send” Button Click at “Cancel” Button
Redirect to “Home Page”Pass User ID in URL &
Click at “Cancel” Button Back to “Create New File”Pass User ID in URL &
Click at “Check Name” Button
This “File Name” is unique.
“File Name” is unique Yes
No^ This “File Name” already exists.
Field is empty^ “File Name” No Yes Enter “File Name”.
Save File in to Data Base Save Mark Info in to DataBase
“File Name” is unique Yes
This “File Name” already exists. No
Field is empty^ “File Name” No
Enter “File Name”. Yes
“Create New File & Mark” Functionality
