Premium Essay

Database Project Documentation Guide

In: Computers and Technology

Submitted By buddy143
Words 367
Pages 2
Database Project Documentation Guide
IMPORTANT Note on how to present a document  No fancy fonts should be used Choose from – Times New Roman Tahoma Verdana Arial  The font size should be 12 or 14. (Neither smaller nor bigger)  Use 1.5 line spacing.  Make sure your document has page numbers.  Insert the Company name in the header.

1.

Cover Page

St. Mary’s College of Tagum
National Highway, Tagum City

Name of System and Company

A Database Project Submitted to the Faculty of Bachelor of Science in Computer Science of St Mary’s College of Tagum

In final fulfilment of the academic requirements for the CS 108 – Database Management System

Submitted by: NAMES
Date Submitted

2. Table of Contents 3. Document Scope - Describes the goal of this document in a narrative. - Introduction 4. System Overview - Provide a brief overview of the system. 5. Business Rules - Brief, precise, and unambiguous description of policy, procedure, or principle of the Company or Organization. 6. Relational Diagram - Representation of the Relational database’s entities, the attributes within those entities and the relationships between those entities. Example

7. Crow’s Foot ER Diagram - A graph/ diagram that represents the conceptual database as viewed by the end user. Example

8. ERM Components - Summarizes the ERM’s components and names the entities and their relations. Example.

. 9. Data Dictionary - Provides detailed accounting of all tables found within the user/designer-created database - Contains (at least) all the attribute names and characteristics for each table in the system - Contains metadata—data about data Example

10. Database Design Decisions - Discuss the decisions that were made when designing the database for the Application, including problems, alternative solutions, and design assumptions that had to be made. - Divide this section…...

Similar Documents

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...(Apollo Group, Inc., 2007). Upgrades to the Kudler Fine Foods’ information systems are necessary to facilitate the goals and objectives of in the Frequent Shopper Program. Development of the Frequent Shopper Program will follow the Systems Development Life Cycle processes to ensure thorough planning, selection, analysis, design, implementation, and operations. Planning and Analysis Prior to beginning the Frequent Shopper Program project, a thorough analysis of tangible measures will ensure stakeholders of a successful venture. Kudler Fine Foods will invest in updating the information system database for tracking customer-buying habits. Recommendations for this program include providing customers with a membership card, which has a magnetic strip for account identification purposes. In keeping with the high quality of products and services Kudler Fine Foods offers, the card design will appear similar to a credit card, unlike the thin plastic cards with bar codes, characteristic of discount grocers. After swiping the customer’s membership card, database tracking will begin for that particular purchase. At chosen intervals, the owner, sales team, store managers, and department managers will be able to view metrics reports relative to this data to analyze specific items bought by participating customers as well as the frequencies and quantities that customers usually purchase. The raw data and practical information will support the measurable objectives of the......

Words: 7143 - Pages: 29

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...(Apollo Group, Inc., 2007). Upgrades to the Kudler Fine Foods’ information systems are necessary to facilitate the goals and objectives of in the Frequent Shopper Program. Development of the Frequent Shopper Program will follow the Systems Development Life Cycle processes to ensure thorough planning, selection, analysis, design, implementation, and operations. Planning and Analysis Prior to beginning the Frequent Shopper Program project, a thorough analysis of tangible measures will ensure stakeholders of a successful venture. Kudler Fine Foods will invest in updating the information system database for tracking customer-buying habits. Recommendations for this program include providing customers with a membership card, which has a magnetic strip for account identification purposes. In keeping with the high quality of products and services Kudler Fine Foods offers, the card design will appear similar to a credit card, unlike the thin plastic cards with bar codes, characteristic of discount grocers. After swiping the customer’s membership card, database tracking will begin for that particular purchase. At chosen intervals, the owner, sales team, store managers, and department managers will be able to view metrics reports relative to this data to analyze specific items bought by participating customers as well as the frequencies and quantities that customers usually purchase. The raw data and practical information will support the measurable objectives of the......

