A

Project Report
On

APARTMENT MANAGEMENT SYSTEM

Submitted in the partial fulfillment of the requirements for the award of the degree

POST DIPLOMA IN COMPUTER APPLCATION

From
HemchandYadav University, Durg(C.G)
Year: 2020-21

Guided by Submitted by
Ms.Shweta Singh Roopankar Sahu

Submitted to
RUNGTA COLLEGE OF SCIENCE AND TECHNOLOGY
Ganjpara, DURG(C.G)
 CERTIFICATE OF APPROVAL
This is to certify that the Project work entitled “Apartment Management
System” is carried out by Roopankar Sahu, a student of PGDCA - II Sem at
Rungta College of Science and Technology GanjparaDurg (C.G) is hereby
approved as a credible work in the discipline of Computer Science for the
award of degree of POST DIPLOMA IN COMPUTER APPLICATION
during the year 2020-21from Rungta College of Science and Technology
GanjparaDurg (C.G.).

-----------------------
(Head of Department) (Computer
science)
Dr. AshishTamrakar
 CERTIFICATE

This is to certify that the project work entitled“Apartment Management

System” Submitted to the Rungta College of Science and Technology
GanjparaDurg (C.G) by “Roopankar Sahu,”in partial fulfillment for the
requirement relating to nature and standard of the award of POST DIPLOMA
IN COMPUTER APPLCATION degree byHemchandYadav
DurgUniversity ,Durg (C.G) for the academic year 2020-21.
This project work has been carried out under my guidance.

--------------------------
Ms.Shweta Singh
 CERTIFICATE OF EVALUATION
This is to certify that the project report entitled “Apartment Management
System”is carried out by“Roopankar Sahu,” a student of “PGDCA- II Sem”
at“Rungta College of Science and Technology Ganjpara Durg (C.G)”after
proper evolution & examination, is hereby approved as a credible work in the
discipline of Computer Science and is done in a satisfactory manners for its
acceptance as a requisite for the award of degree of “Post Diploma in
Computer Application” during the year 2020-21from
“HemchandYadavDurg University , Durg (C.G)” .

Internal Signature External Signature

________________ __________________
 SELF CERTIFICATE

This to certify that the project report entitled “Apartment Management

System”, which is submitted by me in the partial fulfillment for the award of

the degree of Post Diploma in Computer Application, Rungta College of

Science and Technology GanjparaDurg (C.G)comprises the original work

carried out by me.

I further declare that the work reported in this project has not

been submitted and will not be submitted, either in part or in full for the award

of any other degree or diploma in this Institute or any other Institute or

University.

Place :Durg Name : Roopankar Sahu

Date : Roll No:

 ACKNOWLEDGEMENT

It is a great pleasure for us to present our project report on“Apartment

Management System”to the department of PGDCA II SEM ,Rungta

College of Science and Technology GanjparaDurg (C.G).

We are greatly indebted to our FacultyMs Shweta Singh for providing us

with the appropriate topic to work on. We are thankful to our faculty for their

whole hearted co-operation, encouragement, Valuable suggestion & guidance

at the add time throughout the year and also for being so patient with us.

Finally we are also grateful to all those who directly or indirectly helped us

for the successful completion of this project report.

 CONTENTS

 Synopsis of the project

 Main Report
 Objectives & Scope of the project
 Definition of problem
 Hardware & Software Tools
 Theoritical Introduction to project
 MS Access
 Visual Basic 6.0
 System Design
 Database Table Structure
 Input and Output Screen Design
 Testing & Debugging
 Advantages Of Current System
 Limitations Of Current System
 Conclusion
 References
 SYNOPSIS
TITLE OF PROJECT :Apartment Management System
FRONT END USED : Visual Basic 6.0
BACK END USED : MS Access
OBJECTIVE AND SCOPE OF THE PROJECT
 Paper less work environment is what every organization craves for.
 Improve quality of work is the dream of every HR manager.
 Cost saving is what the top management needs.
 Speed up the process of all request generated by the organization.

TESTING TECHNOLOGIES USED

