BCSL-034 Solved Assignment 2021-22

BCSL-034 Solved Assignment 2021-22

To get the PDF click on the button below.

DBMS Lab (BCSL-034) 2021-2022 (July-January)

Note : This assignment has only one question. Answer the question. This question carries 40 marks. Rest 10 marks are for viva voce. You may use illustrations and diagrams to enhance the explanation. Please go through the guidelines regarding the assignments given in the programme guide for the format of presentation.

Question 1: ABC theatre requires a computerized system to streamline their manual operations. The objective of this project is to create a “Theatre Management System” that should automate and provide answers of different queries and generate reports related to theatre that were previously tedious and error prone. You are asked to create the database of ABC theatre in any RDBMS, which must provide the following functionalities: (40 Marks)

• Query support
• Report generation
• Easy input facility for new data
• Keep details about production costs, ticket sales etc
• Maintain necessary details about customer, staff, accommodation (seats), ticket, movies etc.

BCSL-034 Solved Assignment 2021-22

BCSL-034 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download 

After creating the database you must perform the following tasks:
i) Find out how many customers booked the tickets but did not come for watching movie in an year.

ii) Design a report to display different age-group of customer and type of movie (Action, Comedy etc) for which they are mostly coming.

iii) Find the name of attendant who was at duty in Hall_Number-3 (SPICE), 9-12 PM on 20-01-2021.

iv) Write a procedure/trigger on Hall_Number so such that the validity of the number is checked and the name of Hall is automatically displayed on selection of Hall_Number. Assume and create the necessary tables and constraints.

v) Display records where Ticket-Counter person has achieved sales more than average sales of all window persons of all the counters in ABC theatre.

vi) Display all records of staff members where name starts with ‘S’.

vii) Find out the names of top ten movies that gained maximum number of customers in a year.

viii) Design a report to display the history sheet of movies at the end of month contains:

• Number of people watched the movies (day by day record)
• Total cost of movie including purchase cost, display cost, staff cost, Miscellaneous.
• Total profit/loss

Note: You must perform the above said activities and also take prints of screenshots of the layouts, sample input and output along with the necessary documentation for this practical question. Assumptions can be made wherever necessary.

BCSL-034 Solved Assignment 2021-22

BCSL-034 Solved Assignment 2021-22

IGNOU BCA 3rd Sem Solved Assignment 2021-22

IGNOU BCA 3rd Sem Assignment 2021-22 Question PDF Download