ACCT6001: Database Application Case Study of Butler Financing Company

This case study analyzes the application of databases within Butler Financing Company, a mortgage brokerage. It begins with an introduction to database concepts, highlighting the advantages of database implementation over spreadsheets, particularly in reducing data redundancy and improving data integrity. The case study then delves into the design and implementation of a relational database, including an Entity Relationship Diagram (ERD), normalized data tables for borrowers, lenders, and properties, and SQL queries to retrieve and manipulate data. Examples of SQL queries are provided to demonstrate the retrieval of specific data based on different criteria. The case study also includes the creation of forms for data input and display. Furthermore, the case study addresses IT security and privacy considerations, discussing potential threats to database integrity and confidentiality, and suggesting countermeasures such as data encryption and secure data handling practices. References to relevant literature are included to support the analysis.