Project
On
Freedom Technical Institute
(FTI)
Abstract
I am very happy
that I have been able to conduct my Project with ‘Freedom Technical Institute’.
Our Project Name is Freedom Technical Institute (FTI). Obviously, this project
is designed and created for manage computer training center. Especially,
ours is a unique implemented Project on Freedom Technical Institute.
The success of Project
On Freedom Technical Institute would not be possible without the cooperation
and dedication of a person named Mr. Omar Faruk who worked as an effective and
productive partner always on by side. I gratefully offer thanks to him whose effort
and expertise were the foundation of the success of this Project.
Deceleration
I, Mamun Hossain, declare that this Project
report, submitted in partial fulfillment of the requirements for the award of a
Database Designer and Developer under the IDB IT Scholarship Project, Round 21
is wholly of mine. The document has not been submitted for any academic implementation
in any other institution.
Mamun Hossain
Database
Designer and Developer
IDB IT Scholarship Project
IDB Bhabon, Bangladesh
Acknowledgement
This Project report is an integration
of different types of tasks, the accomplishment of which would not have been
possible without the wholehearted assistance of many people whose debt I won’t
be able to express in mere words. I feel honored for being able to continue my
training with my colleagues who were always open-hearted and cooperative. I
profusely acknowledge kind support of them to get success on my project.
I would like to thank the honorable
Project Authority Md. Nowser Ahmed of IDB-BISEW, Dhaka and its all active and
dutiful members especially Md. Saifuddin Siblu for developing a unique platform
of discussion and good taking care all the time. The arrangements of the TSP
provided by IDB are extremely superb and effective.
Above all, I would like to thank my
supervisor and instructor Mr. Al-Amin for his patience, guidance and
inspiration to go ahead. Without his great support I could not have done
whatever I have achieved.
Thanks once again to all.
Mamun Hossain
Database Designer and Developer
Letter
of Project Supervisor
This is to certify that the Project
report titled ‘Freedom Technical Intitute(FTI)’ of Omar Faruk has been approved
by the undersigned in partial fulfillment of the requirements for the award of
a Database Designer & Developer in the faculty of Oracle Database.
Md. Al-Amin
Faculty
(Oracle)
Computer Network
System Limited (CNSL)
Dhaka,
Bangladesh.
Email:
vectoritbd@gmail.com
Phone: 01776-368873
Objectives
After
using this software, We should be able to achieve the followings benefits:
Ø
To
maintain Trainees information.
Ø
Information
about course design & offer by the institution
Ø
To
manage Employees & Trainers Information.
Ø
Able
to manage Account of the Institution.
Ø
Enables
us to prepare various report of the institution.
This
document has been prepared to give a planning and management of the system
design specification and implementation for the real-life projects that each
student of Database Design and Development course under IDB-BISEW IT
scholarship Project Round VII has to develop and implement individually.
ERD FOR FREEDOM TECHNICAL INSTITUTE
List of Table
Project of Freedom Technical Institute (FTI) has eleven tables.
List of the tables are following below.
Login
Trainees
Employees
Trainers
Course
Information
Course
Distribution
Result
Collection
Income
Payment
Expenditure
Acc_manage
Project Script
/* Script to
build software for Freedom Technical Institute(FTI)
Creation
date: 26/11/2014
Run this
script SQL*Plus*/
PROMPT Please wait while User is Dropping &
Created
CONNECT sys/sys ad sysdba
DROP USER CK CASCADE;
CREATE USER CK IDENTIFIED BY CK;
GRANT CREATE USER, CREATE SESSION,
ALTER SESSION, CREATE ROLE, CREATE TABLE,
CREATE VIEW, CREATE ANY INDEX, CREATE
SYNONYM, CREATE PROCEDURE, CREATE SEQUENCE,
CREATE PUBLIC SYNONYM, CREATE
TRIGGER,UNLIMITED TABLESPACE TO CK;
CONNECT CK/CK
@ORCl;
PROMPT
Please wait while tables are created.
PROMPT:
----------- TRAINEES TABLE -----------------
CREATE TABLE TRAINEES(
trainee_id NUMBER(5),
trainee_name VARCHAR2(50)
CONSTRAINT trainees_train_nn NOT NULL,
father_name VARCHAR2(50),
mother_name VARCHAR2(50),
date_of_birth DATE,
age varchar2(25),
cell_number varchar2(20),
trainee_address varchar2(200),
tr_image long raw,
CONSTRAINT trainees_trainee_id_pk PRIMARY KEY(trainee_id));
PROMPT:
----------- Course_info TABLE ----------------
CREATE TABLE COURSE_INFO(
course_id NUMBER(5),
course_name VARCHAR2(50),
course_duration NumBER(3),
course_fee NUMBER(5),
CONSTRAINT info_course_id_pk PRIMARY
KEY(course_id));
PROMPT:
----------- Employees TABLE --------------------
CREATE TABLE EMPLOYEES(
employee_id NUMBER(5)
CONSTRAINT employee_id_pk PRIMARY KEY,
employee_name VARCHAR2(35),
designation VARCHAR2(40),
hire_date DATE,
address VARCHAR2(200),
cell_number VARCHAR2(20),
e_mail VARCHAR2(50),
salary NUMBER(5));
PROMPT:
----------- Course_Distribution TABLE --------------
CREATE TABLE COURSE_DISTRIBUTION(
course_distri_id NUMBER(5)
CONSTRAINT cour_course_distri_id_pk
PRIMARY KEY,
trainee_id NUMBER(5),
course_id NUMBER(5),
trainer_id NUMBER(5),
start_date DATE
DEFAULT SYSDATE,
end_date DATE);
PROMPT:
----------- Result table --------------
CREATE TABLE RESULT(
Serial_no VARCHAR2(10)
CONSTRAINT resl_serial_no_pk PRIMARY KEY,
trainee_id NUMBER(5),
course_id NUMBER(5),
Result VARCHAR2(20),
publication_date DATE);
PROMPT:
-----------Trainers Table --------------
CREATE TABLE TRAINERS(
trainer_id NUMBER(5)
CONSTRAINT traineer_id_pk PRIMARY KEY,
trainer_name VARCHAR2(50),
employee_id NUMBER(5));
PROMPT:
----------- Collection table --------------
CREATE TABLE COLLECTION(
collection_id NUMBER(5)
CONSTRAINT coll_collection_id_pk PRIMARY KEY,
trainee_id NUMBER(5),
amount NUMBER(5),
collection_date DATE DEFAULT SYSDATE);
PROMPT:
----------- Income table --------------
CREATE TABLE INCOME(
income_id NUMBER(5)
CONSTRAINT inc_income_id_pk PRIMARY KEY,
collection_id NUMBER(5),
income_name VARCHAR2(50),
income_date DATE DEFAULT SYSDATE,
income_amount NUMBER(5));
PROMPT:
----------- Payment table --------------
CREATE TABLE PAYMENT(
payment_id NUMBER(5)
CONSTRAINT pay_payment_id_pk PRIMARY KEY,
employee_id NUMBER(5),
payment_amount NUMBER(5),
payment_date DATE DEFAULT SYSDATE);
PROMPT:
----------- expenditure--------------
CREATE TABLE EXPENDITURE(
cost_id NUMBER(5)
CONSTRAINT exp_cost_id_pk PRIMARY KEY,
cost_name VARCHAR2(50),
cost_amount NUMBER(5),
cost_date DATE
DEFAULT SYSDATE);
PROMPT:
----------- ACC_Manage--------------
CREATE TABLE AcC_Manage(
Entry_date Date,
Income_Amount number(10),
Cost_Amount number(10),
Acc_Plug Varchar2(1));
PROMPT:
----------- Login--------------
CREATE TABLE login(
ID Number(4) Primary Key,
USER_NAME VARCHAR2(50),
PASSWORD VARCHAR2(20))
PROMPT:
----------- Allter statement--------------
ALTER TABLE EXPENDITURE
ADD account_head_id VARCHAR2(15);
ALTER TABLE EXPENDITURE
ADD payment_id NUMBER(5);
ALTER TABLE Account_Head
Modify (Type VARCHAR2(20));
ALTER TABLE Account_Head
Add (Category VARCHAR2(4));
ALTER TABLE course_info
Modify (course_DURATION VARCHAR2(20));
ALTER TABLE RESULT
add (GRADE VARCHAR2(25));
ALTER TABLE RESULT
DROP COLUMN RESULT;
ALTER TABLE RESULT
DROP COLUMN PUBLICATION_DATE;
ALTER TABLE RESULT
ADD
(PUBLICATION_DATE DATE);
/
Alter table account_head
rename column type to Amount;
PROMPT:
----------- Triggers Script --------------
CREATE OR REPLACE TRIGGER
ACC_MANAGE_Inc
AFTER INSERT OR UPDATE OR
DELETE ON INCOME
FOR EACH ROW
BEGIN
IF INSERTING
THEN
INSERT
INTO ACC_MANAGE(ENTRY_DATE,INCOME_AMOUNT,COST_AMOUNT,ACC_PLUG)
VALUES(:NEW.INCOME_DATE,:NEW.INCOME_AMOUNT,0,'I');
ELSIF DELETING THEN
DELETE FROM ACC_MANAGE
WHERE
INCOME_AMOUNT=:OLD.INCOME_AMOUNT;
ELSIF
UPDATING THEN
UPDATE
ACC_MANAGE
SET
INCOME_AMOUNT= :NEW.INCOME_AMOUNT
WHERE ENTRY_DATE = ENTRY_DATE;
END IF;
END;
/
CREATE OR REPLACE TRIGGER
ACC_MANAGE_Cos
AFTER INSERT
OR UPDATE OR DELETE ON EXPENDITURE
FOR EACH ROW
BEGIN
IF INSERTING
THEN
INSERT
INTO ACC_MANAGE(ENTRY_DATE,INCOME_AMOUNT,COST_AMOUNT,ACC_PLUG)
VALUES(:NEW.COST_DATE,0,:NEW.COST_AMOUNT,'E');
ELSIF DELETING THEN
DELETE FROM ACC_MANAGE
WHERE COST_AMOUNT=:OLD.COST_AMOUNT;
ELSIF UPDATING THEN
UPDATE
ACC_MANAGE
SET
COST_AMOUNT= :NEW.COST_AMOUNT
WHERE ENTRY_DATE = ENTRY_DATE;
END IF;
END;
/
Input forms Layout Design Specification
Login Page --
Home Page --
Trainees Information Form--
HR Group Form --
Employees Information Form--
Trainers Information form--
Course Group Form --
Course Info Form--
Course Distribution Form--
Result Form --
Account Group Form --
Collection Form --
Income Form --
Payment Form --
Expenditure form --
Using Lov --
Menu Interaction --
Output Reports
Output reports for the computer Training Center Management System for a computer training center given below:
Output Reports Layout Design Specification
Trainees Report --
Result Report --
Income Report --
Cost Report --
Profit Report --
Parameter of Report --
Using Tools and Techniques
- Oracle Database 10g
- Oracle Application Developer 10g
- SQL
- PL/SQL
- FORMS
- REPORT
Conclusion
‘Training
Center Management System for a Computer Training Centre’ the Project is a real
life related project. There are many Computer Training Centre who provides
computer training. This small work will be benefited for the general people if
they take it and utilize properly. There are so many facilities for the end
users and also report generators. The office will be benefited for their
service.
Thank you…….
No comments:
Post a Comment