BLACK BOX TESTING - Black box testing is used to demonstrate that software functions
are operational, that input is properly accepted and output is correctly produced and that the integrity of
external information (i.e. a database) is maintained. A black box test examines some fundamental aspect of
system with little regard for the internal logical structure of the S/W.
WHITE BOX TESTING - Guarantee that all the independents paths within a module have
been exercised at least once. Exercise all logical decision on their true and false side. Execute all loops at
their boundaries and within their operational bounds. Exercise internal data structure to ensure there validity.
WHAT CONTRIBUTION WOULD THE PROJECT MAKE?
The application developed in this project will make the several works of the Shop to be done in a very easy
and efficient way and gives a speed in the works of every aspect for the beneficial of the business.
 PREFACE
Every individual will have a problem with the database queries. Because one has to remember so
many queries to complete a application. To make the task easy, user’s need an interface through which
they can design the queries, automatically just by selecting the tables and fields.

This system which was designed will support all the operations on a table in a given database
like creating a table, inserting values into the table into specific fields, selecting the values from the
table which supports selected fields and selected rows also. We can provide the list of fields we need
and the condition through which we can select the fields.

This system supports updating the table values according the condition and according the fields
list given. We can delete the records from a table by given condition or we can make the table empty.

All the operations performed in the system are committed automatically. When the user cant to
create a table, it should support the data types and the constraints. It should prepare the query along
with the constraint names automatically according to the field list and constraints which the user is
providing.

When selection process comes, it should prompt for table or tables from which we need to select
the data. Once the user selects the table, it should provide the field list from the selected tables. The
system should automatically construct the query which out having any conflicts between the fields the
user selecting.

The same is applicable for other operations like deleting and updating as well as dropping.
 SYSTEM ANALYSIS

HARDWARE CONFIGURATION
 Intel Pentium IV @ 650 MHz
 Intel 810 Cset
 1GB SDRAM (100 MHz)
 Dynamic video memory technology
 10 GB UDMA @33MBps IDE Harddisk drive
 48* IDE CD ROM drive
 1 PARALLEL, 2 SERIAL, 2 USB ports 3 PCI slots
 Microsoft PS/2 mouse with pad
 107 keys windows keyboard
 Windows 98 preloaded with recovery CD media
 14“ digital color monitor
 Intel Etherexpress card

SOFTWARE TOOLS

Operating system : Windows 7

Front end : VISUAL BASIC 6.0

Back end : MS ACCESS 2007

 ABOUT THE WINDOWS

The graphical user interface (GUI)

In 1998 Microsoft released GUI from MS-DOS called as Microsoft-Windows version 98. Instead of
typing commands, the user moves small arrows (called pointer) around the screen perform operations.
The program appears on the screen in rectangular areas. Tasks are performed in visual environment
so that they may be more users friendly.

Multi tasking environment

Supposed to make operation easy and resolve problem with shortcut keys. Windows under Dos platform
is referred to as MS Windows and under UNIX platform is referred to as Windows. It has an option and
it is used on internet also.

What is a window?
It is fundamental interface object through which data commands and controls are organized and
presented to the user. There are basically three types of windows:
 Application windows
 Document windows
 Dialogue windows
Application windows are movable, and constitute the fundamental visual framework for data and
commands in an application.
Document windows are also called workspace; allows an application to manage multiple documents or
multiple views.

Components of Windows
All the Windows components should contain a frame and little bar. It also includes some of the
other components.
 Menu bar
 Scroll bar
 Split box
  Massage box
 Status bar
 Control bar

Advantages of Windows 2007

Windows 2007 embedded with Internet Explorer 4.0 supports browsing of web right from
desktop through active desktop. Plug & play option integrates many types of peripheral devices to be
simply plugged in and it can be used on the fly. The GUI interfaces relives user from cumbersome
typing. Through Dynamic Data Exchange (DDE) windows allow user to run application in the
background without user intervention. Object Linking & Embedding (OLE) allows us to link any object
to other object.

Windows Operations
Basic Windows operations are as follows:
1. Moving windows
2. Resizing windows
3. Closing windows
4. Splitting windows
5. Switching windows

6. Scrolling windows
 ABOUT THE PACKAGE

VISUAL BASIC overview

Visual Basic is a third-generation event-driven programming language first released by

