Premium Essay

Database Project Documentation Guide

In:

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

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...

Words: 4906 - Pages: 20

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...Kudler Fine Foods Service Request SR-kf-013 BSA375 Business Systems Development Abstract Kudler Fine Foods, an upscale specialty gourmet foods shop with three locations (La Jolla, Del Mar and Encinitas), has an expressed interest in the development of a Frequent Shopper Program to enable enhanced information management by tracking customer-purchasing practices. The information collected regarding customer purchase behaviors through the Frequent Shopper Program will improve the quality of Kudler Fine Foods’ product lines and reduce the quantities of perishables discarded. To increase revenue and customer loyalty, and as an alternative to providing discounts, Kudler Fine Foods has partnered with a loyalty points program to offer incentives for customer loyalty in the form of high-end rewards for shopping at Kudler Fine Foods. Customers will earn points with every purchase, redeemable for high-value gift items such as first-class airline upgrades, and other specialty items (Apollo Group, Inc., 2007). Facilitating this effort will require systems planning and selection as well as current and proposed systems analysis and design, in conjunction with systems implementation and integration, training, operations, and maintenance. Kudler Fine Foods Service Request SR-kf-013 Initiatives Outline Kathy Kudler, the founder of Kudler Fine Foods, opened her first gourmet food shop in 2003. Since that time, two additional stores have opened, and other locations in Carlsbad...

Words: 7143 - Pages: 29

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...Kudler Fine Foods Service Request SR-kf-013 BSA375 Business Systems Development Abstract Kudler Fine Foods, an upscale specialty gourmet foods shop with three locations (La Jolla, Del Mar and Encinitas), has an expressed interest in the development of a Frequent Shopper Program to enable enhanced information management by tracking customer-purchasing practices. The information collected regarding customer purchase behaviors through the Frequent Shopper Program will improve the quality of Kudler Fine Foods’ product lines and reduce the quantities of perishables discarded. To increase revenue and customer loyalty, and as an alternative to providing discounts, Kudler Fine Foods has partnered with a loyalty points program to offer incentives for customer loyalty in the form of high-end rewards for shopping at Kudler Fine Foods. Customers will earn points with every purchase, redeemable for high-value gift items such as first-class airline upgrades, and other specialty items (Apollo Group, Inc., 2007). Facilitating this effort will require systems planning and selection as well as current and proposed systems analysis and design, in conjunction with systems implementation and integration, training, operations, and maintenance. Kudler Fine Foods Service Request SR-kf-013 Initiatives Outline Kathy Kudler, the founder of Kudler Fine Foods, opened her first gourmet food shop in 2003. Since that time, two additional stores have opened, and other locations in Carlsbad...

Words: 7121 - Pages: 29

Premium Essay

Computers

...[pic] Quality Assurance Plan For WAN Solutions Date: 5/26/2012 Revision Sheet |Release No. |Date |Revision Description | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |[pic] | | | ...

Words: 5473 - Pages: 22

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

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

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 redesign...

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. Educators...

Words: 6392 - Pages: 26

Free Essay

Vb, Net

...HND Division Head Office - IDM Nations Campus HND in Computing & Systems Development Unit 42 - Programming in .NET (June 2013) Set By : Mr. Sanaka Suranga Perera Student Name: Student Number: Edexcel Registration No: Date Released: 02/04/2013 Branch Name : Due Date: 31/05/2013 Submitted Date: Here by I confirm that this is my own work and that I have not plagiarized any part of it. I have also noted the assessment criteria of the assignment. Student Signature : Outcomes/Grade Descriptors Achieved (Please Tick) |Outcomes/ Grade |P42.1 |P42.2 |P42.3 |P42.4 | |Descriptors | | | | | | |1.1 |1.2 | |P42.1.1discuss the principles, |Include features ,principals of .NET framework(Task 1-a) | | |characteristics and features of | | | |programming using a .NET framework | | | |P42.1.2 critically compare different types|Differentiate the .NET versions (Task 1 -b) | ...

Words: 1224 - Pages: 5

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 important...

Words: 1205 - Pages: 5

