Page 316 - IT_V1.0_Class10
P. 316

15.  Create the following table using the ‘Design View’.


                       Roll No.            Name           Date of Birth       Phone No.             Place
                         A001         Manan Gupta          12/09/1987         2354667667      Delhi
                         A002         Ryansh Sharma        09/05/1986         3435555555      Chattisgarh
                         A003         Rahul John           02/05/1990         6565544324      Mumbai


                  •  Sort the place in decreasing order.
                  •  Set Roll No. as the primary key.
                  •  Delete the record no. A002.

                  •  Add another record.
              16.  You are managing a school database that includes two main tables: Students and Classes.

                  Students Table
                       StudentID        StudentName         DateOfBirth           ClassID

                           1          Priya Sharma           2005-03-15             101
                           2          Rahul Kapoor           2004-07-22             102
                           3          Meena Patel            2005-11-10             101

                           4          Aisha Khan             2004-02-25             103
                           5          Dev Rai                2005-05-30             102

                  Classes Table

                        ClassID           ClassName         TeacherName
                          101         Mathematics         Mr. Prakash
                          102         Science             Ms. Yashika

                          103         History             Mrs. Seema

                  •  Set up a relationship between the Students table and the Classes table.
                  •   Create a query in Design View to list all students along with the class they are in and the teacher of that
                    class.

              17.  Create the following table for the Students’ Details:

                   StudentID       StudentName              Class             Section
                        1       Amit Kumar                    7                  C
                        2       Ria Aggarwal                  8                  A
                        3       Yash Yadav                    6                  D

                        4       Ananya Gupta                  8                  B
                        5       Praveen Seni                  7                  C

                  •  Create a form for the Students’ Details table.
                  •  Enter the following records through the form.

                    6 Gyan Shanker         8      B
                    7 Richa Sinha          6      A



                314     Information Technology Play (Ver 1.0)-X
   311   312   313   314   315   316   317   318   319   320   321