Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - 2629_Devagiri_C-8
P. 71

    See the following tables:

                                                                 Order Table
                                       Order_ID     Product_ID    Order_Quantity     Customer_Name
                                         O001          P101              2           Aarav Sharma

                                         O002          P102               1          Priya Patel
                                         O003          P101               1          Rahul Verma

                                         O004          P103              3           Sneha Iyer

                                                                Product Table
                                         Product_ID    Product_Name        Price     Stock_Quantity

                                            P101       Laptop             50000             20
                                            P102       Smartphone         25000             50

                                            P103       Headphones          1500            100
                                            P104       Mouse                800            200

                        Now, answer the following questions:
                        (a)  Name the primary key in the Product Table.

                        (b)  How many records or tuples exist in the Order Table.
                        (c)  Name the key that creates the relationship between the Order Table and the Product Table.

                            INTRODUCTION TO SQL

                     SQL stands for Structured Query Language. It is the standard language for managing relational
                     databases and performing various operations on the data in the tables. SQL enable us to store,
                     retrieve and manipulate data in the form of tables.

                                       High                                           Integrates
                          Easy to    Performance   Free of                Provides      with       Ensures     Enables
                           use         and         Cost        Offers       High      Various       Data      Multi-user
                                     Efficiency              Portability  Security    Platforms    Integrity   Access

                                                              Key Features of SQL

                      SQL was developed by IBM researchers Raymond Boyce and Donald Chamberlin in the 1970s.

                                                                                                                      69
                                                                                              MySQL: My First Database

| 66 67 68 69 70 71 72 73 74 75 76 |