Words: 7121 - Pages: 29

Premium Essay

Computers

...________________________________________________________________________ We fully accept the changes as needed improvements and authorize initiation of work to proceed. Based on our authority and judgment, the continued operation of this system is authorized. _______________________________ _____________________ NAME DATE Project Leader _______________________________ _____________________ NAME DATE Operations Division Director _______________________________ _____________________ NAME DATE Program Area/Sponsor Representative _______________________________ _____________________ NAME DATE Program Area/Sponsor Director Table of Contents: 1. Purpose 6 2. Reference Documents, Definitions, and Acronyms 7 2.1 Reference Documents 7 2.2 Abbreviations and Acronyms 7 3. Project Management 8 3.1 Project Organization 8 3.2 Methodology 8 3.3 Activities and Tasks 9 3.4 Roles and Responsibilities 10 4. Documentation 10 4.1 Project Notebook 10 4.1.1 Statement of Work 10 4.1.2 Project Plan 10 4.1.3 Individual Progress Reports 10 4.1.5 Issues Log 11 4.2 Functional Specifications Document 11 4.2.1 Purpose 11 4.2.2 Contents 11 4.3 Architecture Design......

Words: 5473 - Pages: 22

Free Essay

Bsa375 Final

...base; as a result, a decision has been made to partner with a loyalty points program that will provide rewards points to customers that can be redeemed for high-end gifts and upgrades. System Requirements Gathering During the initial stage of development, it is imperative to gather enough information to be able to accurately describe the system requirements. The first step is to determine the scope of the project based upon the objective outlined in the request. The next step would be to identify those that have a vested interest in the proposed new system. Once this information is known the project can be divided into modules and tasks can be assigned. Scope The deliverable for this project is to create a business/systems requirement document for the development of the frequent shopper program system to track the purchases of individual customers. The project should make use of the existing system when possible and develop enhancements, where necessary, to provide the added functionality necessary to meet this objective. In addition, the scope of this project should adhere strictly to the primary objective and avoid creep into areas not expressly stated through the service request. Stakeholders It is essential to the project's success to identify key stakeholders in the development of the new system before attempting to gather information to compile the list of system requirements. Some of these contributors will be directly interfacing with the system, while......

Words: 4906 - Pages: 20

Free Essay

Architect

...Fayette County Schools Research Paper Survival Guide June 2009 (revised November 2011) Compiled by: Jillian Bowen, Joanne Dirring, Monica Dorner, Greta Jackson, Shery Kearney, Ann Richardson, and Cheryll Thompson-Smith Based on the work of: Linda Brem, Kathy Franks, Cathy Nix, Ann Richardson, and Cynde Snider Table of Contents Plagiarism………………………………………………………………. Plagiarism Statement - Middle School……………………………..... Plagiarism Statement - High School……………………………….... English Research Requirements…………………………………….. Middle School Requirements…………………………………... 9th Grade Requirements………………………………………… 10th Grade Requirements………………………………………. 11th Grade Requirements………………………………………. 12th Grade Requirements………………………………………. Frequently Asked Questions…………………………………………. Annotated Bibliographies……………………………………….. Citation Formats…………………..……………………………... Common Mistakes………………………………………………. Documentation and Plagiarism…………..…………………….. Internet and Databases…………………………………………. MLA Manuscript Form…...……………………………………… Note Cards…..…………………………………………………… Outlines…………………………………………………………… Paraphrases and Quotations..…………………………………. Parenthetical Documentation……………………………...…... Quoting Poetry……………………………..……………………. Research Papers..………………………………………………. Research Process……………….……………………………… Research Projects……….……………………………………… Source Cards..…………………………………………………… Works Cited Page……………………………………………….. Research Glossary……………………………………………………. Online Resources……………………………………………………… Works Cited…………………………………………………………….....

