1. Question:What is datasheet view? 

    Answer
    Datasheet view is a window that displays data from a table or query in row and column format where you can edit fields, add, delete data as well as search for data.

    1. Report
  2. Question:What is a sub-form? 

    Answer
    A subform is a form contained within another form or a report. Th is feature is useful to represent one-to-many relationship between tables. In the form we can show the data of the Master table and at the same time in a second form we can show related data from the transaction table.

    1. Report
  3. Question:What do you mean by filter? 

    Answer
    Filter is the process of hiding all unnecessary records or displays only the records that satisfy the criteria specified.

    1. Report
  4. Question:What is Lookup Field? 

    Answer
    A Field that stores a list from an existing table or query or a fixed set of values that is looked up.

    1. Report
  5. Question:What are the three key components of relational database design? 

    Answer
    The three key components of relational database design are: entities, attributes and relationship.

    1. Report
  6. Question:Define entity. 

    Answer
    An entity defines any person such as student, teacher; place such as classroom, building; thing such as computer, lab equipment; concept such as course, attendance for which data will be collected.

    1. Report
  7. Question:What are attributes? 

    Answer
    Attributes are one of the building blocks of relational database design that define the additional characteristics or information for an entity.
    For example, name, gender, address, salary, years tenured can be the attributes of teacher entity.

    1. Report
  8. Question:Define relationship. 

    Answer
    A relationship is a logical linkage between two entities that describe how the entities are associated with each other.

    1. Report
  9. Question:How many relationships are possible between two tables or entities? 

    Answer
    There are three relationships possible between two tables namely: one-to-one, one-to-many, many-to-many.

    1. Report
  10. Question:What is cardinality? 

    Answer
    The most important classification of a relationship is called its cardinality. The cardinality of a relationship allows the database modeler to specify how instances of each entity relate to each other. The three major cardinalities are: one-to-one, one-to-many, many-to-many.

    1. Report
Copyright © 2024. Powered by Intellect Software Ltd