Exam Details
| Subject | database management | |
| Paper | ||
| Exam / Course | mba | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | January, 2019 | |
| City, State | gujarat, ahmedabad |
Question Paper
Seat No.
Enrollment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA (Integrated)- SEMESTER 2 EXAMINATION WINTER 2018
Subject Code: 2527107 Date: 01/01/2019
Subject Name: Database Management System
Time: 02:30 PM To 05:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q1
What do you mean by Database? What is the Importance of a Firm Database in an Organization?
Explain the Following:
Data Information Data Management
Q2
How the Databases are Organized in the Organizations? State its types along with suitable examples
Which are the Components of Database? Explain Any Five of your Choice
OR
What is RDBMS? What is the Structure of Relational Data?
Q3
How the Database Architecture affects Data Independence? Explain with Examples both the Concepts
Which are the Database Languages? How the Database Designs and Database Constraints does matters while adopting the Database in your organization?
OR
Q3
Define the Following:
1. Functional Dependencies
2. Decomposition
3. Normalization
4. Public Key
5. Private Key
6. Denormalization
7. Candidate Key
Give a Practical Example of 1NF
Q4
Explain with Diagrams:
Conceptual Data Model
Logical Data Model
Physical Data Model
Write a Note on: Database Relationships. Also Explain all Models with Charts and Diagrams of 5 Customers
OR
Q4
What is SQL? What are Various Features of SQL?
Give a Practical Example of 2NF
Q5
Explain the Following with Diagrams:
Hierarchical Model
Relational Model
Network Model
Draw an E R Model as per following:
There are 500 Students in IIM Ahmedabad Pursuing various Courses like 100 in Marketing, 150 in Human Resources and rest in Finance Streams
OR
Q5
What are the Integrity Constraints and Pitfalls in RDBMS?
Draw an E R Model as per following:
There are 1000 Employees in a Chocolate Manufacturing Co. 10% works in Marketing Department, 20% works in Finance, 25% works in Human Resources Department and the rest of them works in Production Department
Enrollment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA (Integrated)- SEMESTER 2 EXAMINATION WINTER 2018
Subject Code: 2527107 Date: 01/01/2019
Subject Name: Database Management System
Time: 02:30 PM To 05:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q1
What do you mean by Database? What is the Importance of a Firm Database in an Organization?
Explain the Following:
Data Information Data Management
Q2
How the Databases are Organized in the Organizations? State its types along with suitable examples
Which are the Components of Database? Explain Any Five of your Choice
OR
What is RDBMS? What is the Structure of Relational Data?
Q3
How the Database Architecture affects Data Independence? Explain with Examples both the Concepts
Which are the Database Languages? How the Database Designs and Database Constraints does matters while adopting the Database in your organization?
OR
Q3
Define the Following:
1. Functional Dependencies
2. Decomposition
3. Normalization
4. Public Key
5. Private Key
6. Denormalization
7. Candidate Key
Give a Practical Example of 1NF
Q4
Explain with Diagrams:
Conceptual Data Model
Logical Data Model
Physical Data Model
Write a Note on: Database Relationships. Also Explain all Models with Charts and Diagrams of 5 Customers
OR
Q4
What is SQL? What are Various Features of SQL?
Give a Practical Example of 2NF
Q5
Explain the Following with Diagrams:
Hierarchical Model
Relational Model
Network Model
Draw an E R Model as per following:
There are 500 Students in IIM Ahmedabad Pursuing various Courses like 100 in Marketing, 150 in Human Resources and rest in Finance Streams
OR
Q5
What are the Integrity Constraints and Pitfalls in RDBMS?
Draw an E R Model as per following:
There are 1000 Employees in a Chocolate Manufacturing Co. 10% works in Marketing Department, 20% works in Finance, 25% works in Human Resources Department and the rest of them works in Production Department
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)