SWC Programming Software Module for A New Inventory Application Capstone

Assignment: For this assignment-you are being asked to submit a research based analysis report over a Program Specific Case Study.

The parameters are as follows:

Please click on the link on the menu to your left that is specific to your program. Here-you will find a Case Study labeled “Case Study Analysis # 2”

• You will provide a case study analysis report.
• It must be a minimum of 3,000 words (excluding title page and references).
• It must include a separate title page.
• It must include a separate reference page.It must include a minimum of eight scholarly or professional citations written within the last five years.At least four of the eight references must originate from peer-reviewed journals.
• Use of the Southwestern College Deets Library is required.
• APA format is required for the case study analysis report. There are excellent APA resources available via the SC Writing Center in Academic Resources in this Blackboard course.

*Please review the writing assignment grading rubric for additional expectations.

**Please note–When you save your paper- Please title as follows:

Your name, Program, Case Study 2, i.e.

• (Ashden Elias, ACCT, Case Study 2)(Ashden Elias, BSAD, Case Study 2)(Ashden Elias, HCA, Case Study 2)

Session 2 Project 2: Create a Software Module for A New Inventory Application
An aerospace company has decided to update their technology to something more modern and
efficient. The segment of the task that requires your attention is in regard to the inventory system. This
system will need to collect information and store it into a database for each aircraft. This particular
segment focuses on the wheel assembly.
Description: An aerospace company, called AAC, is restructuring its internal technology processes. AAC
is a large corporation that develops and assembles airplanes and cutting-edge craft for several markets,
including commercial and defense. These craft include large passenger jets, attack aircraft, as well as
spaceflight technologies.
The company has chosen to create a new database system to manage its incredibly large and complex
parts inventory.
You work as an application software designer for an international corporation that has received the
contract to create the system, IBN. You are the primary designer and business interface between IBN
and AAC. You will design the User Interfaces that will be implemented.
IBN’s specialists have already determined which software language and database that the application
will be created with. In addition, they have determined the first two modules that will be implemented:
– Aircraft Information Entry and Wheel Assembly Subsystems.
Aircraft Basic Information Entry: These screens will allow for creating and editing of a new aircraft. It
will include the aircraft name, first assembly date, chief designer, description of use, the primary
customer, and a list of parts suppliers.
Wheel Assembly Subsystems: These screens will allow for the entry of all parts required for the
assembly, the number on-hand, the price for the part, and a description of the part.
Deliverables:
1. You will inform AAC as to the database and software language chosen by IBN to create their new
application, in written form. You must detail the reasons that this database and language were
chosen, without being overly technical to the AAC Technology Committee that you will be
interfacing with.
a. A single Word document detailing these requirements is sufficient. Expert sources from
Deets Library and other professional credible sources will be required to substantiate
these requirements. Therefore, the sources will need to be cited to acknowledge credit
for their contributions for concepts, ideas, and facts.
2. You must develop the database for the first phase of the project, providing the data structure
for Aircraft Basic Information Entry, and the Wheel Assembly Subsystems. Tables should follow
standard entity-relationship industry practices.
a. Submit an entity-relationship diagram detailing data structure
b. Provide a backup file of the database with your implemented data structure
3. You must develop and deliver the operational front-end that allows for the entry of the data
into the first phase screens, in the language that you choose. It must be operational and connect
to the database that you created in Deliverable #2.
a. Provide all code and files in zip archive, required to run the project
4. You must provide the above documentation from Deliverable #1, with installation instructions
for implementing your First Phase deliverables for items #2 and #3.
a. Provide installation instructions to implement the system. This can be a single Word
document
Please submit all files as a compressed (*.zip) file via the designated Unit 4 assignment in Blackboard.