Words: 19261 - Pages: 78

Free Essay

Vb, Net

... | |that support the |1-a,b) | | |.NET framework | | | |P42.2.1 design a .NET programming solution|Use design strategies (Task 2-b) | | |to a given problem |(Task 3-b) | | |P42.2.2 explain the components and data | Algorithm for design of user interface. Use case diagrams, | | |and file structures required to implement |class diagrams,etc and Include ERD and database design. | | |a given design |(Task 2-a, Task 3-a) | | |P42.2.3 evaluate potential delivery |Explain the IDE for the system (Task 1-c) | | |environments and | | | |interaction | | | |P42.3.1 implement a .NET programming |Select an appropriate design technique for a given visual | | |solution based on a prepared design |application...

Words: 1224 - Pages: 5

Free Essay

Oracle Business Process Redesign Project

...Software Documentation Process Improvement ISMG 6040 Spring 2011 Dr. Judy Scott Margaret Irene Wallace May 5, 2011 Contents 1. Executive Summary 3 2. Organizational Overview 3 3. Competitive Environment & Strategy 3 4. Oracle’s Fusion Middleware Department 4 5. Business Process Problem Discussion 5 5.1 Project Roadmap 6 6. Results & Findings 8 6.1 Understanding the Current Process 9 6.2 Redesign – Requirements and Design 12 6.3 Oracle 11g – BPM Criteria and ROI & Success Criteria 15 6.4 Develop, Test, Implement, Train 18 6.5 Coping with Cultural Resistance 19 Appendix A: Modeling Experience 20 Appendix B: Process Description 23 Appendix C: Inputs and Outputs 24 Appendix D: Governing Rules for Process Steps 25 References 26 1. Executive Summary The process for creating and publishing software documentation at Oracle is lengthy and involves several roles and departments. The software documentation departments and the number of products they are responsible for have grown tremendously over the years due to acquisitions. However, the documentation process and its tools have not scaled well. There is no overall set of tools for the entire process. Email is the primary communication method, and is the basis for routing work from one step and role to the next. These steps are not automated, and the steps which are automated use out of date, non-integrated tools. The process is overdue for a comprehensive analysis and......

Words: 6563 - Pages: 27

Free Essay

Introduction About Enrolment Grading System

...Course Management System Deployment A Report Submitted to: Project Advisor: Karen Lemone, WPI Professor By: Daniel Pickett __________________________ April 27th, 2006 This project report is submitted in partial fulfillment of the degree requirements of Worcester Polytechnic Institute. The views and opinions expressed herein are those of the authors and do not necessarily reflect the positions or opinions of Worcester Polytechnic Institute. This report is the product of an educational program, and is intended to serve as partial documentation for the evaluation of academic achievement. The reader should not construe the report as a working document. Abstract The WPI OfCourse! course management system provides educators with a set of tools to extend their existent course websites. While this toolset offers great functionality, the installation and configuration of the system is complex and difficult. The project team created a two-tiered installation package that is both simplified and easy to use. User testing was conducted and indicated a significant improvement in the installation procedure. In conclusion, the OfCourse! system was improved by the newly created installer. -i- Executive Summary As the web evolves and grows, educational professionals continue to pursue the use of online tools. While a variety of software exists, educators of average computer literacy seek a feature-rich application that is easy to install and use.......

Words: 6392 - Pages: 26

Premium Essay

Kudler Frequent Shopper

