INF 300 ASSIGNMENT SUBMISSION

1. Introduction

        This is a database system that handles information of Easy Drive School of Motoring.

1.1 Purpose of the system

        The purpose of this system is to improve communication and sharing of information between offices, employees and clients at   Easy Drive school of Motoring. Also, this system will reduce the amount of paper work at this school. Of course this is the first release (version 1) of easy driving school of motoring database system.

1.2 Document convention

Throughout this document of SRS, the font style used is: font name-Times new Roman, font size-12pt, line spacing-1.5

 1.3 Intended audience

        This system is intended to support the members of Easy Drive school of Motoring, namely: staff members, clients and other non staff members.

1.4 Project Scope

The development of this system at easy driving school of motoring will minimize the use paper to store necessary information for the organization.

1.5 Reference

How to write software requirement specifications. http://www.tuffley.com/tcs20001.html

Accessed on 06/02/2011

Sachin, K (2007) software requirement specifications (SRS) Template-Start writing SRS for your project. http://www.sachinkraj.wordpress.com/2007/10/04/ software-requirement-specification-SRS-template-start-writing-srs-for-your-project. Accessed on 06/02/2011

A. Silberschatz, H. Korth, and S. Sudarshan.( 1997) Database System Concepts (3rd ed.).

McGraw-Hill

2 Overall Descriptions

2.1 Product perspective

The development of this system is not a replacement development but it is a new development (version 1) that aims at solving a problem of paper work.

2.2 Product features

The system will enable a user to:

Ø  Login into system

Ø  Update the information

Ø  View information

Ø  Search for information in the database system

2.3 User Classes and Characteristics

This system will be accessed and used by different users with different privileges, below are the users with their privileges

System administrator (database administrator): will be able to-view all information, modify, update and delete information in the database

Staff: will be able to view part of the information in the database and edit (update) just part of the database

Normal user (client or normal staff member): will be able to view only part of the database information

2.4 Operating Environment

This system will under windows operating system platform (all Windows XP versions, all Windows Vista versions and all Windows 7 versions)

The database management system (DBMS) used are MySQL and SQL

This system will run under normal computer specification (at least 20GB HDD, 128MB RAM, and 1.6GHZ processor)

2.5 Design and Implementation constraints

In database creation the following tools will be used:

Ø  MS-Access,

Ø  E-R Diagram

Ø  Data flow diagrams (DFD)

In the database implementation the following tools will be used:

Ø  SQL Server

Ø  Visual basic (any version)

After the delivery of this software system, there will be on field training for users (staffs and system administrator)

2.6 User documentation

The Easy Drive School of motoring Database system will have user documentation (user manual guide) which will direct the users on how to use the system.

2.7 Assumptions and Dependencies

We assume that the system will depend on the availability of Windows operating system (any), MS-access and visual basic. Therefore if these software components miss, the system will not work

3. System features

This part of system features has been mentioned above (2.2) in the part of product features

4 External Interface Requirements

4.1 User interfaces

The Easy Drive school of Motoring database system will have good user interface which will enable system users to the database easily. The user interface will show necessary directives which will help the user on how to access data in a database.

Example: The login form will look like this

The Data entry form will look like this

5. Other Nonfunctional Requirements

5.1 Performance requirements

The Easy Drive School of motoring Database System will have good performance that will help users to easily access information and sharing information. The system will be faster such that the execution time will be minimal. Also, the system will have minimal or no errors and if the errors occur the system will alert the user on the required command.

5.2 Safety requirements        

 This system will require safe environment which is free from viruses.

5.3 Security requirements

The Easy Drive School of motoring Database system should be secured from unauthorized access, that is, only authorized users will have access to the database. This will be ensured through authentication of the users that will involve use of combination of user name and password. This will avoid unauthorized editing, changing or deleting of data from the system.

5.4 System quality attributes

The Easy Drive School of motoring Database system will have high quality in the sense that it will meet the requirements of users and its maintenance will be possible.

5.5 Project documentation

The Easy Drive School of motoring Database system will have the project documentation which will enable the other software developers to develop this system depending on the new user requirements.

Glossary

Database: A centrally held collection of data that allows access and manipulation by one or more users

Database management system (DBMS): a software system that facilitates the creation and maintenance and use of an electronic database

 Data flow diagram (DFD): A diagram that illustrates how data moves through an information system.

DFD

The DFD for the system development is attached in the presented files (DFD.doc)