Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 73 - Modular_V2.0_SQL_Flipbook
P. 73

    Write the queries to create the suggested database and tables and write suitable queries to
                     perform the following operations:

                        Add and Update Items and Inventory: The shop can add new products to the system by entering
                       the details of new items and can even update the inventory and price details of existing items.

                        Enter sale of item: The shop can create sale record of items and simultaneously the quantity of
                       the item will be decremented. (Hint: Update sale and quantity simultaneously)

                        View sales made: The shop can view records of sold items.
                        View current inventory: The shop can view records of current inventory in stock.

                     Project 3                                                             21 st  Century   #Critical Thinking
                                                                                               Skills
                                                                                                   #Productivity & Accountability
                       Consider a student record, courses and enrollments system. It keeps track of all the students', their
                     courses and information about their respective teachers. Their enrollment details are also recorded.

                         Insert Information: Add 10 new enrollments and students' info in their respective tables.

                        Show Courses: Show the names of all the courses along with their teacher's names.
                         Find out: Find out the student count course wise.

                        Update: Update the course information as and when a new course is added.

                     Project 4                                                             21 st  Century   #Critical Thinking
                                                                                                   #Productivity & Accountability
                                                                                               Skills
                     Consider a Hotel management system. It allows the hotel management to add and update details
                     about rooms such as type of room, type of bed, tariff, occupancy status etc. It allows customers to
                     check in to rooms and vacate rooms as per fixed schedule.

                     Write the queries to create the suggested database with suitable tables and columns to perform
                     the following operations:

                        Add and Update Booking: Guest can make new bookings, and can also modify and cancel the
                       bookings. As per the booking, the rooms will be shown as booked on the specified dates. If the
                       booking is cancelled by the guest, the room will be freed.

                        Update Room features and tariff: Hotel management can update the tariff of the rooms, the
                       features of the rooms etc.

                        Room allocation: The management can allocate rooms to the guests as per availability.

                        Room release and Bill calculation: When the guest vacates a room, the room will be released
                       and an invoice will be created for the room charges.

                                                                                                                         71
                                                                                                           Project Work

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