CET 4429 Project Information
Introduction
The CET 4429 project is a group project that can be solo or group. The project will involve the design of a database backend to support a set of supplied from end specifications.
Group Creation
Students may form groups during the frst two weeks of class or perform the project as a solo project.
Project Requirements
All projects will have the following documented. Different levels of completion of the required items is required in each of the 4 project submissions. There will be additional requirements that will be needed in the submissions, these will be in the appendices of the final design report. The final design report will contain all the elements listed below.
- Background requirements
- Who are the stakeholders?
- Why are you building this system?
- Who will use it?
- What does it do?
- Data Dictionary- for all fields that will be stored in the database the following are required in the data dictionary.
- FIeld Name
- Field Description
- Data Type
- Data Lifecycle (where is data created? where does it end up? Who uses it?)
- Restricted access (role access) for read and write
- Database Schema Diagrams
- Database Schema Scripts
- Simple SQL Script for DB Creation
- Schema of all views (and diagrams)
- Script for any views
- Schema Diagram for any Views
- Documentation of all stored procedures
- Stored Procedure Code
- Purpose of stored procedure (can be included in document)
- Written by - can be comment in SP
- Documentation of coded fields and code plan
- Any fields stored codes, must include all codes and descriptions
- Ensure you double check against schema - I will look for coded fields
- Security plan (roles and acess levels to tables, views, stored procedures)
- List all roles and user types.
- Who has access to what? (roles accessing table, view, stored procedure)
- How will appropriate access be ensured?
- Indexing plan and maintenance plan
- What will be indexed?
- How will you monitor performance?
- Who will be responsible for maintaining?
- What access will Maintenance have?
- Proof of deployment in approved database product
- A simple capture of SQL server, Oracle, MySQL that shows DB
Where to get Ideas
It is recognized that not everyone in the class in groups will have access to specifications that will allow them to perform the design for this class. To help with this the class project groups are welcome to use any of the published specs from the SAGE project located at http://ucf-sage.pbwiki.com/ . At this site simply click on SAGE Methodology and you will have access to technical requirements for a number of government processes. Feel free to use any of these as your base for a database development.
Project Submissions
Other Project Ideas
These are ideas for project that I have developed that are about the correct scope for this class project.
Spring 2009 Groups
Spring 2008 Groups
Comments (0)
You don't have permission to comment on this page.