ACCT6001: Database Design and Application Report - Butler Financing

This report presents a database application designed for the Butler financing company, addressing the limitations of their current MS Excel-based system. The report details the necessity of a relational database management system (RDBMS) like MS Access, highlighting benefits such as large data handling, high-speed data retrieval, accuracy, data security, and easy data insertion through forms. It includes an Entity-Relationship (ER) diagram illustrating the relationships between borrowers, lenders, and property appraisers. Furthermore, the report provides examples of database queries, forms, and reports designed to meet the company's requirements, such as checking borrower and lender details, mortgage information, and running predefined queries. The conclusion emphasizes the implementation of these features, except for security, and the importance of a secure database for the company. References to relevant resources are also included.