Tuesday, April 27, 2010
Final Presentation
All good things come to an end.Thursday 15th April was the day the database final project presentation took place.Many people from faculty and industry were there. the presentation was broadcast live on the internet and all the groups did amazing.Big thank you to our supervisors(Dr Mulhim & Dr Giovannucci) the dean, the IT DEPARTMENT and AUD Faculty that were present for their time and kind comments/questions.
Group Members
Muhammmad Danbappa.
A senior Database design and administration student in American University Dubai with with high interest in database security and mobile computing
Ruqayya Dabo
Senior Database design and administration student in American University Dubai interested in database development and Linux systems administrations
A senior Database design and administration student in American University Dubai with with high interest in database security and mobile computing
Ruqayya Dabo
Senior Database design and administration student in American University Dubai interested in database development and Linux systems administrations
BDee's Portal
ABSTRACT
The main idea behind this project is to create a mobile based application in form of portal to tenants in respective buildings to provide self services. The proposed system will provide authorized tenants the access to a controlled database through an enabled mobile device or computer system. It will promote automatic request management, booking and scheduling of common places, e-payments and announcements/memo postings.
Oracle will be the DBMS to be used during the development and operations of the database. The J2ME platform will be used in creating the Application with the aid of Java Programming language.
PROBLEM STATEMENT
The primary communication method between tenants and managers is insufficient enough that people sometimes seek another property to live in. Newsletters delivered to mail boxes and bulletin information is the two most common ways of communicating and takes lots of time before reaching the receiver or the tendency of tenant’s ignorance. However thousands of money is spent in creating and delivering these memos. Maintenance services like pipe leaking request which traditionally can be done through calling or visiting the offices can be done in efficient ways. Handling checks can be difficult and many tenants forget the due date of their checks. We think that creating this application will help minimize the issues regarding these features.
BDee’s Portal will offer numerous services that will make the property management firm be more competitive and attract more tenants and will bring joy and commitment among tenants and managers.
Proposed Solution:
The system will follow the architecture below:
Proposed Solution
Users can access the application through a carrier or wireless network and apache server will have access to the database for storing and retrieving data from the J2EE application on the standard PC. J2ME application will allow authorized users to navigate different pages and perform various jobs and the pages are stored in a database.
MOTIVATIONS
High increase of Smartphone users
Improve the communication medium (newsletters/phone calls)
Management of building on the go
Challenges (developing j2me application for the first time).
Entity Relationship Diagram
It is a diagram that shows the records in the database and their relationships after normalization.
The figure below shows the normalized ERD for BDee’s portal after analyzing and designing, with six entities and their attributes including the relationships.
DATA FLOW DIAGRAM
Data flow diagram is a graphical representation of the flow of data through an information system. Data items flow from an external source or an internal source to external source via an internal process.
Use case Diagram:
This is a diagram that shows the various roles of user and how the system will be used. In our own case we identify all the roles of a given user in a diagram called collaboration case diagram.
Requirements
The requirements of our application are as follows:
4.1 Hardware:
• Standard PC or Laptop: Regular PC that has Intel series 1.36 MHz and above with a minimum of 32kb of RAM. In addition, a regular PC that is capable of supporting oracle10g or SQL server enterprise.
• Mobile phone: The application will be used on blackberry mobile phone which is Java enabled.
• Data rates of 10kps (10)
4.2 Software:
• J2ME (Java 2 mobile edition): It supports embedded systems
• J2EE (Java 2 enterprise edition): For developing the enterprise web based application
• Oracle10g: For managing and developing the database and it has Graphical user interface (GUI) support.
• Operating System: Windows
• Microsoft Office: For documentation of the project
• Eclipse: will be used to develop the java code (10).
Interface Design
The user interface we created follows the object-oriented approach in which user interacts explicitly with objects that represent entities in the domain of the application.
The main idea behind this project is to create a mobile based application in form of portal to tenants in respective buildings to provide self services. The proposed system will provide authorized tenants the access to a controlled database through an enabled mobile device or computer system. It will promote automatic request management, booking and scheduling of common places, e-payments and announcements/memo postings.
Oracle will be the DBMS to be used during the development and operations of the database. The J2ME platform will be used in creating the Application with the aid of Java Programming language.
PROBLEM STATEMENT
The primary communication method between tenants and managers is insufficient enough that people sometimes seek another property to live in. Newsletters delivered to mail boxes and bulletin information is the two most common ways of communicating and takes lots of time before reaching the receiver or the tendency of tenant’s ignorance. However thousands of money is spent in creating and delivering these memos. Maintenance services like pipe leaking request which traditionally can be done through calling or visiting the offices can be done in efficient ways. Handling checks can be difficult and many tenants forget the due date of their checks. We think that creating this application will help minimize the issues regarding these features.
BDee’s Portal will offer numerous services that will make the property management firm be more competitive and attract more tenants and will bring joy and commitment among tenants and managers.
Proposed Solution:
The system will follow the architecture below:
Proposed Solution
Users can access the application through a carrier or wireless network and apache server will have access to the database for storing and retrieving data from the J2EE application on the standard PC. J2ME application will allow authorized users to navigate different pages and perform various jobs and the pages are stored in a database.
MOTIVATIONS
High increase of Smartphone users
Improve the communication medium (newsletters/phone calls)
Management of building on the go
Challenges (developing j2me application for the first time).
Entity Relationship Diagram
It is a diagram that shows the records in the database and their relationships after normalization.
The figure below shows the normalized ERD for BDee’s portal after analyzing and designing, with six entities and their attributes including the relationships.
DATA FLOW DIAGRAM
Data flow diagram is a graphical representation of the flow of data through an information system. Data items flow from an external source or an internal source to external source via an internal process.
Use case Diagram:
This is a diagram that shows the various roles of user and how the system will be used. In our own case we identify all the roles of a given user in a diagram called collaboration case diagram.
Requirements
The requirements of our application are as follows:
4.1 Hardware:
• Standard PC or Laptop: Regular PC that has Intel series 1.36 MHz and above with a minimum of 32kb of RAM. In addition, a regular PC that is capable of supporting oracle10g or SQL server enterprise.
• Mobile phone: The application will be used on blackberry mobile phone which is Java enabled.
• Data rates of 10kps (10)
4.2 Software:
• J2ME (Java 2 mobile edition): It supports embedded systems
• J2EE (Java 2 enterprise edition): For developing the enterprise web based application
• Oracle10g: For managing and developing the database and it has Graphical user interface (GUI) support.
• Operating System: Windows
• Microsoft Office: For documentation of the project
• Eclipse: will be used to develop the java code (10).
Interface Design
The user interface we created follows the object-oriented approach in which user interacts explicitly with objects that represent entities in the domain of the application.
Subscribe to:
Posts (Atom)