Portfolio

LIS4381 - Mobile Web Application Development

Business Card App:

I designed a simple business card application using Android Studio. It features two pages. The first page is my name and picture and once you click the "Details" button, it takes you to a second page with my school contact information and my interests at the time of the app's creation. This was one of the first applications I ever made.

I learned how to design and format apps in Android Studio using XML and to program buttons using Java. The favicon for all my apps in my mobile app development courses was developed during this project.

**NOTE** I edited the second image to block old contact information.














LIS4331 - Advanced Mobile Applications Development

My Users App:

For this project, I designed an admin application that can add, update, and delete users to a database. The application includes a splash screen, a main screen with view, add, update, and delete functions, utilizes ScrollView to permit landscape/portrait views, and uses an SQLite database to store the users.

For the add function it asks the user for their username and password and then stores the information in the database after clicking the corresponding "add" button at the bottom of the application. The update function works similarly, except the user is required to enter their current username and then their new username. To delete the user, the admin simply types the username and hits the "delete" button. If the admin wanted to view the list of users, they tap the "view" button, and a pop up appears with the data collected from the database with the entry number, username, and password displayed. The application includes other pop ups to tell you if the data was added, deleted, updated, or if any input was unsuccessful.

In this project, I used XML to format the interfaces and Java to program classes and create functionality. I utilized the built-in Android Studio class SQLiteOpenHelper to manage the database functions.

Update User

Update User

View Users

View Users



LIS4368 - Advanced Web Applications Development

Customer Web Application:

This project was a combination of projects that taught me how to create a basic form to insert a customer into a database, which uses basic client-side and server-side validation, as well as, a Model View Controller (MVC) framework. I created a database using MySQL Workbench, and then coded and compiled Java Server Pages (JSP) and Java files to create the form with prepared statements to prevent SQL injection, JSTL to prevent XSS, and uses Create, Read, Update, and Delete (CRUD) functionality. After the insert passed validation, you could see the entry in the customer dataset along with all the other entries. You could edit/update or delete any of the entries, as well.

The series of projects that lead to this finished product taught me so much. I obtained experience creating forms, doing client-side and server-side validation, using regular expressions, using MVC framework, CRUD functionality, creating a database (MySQL Workbench), preventing security issues like SQL injection and cross site scripting. I had to locally create a working website and application all using JSP and Java.

Passed Validation (thanks.jsp)

Passed Validation

Modify Form (modify.jsp) Update Customer

Update Customer

Delete Customer with Warning (customers.jsp)

Delete Customer

LIS3781 - Advanced Database Management

Home Office Supply Company Database using MS SQL Server (T-SQL) with Data Mart:

I developed a database with data mart through two related projects. The fictional concept for these projects began with a contract to develop a system that tracks day-to-day business operations for a high-volume home office supply company. The CFO required an updated method for storing data, running reports, and making business decisions depending on trends/forecasts. The CFO also required the ability to maintain historical data to meet governmental regulations. Later, the CFO contracted me to develop a smaller data mart as a test platform.

I created the database using T-SQL code on MS SQL Server, and created an Entity Relationship Diagram (ERD) as a visual reference of the relationships and the database design. For demonstration purposes the project included 10 unique records in the person tab, 25 unique records in the sale table, and 5 unique records in all other tables. There are examples of the T-SQL code and the records in the photos of a table's T-SQL and procedure with its results, as well as a view of the final ERD.

These projects gave me experience designing a database in T-SQL/MS SQL Server with a product history table and it was the first database I made with a data mart. I also learned to manage expanding project scope and complete evolving project deliverables within the committed times.

Table T-SQL Code Example

ERD

Procedure Results Code Example

Procedure Results

Main Page

Main Page

Details Page

Details Page

Check out more of coursework in my LIS4381 Bitbucket.

Splash Page

Splash Page

Add User

Add User

Delete User

Delete User

View After Deletion

View After Deletion

Check out more of coursework in my LIS4331 Bitbucket.

Valid User Form Entry (customerform.jsp)

Valid User Form Entry

Display Data (customers.jsp) with Added Customer

Customer Added

Modified Data (customers.jsp)

Valid User Form Entry

Check out more of coursework in my LIS4368 Bitbucket.

Entity Relationship Diagram

ERD

Procedure Code Example

Procedure

Check out more of coursework in my LIS3781 Bitbucket.

I have projects that use MySQL, Oracle, and MongoDB on there.