answersLogoWhite

0

Check this link

http://www.caspur.it/risorse/softappl/doc/sas_docs/proc/z10ntax.htm

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Educational Theory

Major components of DBMS?

major components of database management system are as follow. 1) Software. 2) Hardware. 3) Data. 4) Procedure. 5) Access language. Software: software plays an important role in the DBMS.


What is the difference between controlled redundancy and uncontrolled redundancy?

Controlled redundancy refers to intentionally duplicating certain components in a system to ensure reliability and fault tolerance, whereas uncontrolled redundancy occurs unintentionally due to inefficient processes or lack of coordination. Controlled redundancy is planned and managed to enhance system performance, while uncontrolled redundancy can lead to inefficiencies and waste of resources.


What is Data redundancy in DBMS?

In database we store data however the can be redundant. Redundancy means repetitive data that is taking extra storage space . So to reduce or prevent the storage space we should eliminate redundancy or just reduce it.


Discuss the main categories of data models?

Conceptual(high-level, semantic ) data models: Provide concepts that are close to the way many user perceive data. Physical(low -level, internal) data models: Provide concepts that describe details of how data is stored in the computer. Implementation(representational) data models: Provide concepts that fall between the above two, used by many commercial DBMS Implementation.


Explain the concept of Relational Model with a real time example of a University System?

The fundamental assumption of the relational model is that all data is represented as mathematical n-ary relations, an n-ary relation being a subset of the Cartesian product of n domains. In the mathematical model, reasoning about such data is done in two-valued predicate logic, meaning there are two possible evaluations for each proposition: either true or false (and in particular no third value such as unknown, or not applicable, either of which are often associated with the concept of NULL). Some think two-valued logic is an important part of the relational model, while others think a system that uses a form of three-valued logic can still be considered relational.[citation needed][who?] Data are operated upon by means of a relational calculus or relational algebra, these being equivalent in expressive power. The relational model of data permits the database designer to create a consistent, logical representation of information. Consistency is achieved by including declared constraints in the database design, which is usually referred to as the logical schema. The theory includes a process of database normalization whereby a design with certain desirable properties can be selected from a set of logically equivalent alternatives. The access plans and other implementation and operation details are handled by the DBMS engine, and are not reflected in the logical model. This contrasts with common practice for SQL DBMSs in which performance tuning often requires changes to the logical model. The basic relational building block is the domain or data type, usually abbreviated nowadays to type. A tuple is an unordered set of attribute values. An attribute is an ordered pair of attribute name and type name. An attribute value is a specific valid value for the type of the attribute. This can be either a scalar value or a more complex type. A relation consists of a heading and a body. A heading is a set of attributes. A body (of an n-ary relation) is a set of n-tuples. The heading of the relation is also the heading of each of its tuples. A relation is defined as a set of n-tuples. In both mathematics and the relational database model, a set is an unordered collection of items, although some DBMSs impose an order to their data. In mathematics, a tuple has an order, and allows for duplication. E.F. Codd originally defined tuples using this mathematical definition. Later, it was one of E.F. Codd's great insights that using attribute names instead of an ordering would be so much more convenient (in general) in a computer language based on relations. This insight is still being used today. Though the concept has changed, the name "tuple" has not. An immediate and important consequence of this distinguishing feature is that in the relational model the Cartesian product becomes commutative. A table is an accepted visual representation of a relation; a tuple is similar to the concept of row, but note that in the database language SQL the columns and the rows of a table are ordered. A relvar is a named variable of some specific relation type, to which at all times some relation of that type is assigned, though the relation may contain zero tuples. The basic principle of the relational model is the Information Principle: all information is represented by data values in relations. In accordance with this Principle, a relational database is a set of relvars and the result of every query is presented as a relation. The consistency of a relational database is enforced, not by rules built into the applications that use it, but rather by constraints, declared as part of the logical schema and enforced by the DBMS for all applications. In general, constraints are expressed using relational comparison operators, of which just one, "is subset of" (⊆), is theoretically sufficient. In practice, several useful shorthands are expected to be available, of which the most important are candidate key (really, superkey) and foreign key constraints.

Related Questions

What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


What are three types of dbms?

Hierarchical DBMSNetwork DBMSRelational DBMS


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What are the importance of dbms in industrial environment?

importance of DBMS


What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.


When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.


What is the use of dbms?

DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)


What is DBMS?

DBMS is short for database management system . DBMS is the collection of related records.


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.


How do you start and finish a transaction in DBMS?

How do you start and finish a transaction in DBMS?