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

