0
Simply put a computer database is an electronic filing and sorting system.
Decades ago the same functions were performed with Index Card systems.
A computer database consists of a structured file format into which an operator can input information.
The database structure consists of a number of set fields, a simple example would be something like:
Record#: [Discrete field]
Title:
Initial:
Family name:
Address:
City:
Postal/ Zip code:
Telephone number:
A number of fields is grouped into a record, one record containing all the information for one person, in most databases the records will be unique, meaning that no record is the same as another.
An additional record number field is normally added by the database system to the record, this is normally discrete and cannot be viewed by the operator.
When the database is being designed the programmer will specify what type of data is to be entered into a particular field: Character (or string), Numeric, Alphanumeric or "memo"; this practice enables sorting functions to be performed on the data, as well as ensuring that data is entered in a structured fashion.
In order to make use of the data within the system and make accessing the data faster a system of indexes or keys are employed. What this does is order the records in a particular fashion so that the data can be accessed and utilized by the operator. Indexes, Keys and Sorting is a whole book on its own - See some of the related links.
Once you have a number of records stored you can then sort, find records, modify and delete data.
For example if you had a large database of address data (like the example above), you could find and print the records of all the people with a particular Family name or print the records of all the people who live within the same Postal code/ ZIP code.
Databases are a huge part of our life. The page that you are currently viewing is built using a database which handles the questions and answers!
Wiki User
∙ 10y ago
A computer database is a structured collection of data that is organized and stored electronically. It allows for efficient storage, retrieval, and manipulation of data for various applications and purposes. Databases are commonly used in organizations to store and manage large volumes of information.
Add your answer:
Earn +20 pts
What is SGA in orcle?
SGA stands for System Global Area in Oracle. It is a shared memory region that contains data and control information for Oracle instance. SGA is divided into components such as buffer cache, shared pool, and redo log buffer, which are used to efficiently manage database operations and improve performance.
What are the main theories of a relational database approach to storing and accessing data?
The main theories of a relational database approach include the relational model, which organizes data into tables with rows and columns; normalization, which reduces data redundancy and improves data integrity; and SQL (Structured Query Language), which is used to interact with the database for querying and manipulation of data. These theories aim to ensure data consistency, provide flexibility in querying data, and allow for scalability in managing large volumes of data.
What is E-R model. What is an Entity set?
The E-R model is a data model used to describe the relationships between entities in a database. An Entity set is a collection of similar entities (objects) with shared attributes that are grouped together in the database.
Which fields are needed a school database?
A school database should include fields such as student information (e.g. name, grade level, contact details), teacher information (e.g. name, subject taught, contact details), class information (e.g. class name, schedule, teacher assigned), and grades or academic records. Additional fields may include attendance records, extracurricular activities, and disciplinary records.
Major components of DBMS?
The major components of a database management system (DBMS) include data definition, data manipulation, data integrity, and data security. Data definition involves defining the structure of the database and schema, data manipulation involves querying and modifying data, data integrity ensures the accuracy and consistency of data, and data security involves protecting the database from unauthorized access and ensuring data confidentiality.
What is the Difference between a database and a database server?
A database is a file. A database server is a computer that shares that file over a network.
What is the meaning of manual database?
A manual database is a data storage system where information is managed and organized using physical methods like paper files, folders, or index cards instead of digital tools or software. This type of database requires manual entry, storage, retrieval, and organization of data without the use of automated systems.
Is a computer that stores and provides access to a database?
Database Server
What computer stores and provides access to a database?
Database Server
What do you think a database is?
A database in computer terms is a system that organizes data. A database can have information about anything, ranging from music to different locations to travel.
How computer database saves papers?
because its a computer
What is a desktop database?
I assume it is a database used on a local desktop computer.
The meaning of a computer database?
Meaning of database is like some data that has been saved to a computer in some maybe documents
What is database and database system?
A database is essentially an organized collection of data, typically stored electronically on a computer system. Imagine a giant filing cabinet with information neatly sorted and filed away. That's kind of what a database is like, but way more efficient and powerful. Here's a breakdown of the key aspects: Organized Collection: Data isn't just dumped in a pile. It's structured in a specific way, often using tables with rows and columns, to make it easy to find and use the information you need. Electronic Storage: Most databases are digital these days, allowing for much faster access and manipulation of data compared to physical filing systems. Now, to manage this data effectively, you need a database management system (DBMS). Think of it as the filing cabinet manager. A DBMS is a software application that lets you: Interact with the Database: You can create databases, add, update, and delete data, and most importantly, retrieve information you need. Manage Data Structure: The DBMS defines how data is organized and ensures it stays consistent and usable. Control Access: The DBMS controls who can access the data and what they can do with it, keeping things secure. Some common examples of DBMS software include MySQL, Microsoft SQL Server, and Oracle Database. So, the database and DBMS work together to form a database system. The database stores the information, and the DBMS provides the tools to manage and access it effectively. This allows businesses and organizations to keep track of large amounts of data efficiently, from customer information to product inventory.
What is a computer based database?
urrrmmm
Is database hardware?
A database manager is a computer program (or programs) that manages database information. Most database programs can be purchased or obtained from many places and installed on a computer. That makes it software.If the database program is part of and supplied with the computer vendors system, than it is system software.It is possible to securely store the database program in a type of memory where its location is fixed and not changeable using normal programming methods. That would make it firmware.If the database software is implemented in the actual computer machinery and not changeable without replacing or changing computer components, it would be hardware.
Database projects for final year computer science?
cse projects based on database