Premium Essay

Kudler Frequent Shopper

...Running head: SERVICE REQUEST SR-KF-013 - KUDLER FINE FOODS Service Request SR-kf-013 – Kudler Fine Foods Kent Alexander, Tracy Duncan, Elvis Rocha Jr, Eliseo Perez, Todd Ruggles University of Phoenix BSA375 Fundamentals of Business Systems Development May 10, 2010 System Development Phase I Kudler Fine Foods is committed on providing customer satisfaction to all customers that purchase products from all of affiliated stores. To better serve the customers, Kudler is interested in developing a system to track customer purchases through a Frequent Shopper Program to award loyalty points for redemption (Kudler Fine Foods). Scope To develop a Frequent Shopper Program (FSP) that will improve customer’s satisfaction, track purchasing activities from the customers, and offer high end product for redemption as a reward for shopping at their stores. Goal Under the new program, each customers purchase transactions will be recorded and reward points will be earned base on dollar amount spent per transaction. Once points are accumulated, the points can be redeemed for high end gifts, products, specialty foods (Kudler), or partnership services from vendor companies. With the new system implementation, Kudler Fine Foods will be able to add new value to customers; improve customer satisfaction, increase margin profits, customer loyalty, and have adequate management system to track customer’s spending habits at Kudler Fine Foods. ...

Words: 5143 - Pages: 21

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. * Supports the...

Words: 1125 - Pages: 5

Premium Essay

Online Course Reservation

...ONLINE COURSE RESERVATION Arise and Shine Version 1.0 Revision History |Date |Version |Description |Author | |12/02/2014 |1.0 |Online course reservation |ram | | | | | | | | | | | | | | | | Table of Contents 1. Introduction 1 1.1 Purpose 1 1.2 Scope 1 1.3 Definitions, Acronyms and Abbreviations 1 1.4 References 1 1.5 Overview 1 2. Positioning 1 2.1 Business Opportunity 1 2.2 Problem Statement 1 2.3 Product Position Statement 2 3. Stakeholder and User Descriptions 2 3.1 Market Demographics 2 3.2 Stakeholder Summary 2 3.3 User Summary 2 3.4 User environment 3 3.5 Stakeholder Profiles 3 3.5.1 3 3.6 User Profiles 3 3.6.1 3 3.7 Key Stakeholder / User Needs 4 3.8 Alternatives and Competition 4 3.8.1 4 3.8.2 4 4. Product Overview 4 4.1 Product Perspective...

Words: 1769 - Pages: 8

Premium Essay

Parul Project

...Online Shopping System Project Documentation Glamour Basket HDSE-II eProject Sz Aptech Education Center Garden Center, Pakistan PH: +92212237040-2 EMAIL: aptech-gdn@cyber.net.pk URL: http://www.aptechgdn.com Glamour Basket Online Shopping System Page 1 CERTIFICATE This is to certify that Hospital Management System embodies the original work done by Aisha Yousuf, Muniba Shah and Muhammad Babar Khan and Zulekha, in 2011-2012 during this project submission as a partial fulfillment of the requirement for the Aptech Worldwide (Computer Education) Garden Center, Karachi, Pakistan for the final project of the HDSE-II. Mr. Aziz Husain (CEO) APTECH Computer Education Garden Branch Mr. Naeem Zia (Center Manager) APTECH Computer Education Garden Branch Ms. Hajra Ismail (Academic Head) APTECH Computer Education Garden Branch Glamour Basket Online Shopping System Page 2 ACKNOWLEDGEMENT The satisfaction that accompanies that the successful completion of any task would be incomplete without the mention of people whose ceaseless cooperation made it possible, whose constant guidance and encouragement crown all efforts with success. We are grateful to our project guide Mr. Muhammad Waqas Ilyas for the guidance, inspiration and constructive suggestions that helpful us in the preparation of this project. We also thank our colleagues who have helped in successful completion of the project. Aisha Yousuf (Student509323) Muniba Shah (Student503412) ...

Words: 1738 - Pages: 7

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 in ...

Words: 1741 - Pages: 7