... Functions The new system implementation requires the following functions: • Project Planning • Analysis • Design • Implementation • Support In addition to the functions, the following strategies must also be implemented along with the functions: • System Design and Development • Vendor Selection • Equipment Selection • Customer Surveys • Data Analysis • Systems Testing • Troubleshooting • Employee / Vendor Training • Implementation Supporting Measures for Success As Kudler File Foods develops their Frequent Shopper Program they will need to identify ways to determine degree of success of the project. These measurements need to align with the scope of work and goals in which they have identified. Scope: • Create a “Frequent Shopper Program” to attract customers and create customer loyalty and track customers spending habits Identified Goals: • Ability to track reward points for customers • Ability to track customer product purchasing habits • Ability to track customer transactional purchasing dollar spent • Increase customer spending • Gain customer loyalty Additionally the measurements are not only needed to track success and effectiveness but they help to identify needed changes of a project. In addition, measurements help gain program support from stakeholders during the design......

Words: 5143 - Pages: 21

Premium Essay

Online Course Reservation

...Requirements 7 9.3 Performance Requirements 7 9.4 Environmental Requirements 7 10. Documentation Requirements 7 10.1 User Manual 7 10.2 Online Help 7 10.3 Installation Guides, Configuration, Read Me File 7 10.4 Labeling and Package 9 Introduction The purpose of this document is to collect, analyze and define high-level needs and features of the online course reservation It focuses on the capabilities needed by the stakeholders, and the target users, and why these needs exist. The details of how the online course reservation fulfils these needs are detailed in the use-case and supplementary specifications. By online course reservation we can study easily and in good manner. The purpose of this system is to make ease of learning instead of waiting for their turn in coaching center and also reduces the resources. 1 Purpose The purpose of this system is to make ease of learning instead of waiting for their turn in coaching center. It saves the travelling time and students can spend much time in learning. 2 Scope • The system must be safe • The system should be efficient • The system must be economic • The system must be feasible 3 Overview The document explains how the online course reservation helps the users by creating an account in online course reservation. The user can check the availability of the course from the database instead of checking in every institute in the online which minimizes the time......

Words: 1769 - Pages: 8

Premium Essay

Marketing

...DOCUMENT TEMPLATES FOR STUDENT PROJECTS IN SOFTWARE ENGINEERING Declan Delaney and Stephen Brown Department of Computer Science, National University of Ireland, Maynooth Date: August 2002 Technical Report: NUIM-CS-TR2002-05 Abstract This technical report outlines the contents of a minimal set of software development documents, tailored for use by students in software engineering projects, and firmly based on IEEE standards. The document set is designed to support software development activities. It provides a framework for use in undergraduate software engineering projects, both individual and team-based, that helps students to learn best practice. A supplementary report describes the content of each document in more detail. 1. Background. Projects form an important part of the education of software engineers. They form an active method of teaching, as defined by Piaget, leading to a "training in self-discipline and voluntary effort" [1], which is important to software engineering professionals. Two purposes served by these projects are: education in professional practice, and outcomes-based assessment, as identified in the ACM/IEEE Computing Curricula 2001 [2]. An infrastructure must be provided whereby the students are well guided in their learning, yet have an opportunity to display their individual achievements for the purposes of assessment. This corresponds to the ‘ integrational’ and ‘ differential’ modes of education as described by Cook......

Words: 1741 - Pages: 7

Premium Essay

Kudler Food Program

...at every location. FSP Project Scope The scope of the FSP project includes all: * Hardware * Software * Infrastructure * Network Components * Documentation * Training Frequent Shopper Project Stakeholders The Project Management Institute’s (PMI®) Guide to the Project Management Body of Knowledge (PMBOK Guide®) expands this definition to include anyone who, “… is actively involved in the project, or whose interests may be positively or negatively affected by execution or completion of the project.” A logical first step to identifying project stakeholders is to look at possible stakeholder groups. In general, these can be sorted into three levels: Level 1 - Stakeholders within the project organization: Senior Management, Sponsor, Customer, Users The level one stakeholder defines the need and requirements for the project, and controls the traditional project constraints of cost, time, and scope (the “triple constraints”). This includes the organization senior management, the sponsor, and possibly others who, by their position, may influence the project. Senior managers approve and contribute resources to the project, and/or may be users of the outcome of the project. It is in effect senior management’s project, and they define the product to be produced. Level 2 - Stakeholders within the project: Project Manager, Core Team Members, Vendors and Suppliers, Support Staff At the second level are the project manager and team, and any...

