Sem: Dec-2024 Maximum Marks: 50 Examination: End Exam Date: Dec 8, 2024 Duration: 2.5hrs
Programme code: 18 Programme: MBA for Working Executive	Class: FY	Semester: III Batch- 2023-24
College: K. J. Somaiya Institute of Management	Name of the department/Section/Center: Data Science and Technology (DST)
Course Code:	Name of the Course: Database Concepts & Applications
Instructions: State your assumptions (if any) clearly

Question No.	Max. Marks
1	Draw ERD (List the Business rules/assumptions clearly – if any, Present the table structures demonstrating the following) A resort-park has number of location through the city. Each location has unique ID, address, description and maximum capacity. Each of the resort-park has different designated areas such as picnic spot, football field, Water Park etc. Each of the designated areas has area ID, a type, a description, a size. A location may have one or many resort-park. Each of the resort-park can organize multiple events. For each of the event, event ID, event name, description and designated area where the event is held is recorded. One event can be held across multiple areas. There are three different types of events: Sporting events, stage performance events and conferences. The resort-park rents some equipment to the visitors. There are three categories of equipment’s – Bike, Boats and Sports Kits All equipment are not rental equipment’s, some are used by the employees	[20]
2	Answer any THREE of the following ACID property Hierarchical and Network Model Explain the reason for adopting DBMS over conventional file management system Describe roles and responsibilities of DBA. Explain the factors that impact database performance	[15]
3	Design a form to collect details of the candidates applying for a particular certificate course. Normalize the tables required for recording the attributes. State rules clearly Explain the meaning of DDL and DML in SQL. Give examples of each	[10]

-x-x-x