The Use of Databases Essay Example | Topics and Well Written Essays - 750 words

The Use of Databases - demonstrate ExampleWhile selecting a database for a sm all(prenominal) organization like real estate business, Microsoft glide path is the best. It gives an easy layout to design a database of our own, with wizard facility.In a small real estate business, tens of clients go out everyday and tell us about their requirements. Some needs to have house on allow and some wants to buy a house. Even few comes here to sell their house. So in beau monde to keep a record of all these, we need to have a Database. So that whenever a customer comes here to seek a house on rent, we locoweed show him/her a list that contains all the houses that we got. It can unless be done with the support of a Database. A Database can not only inclose the cultivation but it can give us the prin card form of the data as well in Reports.The first thing while develop a Database is that we created cards, as they actually store the data in them. But the interface is provided with the help of forms. And we can access the data in our Database with the help of Queries that works simply as question been asked.This Database contains a table of permanent customers that includes their names, with a unique ID, inter-group communication lens recite and address as well. The other table contains the list of houses that are available on rent. This table contains all the information about these houses, their size, location, number of rooms and the rent money as well. The other table contains the list of houses that are there to be sold. It in like manner contains all information about them, like size, location, number of rooms and their prices. Another table contains the list of customers that are involuntary to rent a house. This table contains their demands as well, that what kind of house they need and the location, size and number of rooms in it. The other table contains the customers elaborate that want to buy a house. And also their demands. The above mentioned both tables contains the contact number of customers as well, so that they can be contacted when needed. Another table deals with the employees of the regular. The firm has 10 employees working at present. Two employees are for office work and eight are the salesmen. The table contains their details, like their names with a unique ID, their addresses, contact numbers, date of joining the firm, starting salary, current salary, and also their account numbers.The computer operator in the firm uses Forms to register data in the database. Forms are the interface provided by the database so that data can be entered more conveniently. There is a main form, which gives the main menu, ask the operator whether he wants to enter employee information or customer information. In employee section he can enter the information for new employee or he can update the record of existing employee as well. In Customers section, he can enter the information about the customers who are looking for a hous e to rent and also those who are willing to give their houses on rent. And also the customers who want to buy a house and their demands as well and also the customers information who are looking for the buyer.Queries are used, so that we can quickly have the information for our call for house. Suppose a customer is looking for a house with three rooms in downtown, we can simply put the number of rooms a