Microsoft in 1991. It evolved from the earlier DOS version called
BASIC. BASIC means Beginners' All-purpose Symbolic Instruction Code. Since then
Microsoft has released many versions of Visual Basic, from Visual Basic 1.0 to the final
version Visual Basic 6.0. Visual Basic is a user-friendly programming language designed
for beginners, and it enables anyone to develop GUI window applications easily.

In 2002, Microsoft released Visual Basic.NET(VB.NET) to replace Visual Basic 6.

Thereafter, Microsoft declared VB6 a legacy programming language in 2008.
Fortunately, Microsoft still provides some form of support for VB6. VB.NET is a fully
object-oriented programming language implemented in the .NET Framework. It was
created to cater for the development of the web as well as mobile applications. However,
many developers still favor Visual Basic 6.0 over its successor Visual Basic.NET.

Programming Aids
Visual Basic is having the following programming aids:

 From
 Project
 Tool box
 Properties
 Tool bar

Form:
A form window is a logical container for the JSP programming objects (such as dialog boxes and
action buttons) that made up a screen display.
 A simple application cam consists of a single form, bit you will normally have a collection of
forms initially named form1, form2, and so on by the GUI, but we can change their name to confirm to
our application.

Project window:
Project windows list the forms and other programming modules that make up our project.

Tool box:
Toolbox contains a number of control buttons that are used to install various objects called
controls on a form.

Properties:
Properties are a table that shows numerous that we can assign to a form or control. The GUI uses
these properties to develop code that carries out program is executed.

Tool bar:
Tool bar contains a number of action buttons that can speed up our use of the GUI
 INTRODUCTION TO VISUAL BASIC 6.0

Features of Visual Basic:

 Visual Basic includes certain low level features that are normally available only in assembly or
machine language.

 Visual Basic is widely available, commercial interpreter are available for most
personal computer, mini computers and main frames.

 Visual Basic is largely machined independent. Programs written in visual basic are
easily ported from one computer to another.

 Your programs interface may include the familiar controls that window users already
know how to operate-such as command buttons, option list, text boxes and scroll bars.

 With just a few mouse actions, you can add any combination of these controls to a
program.

 As a result design tasks that used to require many hours of detailed programming
efforts can how be completed in minutes.
  In Visual Basic you can quickly design the visual elements of any new programming
project.

Add the ADODB components in the VB Toolbox.

Add ADOBD component

Add an Adodb component, [Right Click] on the Control Object > Click Properties.

 THE PROGRAMMING PROCESS

These standards steps are to be followed while creating Visual Basic Programs:

1. Deciding what your application is do by crating an

overall design.
2. Creating the Visual Basic portion of the application (the serene and menus that the users
will interact with)

3. Adding the Visual Basic programming language code to tie the Visual Basic elements
together and to automate the program.

4. Testing the application to locate and remove any bugs.

5. Compiling the tested application and distribute the

compiled application to the end users.

Visualbasic includes a special helpers system called a debugger that the programmer can use to help
locate bugs that appear during testing. The debugger is an interactivemonitoring system that you turn on
and off inside Visual Basic that helps you locate statements that may contain bugs.

Programming Maintenance
Apart from the bugs, the programmer has to maintain the program he /she has created. Program
Maintainance is a term used for the updating of a program after the program after the program is put into
use. This updating may be aresult of the users request or a change in the way the program needs to
operate.

Project

A project is a collection of files that make up your application. A single Application might consist of
several files and the projects is the collection of those files.

Multiple Documents Interface (MDI)

It allows the application to contain multiple documents windows. In effect, this interface lets your work
with several sets of data in multiple window within the program. Each document window is called a
child window.

Single Document Interface (SDI)

It limits the application take on a window Explorer- like interface with topic summaries in the left
window an details for a selected topic in the right pane.
 SYSTEM ANALYSIS

Why is System Analysis Necessary?

During system analysis some activities are carried out, such as problem definition, design,
implementation.
Before designing the actual system/project, you should know,

1. What is the problem?

2. How to solve it?

3. What are the technical factors required?

4. What are its features and limitations?

If a system is designed without considering above activities then the system will not work properly
to the satisfaction of user requirement.

So system analysis is necessary to design perfect and accurate system, which satisfies the user
requirement.

Role of system analyst:

