(i) Write the degree and cardinality of the above table. -Technology

(i) Write the degree and cardinality of the above table. -Technology
by

1 Answer

Answer :

(i) The degree is 6 and cardinality is 5.(ii)+------------+|max(DOJ)|+------------+|1998-02-21|+------------+(iii) Delete from Customer_Details where Accumlt_Amt is NULL;
by

Related questions

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity

Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity

Last Answer : B) Degree

The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Last Answer : B) Cardinality, Degree

Write difference between cardinality and modaling.

Description : Write difference between cardinality and modaling.

Last Answer : Cardinality Modality Cardinality defines the range of object-to object Relationships Modality indicates whether or not a relationship between objects is mandatory Expected ... maximum numbers occurrences in relationship It gives minimum numbers occurrences in relationship

What is the cardinality of a set which contains sets within it?

Description : What is the cardinality of a set which contains sets within it?

Last Answer : Its been a little while but I think each set is 1 item. So in your case the cardinality is 5. (Someone correct me if I’m wrong).

In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Last Answer : (A) Number of tuples

Based on the cardinality ratio and participation ............... associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. (A) Entity (B) Constraints (C) Rules (D) Keys

Description : Based on the cardinality ratio and participation ............... associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. (A) Entity (B) Constraints (C) Rules (D) Keys

Last Answer : (B) Constraints

Write the relationship between a database and a table. -Technology

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Write down the steps to insert a new row into the table. -Technology

Description : Write down the steps to insert a new row into the table. -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3 When you have finished adding records in the datasheet, save it and close it.

Write HTML code to display a table with border of 5px. -Technology

Description : Write HTML code to display a table with border of 5px. -Technology

Last Answer : l2 „

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

Write an HTML code to create the following table: 100 Amit 10 A -Technology

Description : Write an HTML code to create the following table: 100 Amit 10 A -Technology

Last Answer : The HTML code is Roll NumberNameClass 100 Amit 10 A 101 Ankit 10 B 102 Arnab 10C Footer 1 Footer 2 Footer 3

Observe the following table and write the HTML code to generate it: Question Marks -Technology

Description : Observe the following table and write the HTML code to generate it: Question Marks -Technology

Last Answer : The HTML code isquestion< /th >marksl225

Observe the following table and write the HTML code to generate it: Period 1 Period 2 -Technology

Description : Observe the following table and write the HTML code to generate it: Period 1 Period 2 -Technology

Last Answer : The HTML code isPeriodlPeriod2 MathScienceEnglishSST Science< /td >SST

Write the HTML code to generate the following table with the contents exactly in the same format as shown within the table: -Technology

Description : Write the HTML code to generate the following table with the contents exactly in the same format as shown within the table: -Technology

Last Answer : The HTML code is

Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Last Answer : The HTML code is

Write the complete <TABLE>…</TABLE> tags to create a table with the following contents. -Technology

Description : Write the complete … tags to create a table with the following contents. -Technology

Last Answer :

Observe the following table and write the HTML code to generate it: Activities -Technology

Description : Observe the following table and write the HTML code to generate it: Activities -Technology

Last Answer : HTML code is: Acdvities Sr School Maths Club Robotics Club Photography Middle School Gymnastic Yoga Computer Club Primary School Dance Vocal Music Swimming

Write an HTML code to print the following table: -Technology

Description : Write an HTML code to print the following table: -Technology

Last Answer :

Observe the following table and write the HTML code to generate it : -Technology

Description : Observe the following table and write the HTML code to generate it : -Technology

Last Answer : GenerateHTML code

Write any two attributes for each tag: (a) <img> (b) <Table> (c) <A> -Technology

Description : Write any two attributes for each tag: (a) (b) (c) -Technology

Last Answer : img tag-src, alt, height, widthtable tag - align, bgcolor, border, cellpadding, cellspacinga tag -href, name

Write HTML code to display the following table : -Technology

Description : Write HTML code to display the following table : -Technology

Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Description : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Description : How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Last Answer : Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information

A table named School (containing data of students of the whole school) is created -Technology

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Distinguish between a record and a field in a table, with an example. -Technology

Description : Distinguish between a record and a field in a table, with an example. -Technology

Last Answer : Distinguish between a record and a field in a table are as follows:RecordFieldIt is a collection of data items, which represent a complete unit of information about a thing or a person.It is an ... called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.

Consider the following table: Employee EmpNo EmpName Designation -Technology

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

Data is stored in RDBMS in the form of (a) table (b) query -Technology

Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology

Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.

Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

Table is also known as ………… . -Technology

Description : Table is also known as ………… . -Technology

Last Answer : Table is also known asrelation.

A field in a table is also called as ………………… . -Technology

Description : A field in a table is also called as ………………… . -Technology

Last Answer : A field in a table is also called ascolumn.

………….. is the smallest part of a table in which one data item can be kept. -Technology

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

A foreign key is a reference of the ………….. key in another table. -Technology

Description : A foreign key is a reference of the ………….. key in another table. -Technology

Last Answer : A foreign key is a reference of the primary keyin another table.

A relationship cannot be created with the help of a table. -Technology

Description : A relationship cannot be created with the help of a table. -Technology

Last Answer : False A relationship is a connection between two tables of data.

A database can have only one table. -Technology

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

A table can have multiple primary keys. -Technology

Description : A table can have multiple primary keys. -Technology

Last Answer : False If we create multiple primary keys in a table, the primary key will be unable to find the unique key value.

A foreign key is a primary key in another table. -Technology

Description : A foreign key is a primary key in another table. -Technology

Last Answer : True When a table’s primary key field is added to a related table in order to create the common field which relates two tables, it is called a foreign key in the related table.