Exam Details
| Subject | system management | |
| Paper | ||
| Exam / Course | mba | |
| Department | ||
| Organization | solapur university | |
| Position | ||
| Exam Date | May, 2017 | |
| City, State | maharashtra, solapur |
Question Paper
M.B.A. (Semester IV) Examination, 2017
RELATIONAL DATABASE MANAGEMENT SYSTEM
Group D System Management (Paper III)
Day and Date Monday, 22-5-2017 Total Marks 70
Time 10.30 a.m. to 1.30 p.m.
Note Question No. 1 is compulsory.
Solve any two questions from and any two from 7.
All questions carry equal marks (14 marks).
1. Case Study
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. 8
Write SQL commands to insert data in each of the entity. 6
2. Answer any two of the following 14
Compare between Relational and Hierarchical Database Systems.
Discuss the advantages and disadvantages of Normalization.
Explain the components of entity relationship diagram.
3. Answer any two of the following 14
Discuss JOINS in database.
Differentiate between functions and stored procedures in RDBMS.
Write a note on Queries and Sub-queries.
4. Answer in brief on any two of the following 14
Discuss different operators in databases.
Discuss SELECT statement with various clauses in detail.
Write note on the role of Data Base Administrator.
5. Discuss Codds rules with respect to RDBMS. 14
6. Discuss various SQL Command types with Syntax of various statements. 14
7. Discuss the basic data types and operators in RDBMS. 14
RELATIONAL DATABASE MANAGEMENT SYSTEM
Group D System Management (Paper III)
Day and Date Monday, 22-5-2017 Total Marks 70
Time 10.30 a.m. to 1.30 p.m.
Note Question No. 1 is compulsory.
Solve any two questions from and any two from 7.
All questions carry equal marks (14 marks).
1. Case Study
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. 8
Write SQL commands to insert data in each of the entity. 6
2. Answer any two of the following 14
Compare between Relational and Hierarchical Database Systems.
Discuss the advantages and disadvantages of Normalization.
Explain the components of entity relationship diagram.
3. Answer any two of the following 14
Discuss JOINS in database.
Differentiate between functions and stored procedures in RDBMS.
Write a note on Queries and Sub-queries.
4. Answer in brief on any two of the following 14
Discuss different operators in databases.
Discuss SELECT statement with various clauses in detail.
Write note on the role of Data Base Administrator.
5. Discuss Codds rules with respect to RDBMS. 14
6. Discuss various SQL Command types with Syntax of various statements. 14
7. Discuss the basic data types and operators 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