0
Wiki User
∙ 15y ago
Wiki User
∙ 11y agoA database is a set of data, which may either be a simple table of values (much like an array), or a more complex series of tables that form relationships with one another (like a hierarchy of objects).
A database value is simply a record, much like a C-style structure that has one or more data members. A data member may contain a value (a number, string or other object), or it may refer to a record within another related table. For instance, a list of names and address may be split into two tables, one for the addresses, the other for the people who live at those addresses. Thus a husband and wife, for instance, will typically share the same address, thus avoiding the need to enter the same address twice. The name table simply refers to the appropriate record in the address table.
Databases can also include queries or scripts -- small programs -- that aid in both locating subsets of the data and in producing reports. SQL (pronounced sequel), is the most popular database system, and the name is derived from the Structured Query Language that empowers the database.
Databases also include security protocols that permit or deny access to both users and to external programs, including other databases, as well as provide a suite of system tools that allow, amongst other things, to backup and restore data, and to check data in and out of the database when multiple users need to modify that data (thus preventing two users modifying the same data at the same time).
Databases may also include user-friendly interfaces, however (access permitting) external programs can be used to make use of the data (as variables for instance) or to generate scripts that require more complex processing than that provided by the built-in database scripts alone, or indeed to provide a complete interface to the data.
Add your answer:
Earn +20 pts
Which type of data is used to explain a relationship?
A foreign key constraint is used to represent a relationship in a RDBMS (relational database management system).
What is database design?
Design of the database (Database Design) refers to a given application environment, optimize the structure of the database, the database and applications, which can efficiently store data to meet the application needs of various user information needs and processing requirements). At www. myelibrary.net.In you can clearly understand what is the database design.
Why is a table created in database?
Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.Tables are central to a database. A table stores the data. Everything else in the database, such as queries, forms and reports, use the data from the table. Without tables, a database is useless as it would have no data.
What is the use of JDBC?
JDBC stands for Java Database connectivity which is a standard java API for database. It is for database connectivity with project.
Explain how atomicity durability is implemented in DBMS using shadow copy scheme?
The recovery-management component of a database system can support atomicity and durability by a variety of schemes. We first consider a simple, but extremely inefficient, scheme called the shadow copy scheme. This scheme, which is based on making copies of the database, called shadow copies, assumes that only one transaction is active at a time. The scheme also assumes that the database is simply a file on disk. A pointer called db-pointer is maintained on disk; it points to the current copy of the database. In the shadow-copy scheme, a transaction that wants to update the database first creates a complete copy of the database. All updates are done on the new database copy, leaving the original copy, the shadow copy, untouched. If at any point the transaction has to be aborted, the system merely deletes the new copy. The old copy of the database has not been affected. If the transaction completes, it is committed as follows. First, the operating system is asked to make sure that all pages of the new copy of the database have been written out to disk. (Unix systems use the flush command for this purpose.) After the operating system has written all the pages to disk, the database system updates the pointer db-pointer to point to the new copy of the database; the new copy then becomes the current copy of the database. The old copy of the database is then deleted.
Explain architecture of Distributed Database systems Also explain the reasons for building distributed database systems?
1 Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?
What are the characteristics of database?
chandranana explain the characteristic of database?
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
Explain how a database makes paying for a product online possible?
explain how database makes paying for products on the internet possible?
Database Design?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
Enumerate the database management object and explain?
i dont know the ans.
Difference between database and relational database explain with example?
Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.
Where can one find a web-based database?
One can find a web-based database online on a few different websites. These sites explain in more detail the extent of this database and its function.
Explain the Purpose of the employee history card and leave card?
maintaining database.
Explain 2 advantages of a paper based database?
that it is cheap and use eaisly
How do you explain in detail the role of dba also explain oracle tools available?
The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance.The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements.
