Page 93 - iPro_trackGPT_V5_Class7
P. 93

SDG Activity




                    Create a database to manage and track students’ health records and
                    vaccinations.

                    •   Include tables for Students (Name, Age, Health Issues), Vaccinations
                      (Student ID, Vaccine Name, Date Administered), and Appointments
                      (Student ID, Appointment Date, Doctor’s Name).
                    •  Link Students with Vaccinations and Appointments.

                    •  Enter and update health records and appointment details.
                    •  Create reports on vaccination status and health records.






                     Digital Drills                                               #Digital Literacy
                                                                                  #Creativity & Innovativeness

                   Create a table using Design View and perform the following:
                                                       Employee Details
                    Employee code          Name          Date of Birth        Mobile              City
                         ES023        Mukund Mehta         28/02/96         987689XXXX           Delhi
                         ES450        Reena Aggarwal       16/04/98         956865XXXX          Mumbai
                         ES456        Priya Sharma         15/05/87         887557XXXX           Agra
                         ES867        Sushant Garg         20/06/88         787677XXXX        Hyderabad
                         ES672        Prem Gupta           25/11/95         981729XXXX           Delhi
                         ES222        Lovely Arora         30/01/91         912747XXXX          Panipat
                         ES098        Manya Bhasin         01/03/90         957293XXXX         Gurugram
                         ES560        Tanish Mehra         07/08/94         918394XXXX          Mumbai
                   •  Add 2 more records of new employees
                   •  Set Employee code as Primary Key
                   •  Sort the data in ascending order of DOB.
                   •  Delete the record for Employee – Sushant Garg






                 Teachers' Turf

                 1.  Discuss the different relational database management systems such as MS SQL Server and Oracle.
                 2.  Explain the concept of different types of keys, such as composite key and foreign key.
                 3.  Discuss the procedure to create a database by using the built-in templates.











                                                                          Database and DBMS—An  Introduction     91
   88   89   90   91   92   93   94   95   96   97   98