TechOnespot

 Class 11th Chapter :- 10 Working with table Primary key The table which contains primary key is known as master table. Foreign key It can be defined as field or combination of fields whose values are borrowed from another table. Foreign key field cannot contain a value that does not exist in its related primary key field. Conceptually there can be three major types of relationship between any tables of the database. • One to One • One to Many Many to Many Base has very important and interesting feature called Field Properties. Field properties determine how the values in the field are stored and displayed. Default value: Many times it may happen, that we want to store some predefined default value automatically in a particular field at the time of entering a new record in the table.  Choose the most appropriate option from those given below : (1) Which of the following operations cannot be performed on a record in database? (a) Insert (b) Delete (c) Hide (d) Update (2) Which of the fo