Page 292 - IT-802_class_12
P. 292

PRODUCT: This table stores details of products available for shopping. It will store information such as product_id, name,
        price, quantity, brand, color, size, seller_id.
        Entities Involved

        Schema: PRODUCT (Product_id, Pname, Price, Qty, Brand, Colour, Size, Seller_id)
        (The column name underlined is the primary key).


                       Name             Datatype                           Remarks
                  Product_id       Int(10)            Product number which will identify it (Primary Key)

                  Pname            Varachar(50)       Product Name

                  Price            Number (10,2)      Price of the Product

                  Qty              Int (10)           Quantity of items left in Stock

                  Brand            Varchar(50)        Item’s brand name
                  Colour           Varchar(50)        Item’s colour

                  Size             Number(10,2)       Item’s size

                  Seller_id        Int(10)            Id of the seller selling the item

        In an application, you will have to create various tables like SELLER, BRAND DETAILS, CATEGORY etc. Developing a schema
        like the one given above will help you have clarity of thought and develop the layout of your database.



             Recap Zone


           Ð Ð  Since database management systems provide efficient data storage and fast retrieval, they find applications in a variety of fields.
           Ð Ð  Database application is used in education to keep data such as student information, grades, timetable and results.
           Ð Ð  Database application is used in banking to keep track of consumer data. For instance, Customer personal information like
             residence, age, gender, PAN card, occupation, and contact information will be collected.
           Ð Ð  Database application is used in to store information about guests, their check-in and check-out times, duration of stay and room
             number allocated.



        Solved Exercise



                                                        Section A
                                                 (Objective Type Questions)
        A.  Choose the correct option.
           1.  Which of the following is/are the applications of database in education?
             i.  To maintain details on transactions that happens everyday.
             ii.  To keep track of online and offline reservations.
             iii. To keep data such as student information, grades, timetable and results.
             iv. None of these

           2.  Which of the following is a payment method in online shopping?
             i.  Net banking                                    ii.  Credit card
             iii. Cash on delivery                              iv.  All of these

          290   Touchpad Information Technology-XII
   287   288   289   290   291   292   293   294   295   296   297