Define the term tuple and domain.

Define the term tuple and domain.
by

1 Answer

Answer :

tuple: A row is called a Tuple.

domain:A domain is a set of all possible (or permissible) values in an attribute.

OR 

A Domain is defined as a kind of data represented by an attribute.
by

Related questions

Define Domain and Attribute.

Description : Define Domain and Attribute. 

Last Answer : * Domain: All permissible values of attributes are called as a domain. * Attribute: is a property or characteristics of an entity set. 

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Description : How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Last Answer : The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE.

A set of possible data values is called (A) attribute. (B) degree. (C) tuple. (D) domain.

Description : A set of possible data values is called (A) attribute. (B) degree. (C) tuple. (D) domain.

Last Answer : D) domain.

Explain Domain constraints with Syntax and example.

Description : Explain Domain constraints with Syntax and example. 

Last Answer : Domain constraints are used to maintain value according to user specification Domain constraints are: 1. Not null-such constraints are applied to an attribute when we have to specify that the ... datatype(size),attr2 datatype(size) constraint nameofconstraint check(attr<value)); or

Define the term Foreign Key.

Description : Define the term Foreign Key. 

Last Answer : A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It ... between tables because it references the primary key of another table, thereby establishing a link between them.

Define the term Data Model.

Description : Define the term Data Model.

Last Answer : Underlying structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. Data models define how data is connected to each other and how they are processed and stored inside the system.

Define the term Database Schema

Description : Define the term Database Schema

Last Answer : The overall design of the database is called the database schema. A schema diagram displays only names of record types (entities) and names of data items (attributes) and does not show the relationships among the various files. 

Define database model.

Description : Define database model. 

Last Answer : Definition of database model: A database model is a type of data model that determines the logical structure of a database. It also fundamentally determines in which manner data can be stored, organized and manipulated. 

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

Define Constraint.

Description : Define Constraint. 

Last Answer : Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in ... are applied only to one column, whereas the table level constraints are applied to the whole table. 

Define Normalization, list its types.

Description : Define Normalization, list its types.

Last Answer : Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that ... data from the relation tables. Types of Normalization are: 1NF,2NF,3NF,4NF,5NF

Define Data and instance.

Description : Define Data and instance.

Last Answer : Data: Data can be defined as facts or information that can be recorded and have an implicit meaning.  Instance: The collection of information stored in the database at a particular moment is called an instance of the database.

Define constraints, list types.

Description : Define constraints, list types.

Last Answer : Constraints are used to limit the type of data that can go into a table. Constraints are used to ensure accuracy and consistency of data in a relational database.  Types of Constraints : ... Constraint 3.UNIQUE Constraint 4.CHECK Constraint 5.Primary Key Constraint 6. Foreign Key Constraint

Define primary key and candidate key.

Description : Define primary key and candidate key.

Last Answer : Primary Key: A primary key is an attribute in Relation that uniquely identifies the rows in relation. A Primary key does not hold NULL values and duplicate values.  OR A key which is selected by the ... , Name) can be a candidate key if and only if Name and Rollno individually are not unique. 

Define (i) Data Abstraction, (ii) Data Redundancy.

Description : Define (i) Data Abstraction, (ii) Data Redundancy.

Last Answer : Data abstraction is defined as  *Suppression of details of data organization and storage  *Highlighting of the essential features for an improved understanding of data  *The characteristic that allow ... of data abstraction. This level describes the user interaction with database system. 

How do you pronounce 'tuple' ?

Description : How do you pronounce 'tuple' ?

Last Answer : Never heard of it. A real word?

How to fix - TypeError: 'tuple' object does not support item assignment -Web-Development

Description : How to fix - TypeError: 'tuple' object does not support item assignment -Web-Development

Last Answer : answer:

Python : How to add a new item to the tuple -Web-Development

Description : Python : How to add a new item to the tuple -Web-Development

Last Answer : answer:

Covert the output of Zip() from tuple to list in Python -Web-Development

Description : Covert the output of Zip() from tuple to list in Python -Web-Development

Last Answer : answer:

not tuple -Web-Development

Description : not tuple -Web-Development

Last Answer : answer:

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Description : A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Last Answer : both (a)and (b)

A tuple is 1) - 1) Column of a Table 2) Two dimensional Table 3) Row of a Table 4) key of a Table

Description : A tuple is 1) - 1) Column of a Table 2) Two dimensional Table 3) Row of a Table 4) key of a Table

Last Answer : 3) Row of a Table

A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. A) First B) Second C) Third D) Fourth

Description : A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. A) First B) Second C) Third D) Fourth

Last Answer : C) Third

In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

Description : In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

Last Answer : B) Domains

The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.

Description : The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.

Last Answer : (A) tuple

A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Description : A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Last Answer : C) a tuple

Is the following piece of code valid? >>> a=(1,2,3,4) >>> del a a) No because tuple is immutable b) Yes, first element in the tuple is deleted c) Yes, the entire tuple is deleted