System analysis is central to the whole of system development. It includes gathering the necessary
data and developing plans for new system. This is not an easy task because many people need to be
satisfied and many conflicts resolved.
 The system analyst is the person who guides the analysis, design and implementation and
maintenance of a given system. In performing these four tasks, the analyst must always match the
information system objectives with the goals of organization.

1. System analyst must determine the requirements of user of a new system so that during analysis they
can discuss with users how to design a new system that meets the requirements.

2. System analyst has to provide different solutions to the problem, to satisfy user requirements.

3. The system analyst must be a able to find out the details about the system itself. To do this, the
analyst will have to look at such things as forms (input, output formats), data used by the organization.

4. System analyst must also be able to work in environments that have considerable ambiguity and
uncertainty.

5. System analyst must also be creative and imaginative in producing new solutions to meet user
requirements

The multifaceted role of the analyst:

The analyst plays his role in many characters. These various roles played by him are:

1. Change agent

2. Monitor

3. Architect

4. Psychologist

5. Sales person

6. Motivator

7. Politician.

Change agent:

The analyst is called as change agent because sometimes he changes the entire policy of
industry or organization to improve overall working as well as profit of the organization. The
change is brought implementing new software based computer system. In order to make this
change successful the analyst should give user as much participation as possible while designing
the system.

Investigator and monitor:

The analyst finds out why user is not satisfied with the not present system he is using.
What are the drawbacks of pitfall in the present system, that user wants to remove by replacing it
with new system.
 The analyst also monitors the activities going on while designing a new system. The
activities to be monitored include successful completion of programs with respect to time, cost
and quality.

Architect:System analysts are like architects. He must work with user to identify the goals and
shapes of new system. Architect first prepares a plan and according to that plan he develops a
building.A system analyst also creates several plans and develops or builds system according to that
plan.

Psychologist:

Analyst plans the role of psychologist in the way he/she reaches people interprets their
behavior and draws conclusion from their interactions.

Sales person:

The analyst works as a sales person by giving oral presentation of the system at each
stage of development. The analyst should be very good in communication and in putting his
ideas before the user. Also he should be able to clarify the issues raised by the user at the time of
presentation.

Motivator:

The analyst work as a motivator after the system is implemented. It is the responsibility
of the analyst to motivate the users to use the new system. it is directly dependent how much
user participation is given in the project design and how much efforts are taken to train the user,
that the user can be motivated to use the new system.

Politician:

A politician should be a good diplomat, should have proper good control on his party
members and should have good influence on the people. It is true for becoming a successful
system analyst. While designing a new system, the analyst should not only think about the
technical side but also keeping good relations, good control and good influences on the people
with and around him.

Statements Action

Beep cause speaker to beep

End causes program execution to exit
If Then Else make logical decision
Do...loop causes repetition of code segment
 A procedure consists of statements and other language elements comprising one or more lines of
code procedures that use the statements sub and end to run to make their beginning and endings.

DATA TYPES

By default Visual Basic variables are of variant data types. The variant data type can store numeric,
date/time or string data. When a variable is declared, a data type is supplied for it that determines the
kind of data they can store. The fundamental data types in Visual Basic including variant are integer,
long, single, double, string, currency, byte and boolean. Visual Basic supports a vast array of data
types. Each data type has limits to the kind of information and the minimum and maximum values it can
hold. In addition, some types can interchange with some other types. A list of Visual Basic's simple
data types are given below.

1. Numeric

Byte Store integer values in the range of 0 - 255

Integer Store integer values in the range of (-32,768) - (+ 32,767)
Long Store integer values in the range of (- 2,147,483,468) - (+ 2,147,483,468)
Single Store floating point value in the range of (-3.4x10-38) - (+ 3.4x1038)
Double Store large floating value which exceeding the single data type value
store monetary values. It supports 4 digits to the right of decimal point and 15 digits
Currency
to the left

2. String

Use to store alphanumeric values. A variable length string can store approximately 4 billion characters

3. Date

Use to store date and time values. A variable declared as date type can store both date and time
values and it can store date values 01/01/0100 up to 12/31/9999

4. Boolean

Boolean data types hold either a true or false value. These are not stored as numeric values and
cannot be used as such. Values are internally stored as -1 (True) and 0 (False) and any non-zero value
is considered as true.

