CBSE Class 7 Computer Science Database and DBMS Worksheet Set 01

Answer: 1. Open Microsoft Access.
2. Choose Blank database from the available templates.
3. Type a file name for the database in the File Name box.
4. Click Create. A new database opens with an empty table ready for use.

Teacher's Note:
1. Learn the steps in order because the exact button names are often asked.
2. Practise them on a computer to remember them better.

Answer: Microsoft Access is a Relational Database Management System (RDBMS) used to store, organise and retrieve data.
Features: 1. It is user-friendly and menu driven. 2. It suits small projects as well as large businesses. 3. It lets users create tables, queries, forms and reports. 4. It allows easy editing and maintenance of data.

Teacher's Note:
1. Access belongs to the Microsoft Office family of programs.
2. Mention at least three features in your answer.

Answer: A database is an organised collection of related information stored together so that it can be easily searched, updated and managed. A school's student records or a shop's list of products is an example.

Teacher's Note:
1. Remember the words organised and related.
2. Give a real-life example to make the answer complete.

Answer: A DBMS (Database Management System) is software that is used to create, store, manage and retrieve data in a database.
Advantages: 1. Data can be shared easily among many users. 2. Data can be searched and updated quickly. 3. Repetition of data is reduced. 4. Data is kept safe and accurate.

Teacher's Note:
1. DBMS is the software and the database is the data itself.
2. Learn the full form along with two or three advantages.

Answer: Examples are Microsoft Access, Microsoft SQL Server, MySQL, Oracle and PostgreSQL.

Teacher's Note:
1. Write the names carefully because they are proper nouns.
2. Access is the one used in school.

Answer: A table is an object that stores data in rows and columns. Each column is a field and each row is a record.
Common data types: Text, Number, Date/Time, Currency, Yes/No and AutoNumber.

Teacher's Note:
1. A table is the main building block of a database.
2. Match each field with the right data type, for example Number for marks.

Answer: 1. Open the database.
2. Click the Create tab and choose Table (or Table Design).
3. Enter the field names in the Field Name column.
4. Select a data type for every field.
5. Enter the data in the rows of the datasheet.

Teacher's Note:
1. Think of the steps as name the fields, set their types, then enter data.
2. Table Design view gives more control over data types.

Answer: 1. Click the Save button on the Quick Access Toolbar (or press Ctrl + S).
2. Type a name for the table in the Save As box.
3. Click OK.

Teacher's Note:
1. The same steps work in many other programs.
2. Give the table a meaningful name so that you can find it later.

Answer: True. Access stores data in related tables.

Teacher's Note:
1. Access is called relational because tables can be linked.
2. This is a basic fact to remember.

Answer: False. Access makes it easy to maintain and edit a database.

Teacher's Note:
1. Ease of use is one of its main features.
2. The word not makes the statement wrong.

Answer: True. This is the basic definition of a database.

Teacher's Note:
1. Related is the key word here.
2. Unrelated data kept together is not a database.

Answer: True. Each row holds the values of all fields for one item.

Teacher's Note:
1. One row means one record.
2. One column means one field.

Answer: True. It is a DBMS that serves database requests from clients.

Teacher's Note:
1. MySQL and Oracle are other examples.
2. SQL Server is a larger product than Access.

Answer: False. Easy sharing of data among users is one of the advantages of a DBMS.

Teacher's Note:
1. Sharing is a major benefit of a DBMS.
2. Check the advantages list again if you were unsure.

Answer: clients (users or other programs).

Teacher's Note:
1. A client sends a request and the server replies with data.
2. This is a common computer idea.

Answer: relational (RDBMS).

Teacher's Note:
1. The R in RDBMS stands for relational.
2. Relations here mean links between tables.

Answer: large businesses.

Teacher's Note:
1. Access is flexible in size.
2. It is not meant for very huge systems, though.

Answer: Microsoft Access (MySQL or Oracle are also correct).

Teacher's Note:
1. Any real DBMS name is acceptable.
2. Spell it correctly.

Answer: Database Management System.

Teacher's Note:
1. Learn full forms exactly as given.
2. Do not write Data Base in a different order.

Answer: An object is a part of a database that is used to store or work with data, such as a table, query, form or report.

Teacher's Note:
1. Access has several kinds of objects.
2. The table is the most important one.

Answer: A table is a database object that stores data in rows and columns about one subject, such as students or books.

Teacher's Note:
1. Compare it with a spreadsheet to understand it quickly.
2. Every database has at least one table.

Answer: A field is a column in a table that stores one kind of information, such as Name or Roll No.

Teacher's Note:
1. Each field has a name and a data type.
2. Fields are also called attributes.

Answer: A record is a row in a table that holds all the field values for one item, for example the details of one student.

Teacher's Note:
1. A table with 40 students has 40 records.
2. A record is made of many fields.