Executive summary. 1
Data and process models of the new system.. 3
Class diagram.. 3
Entity relationship diagram.. 5
Use Case Diagram.. 9
Context level DFD. 10
Sequence Diagram.. 11
Activity diagram.. 11
Level 1. 13
Conversion process. 13
Options. 14
Ø Data Integration. 14
Ø Data Integrity. 14
Ø Data Independence. 14
The databases are implemented using a DBMS package. Each particular DBMS has unique characteristics and general techniques for Database Design. 14
Selected technology. 15
Conversion Steps. 15
Team Skills required. 16
Training requirements. 17
Assumptions. 17
Conclusion and recommendations. 17
References: 17
Executive summary
The report here will specify the process and design requirements of Trim Fit application. The application is developed to fulfil all requirements of the company supporting employees at all levels. The report here outlines capacity and boundaries of the proposed system for Trim Fit. The software is first release and aims to support business and technical requirements of business with focussing on customer management and employee performance control functions. Company owner wants to overcome current system pitfalls and so help in upcoming problems that business is facing.
The report will starts with analysing feasibility of the proposed system and then will analyse design modules of the system. An entity relationship diagram will be designed in order to outline conceptual data modelling and relationship between the entities. In other parts of design process, use case diagrams stating actors and responsibilities in current system, class diagrams showing classes, data variables and functions by which system will comprised of and data flow diagrams for depicting flow of data and processes are outlined.
The conversion process which will states conversion process which is required for transferring of information from current system to proposed system. After completion of design and conversion requirements, skills which are required by development team for successful completion of the project and skills needed by TrimFit employees so that they can work with system.
There are number of assumptions that were made during analysis report so next section will outline all assumptions that aware assumed for the process.
The report aims to discuss all requirements so that system can be developed successfully and therefore resulting into an integrated system that will support all functional and business needs of company. Development team is required to develop and effective web based system.
Data and process models of the new system
Class diagram
The class diagram will outline all classes that will form basis of this proposed system. Here is detail of all the proposed calluses
- Customer class: The customer class is responsible for maintaining details of all customers. The class will help the system to add, update customer information to the system. The class is base class for membership and payment class.
- Membership class: The Membership class is developing to keep track of all member ship services that a member have. The class will track membership renewal, expiry time and other details related to membership of any customer.
- Payment class: Payment class is chilled class of class employee. This class aims to keep track of all payment details required by the business so that payment can be controlled and managed in an effective way. The class records last payment date and provide an alert of next payment date so that no customer’s payment is left unpaid and can be made timely.
- Employee class: Employee class contains details to all employees. The class will help to add, delete and update information related to employees of TrimFit business.
- Employee schedule: One of business needs of business is to manage classes that the gym trainers will take at different time slots. This class will provide this required functionality of the system. This class will help employees to schedule and view their time charter.
- Services: The services class will contain details about different services/ memberships provided by TrimFit to its members. It will help the owner to add, delete, and update any membership services.
The figure below is the class diagram, for the proposed system.
The proposed classes will provide different functionalities to the system and members but all these classes are restricted on level of accessibility. This accessibility is provided on basis of level of designation of employee. The owner, who will be given admin rights, will have full control of the system and so can access all classes but employees are restricted to access their details only. Similarly employees will be allowed to register with system. All these accessibility rights are employed in order to data confidentiality and restrict any illegal access.
Entity relationship diagram
Entity relationship diagram given above outlines all the tables needed for designing database for handling the database requirements of the company. The database will consists of different tables for recording customer and employees details and type of services related to them. The table below describes the different tables and their description (Role) in proposed system
Table: Customer table is used to all basic details of customer who visit and take different membership at TrimFit.
| Entity | Attribute | Description |
| Customer | Id | Primary key |
| First name | ||
| Last name | ||
| Street | ||
| City | ||
| state | ||
| Zip | ||
| Contact 1 | ||
| Contact 2 | ||
| Induction | ||
| Date of induction |
2. Membership: The membership table keep track of all membership taken by the customer. The table will help to check expiry and renewal of memberships
| Membership | Ref id | Primary key |
| Date taken | ||
| Membership id | ||
| Emp id | Foreign key |
3. Payment: The table will keep track of all payment details related to a customer. The table is used to track time the last payment was made and time when next payment will be made.
| Payment | Transaction id | Primary key |
| Last date | ||
| Next date | ||
| Payment | ||
| Balance | ||
| Emp id | Foreign key |
Attendance: the table is used to track the number of times a class is attended by any customer. This is applicable to employees who have taken membership on number of days.
| Attendance | Ref id | Primary key |
| No of classes | ||
| Emp id | Foreign key |
Services: This table keep record of all the services which are offered by TrimFit.
| Services | Membership id | Primary key |
| Type | ||
| Name | ||
| Duration | ||
| Fees |
Employee: The employee table contains all basic details related to employees who work at TrimFit
| Employee | empId | Primary key |
| First name | ||
| Last name | ||
| Street | ||
| City | ||
| state | ||
| Zip | ||
| Contact 1 | ||
| Designation | ||
| Salary | ||
| Joining date |
Schedule: This table will keep track of classes that an employee will take. The schedule is prepared by admin.
| Schedule | Schedule | Primary key |
| Time | ||
| Duration | ||
| Date details | ||
| Emp id | Foreign key |
Use Case Diagram
Context level DFD
Sequence Diagram
Activity diagram
Level 1
Conversion process
In order to install the proposed system in business environment, current system will be migrated to system under development. Data migration is must so that upon integration on business with automated system there may not left any place of errors, exceptions and loss of data. In this section we will check various options and will select the best option from all available one.
Options
The overall objective in the development of the database technology has been to treat data as an organizational resource and as an integrated whole. Database management system allows data to be protected and organize separately from other resources. Database is an integrated collection of data. The most significant of data as seen by the programs and data as stored on the direct storage access storage devices. This is the difference between logical and physical data. The organization of data in the database aims to achieve free major objectives(Korth, 2008, p- 178):
Ø Data Integration
Ø Data Integrity
Ø Data Independence
The databases are implemented using a DBMS package. Each particular DBMS has unique characteristics and general techniques for Database Design.
As per the requirement of the merchant shop, the three kinds of database can be used are as follows (taken from website):
- Microsoft Access
- Oracle
- Microsoft SQL Server
- Open source DBMS
The features of these three kinds of database systems enable them to use for keeping the financial record, inventory record, employee record and general purpose record. In case of organizations, the database is normally managed on the basis of the department separately. The accounts department will have its own database, the Hr department will be having its own database, the marketing department will have its own and likewise.
Selected technology
As per business and budget needs of the TrimFit business, Microsoft Access will suit the needs of organization. Microsoft Access provides a very easy interface than other database options described below. Employees of organization are mainly from a non technical background and using other available database options will be little complex for employees. Also, Database requirements of business are also small and simple and Microsoft Access suits these kinds of database needs.
Conversion Steps
- Collect all documents that are managed by business for data collection and business support
- All data is collected on a single file and group them as per departments
- All data collected will be stored in logical form as tables in selected technology.
- Integrate the proposed automated system with database
- Testing: Testing is a crucial process which is carried out to check if the migration step fully supports all the functional and business requirements of the business. The testing strategies that will be used for this purpose are described below
- Unit testing: the testing strategy is generally based on class level testing. The testing is done on the code by the developer itself.
- Integration Testing: the testing strategy is basically done to test whether the modules which were tested independently works properly when they are integrated together to form a composite module.
- White box testing: the testing strategy test for all the internal code (i.e. the data structure and algorithm implemented in the code).the testing will test for the API’s used, code, fault, mutation testing. The white box testing is pure testing.
- ACCEPTANCE TESTING: Acceptance testing test if the system is well adapted to the changed user environment. When all the work is completed at the developer end (developing and testing) then the software is tested in the user lab with his own hardware and to check whether it is performing in same way and same level at which it was working at developer end. Acceptance testing is performed by the user himself.
Team Skills required
The skills required by team are
- Proficient in technology: The technology selected for this project is Java and team is required to be proficient in Java. User interface will be developed using HTML so system designer and develop must have a deep knowledge of two technologies
- Database: Team must assign duty to handle database requirement to an efficient employee who have knowledge of Microsoft Access and other database queries and reports.
- Good communication skills and analysis power.
- Good business and presentation skill
- strong problem solving skills and good presentation skills
- dexterous, got interviewer skills and effective listening skills
- Technical aptitude
- result oriented
- Team leading and strong analysis skills.
Training requirements
The employees at TrimFit are required to be trained so that they can effectively manage the automated system. Training needs proposed for employees are
- Database handling techniques
- Must be trained to how to work with propend system
- Internet usage and exception handling
- the proposed entities are able to support database requirements of the company
- the project will be completed in propend budget and time
- the proposed system will be based on current system
- employees can be trained to use the system efficiently
Assumptions
Conclusion and recommendations
The proposed software is required to provide business and functional needs of TrimFit. The report analyse all the design, database and training need that are required by proposed system. The system will be a web based application that will help the business to achieve its goals and overcome existing problems. It is highly recommended that the user interface must be very easy and self explaining. The proposed system must be efficient and able to overcome all exceptions.
References:
Khaled M. Khan, Mahesha Kapurubandara.Urvashi Chadha, Incorporating Business Requirements and Constraints in Database Conceptual Models.Proceeding of the first Asian-Pacific conference on Conceptual modelling.Volume 31, pp: 59-64.Australian Computer Society, Inc.)
Oracle.Tasks of database administrator.referred from http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba002.htm
EDM.Skills required of a database manager.referred from http://www.effectivedatabase.com/skills-required-of-a-database-manager
LC36
But you can order it from our service and receive complete high-quality custom paper. Our service offers Information system essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”
