BITM 330 – Spring 2019
Final Project – Part 1
Information System Development
INSTRUCTIONS – For this project you will develop a prototype of a software application with a database component. This assignment is divided into two parts: Part 1, which consists of  application/database design; and Part 2, which consists of application/database implementation. These instructions identify the items you need to complete for Part 1. This assignment consists of creating an application proposal plan on Word/Text document which includes application introduction, use case diagrams, graphic user interfaces, data models and queries, as outlined below. Submit this assignment in .DOC, .DOCX or .PDF format only.
a. Introduction to the application. In a paragraph explain your application or system: what is its purpose? what does it do? who can use it? is it offline / online (internet, web, both)? Desktop or mobile? Mention some specific functions and how one would go about using them. Identify any interesting differences or novelty about your application in comparison to similar applications already available (if applicable).
b. Use Case Diagrams. Provide at least 2 use case diagrams describing sets of functions of your system for a typical user or multiple users. Provide a couple of sentences describing each diagram. Use software application to draw the diagrams, such as Powerpoint, creately.com or Microsoft Visio. Make sure to include at least 4 components of use case diagrams. Name your users.
c. Graphic User Interface. Provide the look of at least 2 Graphic User Interfaces for your application.These should be akin to pages where users make choices and/or are provided certain functions; or forms where users enter input (e.g. order payment form, new customer form, etc). Draw the GUIs with a software application. Provide a brief explanation of what each GUI refers to.
d. Data Model. Provide a data model (entity-relationship diagram) for your database. This data model should include at least 5 entities. You should develop the data model in a database modeling software. Make sure to identify relationships, maximum and minimum cardinality via crow’s foot notation or UML class diagram notation. Identify primary keys and foreign keys. On average, your data model should have at least 4 fields/attributes per entity.
e. Queries. Create 5 queries for your system. Explain what each query does in English and include the SQL code. In all, you should have at least the following elements: 1 calculated field; 2 built-in functions; 1 group by component; and 1 sorting component.