...Project 1 1.3. Glossary 2 1.4. References 2 1.5. Overview of Document 2 2.0. Overall Description 4 2.1 System Environment 4 2.2 Functional Requirements Specification 5 2.2.1 Reader Use Case 5 Use case: Search Article 5 2.2.2 Author Use Case 6 Use case: Submit Article 6 2.2.3 Reviewer Use Case 7 Use case: Submit Review 7 2.2.4 Editor Use Cases 8 Use case: Update Author 8 Use case: Update Reviewer 9 Use case: Update Article 9 Use case: Receive Article 10 Use case: Assign Reviewer 11 Use case: Receive Review 11 Use case: Check Status 12 Use case: Send Response 12 Use case: Send Copyright 13 Use case: Remove Article 14 Use case: Publish Article 14 2.3 User Characteristics 15 2.4 Non-Functional Requirements 15 3.0. Requirements Specification 17 3.1 External Interface Requirements 17 3.2 Functional Requirements 17 3.2.1 Search Article 17 3.2.2 Communicate 18 3.2.3 Add Author 18 3.2.4 Add Reviewer 19 3.2.5 Update Person 19 3.2.6 Update Article Status 20 3.2.7 Enter Communication 20 3.2.8 Assign Reviewer 21 3.2.9 Check Status 21 3.2.10 Send Communication 22 3.2.11 Publish Article 22 3.2.12 Remove Article 23 3.3 Detailed Non-Functional Requirements 23 3.3.1 Logical Structure of the Data 23 3.3.2 Security 25 Index 26 List of Figures Figure 1 - System Environment 4 Figure 2 - Article...
Words: 6057 - Pages: 25
...Software Requirements Specification October 28, 2013 Window App for Sending SMS to mobiles via internet from your computer Submitted by: Muhammad Gulfam Submitted to: Engr. Natasha Nigar Software Engineering Table of Contents Table of contents……………………………………………………………………. List of figures……………………………………………………………………….. 1. Introduction………………………………………………………………….3 1. Purpose……………………………………………………………...3 2. Scope of project……………………………………………………...3 3. Glossary……………………………………………………………...3 4. Overview of document……………………………………………….4 2. Overall Description……..…………………………………………………......5 2.1. System Environment...……………………………………………….5 2.2. Functional Requirement Specification ……………...……………….6 2.2.1. User use cases………………………………………………...6 2.3. User characteristics …………………………………………………….11 2.4. Non Functional Requirements ……………………………….…………11 3. Requirement Specification …………………………………………………..12 3.1 Functional Requirements ……………………………………………12 List of diagrams Fig.1 System Environment ………………………………………………………….3 1.0. Introduction 1.1. Purpose The purpose of this document is to present a detailed description of the Window App for Sending SMS to mobiles via internet from your computer. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must...
Words: 2905 - Pages: 12
...Project 1 1.3. Glossary 2 1.4. References 2 1.5. Overview of Document 2 2.0. Overall Description 4 2.1 System Environment 4 2.2 Functional Requirements Specification 5 2.2.1 Reader Use Case 5 Use case: Search Article 5 2.2.2 Author Use Case 6 Use case: Submit Article 6 2.2.3 Reviewer Use Case 7 Use case: Submit Review 7 2.2.4 Editor Use Cases 8 Use case: Update Author 8 Use case: Update Reviewer 9 Use case: Update Article 9 Use case: Receive Article 10 Use case: Assign Reviewer 11 Use case: Receive Review 11 Use case: Check Status 12 Use case: Send Response 12 Use case: Send Copyright 13 Use case: Remove Article 14 Use case: Publish Article 14 2.3 User Characteristics 15 2.4 Non-Functional Requirements 15 3.0. Requirements Specification 17 3.1 External Interface Requirements 17 3.2 Functional Requirements 17 3.2.1 Search Article 17 3.2.2 Communicate 18 3.2.3 Add Author 18 3.2.4 Add Reviewer 19 3.2.5 Update Person 19 3.2.6 Update Article Status 20 3.2.7 Enter Communication 20 3.2.8 Assign Reviewer 21 3.2.9 Check Status 21 3.2.10 Send Communication 22 3.2.11 Publish Article 22 3.2.12 Remove Article 23 3.3 Detailed Non-Functional Requirements 23 3.3.1 Logical Structure of the Data 23 3.3.2 Security 25 Index 26 List of Figures Figure 1 - System Environment 4 Figure 2 - Article...
Words: 6057 - Pages: 25
...A Microfinance MIS A Microfinance MIS Mifos is a database system that was designed specifically for countries that are developing microfinance institutions. This database system is intended to be use by institutions whose purpose is to “deal with the planning for, development, management, and use of information technology tools to help people perform all tasks related to information processing and management” (Rainer and Turban, 2008, p.24). The different types of analysis include: Business reporting and client management; it can also include the ability of savings and loan portfolio analysis report that can be run on Mifos. Some of the system advantages are easy, effectiveness, positive social and business impacts, growth and scalability. Some of the other important design features are: protection, data integrity, flexibility and quickness. A MySQL database is run under Mifos. (Grameen Foundation, 2008). This is used for the commonly known web applications. This is usually use to store and log user data (i.e. Facebook). Within the database you can find, account authentication, authorization and administration structures built within this database. These utilities are usually assemble as one application component, this makes it user friendly. The rest of the applications are designed for loan officers, branches and loan reviewers. Business logic is supported within the function through the use of tables for this data. This is believed to be the most excellent...
Words: 278 - Pages: 2
...Fundamentals of Database Systems Laboratory Manual1 Rajshekhar Sunderraman Georgia State University August 2010 1 To accompany Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley, 2010. 2 Preface This laboratory manual accompanies the popular database textbook Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley, 2010. It provides supplemental materials to enhance the practical coverage of concepts in an introductory database systems course. The material presented in this laboratory manual complement many of the chapters of the Elmasri/Navathe text typically covered in most introductory database systems courses. Chapter Mappings The laboratory manual consists of 8 chapters and the following table shows the mapping to the chapters in the Elmasri/Navathe textbook: Laboratory Manual Chapter Elmasri/Navathe 6th Edition Chapter(s) Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapters 7, 8, and 9 Chapters 3, 6, and 26 Chapters 4, 5, and 13 Chapters 4, 5, and 14 Chapters 15 and 16 Chapter 11 Chapter 12 Chapters 13 and 14 Chapter 1 presents ERWin, a popular data modeling software that allows database designers to represent Entity-Relationship diagrams and automatically generate relational SQL code to create the database in one of several commercial relational database management systems such as Oracle or Microsoft SQLServer. The material presented in this chapter is tutorial...
Words: 18417 - Pages: 74
...Microsoft Access or Microsoft SQL Server: What's Right in Your Organization? SQL Server Technical Article Writers: Luke Chung Technical Reviewer: Matt Nunn Published: December 2004, revised July 2006. Applies To: SQL Server 2005 Summary: This paper explains how Microsoft® Access is used within an organization. It also explains when to use Access and when to use Microsoft SQL Server™. Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering...
Words: 6412 - Pages: 26
...HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper Saddle...
Words: 70521 - Pages: 283
...WORLD VISION POSITION DESCRIPTION |KEY POSITION INFORMATION | |Job Title |DM&E Coordinator | |13 | |Reports To |Program Team Leader | |Department/Group |Quality Team |Location |Sarajevo | WORK CONTEXT / BACKGROUND: World Vision’s earliest involvement in Bosnia-Herzegovina (BiH) was in 1994. Over the years, WV BiH has re-shaped its ministry from a largely return-focused program to one in alignment with the country’s basic development needs. WV BiH strategic intent is to contribute towards CWB in BiH (child wellbeing). To date, WV BiH works in partnership with communities, local and national government, faith-based institutions and civil society for the well-being of children. WV BiH makes no distinction of faith, ethnicity or gender when delivering its assistance to children and their families. Currently WV BiH employs 80 staff across the country. The overall annual budget for World Vision Bosnia and Herzegovina is around $4.6 million. PURPOSE OF POSITION: To lead the DM&E processes of intentional design and gathering of evidence of programs. This will be done through the...
Words: 1594 - Pages: 7
...Hibernate allows us to do object relational mapping. Simply this mean, conversion of objects derived from java classes inside the application, directly to tables in the database. This will reduce the effort utilized in drawing ER diagrams, normalization (conceptual design) as well as physically writing SQL coding to complete the physical design inside the RDBMS. Hibernate will prevent getting your java code dirty via writing SQL within it. If you use hibernate, no sql within your java application at all. Also hibernate provides:- • Caching of frequently used data record. Its several times efficient than retrieving from the database. • Needn’t opening and closing database connections. This will prevent memory leakage problems • Allow the java application to work with multiple DBMSes. • Small change in the java code will alter the table in the DB. Needn’t dropping the table. • 80% of code reduction in the application program When the required operation was initiated from the application, hibernate is versatile enough to auto generate the required SQL coding Go to this site called www.hibernate.org/downloads After going into the site .. notice some changes Look at the release bundles .. under the release bundle , download the latest version Add those into the library.. all those jar files to the library And then add a xml file and name as hibernate.cfg And then go to project file and search for a file in the name of hibernate.cfg.xml And from that get the...
Words: 309 - Pages: 2
...beneficial to switch to a more relational database like Microsoft Access. In turn, this will help improve internal communication and help streamline some of the work processes for the sales department. Currently the Party Plates Company uses Microsoft Excel to track personnel data in a spreadsheet inputting small amounts of repetitious data each time a record is created. Although Microsoft Excel and Microsoft Access offer some of the same tools such as applying filters, sorting table data, and extracting information, Microsoft Access a relational database, has features to track actions and events in multiple related tables. It offers more built in tools better to organize, track, and to make a relational structure between the tables by using a common field for the purpose of creating queries, forms, and reports large amounts of data than Microsoft Excel. The Party Plates Company would benefit from the use of converting their personnel data from single Microsoft Excel spreadsheets into a relational database, such as Microsoft Access (2012 Microsoft Corporation). There are many benefits that Party Plates would get from using Microsoft Access. The cost is reasonable to the other databases available; this system permits customization of databases making it possible to manage other functions together in the same area and not have to use more than one database. Microsoft Access prevents the duplication of the same information entered into the database. This will help save time entering...
Words: 720 - Pages: 3
...| In a database system, a question such as "Find the names of all students who take class ENG210" is called aAnswer | | Selected Answer: | query | Correct Answer: | query | | Question 2 4 out of 4 points | | | Protecting the database from unauthorized access or modification is calledAnswer | | | | | Selected Answer: | data security | Correct Answer: | data security | | | | | Question 3 4 out of 4 points | | | In a bank, all of the following are examples of end users EXCEPT aAnswer | | | | | Selected Answer: | database administrator | Correct Answer: | database administrator | | | | | Question 4 4 out of 4 points | | | A data dictionary can be used toAnswer | | | | | Selected Answer: | record the database structure | Correct Answer: | record the database structure | | | | | Question 5 4 out of 4 points | | | The miniworld that is represented in a database is also called theAnswer | | | | | Selected Answer: | universe of discourse | Correct Answer: | universe of discourse | | | | | Question 6 4 out of 4 points | | | In the staged database design approach, in what order are the three models developed?Answer | | | | | Selected Answer: | conceptual, logical, physical | Correct Answer: | conceptual, logical, physical | | | | | Question 7 0 out of 4 points | | | The process of categorizing objects by identifying...
Words: 773 - Pages: 4
...Query and * Implement database systems. Unit abstract An understanding of: * Database tools and * Database technologies * Database * Complex data structures and interface Databases provide the infrastructure to many organisations and they offer support to key business applications and information systems. The most common database model used commercially is the relational one. The aim of this unit is to: * Provide a knowledge and understanding of database systems, including * Design principles * Practical implementation and development skills for both the system designer and software engineer. The importance of structured query languages should be stressed, in terms of how they can be used to manipulate data and how they are used for a variety of tasks including querying and report writing. On completion of this unit the learner should be able to understand, design, query and implement a database(s). Learners will also have a theoretical insight into the requirement for designing a database that meets a given user or system requirement and that is functional, user friendly and robust. Learning outcomes On successful completion of this unit a learner will: 1. Understand data models and database technologies 2. Be able to design and implement relational database systems 3. Be able to use manipulation and querying tools 4. Be able to test and document relational database systems. Unit content ...
Words: 576 - Pages: 3
...1.0 Introduction. This chapter of the project report comprises of the background of the study, statement of the problem, general and specific objectives of the research, scope of the study and significance of a computerized records management system. 1.1 Background information. I have much concentration on one of primary school known as kyegera parents primary school. It is one of the many privately owned primary schools in kampala district. This primary school was constructed and started operating in 2006 to offer good education to the young generation in the district and perhaps competite with the rest of the country’s schools. The manual based granding system is the current system used by this education institute as I analyze this system I found that the system was costly in terms of purchasing papers, calculator and minimising error. A computerized granding management system for an education institution is all about simpling stundents granding, securing reports, managing and quick retrieval of data and storage of large volume of data with the help of hard drive and can be kept for long period of time. It also allows deletion and editing of data which cannot be done on paper. 1.2 Problem statement. The institutions current system is mainly manual based granding system which are costly in terms of granding using calculator , storage and securing records from intruder to access them. 1.2.1 General objective. The purpose of this project is to design a computerized...
Words: 8272 - Pages: 34
...Efficiency and collaboration proposal Benefits of using Microsoft Access Microsoft Access is a database application included in Microsoft Office, which helps businesses to save money. The different components and features make Microsoft access easy to use. The database application is beneficial to the work environment and offers a quick-learning format (Demand Media, Inc., 1999-2012). People can create an operational database in less than one-hour when importing information from other Microsoft Office applications (Demand Media, Inc., 1999-2012).Microsoft Access is capable of taking information from the enterprise software. More than one person can access or use the database at a time. People can add, delete, and update information instantly without the knowledge of programming languages (Demand Media, Inc., 1999-2012). Beginners can use the database wizard to create database objects and relationships that has easy to follow instructions. The database application helps to avoid errors and duplicates of data. The application is compatible with word and excel. There is no database code needed to perform database functions where with other applications a code is required. Microsoft Access has predesigned database templates allowing people to add data immediately without developing a template (Demand Media, Inc., 1999-2012). A business would benefit from Microsoft Access because most businesses grow and collect data over the years. The business can use the application to...
Words: 267 - Pages: 2
...Stock Portfolio Management The following exercises are designed to provide you more practice with querying an Access database. To begin this exercise, retrieve the file PortfolioManagment.accdb from Blackboard (found in the Learning Module called Databases & Access -> Presentation & Data Files). Open the database file. Design Challenges 1. Open the Client table. How many records does it have? ______ How many fields does it have? ______ 2. What is the primary key for the Client table? 3. Set the primary key for the Stock table. 4. Review the data types assigned to the Stock Purchase table. One data type is incorrect. Please correct the data type and save the change. 5. Set the primary key for the Stock Purchase table. 6. Create a form for the Client table that allows easy entry of a new client. 7. Using your form you just created, add yourself to the Client table. Call the form Client Entry Form. 8. Add your favorite stock to the Stock table. Make up data if you do not know specifically what exchange or current price it trades at. 9. Buy 100 shares of the stock that you just added to the Stock table. Query Challenges 10. Select the Stock table. Create a query called NYSE Stocks that lists all stock tickers traded on the NYSE. The resulting query should be sorted by the stock’s name. 11. Select the Stock table. Create a query called Expensive Stocks that lists all stocks whose stock price is greater...
Words: 437 - Pages: 2
