Database-Driven Application for Sofa So Good (Furniture Rental Store)

Group Number: CS6232-G3

Group Members:

• Stan Shadrix, Project Manager (Email: [email protected])
• Benjamin Lively (Email: [email protected])
• Deeksha Namani (Email: [email protected])

Project Overview:

The purpose of this group project is to apply the principles learned in the Database Systems I and II through the design and implementation of a database-driven application for Sofa So Good, a furniture rental store. The project aims to demonstrate proficiency in:

• Database design and normalization
• SQL query formulation including DDL and DML
• Implementation of stored procedures
• Database connectivity and operations from a C# application
• Application of the MVC architecture with a Data Access Layer

Project Tasks:

Design and implement a revised database schema for RentMe, considering the modified requirements from the previous semester.

The Application will contain the following functionalities:

• Membership-based furniture rental services
• Employee-assisted registration and furniture rental transactions
• Inventory management with search capabilities
• Rental and return transaction processing
• Authentication of employees with secure password storage
• Administrative interface for report generation

Software and Tools:

• Database: MS SQL Server DBMS
• Development IDE: Visual Studio
• Programming Language: C#
• The application is a desktop (NON-WEB) application using Windows Forms.

Development Approach:

Iterative and incremental development with the application of software development best practices and design patterns.

Additional Notes:

The initial specifications may be refined through discussions with the customer (instructor) to clarify requirements. Group members are responsible for keeping their local databases up-to-date to maintain consistency across development environments.

Deadlines and Submission:

All project deliverables are to be submitted by the specified due date on Moodle. Regular updates and version control are to be maintained through Git, with meaningful commit messages reflecting the progress of the project.