5. Variant

Stores any type of data and is the default Visual Basic data type. In Visual Basic if we declare a
variable without any data type by default the data type is assigned as default.
HOME PAGE

The HOME PAGE allows you to create a application that maintains multiple forms within a
single container form .Applications such as Microsoft word for windows have .In HOME PAGE
applications the menus for each child forms are displayed the HOME PAGE form, rather than on the
child’s forms .When the child form has the focus, that child’s menu replaces the HOME PAGE form’s
menus. On the menu bar it is common for HOME PAGE applications to use several sets of menus .When
the user opens document, the application displays the menu associated with that type of document.

CREATING MENUS FOR THE HOME PAGE APPLICATIONS

You can create menus for your VB application by adding menu controls to the HOME PAGE
form and to the child forms.
One way to manage the menus in your HOME PAGE applications is to place the menu controls you want
displayed all of the time, even when no child forms are visible, on the HOME PAGE form. When you
run the application, the HOME PAGE form’s menu is automatically displayed when there are no child
forms visible.
Place the menu controls that apply to a child form on the child form at run time, as long as there is at
least one child form visible. This menu titles are displayed in the menu bar of the HOME PAGE form
.Some applications support more than one type of document .For example , in Microsoft access , you can
such as this is in VB , use to child forms. Design one child with menus that perform spreadsheet tasks
and the other with menus that perform charting tams. AT run time when an instance of a spreadsheet
from has the focus, the spreadsheet menu is displayed. And when the user selects the chart, that forms
menu is displayed. If all the spreadsheets and charts are closed the HOME PAGE form menu are
displayed.
 CREATING A WINDOW MENU

Most HOME PAGE application incorporates a window menu. This is a special menu that
displays the captions of all open child forms. In addition, some application place commands on this menu
that manipulates the child windows such Cascade, title and arrange icons.

Any menu control on an HOME PAGE form or HOME PAGE child form can be used to display
the list of open child forms be setting the window list property for that menu control to true. At run time,
VB automatically manages and displays the list of captions and displays a check mark next to the one
that had the focus most recently .In addition, a separator bar is automatically placed above the list of
windows.
 MICROSOFT ACCESS 2007
(One of most frequently used database)

ACCESS Components:

Microsoft Access is a database management system (DBMS) from Microsoft that combines

