Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 72 - Modular_V2.0_SQL_Flipbook
P. 72

    PROJECT WORK

                                                                                                        #Critical Thinking
                                                                                                21 st  Century   #Technology Literacy
                  Project 1                                                                         Skills  #Initiative

                  Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its Customers
                  and make their billing details. The table name and its structure are as follows:

                                Table Name-CUSTOMER                              Table Name-BILLDETAILS

                            Field Name             Data Type                 Field Name              DataType

                        Cust_id                Number[INTEGER]           Cust_id                Number[INTEGER]
                        C_name                 Text[VARCHAR]             Quotation              Number[INTEGER]

                        Add_1                  Text[VARCHAR]             Challan                Number[INTEGER]

                        State_id               Number[INTEGER]           Bill                   Number[INTEGER]

                        Phone                  Number[INTEGER]           Amount_billed          Number[INTEGER]

                        Mobile                 Number[INTEGER]           Amount_paid            Number[INTEGER]

                        Contact_person         Text[VARCHAR]
                        Credit_limit           Number[INTEGER]

                                                            Table Name-STATE
                                               Field Name                         Data Type

                                    State_id                           Number[INTEGER]
                                    State_name                         Text[VARCHAR]

                     Generate a query that will display the records of Customer Table along with State_name and
                     Billing details of the customer.
                     Update any Cust_id in CUSTOMER table and verify if the same gets updated in BILLDETAILS
                     table. Check and report.

                  Project 2                                                             21 st  Century   #Critical Thinking
                                                                                                #Productivity & Accountability
                                                                                            Skills
                    Consider a shop selling electronic items. It allows to add new products to the inventory and update

                  the inventory when new stock is added. It allows to search for the availability of a desired product.

                    70
                          Touchpad MODULAR (Ver. 2.0)

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