What Is A Data Base?

A database is a structural set of related data that is organized in such a way that the information can be easily managed, accessed, and updated. The purpose of a database is to replace paper documents, files, and filing cabinets. The data collected in databases is an efficient way to store, retrieve, and analyze the information.

Databases today are essential to every business. Whenever you visit a major Web site – Google, Yahoo!, Amazon.com, or thousands of smaller sites that provide information – there is a database behind the scenes serving up the information you request (Hector, Ullman, & Widom 2008). Database systems are becoming as common in the workplace as the essential one that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user.

A collection of programs that manages the database structure and controls access to the data stored in the database.

A Table is where you are organised and store data so you have to create the table before store any data. By creating table, you need to define few things, Fields name, Data type, and the Description.

Database plays a major role in any organization. As a Database administrator(DBA) he/she is responsible in developing, implementing and maintaining the databases and DBA 's are also responsible in updating, backup 's and security of the databases. The first Database Management System was developed in the late 1960 's by two firms based on their network data model but in the early 1970’s a scientist of IBM introduced Relational database theory after six years IBM completed prototype on RDBMS (relational database management system). Oracle created the first versatile Relational Database Management Systems In 1983, which allowed organizations to use their DBMS on different machines including mainframes, workstations, and Pc 's. In 1993 Microsoft first created a database application called Access for Macintosh machines. Microsoft SQL server is a RDBMS which is used to store and retrieve the data by other software applications. There are 12 types of servers concentrated on various types of user 's from single computer to large networks (Microsoft SQL DBA).

The data that is being stored in a database is known as Meta data. Meta data is also recognized as schema for the real world data. It expresses that what sort of data will be stored in the database, what will be size of a assured attribute of the real world data, how many and what qualities will be used to collect the data about the entity in the database.

I am utilizing the Relational Database in my proposal. According to Murthy, data in a relational database, is mainly represented in tables and is considered to be an assortment of relations. A relational database is similar to a spreadsheet, in that a relational database organizes data in tables. The table is then made up of rows and columns. A row is also known as a record or tuple, and a column is also known as called a field or attribute. Using a relational database allows me to efficiently store huge amount of data, and effectively retrieve selected data. Tables in the relational database are distinguished by a primary key, which confirms that “no

Since 1960 and beyond the need for an efficient data management and retrieval of data has always been an issue due to the growing need in business and academia. To resolve these issues a number of databases models have been created. Relational databases allow data storage, retrieval and manipulation using a standard Structured Query Language (SQL). Until now, relational databases were an optimal enterprise storage choice. However, with an increase in growth of stored and analyzed data, relational databases have displayed a variety of limitations. The limitations of scalability, storage and efficiency of queries due to the large volumes of data [1] [2].

A database is a collection of data that is organized and is supposed to be organized in such a way that it resembles reality. An example is finding the amount of room on a flight, so you find one with a spare seat available. Databases are supposed to be organized in a way where in the end the users and stake holders that may not have the same knowledge of a database as you, can easily read and

Attributes are used inside a table to display which ones linked to the primary key for instance if the customer ID was a primary key the one of the attributes could be customer name or in relation to sports type of sport.

Database A database is an organised body of related files and or information. It is simply an automated library system an is maintained as an integral part of most organisations worldwide. A cite on the World Wide Web, the Webopedia Computer Dictionary, refers to the database as a collection of information organized and presented to serve a specific purpose. (A telephone book is a common database.)

While designing and defining tables in databases, it is important to find out the data type for each column in the data tables. A data type is an attribute which defines the type of data an object can retain: integer, string, data and time, etc. There are basically three main types: text, numbers and date/times. The data types are different, depending on the database management system (DBMS), the various types of which include SQL Server, Oracle and MySQL.

Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.

Microsoft Access is a database engine and development environment in one package. It is typically workstation-based, and designed to be easy to use, even for users

This database is the basis for all actions in the system and can be trivially updated and used to aid in all of the system’s processes, meaning all of the required information is stored in one central location and thus is easily accessible. This is a far more reasonable storage method than a paper-based file system, where the time of traveling to and physically searching the records for the required information could be a burden. Human error could also be a factor in that mistakes could be made in the filing process which would not occur in a well written database system and mistakes or changes on physical records can be messy to