Exam Details
| Subject | relational database management system (rdbms) | |
| Paper | ||
| Exam / Course | mba | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | December, 2018 | |
| City, State | gujarat, ahmedabad |
Question Paper
1 P a g e
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA SEMESTER 3 EXAMINATION WINTER 2018
Subject Code: 3539251 Date:07/12/2018
Subject Name: Relational Database Management System (RDBMS)
Time: 10:30 AM To 01:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
1
Answer the following questions.
A. Database
B. Meta data
C. Entity
D. Attribute
E. Cardinality
F. SQL
G. DML
14
2
Explain disadvantages of conventional file based system over DBMS.
7
Explain the database architecture with necessary examples.
7
OR
Explain various components of database management system.
7
3
Explain Hierarchical database model with proper example.
7
Explain various keys available in ER diagram.
7
OR
Explain Normalization process with suitable examples.
7
Explain Logical database model with example.
7
4
Explain Codd's rule with proper examples.
7
Explain relational data structure with consideration of Employee database of any organization.
7
OR
4
Explain decomposition with proper example.
7
2 P a g e
What is DML? Explain various commands available under DML with suitable examples.
7
5
Homefab is one of the leading furniture showrooms in Ahmedabad. They have their own designing workshop for different furniture requirements. Now owner Mr. Virendra wants to digitalize all the available database of sales people, employee, customer, product line, vendor list details of raw material.
Using this information create ER diagram for Homefab furniture.
14
OR
5
For the above case, write various SQL database definition commands
7
For the above case, write various SQL transactional control commands.
7
Best of Luck
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA SEMESTER 3 EXAMINATION WINTER 2018
Subject Code: 3539251 Date:07/12/2018
Subject Name: Relational Database Management System (RDBMS)
Time: 10:30 AM To 01:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
1
Answer the following questions.
A. Database
B. Meta data
C. Entity
D. Attribute
E. Cardinality
F. SQL
G. DML
14
2
Explain disadvantages of conventional file based system over DBMS.
7
Explain the database architecture with necessary examples.
7
OR
Explain various components of database management system.
7
3
Explain Hierarchical database model with proper example.
7
Explain various keys available in ER diagram.
7
OR
Explain Normalization process with suitable examples.
7
Explain Logical database model with example.
7
4
Explain Codd's rule with proper examples.
7
Explain relational data structure with consideration of Employee database of any organization.
7
OR
4
Explain decomposition with proper example.
7
2 P a g e
What is DML? Explain various commands available under DML with suitable examples.
7
5
Homefab is one of the leading furniture showrooms in Ahmedabad. They have their own designing workshop for different furniture requirements. Now owner Mr. Virendra wants to digitalize all the available database of sales people, employee, customer, product line, vendor list details of raw material.
Using this information create ER diagram for Homefab furniture.
14
OR
5
For the above case, write various SQL database definition commands
7
For the above case, write various SQL transactional control commands.
7
Best of Luck
Other Question Papers
Subjects
- accounting for managers
- accounting for managers (afm)
- advance marketing management
- applied pharmaceutics
- b2b marketing
- banking and insurance
- banking and insurance -ii
- brand marketing
- business analytics (ba)
- business communication
- business english (be)
- business environment
- business ethics
- business ethics and corporate governance (becg)
- business law for managers
- business mathematics
- business process reengineering
- business process reengineering (bpr)
- business statistics
- business statistics (bs)
- business structure and management
- business structure and process
- change management & organization development
- change management and organizational development
- company law
- compensation management
- computer applications
- constitution of india
- consumer behavior (cb)
- consumer behaviour
- cooperative management
- corporate accounting (ca)
- corporate restructuring
- corporate tax planning
- corporate taxation (ct)
- corporate taxation and financial planning (ct & fp)
- cost & management accounting (cma)
- cost and management accounting
- counseling skills for managers
- creativity and innovation
- creativity, incubation and innovation (cii)
- cross continent business philosophy
- cyber security and it governance (csitg)
- database management
- designing of operations system (dos)
- development of human skills
- digital marketing
- e-commerce
- ecological management & business
- economics for managers (efm)
- effective communication skills
- elements of direct & indirect taxes
- elements of financial accounting
- english language
- enterprise resource planning
- entrepreneurial finance (ef)
- entrepreneurship
- environment for business
- environment management
- export – import policy, procedure documentation
- export-import policy procedures & documentation
- export-import procedures
- family business management
- financial accounting
- financial management
- financial planning
- foreign exchange management
- foreign language-french
- french (foreign language)
- fundamentals of information technology
- fundamentals of marketing (fom)
- gandhian philosophy for managing business (gpmb)
- german (foreign language)
- global human resource management (ghrm)
- healthcare and hospital management
- human resource development
- human resource management
- human resource management.
- human skills
- human values & business ethics (hvbe)
- import export procedures
- income tax (it)
- indian economy
- indian ethos & human quality development
- information system audit and control
- information systems
- information technology and global business
- integrated marketing communication
- integrated marketing communication (imc)
- intellectual property rights
- international accounting practice
- international business
- international business (ib)
- international commercial law (icl)
- international economic environment (iee)
- international economics (ie)
- international finance
- international financial management (ifm)
- international human resource management
- international human resource management (ihrm)
- international marketing
- international supply chain management
- inventory management, material planning and management
- inventory management, materials planning and management
- investment banking (ib)
- labor law
- leadership
- legal aspects business
- legal aspects of business
- legal aspects of business (lab)
- macro economics (me)
- management accounting
- management control system
- management control systems
- management information system
- management of cooperatives
- management of financial planning (mfp)
- management of financial services (mfs)
- management of industrial relation and labour law
- management of industrial relations and labour laws (mir & ll)
- management principles
- managerial communication
- managerial communication (mc)
- managerial economics
- managerial economics(me)
- managing digital innovation and transformation (mdit)
- marketing management
- marketing research (mr)
- material management
- mergers and acquisitions
- micro economics
- micro small and medium enterprise
- multicultural organizational behavior (mob)
- new entrepreneurship & innovation management
- new venture creation
- operation management
- organisational dynamics
- organizational behavior
- organizational behaviour
- performance management (pm)
- principles of management (pm)
- product & brand management (pbm)
- product and brand management
- product design and development
- production & operations management (pom)
- production and operations management
- production management
- project management
- project management for entrepreneurs
- public relation management
- quantitative analysis - ii
- quantitative analysis (qa)
- quantitative analysis-i
- relational database management system (rdbms)
- research methodology
- research methodology (rm)
- retailing - ii
- retailing and franchising (rf)
- risk management
- rural marketing
- sales & distribution management
- sales and distribution management (sdm)
- security analysis & portfolio management
- security analysis & portfolio management (sapm)
- service marketing
- services and relationship marketing (srm)
- social entrepreneurship
- social media analytics (sma)
- strategic financial management
- strategic financial management (sfm)
- strategic human resource management
- strategic information technology management
- strategic management
- supply chain & logistics management
- supply chain and logistics management
- supply chain management
- supply chain management (scm)
- system analysis and design
- system analysis and design(sa&d)
- talent management
- technology and business
- technology management
- total quality management and world class manufacturing excellence (tqmwcme)
- tourism and hospitality management (thm)
- wto multilateral trading system and it’s impact on business
- wto multilateral trading system and its impact on business(wmts-i)