Words: 4256 - Pages: 18

Premium Essay

Hello

...Team B Project Scedule Shawn Calvin, Kristoffer Cabrera, Michael Foy, Daniel Perez, and Seaborn Hankerson CMGT/410 September 1, 2014 Marc Portner Business Requirement Document Project Description Team B Incorporated CEO has decided that the organization can benefit from a centralized data base for automating and managing global IT service relationships. Project Unification will combine all the company data from each location’s data base using the program ServiceNow. This program will enable the location managers to access and use company wide data from a single data base that will be located at the company headquarters in Seattle, WA. The business requirements for Project Unification are listed below. The budget of $150,000 for Project Unification has been legally approved by the CEO and all the stake holders. The project estimated completion will be 8 months from its inception. Project Unification has the following system and user requirements: • ServiceNow Service Automation Platform • Contractual and Legal documentation on the ServiceNow service • Individual clients for each location • Centralized Server/Data Base for Seattle, WA location • IT department employees and ServiceNow IT to begin implementation of the ServiceNow platform • Mandatory off-site training for location managers on the use of the new platform Functional requirement are very......

Words: 1205 - Pages: 5

Premium Essay

It Project Roles

...Responsibilities for IT Projects Project Title | [type the project title here] | Project Manager | | Document Version & Change History & Update Date | | | Title | Role | Name | Project Sponsor | Commissions the team to deliver the project and champions the cause throughout the project. Typically a senior member of staff with a relevant area of responsibility that will be affected by the outcome of the project. This may be a senior executive, director, or program manager. The sponsor is continually involved, including defining the project and actively reviewing the progress. | (Name of Individual) | Responsibilities | * Ultimate authority and responsibility for the success of the project. * Communicates on behalf of the project or defers to Project Manager. * Garners commitment from other key stakeholders. * Assures availability of essential project resources. * Approves the budget and decides tolerance levels. * Authorizes and approves/rejects “Project Change Requests” issues that affect Scope, Cost, Time or Quality which are outside of tolerance levels. * Leads the project steering committee. * Facilitates organizational level problem solving and ensures escalated risks/issues are resolved. * Makes key decisions on changes, risks, conflicting objectives and any other issue that is outside of the project manager's designated authority. * Negotiates a path through complex diplomatic areas of the project. *......

Words: 1125 - Pages: 5

Free Essay

Setu Managment System

...Software Requirements Specification for SETU Management System Version 3.0 approved Prepared by : Akshay sharma ISDL Project 24-9-13 Table of Contents Table of Contents ii Revision History ii 1. Introduction 1 1.1 Purpose 1 1.2 Document Conventions 1 1.3 Intended Audience and Reading Suggestions 1 1.4 Product Scope 1 1.5 References 1 2. Overall Description 1 2.1 Product Perspective 1 2.2 Product Functions 2 2.3 Operating Environment 2 2.4 Design and Implementation Constraints 2 2.4 User Documentation 2 2.6 Assumptions and Dependencies 2 3. External Interface Requirements 2 3.1 User Interfaces 2 3.2 Hardware Interfaces 3 3.3 Software Interfaces 3 3.4 Communications Interfaces 3 4. System Features 3 4.1 Software choices Error! Bookmark not defined. 4.2 Receipt/ Report generation Error! Bookmark not defined. 4.3 Administrator for verification…………………………………………………………………….4 5. Other Requirements 4 Appendix A: Glossary 4 Appendix B: Analysis Models 5 Appendix C: To Be Determined List Error! Bookmark not defined. Revision History |Name |Date |Reason For Changes |Version | |SETU Management (Beta version) |10-9-13 |Very few certificates are......

Words: 1289 - Pages: 6