StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

The Use of Databases - Assignment Example

Cite this document
Summary
The paper “The Use of Databases” focuses on a logical collection of files. Instead of saving your data in different files, we can have a Database. Information can be stored in an organized way and can be accessed and shared easily. It had made transactions, indexing, aggregate, and table structure…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.1% of users find it useful
The Use of Databases
Read Text Preview

Extract of sample "The Use of Databases"

Download file to see previous pages

In a small real estate business, tens of customers visit every day and tell us about their requirements. Some need to have a house on rent and some want to buy a house. Even a few come here to sell their house. So in order 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 can show him/her a list that contains all the houses that we got. It can only be done with the help of a Database. A Database can not only store the information but it can give us the printable form of the data as well in Reports.

The first thing while developing a Database is that we created tables, 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 a question been asked. This database contains a table of permanent customers that includes their names, with a unique ID, contact number 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 also contains all the information about them, like size, location, number of rooms and their prices. Another table contains the list of customers that are willing to rent a house. This table contains their demands as well, that what kind of house they need and the location, size, and the number of rooms in it. The other table contains the customer's details that want to buy a house. And also their demands. The above mentioned both tables contain the contact number of customers as well so that they can be contacted when needed.

Another table deals with the employees of the firm. 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 enter data in the database. Forms are the interface provided by the database so that data can be entered more conveniently.

There is the main form, which gives the main menu, asks the operator whether he wants to enter employee information or customer information. In the employee section, he can enter the information for a new employee or he can update the record of existing employees as well. In the Customers section, he can enter the information about the customers who are looking for a house 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 customer's information who are looking for the buyer.

Queries are used so that we can quickly have the information for our required house. Suppose a customer is looking for a house with three rooms in downtown, we can simply put the number of rooms.

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(The Use of Databases Assignment Example | Topics and Well Written Essays - 750 words, n.d.)
The Use of Databases Assignment Example | Topics and Well Written Essays - 750 words. https://studentshare.org/information-technology/1524934-the-use-of-databases
(The Use of Databases Assignment Example | Topics and Well Written Essays - 750 Words)
The Use of Databases Assignment Example | Topics and Well Written Essays - 750 Words. https://studentshare.org/information-technology/1524934-the-use-of-databases.
“The Use of Databases Assignment Example | Topics and Well Written Essays - 750 Words”. https://studentshare.org/information-technology/1524934-the-use-of-databases.
  • Cited: 0 times

CHECK THESE SAMPLES OF The Use of Databases

Marketing-It's Popcorn Time

One of the aspects of this tool is The Use of Databases which gathers information about the demographics, past orders, and transaction history with the customer.... Through the internet, a company can also customize buyer experience through the use of value-adding features which can be manipulated by the customer.... The commercialization of internet together with the proliferation of dotcoms are just but few manifestations of how technology has driven the global business… It's Popcorn Time (IPT), just like any other company which have harnessed the potential of utilizing technological advancement in their operations, can also benefit from the employment of the internet technology, customer relationship management (CRM), and databases in 26 March 2007 It's Popcorn Time and Technology It is irrefutable that rapid technological advancements have provided numerous benefits to business organizations....
2 Pages (500 words) Essay

Databases, Search Engine, Research Resources, Refining Search Terms

In academic circles with the frequent need of large quantities of information The Use of Databases has become popular and can be seen in the linkage that they maintain with databases in addition to the libraries that they still maintain.... Through the Internet it is possible to get into the databases and access the information available at the databases.... Invariably the databases collect a membership fee NET Introduction: Securing information required for research purposes traditional involved securing them from hard copies located in Libraries or purchased from book shops....
2 Pages (500 words) Essay

How Are Databases Used in Organisations

In this paper, we shall focus on The Use of Databases in... Relational model follows a tabular database in which data is defined such that it can be reorganized and Another type of databases is distributed databases.... databases are divided into tables.... Each table has… Each table has a number of records. databases can be organized by different means.... These are databases which are scattered and stored over different systems on a network....
6 Pages (1500 words) Essay

Enterprise Resource Planning as a Modular Integrated Systems Strategy

Also, the use of one database allows for better organization of data.... In terms of component sharing modularity, these tools are designed to use the same battery pack between them and the drill head being switched for a sander is an example of component swapping modularity....
8 Pages (2000 words) Case Study

Job Selection Analysis

These resources include computers, access and security of the internet telephone system and other electronic functions that will be specified or as instructed by the… 900) The organization is an affiliate of the global network of scientific centers of excellence thus the atmosphere along with the colleagues will be multinational, highly motivating and provide exceptional opportunities for growth I am a y-rated computer and information systems professional with nine years of comprehensive knowledge in organization, maintenance, development and implementation of information systems along with software to assist firms to stay competitive through training staff, supervision of security operations and giving advice to management on the probable consequences of changes in technology, in addition to broad customer care experience in a fast-paced and highly technical environment....
8 Pages (2000 words) Essay

Blogs for innovation

In 2006, a Dutch couple, Asha D'Souza and Louk Vreeswijk whose home country is Geneva moved to Madhya Pradesh in India.... Asha being a sociologist, she had an international experience in the… On the other hand, Louk was an anthropologist as well as documentary film expert and had an interest in Indian culture, arts, and crafts....
4 Pages (1000 words) Essay

Web Technologies & Management Systems

This paper stresses that the widespread use of database management systems coupled with web technologies allows organizations to collect maintain and sell vast amounts of private personal data fast and cheaply.... Apart from the financial embezzlements retrieving of other valuable information which can be possibly used for any purpose are possible through the inappropriate use of credit cards.... hellip; According to the study, millions of personal data items are routed daily to corporate databases and data warehouses through sales calls and credit checks....
5 Pages (1250 words) Assignment

Web Site Privacy Policies and Procedures

Consumers fear credit card theft Apart from the above concerns, advances in internet technology for instance, The Use of Databases which stores information of every transaction captured in forms.... Cookies are other reasons to worry about internet use and privacy....
5 Pages (1250 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us