Page 99 - TP_iPlus_V2.1_Class7
P. 99
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Consider the following table Student.
Field Name Data Type
Rollno
Admno
Name
Dateofbirth
Gender
Photograph
1. Suggest data types for all the fields
2. Which field will you choose as Primary Key – Rollno or Admno.
3. Which database object will you use to enter or update a record in a table that is connected to it.
#Experiential Learning
Let’s Explore
Surf the internet to find the difference between DBMS and RDBMS.
#Digital Literacy
#Creativity & Innovativeness
Practical Time
Create a table using the Design View.
Customer Data Type
Cust_id
Cust_name
Cust_add
Cust_mobile
1. Choose the appropriate data types for all the above mentioned fields.
2. Choose the primary key.
3. Insert three records.
Teacher’s Corner
1. Discuss real life scenarios where a DBMS is utilised.
2. Explain the concept of relationships in Microsoft Access.
3. Discuss the different data types available in Access. Also discuss the field properties of each.
97
Database and DBMS—An Introduction