the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is
a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold
separately.
Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or
link directly to data stored in other applications and databases.[1]
Software developers, data architects and power users can use Microsoft Access to develop application software.
Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-
based programming language that can reference a variety of objects including DAO (Data Access
Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports
expose their methods and properties in the VBA programming environment, and VBA code modules may declare
and call Windows operating system operations.

FEATURES OF MS ACCESS:_

1. Ideal for individual users and smaller teams

2. Easier than client-server database to understand and use
3. Import and export to other Microsoft Office and other applications
4. Ready templates for regular users to create and publish data
5. Allows building and publishing Web databases effortlessly
6. A user friendly feature ‘Tell Me’ for assistance
7. Allows developers to create custom solutions using VBA code
8. Hide/Show option for Ribbon
9. Allows users to Report View Eliminates Extra Reports
10.Allows output Reports in PDF format
 Working with MS Access Database
To create a blank database
Open Microsoft Office Access 2007 ( Check MS office documentation for
other versions) > Click “Blank Database”.

Click Blank Database

 OBJECTIVE

Every individual will have a problem with the database queries. Because one has to remember so
many queries to complete aapplication.To make the task easy, users need an interface through which
they can design the queries, automatically just by selecting the tables and fields.

This system which was designed will support all the operations on a table in a given database
like creating a table, inserting values into the table into specific fields, selecting the values from the
table which supports selected fields and selected rows also.We can provide the list of fields we need and
the condition through which we can select the fields.

This system supports updating the table values according the condition and according the fields
list given. We can delete the records from a table by given condition or we can make the table empty.

All the operations performed in the system are committed automatically.When the user cant to
create a table, it should support the data types and the constraints. It should prepare the query along with
the constraint names automatically according to the field list and constraints which the user is providing.

When selection process comes, it should prompt for table or tables from which we need to select
the data.Once the user selects the table, it should provide the field list from the selected tables.The
system should automatically construct the query which out having any conflicts between the fields the
user selecting.

The same is applicable for other operations like deleting and updating as well as dropping.
The Main Objective of This Project is:

1. Reduction in time: Time can be reducing by eliminating the duplicate data entries in different
records.

2. Proper utilization of resource: By managing the data in computer a lot of paper can be
saved resulting in less wastage of natural resource.

3. Proper Utilization of manpower: Many persons are involved in the malignance of data a
single computer can replace them.

4. Reduction in overhead expenses: As the time is saved. Manpower is reduced and there is
reduction in power this leads directly to reduction in overhead expenses.
ER DIAGRAM
 TABLE STRUCTURE

BLOCK TABLE

INDIVIDUAL TABLE
COMPLAIN TABLE

BILL TABLE
 OUTPUT SCREENS

LOGIN FORM

PROGRESSBAR

MDI FORM
Block Details

Individual Details
Bill Details

Complain Details
REPORTS
Block Report

BILL Report
TESTING&DEBUGGING
TESTING:-
Software testing is a critical element of software quality assurance and represents the ultimate
review of specification, design and code generation. once source code has been generated, software
must be tested uncover errors as possible before deliver to your customer.

TESTING OBJECTIVES:-
1.Testing is process of executing a program with the intent of finding an error.
2. A good test case is one that has a high probability of finding an as-yet-undiscovered error.

TESTING PRINCIPLES:-
1.A tests should be traceable to customer requirement.
2. Testing should begin “in the small” and progress towards testing ”in the large”.
3.Exhaustive testing is not possible.
4. To be most effective, testing should be conducted by an independent third party.

DEBUGGING:-
Debugging occurs as a consequence of successful testing .That is, when a test case uncovers, debugging
is the process that results in the removal of error.

TYPES OF TESTING:-

1. UNIT TESTING
Unit testing focus verification effort on the smallest unit of software design the software
component or module .Unit testing is normally considered as an adjunct to the coding state.

2. VALIDATION TESTING
Validation testing is a process of determining whether a fully developed system conforms to
its requirement specification.

3. SYSTEM TESTING
 The aim of testing the process is to identify all defects existing in a software product. During
system testing the fully integrated system is tested against the requirement of the system as recorded in
the SRS documents.

4. BLACK BOX TESTING

Black box testing is used to demonstrate that software functions are operational, that input is
properly accepted and output is correctly produced
and that the integrity of external information (i.e. a database) is maintained.
A black box test examines some fundamental aspect of system with little regard for the internal
logical structure of the software.

5. WHITE BOX TESTING

Guarantee that all the independents paths within a module have been exercised at least once.
Exercise all logical decision on their true and false side .
Execute all loops at there boundaries and within their operational bounds. Exercise internal data
structure to ensure there validity.

ADVANTAGESOF CURRENTSYSTEM

 Time and resource saving.

  Chances of error minimize.

 Reduces paper work.

 Easy access of system.

 Long amount of data can be stored.

 User friendly Interface.

LIMITATIONSOFCURRENTSYSTEM

LIMITATIONS

 Searching of record is not of high level

 Database security is not considered

 Backup facility is not considered

CONCLUSION
This system is implemented fulfilling all the client requirements. The interfaces
designed for the system is very user friendly and attractive. It has successfully
implemented the client part of any database, which includes designing of query
manually, designing of queries through a wizard. This provides an easy tool for
the end user who doesn’t know the query language.

The system has successfully passed the testing at the development site and
is under the testing phase in the presence of the client. The system is waiting for
the client response.
 BIBLIOGRAPY

1. Systems Analysis and Design

- Elias M. Awad.

2. VISUAL BASIC 6.0

-Black Book

3. MS ACCESS 2007

-McGraw Hill
 REMARKS&SUGGESTIONS

Remarks:

a) ……………………………………………………………………………….…..
b) ……………………………………………………………………………………
c) …………………………………………………………………………………...
d) ……………………………………………………………………………………
e) ……………………………………………………………………………………

Suggestion:
a) ……………………………………………………………………………………
b) ……………………………………………………………………………………
c) ……………………………………………………………………………………
d) ……………………………………………………………………………………
e) ……………………………………………………………………………………