0
What else can I help you with?
What is a term a developer uses for a record in a relational database?
A developer may refer to a record in a relational database as a "row" or a "tuple". This term is used to describe a single entry of data that contains information related to a specific entity in a database table.
How are schools using multimedia database?
The incorporation of multimedia database systems will improve the quantity and quality of information manipulated by computer users in all fields, computer aided design, and information retrieval. The area of intelligent multimedia content analysis and retrieval techniques is an emerging discipline. Techniques for representing and extracting semantic information from media such as speech, images, and video are required. When a multimedia application lacks a database, the data structure is buried in the script, where all of its value is lost. This omission also makes the script more complicated and less flexible. Using a multimedia database makes the data structure logic available to other multimedia applications and simplifies the script so that many scripts can share the same multimedia metadata. In addition, when a multimedia or abstract data database is organized and annotated for one application, other applications can use those annotations without going through the same time-consuming process. This capability adds great value to the data through reuse and controlled redundancy. When multimedia application content is controlled by the multimedia database, multimedia content can be added, deleted, or modified without modifying the application script. For example, interactive kiosks that display, describe, and demonstrate products can be updated automatically without reprogramming the application script. Furthermore, a multimedia application such as a multimedia textbook can actually control the operation of book topics that have the same look and feel. This control lets the script perform as a template: An entire series of math textbooks (algebra, calculus, trigonometry, and geometry), including text and video, can use the same multimedia application because all data is physically separate. Search and retrieval operations are critical in interactive multimedia applications; they must be equally efficient and powerful. Search and retrieval of multimedia and abstract data is challenging, but multimedia databases make it feasible through internal storage format flexibility and efficient operation. The DBMS should have significant knowledge about the data and its structure to enable powerful semantic optimizations and intelligent searches. Search and retrieval operations also give the application access to media components so that they can be dynamically and seamlessly processed when necessary. By: IBZ_BEAST
What is DBMS and is its function?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Discuss briefly about DBMS?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What are data models in dbms?
A data model is a collection of concepts that can be used to describe the structure of a database. Data models can be broadly distinguished into 3 main categories- 1)high-level or conceptual data models (based on entities & relationships) It provides concepts that are close to the way many users perceive data. 2)lowlevel or physical data models It provides concepts that describe the details of how data is stored in the computer. These concepts are meant for computer specialist, not for typical end users. 3)representational or implementation data models (record-based,object-oriented) It provide concepts that can be understood by end users. These hide some details of data storage but can be implemented on a computer system directly.
How would you describe a relational database?
Most modern databases are relational, meaning that data are stored in tables, consisting of rows and columns, and that data in different tables are related by the meanings of certain common columns.
Database management the origin and its growth in sql?
E. F. Codd introduced the term in his seminal paper "A Relational Model of Data for Large Shared Data Banks", published in 1970. In this paper and later papers he defined what he meant by relational. One well-known definition of what constitutes a relational database system is Codd's 12 rules. However, many of the early implementations of the relational model did not conform to all of Codd's rules, so the term gradually came to describe a broader class of database systems. Relational databases, as implemented in relational database management systems, have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data and much more. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use, even though they are much less efficient. As computer power has increased, the inefficiencies of relational databases, which made them impractical in earlier times, have been outweighed by their ease of use. However, relational databases have been challenged by Object Databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases. http://en.wikipedia.org/wiki/Relational_... http://en.wikipedia.org/wiki/Relational_...
What is a flat file database?
Flat file databases are also called as relational databases describe any different means to encode a database model. This requires data to be kept in one large table. Big up Philip Proctor
Describe basic operation of relational algebra?
CHUT
Describe three commonly used data models?
Enterprise data model, Relational model and ????
List and describe 3 Database Systems?
Analytical databaseThese databases store data and information extracted from selected operational and external databases. They consist of summarized data and information most needed by an organization's management and other end-users. Some people refer to analytical databases as multidimensional databases, management databases, or information databases.Operational databaseThese databases store detailed data needed to support the operations of an entire organization. They are also called subject-area databases (SADB), transaction databases, and production databases. For example:customer databasespersonal databasesinventory databasesDistributed databaseThese are databases of local work-groups and departments at regional offices, branch offices, manufacturing plants and other work sites. These databases can include segments of both common operational and common user databases, as well as data generated and used only at a user's own site.
Why relational algebra is a procedural query language?
The syntax of a query in relational algebra essentially describes the query evaluation algorithm i.e. SELECT WHERE FROM --------------- I don't agree with the above answer. Notice that 'SELECT WHERE FROM' is fragmentary SQL. It does not describe an algorithm, or procedure, for obtaining the desired results. Rather, it describes the characteristics of the desired results and where they might be obtained. In fact, relational algebra is not inherently procedural. It involves closed collections of objects called relations and a set of permitted operations on these objects. Please see the link.
Describe the operations functions and nature of the operations manager's job?
give me answer
What is relational death?
Relational death is a medical term used to describe the death of someone that had a certain disease or condition. It essentially means because of this illness, the doctors knew that death would happen eventually.
What are the main characteristics of a relational model?
The main characteristics of this "databases" is that the belief that what is mathematically elegant, is also the simplest and best. So the relational model is based on relational calculus, where you see the database as "relations" of tuples, where each tuple represent elements of data. You then go on and describe addition, subtraction (insert, delete), multiplication (join) and division (inner join) as operators on tuples, and projection as operators on elements. <p> This works fine, and a RDBM has to support integrity constraints that ensures that the mathematical properties are retained. If you do not like calculus, you can also describe the RDBMS with "relational algebra". A more pragmatic way of structuring data, that was intended to reflect the use of data can be found in the CODASYL DBTG proposal. Such databases will be vastly more efficient, there will be things you cannot do, whereas all can be done with a relational database - somehow.Note that a database as such is based on assumptions of support to retain consistency, data is supposed to never be lost, and when you make changes, you are able to "commit" them all because they are in the application logic defined so that it is not one, but all changes or none. If you do not manage to complete the application logic, every single trace of the changes is to be removed - "undone". A database shall also support multiple users at once, and see to that your changes are protected from others messing around with the data that you work on. This separate the various databases from using the plain file system. If you just make an application, the CODASYL database model will be much easier to work with, but when you later want to expand and add to the application, you will prefer to use the more general relational model, since this does not constrain you in any way.
Describe database normalization?
Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency
Name and describe types of database management system available in market?
Usually, "database management systems" are referred to Relational Database Management System. Types include: Microsoft SQL Server Oracle MySQL (along w/ a myriad of open source products) These differ from flat file databases such as FoxPro, MS Access, etc.
