WITH THE NAME OF THE MOST
MERCIFUL THE MOST BENEFICENT
THE AIMS HARIPUR
Developed by:
WAHEED ULLAH (roll number: 64681)
INAM UL HAQ (roll number: 64680)
RAHAT ALI (roll number: 64682)
SUPERVISOR BY: (SIR RAFAQAT MEHMOOD)
DATE
DEDICATON
Dedication to our loving Father, Mother,
Brother and Sisters….
Final Approval
The project report of RAFAQAT MEHMOOD is
approved.
Internal Supervisor: __________________
Mr. Rafaqat Mehmood
Internal Examiner: ___________________
Mr. Rafaqat Mehmood
External Examiner: ___________________
Dated:
TABLES OF CONTENTS:
Certificate………………………………………………..2
Acknowledgement……………………………………....3
SYSTEM DESIGN……………………………………..6
Introduction………………………………………………7
Tables Names ………………..……………………….....8
ERD…………………………………………………….....9
RELATIONSHIP………………………………………10
MS-ACCESS SCREENSHOT……………………….11
Tables……………………………………………………..12
Form………………………………………………...…….13
Queries…………………………………………………....14
Reports…………………………………………………....15
CONCLUSION…………………………………………16
CERTIFICATE
I hereby undertake that this project is an original one and no part of this project falls
under plagiarism. If at any stage found, I will be responsible for the consequences.
Student Name:
⮚ WAHEED ULLAH
⮚ INAM UL HAQ
⮚ RAHAT ALI
Date:
Certified that the contents and form of the project’s Report/Documentation Entitled SUFFAH
SUFFAH EDUCATIONAL ACADEMY Submitted by as above mentioned found satisfactory for
the requirements of the DIT.
Project supervisor:
SIR RAFAQAT MEHMOOD
ACKNOWLEDGEMENT
First of all I would like to thanks Allah Almighty for His Kindness and Grace without
which this task could not be accomplished. After that I would to thanks my parents
and Teacher for their constant assistance and help me in the completion of this
project.
I take this opportunity to express my profound and gratitude regards to my guide
SIR RAFAQAT MEHMOOD for his exemplary guidance and constant encouragement
throughout the project .The blessing help and guidance given by his time to shallot
carry me a long way in the journey Of life .I am about to embark.
INTRODUCTION
It is an organized collection of related data that is store
in efficient and compact manner.
Our project on COMSATS UNIVERSITY ONLINE SYSTEM gives idea about
the management and some students of university. The project C U
ONLINE SYSTEM includes ID of admin and students and their
detail. It has the facility to give a unique ID to every student and their
staff automatically. So we can find any record about student, admin, etc in
university easily with the help of DBMS.
The HMS can be accessed using a unique password. The data can be
retrieved easily. The interface is very user friendly. The data is well
protected for use and make the data processing fast.
Tables Names and Their Attributes:
1. Doctor Table:[Link]:
DOC ID P ID
D Name P Name
D Gender Phone No
QualificationP Gender
3. ROOM Table:P Age
Room ID Admit Date
Room Type
Total bed
Used bed
Empty bed
5. Transport [Link]
V IDM ID
Doc ID M Name
D Name Quantity
D Contact R ID
Van Type
Charges
RELATIONSHIPS:
SCREEN SHOTs:
Tables:
Table is the most important objects of [Link] is the central concept in
relation in [Link] data in a relational database is stored in tables.
Adatabase consists of many tables .Each table is identified by separate
name.
Admin and students Table:
Student table:
Courses Table:
Department Table:
Student faculty Table:
quiz TABLE:
Web resources Table;
QUERIES:
A Query is a statement that extracts specific information from
[Link] is retrieve according to the criteria given by the user .The
output of a query can be used as source of records for FORMS and
REPORTS.
Admin and address Query:
grades QUERY:
Attendence query:
FORMS:
A graphical interface used interact with database is called form. Forms are
used to enter database. A form consists of text box, labels buttons and other
graphical object.
admin Form:
Student Form:
quiz Form:
result Form:
Department Form:
Reports:
Reports are the output of database application. Reports are used to retrieve
and present the data in a formatted way. T he information on the reports
rearrange in different ways. Reports are very important in making key
decision .The user can print the report to send them to different people.
Admin Report:
courses Report:
department Report:
result Report:
Student login Report:
CONCLUSION:
This project has been successfully developed using the standard software
development strategies that are followed in the industry.
This project has been developedby our sincere effort. It has few useful
[Link] though some limitations exist. According to the specified
functionality, it will work in a proper manner. Through this project we have
tried to make it user friendly to some extend. In this way, using this
software a successful Hotel management can be run with a major
achievement
The outcome of the project is that it interacts with the user based on the
chosen option.