A table ‘customer’ has 10 columns but no row. Later, 10 new rows are inserted and 3 rows are deleted in the table. What is the degree and cardinality of the table customer.
1 Answers
Talk Doctor Online in Bissoy App
What is the difference between ‘Rows’ and ‘Columns’ in a table?
Distinguish between data and information are as follows: Data Information It 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...
1 Answers 1 views
In a table, columns are called ………. and rows are called ………… .
In a table, columns are called fields and rows are called records.
1 Answers 1 views
When no object has been deleted, the desktop does not contain the Recycle Bin folder.
False The desktop always contains the Recycle Bin folder whether object has been deleted or not.
1 Answers 1 views
Write a code to create customer’s list with their number & name and delete any particular customer using his /her number.
customer=dict( ) n=input(” Enter total number of customers”) i=l while i<=n: a=raw_input(“enter customer name”) b=raw_input(“enter customer number”) customer[a]=b i=i+l name=raw_input(” enter customer name to delete”) del customer[name] l=customer.keys( ) print “Customer Information” print “Name”/\t’/’number” for i in 1: print i/\t’,customer[i] Output : Enter total number of...
1 Answers 3 views
Write a program to search input any customer name and display customer phone number if the customer name is exist in the list.
def printlist(s): i=0 for i in range(len(s)): print i,s[i] i = 0 phonenumbers = [‘9840012345’,‘9840011111’,’ 9845622222’,‘9850012345’,‘9884412345’] flag=0 number = raw_input(“Enter the phone number to be searched") number = number.strip() try: i = phonenumbers.index(number) if i >= 0: flag=1 except ValueError: pass if(flag <>0): print “\nphone number found...
1 Answers 25 views
A table ‘student’ has 3 columns and 10 rows and another table ‘student 2’ has the same columns as student but 15 rows.
Degree = 3 Cardinality = 30 (20 + 15 – 5)
1 Answers 1 views
A table ‘student’ has 4 columns and 10 rows and ‘student 2’ has 5 columns and 5 rows.
Degree = 4 x 5 = 20 [no. of columns] Cardinality = 10 x 5 = 50 [no. of rows]
1 Answers 1 views
Deepika wants to remove all rows from the table BANK. But he needs to maintain the structure of the table.
DELETE FROM BANK.
1 Answers 2 views
What are horizontal rows and vertical columns in a periodic table known as?
The horizontal rows are known as periods and vertical columns in the periodic table are known as groups
1 Answers 1 views
State, true or false. If false, give a reason. A column matrix has many columns and only one row.
False A column matrix has only one column and many rows.
1 Answers 1 views