Database Online Tutoring

Introduction

Database is an organized collection of logically related data, in other words it’s a collection of information which is organized for easily accessible, managed and updated data. So, it is a form of organized data into rows, columns and tables, which is listed to make it simple to find relevant information. When data is organized it gets updated, expanded and deleted as new information is added. To control all the data, a database management system (DBMS) is used which is a group of programs that control the database to supply a connection between the database and its users and other application programs. Its objective is to provide a convenient and effective method of defining, storing, retrieving, and controlling the data contained in the database. MSAccess, LibreOffice, MySQL,Oracle are the different types of DBMS.

The Butler Financing Company is a company that runs the business of mortgage brokerage. The main objective of the company is to keep record of all borrowers, lenders and the property appraiser involved in the financing process. For the last 5 years it has been providing services to the customer with satisfactory results and profits. The company is using a spreadsheet to keep all the records of its borrowers, lenders and property appraiser in table list form. Since they are doing it manually there are high chances of data duplication, higher data redundancy, user error, difficult for users to process, and take too long to use. Even the records stored need to be updated manually by the employee. So, to reduce all these circumstances the company needs to upgrade the system to a database.

 

Tips for Making a good Database design 

The database is the set of data collections which are stored and retrieved using electronic means. Databases keep records in a very organized way which helps to find out the right one in a quick manner. So, the database management system supports the storage and manipulation of the data.

 

Get Database Assignment Help from online tutoring Experts

When a company becomes bigger, more customers might come for the services. There will be a higher number of borrowers and lenders. To handle such a big amount of data in a manual process is time consuming and will not work properly. For such cases a spreadsheet is not a good choice for the large data. There will be conflict in finding exact data in spreadsheets but while using a database it will be easy to find the data. Thus, it is more reliable to manage large data in databases. When there is a large amount of data it is not accurate in the spreadsheet. That means it takes more time to update the data in spreadsheets but it is easy to update large amounts of data in databases with different users. While there are chances of data duplication in spreadsheets. The users in the spreadsheet cannot work together with the same data at the same time because of this there is always a higher chance of data duplication and deleting of data. Security is one of the major issues in spreadsheets. Anyone can easily access, delete and update the saved data in a spreadsheet. But in the database there is security for the data, where users can set privileges for accessing, deleting and updating the saved data in the database. To avoid such a scenario from the company the management must replace their data entry system to database management system.

 

Academic Assistance for Database Design  

E-R Diagram

An Entity Relationship (ER) diagram is a type of diagram that exemplifies how “entities” relate to each other within a system. ER diagrams are most frequently used to design or debug relational databases in the fields of business information systems, education, research and in many other fields. The entity can be people, objects or concepts which directly relate to each other.

The Butler financing Company who runs the mortgage brokerage business whose job is to provide services to their borrower and lenders. In the given business scenario of the company the main entity of the system can be considered as borrower, lender and property appraiser. Within this entity its attributes are also identified. For the borrower entity, borrower number, first name, last name, current address and requested mortgage amount can be examined as its attributes. Here the borrower number has a unique number that clearly identifies the borrower’s first name, last name, current and the requested mortgage amount when we search for the borrower number. It applies to lenders and the property appraiser also where they also have the unique lender number and property appraiser that will show us the list of lenders with its name, office address and which property appraiser is chosen by the borrower. In the lender entity it has lender name, lender office address which are its attributes. As well as property appraiser number and name are the attributes. The ER diagram shows the relationship between the borrower and lender is many to many, that means one borrower can borrow money from one or more than one lender same as one lender can lend money to one or more than one borrower. The same relationship is applied to lenders and property appraisers also. The following diagram shows the relationship between borrower, lender and property appraiser.