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
   94   95   96   97   98   99   100   101   102   103   104