relational database management system

solapur university

Exam Details

Subject relational database management system
Paper
Exam / Course mba
Department
Organization solapur university
Position
Exam Date 30, November, 2018
City, State maharashtra, solapur


Question Paper

M.B.A. (Semester IV) (CBCS) Examination, 2018
SYSTEM MANAGEMENT
Relational Database Management System
Group D (Paper III)
Day and Date Friday, 30-11-2018 Max. Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions Question No. 1 is compulsory.
Solve any two questions from 4 and any two from
6 and 7.
All questions carry equal marks indicated in the right side
of each question.
1. Solve the following 14
A general hospital consists of a number of specialized wards such as Maternity,
Pediatric, oncology, etc. Each ward hosts a number of patients, who were
admitted on the recommendation of their own General Practitioner and
confirmed by a consultant employed in the hospital. On admission, the personal
detail of every patient is recorded. A separate register is maintained to store
the information of tests undertaken and the prescribed treatment. A number
of tests may be conducted for each patient. Each patient is assigned to one
leading consultant. Doctors are specialist in some branch of medicine and may
be leading consultants for number of patients, not necessarily from the same
ward.
Identify various entities (at least in the database and their attributes.
Write SQL commands to insert data in each of the entity.
2. Answer any two of the following 14
Differentiate between Hierarchical and Network Models of Database.
Discuss SQL aggregate functions in RDBMS.
Discuss SELECT statement with various clauses in detail.
3. Write short notes on any two of the following 14
Role of Database administrator.
Object Oriented database.
'INSERT' statement of SQL.
4. Answer in brief on any two of the following 14
Explain entity relationship diagram and its use in RDBMS.
What is Normalization Explain types of normalization.
Discuss JOINS in database.
5. Discuss Codd's rules with respect to RDBMS. 14
6. Discuss Reports Writing and use of SQL in report writing. 14
7. Explain in detail functions and procedures in RDBMS. 14


Other Question Papers

Subjects

  • (paper – x) financial management
  • (paper – xi) human resource management
  • accounting for management
  • accounting for managers
  • agricultural marketing
  • agricultural production management
  • agro-processing industries and rural industrialization
  • banking and insurance (paper – xvi)
  • brand management and social marketing
  • busines ethics
  • business ethics (new) (cbcs)
  • business ethics (old)
  • corporate planning and strategic management (old)
  • corporate planning and strategic management(old cbcs)
  • day and date : friday, 30-11-2018 total
  • economic environment for business
  • entrepreneurship development and project management
  • excel
  • excellence in management
  • export policy, procedure and documents (paper – ii)
  • financial decision analysis
  • financial management
  • fundamentals of agriculture and co-operative management
  • fundamentals of agriculture and co-operative management (new cbcs)
  • global human resource management
  • group d – system management (paper – ii)
  • human resource initiatives (paper – ii)
  • human resource management
  • indian financial system
  • indian financial system (paper – xix)
  • industrial engineering
  • industrial relations and labour regulations
  • integrated marketing communication and consumer behaviour
  • international busines (paper – xiii)
  • international business environment (old)
  • international business environment (paper – i)
  • international finance
  • international financial system and markets
  • international financial systems and markets
  • international logistics
  • international marketing
  • international trade and agriculture
  • international trade procedures and documentation
  • international trade procedures and documentations
  • investment management
  • it for management
  • legal aspects of busines
  • legal aspects of business
  • logistics and supply chain management
  • logistics and supply chain management (paper – xx)
  • management accounting
  • management accounting (paper–xviii)
  • management acounting
  • management information system
  • managerial communication – i
  • managerial communication – ii
  • managerial economics
  • managerial excellence
  • marketing management
  • marketing management (cbcs)
  • operations management
  • organisational behaviour
  • organizational behaviour
  • paper – ix : marketing management
  • paper – xii : production and materials management (old)
  • paper – xiii : economic environment of busines
  • paper – xiv : managerial comunication – ii
  • paper – xv : research methodology
  • paper – xvi : event management(new)
  • paper – xvi : operations management
  • paper – xvii : strategic management
  • performance management and compensation
  • perspectives of management
  • principles of management
  • product and brand management
  • product and brand management (paper – i)
  • production and materials management
  • production management and operations research (paper – xii)
  • programing concepts and advanced
  • programming concepts and advanced excel
  • project planning and working capital management
  • purchasing and inventory management
  • purchasing and inventory management (paper – xix)
  • quality management
  • relational database management system
  • research methodology
  • research methodology (paper – xv)
  • retail and rural marketing
  • sales and distribution management (new) paper – xx
  • sales and strategic marketing
  • sales and strategic marketing (new cbcs)
  • sales and strategic marketing (old)
  • security and control information system
  • skill development (paper – xix)
  • statistical methods
  • statistics for management
  • strategic financial management
  • strategic financial management (paper – ii)
  • strategic human resource management
  • strategic human resource management (old)
  • strategic human resource management (paper – xix)
  • system management
  • system management security and control information system
  • systems management
  • systems management (paper – i)
  • systems management (paper – ii)
  • taxation
  • training and development
  • training and development gr.c : human resource management
  • world class manufacturing