Description : Is the following piece of code valid? >>> a=(1,2,3,4) >>> del a a) No because tuple is immutable b) Yes, first element in the tuple is deleted c) Yes, the entire tuple is deleted

Last Answer : c) Yes, the entire tuple is deleted

What is the output of the following code? >>> a=(1,2,3,4) >>> del(a[2]) a) Now, a=(1,2,4) b) Now, a=(1,3,4) c) Now a=(3,4) d) Error as tuple is immutable

Description : What is the output of the following code? >>> a=(1,2,3,4) >>> del(a[2]) a) Now, a=(1,2,4) b) Now, a=(1,3,4) c) Now a=(3,4) d) Error as tuple is immutable

Last Answer : d) Error as tuple is immutable

If a=(1,2,3,4), a[1:-1] is a) Error, tuple slicing doesn’t exist b) [2,3]. c) (2,3,4) d) (2,3)

Description : If a=(1,2,3,4), a[1:-1] is a) Error, tuple slicing doesn’t exist b) [2,3]. c) (2,3,4) d) (2,3)

Last Answer : d) (2,3)

What is the data type of (1)? a) Tuple b) Integer c) List d) Both tuple and integer

Description : What is the data type of (1)? a) Tuple b) Integer c) List d) Both tuple and integer

Last Answer : b) Integer

Which of the following is a Python tuple? a) [1, 2, 3]. b) (1, 2, 3) c) {1, 2, 3} d) {}

Description : Which of the following is a Python tuple? a) [1, 2, 3]. b) (1, 2, 3) c) {1, 2, 3} d) {}

Last Answer : b) (1, 2, 3)

Which of the following is a Python tuple? a) [1, 2, 3] b) (1, 2, 3) c) {1, 2, 3} d) {}

Description : Which of the following is a Python tuple? a) [1, 2, 3] b) (1, 2, 3) c) {1, 2, 3} d) {}

Last Answer : Answer: b Explanation: Tuples are represented with round brackets.

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

Define the term of Domain, codomain and range of a relation: -Maths 9th

Description : Define the term of Domain, codomain and range of a relation: -Maths 9th

Last Answer : Let R be a relation from set A to set B. Then, the set of first element of the ordered pairs in R is called the domain and the set of second elements of the ordered pairs in R is called the range. The second set B is called ... 16, 25, 36}, Range of R = {4, 5, 6} and Codomain of R = {1, 4, 5, 6}.

Explain various types of Relational constraints.

Description : Explain various types of Relational constraints.

Last Answer : Relational Constraints Relational constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other ... - It establishes parent child relationship between two tables. For example :Foreign key constraints 

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

Explain advantages of centralized and distributed databases.

Description : Explain advantages of centralized and distributed databases.

Last Answer : Advantage of Centralized databases   * Data integrity is maximized -Data integrity is maximized and data redundancy is minimized because data is stored at a single place.  * Easier Database Administration - ... data is distributed, a group of users can easily share and use data of different sites

Describe the three levels of data abstraction with diagram.

Description : Describe the three levels of data abstraction with diagram. 

Last Answer : Three levels of data abstraction are:  Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details ... highest level of data abstraction. This level describes the user interaction with database system.

Describe object-oriented data models.

Description : Describe object-oriented data models.

Last Answer : Object Oriented Model : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose ... with other objects. It is also said to be semantic data model.

Distinguish between file processing system and DBMS.

Description : Distinguish between file processing system and DBMS.

Last Answer : Database Management system File processing system 1. Presence of Self-describing nature of a database system and Metadata. 1. File processing don't contain any self describing feature and ... to use DBMS 5. Controlling Redundancy is one of most important feature to use DBMS

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Explain client/server database system.

Description : Explain client/server database system. 

Last Answer : 1. It has two logical parts client and server.  2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development ... as application server to receive and send requests from client machine to database server and vice versa.

Compare file system and database system.

Description : Compare file system and database system. 

Last Answer : File system Database system  1. File processing don't contain any self describing feature and neither posses metadata.  1. Presence of Self-describing nature of a database system and Metadata. ... own file.  5. Controlling Redundancy is one of most important feature to use DBMS

Describe enhanced ER model with the help of example.

Description : Describe enhanced ER model with the help of example. 

Last Answer : Enhanced ER is a high-level data model that incorporates the extensions to the original ER model. It is created to design more accurate database schemas. EER reflects data properties and constraints more precisely ... example: Square, Circle, Triangle are the sub class of Shape super class. 

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

List advantages of Normalization.

Description : List advantages of Normalization. 

Last Answer : List of Advantages of Normalization are the following: 1. More efficient data structure. 2. Avoid redundant fields or columns. 3. More flexible data structure i.e. we should be able to ... 7. Minimizes data duplication. 8. Close modeling of real world entities, processes and their relationships.