Case Study on Database Apllication
7 Pages1629 Words488 Views
Added on 2020-12-18
Case Study on Database Apllication
Added on 2020-12-18
ShareRelated Documents
DATABASE APPLICATION- CASE STUDY
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1MAIN BODY...................................................................................................................................1Justification of the database.........................................................................................................1Entity Relationship diagram........................................................................................................2Database tables.............................................................................................................................3Queries.........................................................................................................................................3IT privacy and security................................................................................................................3CONCLUSION................................................................................................................................4REFERENCES................................................................................................................................5
INTRODUCTIONDatabase application can ex explained as a computer program whose primary purpose isto retrieve and enter data into a computerised database. There various kinds of databaseapplications such as accounting system, reservation system etc. This assignment is based on acase study of Butler Financing company that runs a mortgage brokerage business. They maintaina list of data spreadsheet which consist of the data of their borrowers and lenders. They need adatabase to store and maintain their spreadsheet data. In this assignment MS Access will be usedas a database design tool for solving their problem and storing data. Based on the informationprovided Entity relationship diagram will also be drawn. MAIN BODYJustification of the databaseMicrosoft Access is a database management system created by Microsoft. It is acombination of software development tool and Microsoft database design engine. It normallystores data in its own format which can imported or linked directly to any kind of application aswell as with other databases as well. It is one of the simplest and secure database that can be usedto store data. It is just one part of Microsoft's data management product strategy. Like othernormal relational databases it allows its users to like all kind of related information easily witheach other with its severally powerful connectivity features (Souza and et.al., 2016). It can easilyimport or export that database files either to other applications or database or from otherdatabases. One of the best feature of MS access is that it can easily understand wide variety ofdatabase file structures. In fact it also supports data that has been exported from spreadsheetsdatabase files etc. It is one of the most commonly used database that can be used by theorganisations or students to store their data in any format which is required by them. It is used for variety of purposes but basically it is used for creating tables, forms,queries, reports etc. and connect then together with macros. The main concept behind MS accesswas to make it easy for the users to access the data from any kind of source. It can also importdata from sources like Outlook, Excel, dBase, ASCII, FoxPro, oracle, SQL Server etc. Data thatis used for linking can be used for querying, viewing, reporting, editing etc. It also helps inchanging the present existing data into latest data and not only this it can also perform variouskinds of joints that are used to join data sets that are mostly stored in different platforms(Kristensen, Teoh and Baker, 2015). It also provides a feature through which queries can be1
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design and Implementation: A Case Study of 'The Butler Financing'lg...
|15
|2231
|72
Data Modelling, Management and Governance for Sports Club Management Systemlg...
|13
|2574
|259
Database Designing and Implementation for Accounting Information Systemslg...
|9
|1708
|286
Assessment 1 Database Analysis and Designlg...
|14
|1477
|127
Database Design and Developmentlg...
|27
|3992
|59
Understanding LINQ with CSV and XMLlg...
|2
|887
|255