Exam Details
| Subject | database management | |
| Paper | ||
| Exam / Course | mba | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | April, 2016 | |
| City, State | gujarat, ahmedabad |
Question Paper
Page 1 of 1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA SEMESTER 3 • EXAMINATION • WINTER • 2016
Subject Code: 2830401 Date: 03/01/2017
Subject Name: Database Management
Time: 02:30 pm 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.
Q.1
What is three-schema architecture for database development? Discuss the difference between user views, a conceptual schema, and an internal schema as different views of the same database.
07
Explain data, information and metadata with examples.
07
Q.2
Differentiate between attribute, entity and entity instance. Explain the different types of attributes with examples.
07
Discuss the COMMIT and ROLLBACK command in SQL with examples.
07
OR
Explain DDL, DML and DCL in detail.
07
Q.3
Discuss different types of databases and parameters affecting their implementation.
07
What are the special guidelines for naming relationships?
07
OR
Q.3
Explain Attribute inheritance in detail and also discuss Generalization Specialization rule.
07
What is client/server architecture? List major advantages of the three-tier architecture compared to other approaches.
07
Q.4
Define join. Explain in brief the various types of joins.
07
Explain cardinality constraints. List different types of cardinality constraints, and draw an example of each.
07
OR
Q.4
Discuss degree of relationships. Explain Unary, Binary and Ternary relationships in detail.
07
What is the difference between base table and virtual table? Discuss pros and cons of using dynamic views.
07
Q.5
Briefly describe problems that often arise in merging relation and common techniques for addressing those problems.
07
Explain relational database management system and also discuss the advantages gained by the adoption of the standardized relational language.
07
OR
Q.5
Define Referential Integrity Constraints. Explain Insert, Delete, Update anomalies with example.
07
Compare SDLC with RAD and Agile software development approach.
07
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA SEMESTER 3 • EXAMINATION • WINTER • 2016
Subject Code: 2830401 Date: 03/01/2017
Subject Name: Database Management
Time: 02:30 pm 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.
Q.1
What is three-schema architecture for database development? Discuss the difference between user views, a conceptual schema, and an internal schema as different views of the same database.
07
Explain data, information and metadata with examples.
07
Q.2
Differentiate between attribute, entity and entity instance. Explain the different types of attributes with examples.
07
Discuss the COMMIT and ROLLBACK command in SQL with examples.
07
OR
Explain DDL, DML and DCL in detail.
07
Q.3
Discuss different types of databases and parameters affecting their implementation.
07
What are the special guidelines for naming relationships?
07
OR
Q.3
Explain Attribute inheritance in detail and also discuss Generalization Specialization rule.
07
What is client/server architecture? List major advantages of the three-tier architecture compared to other approaches.
07
Q.4
Define join. Explain in brief the various types of joins.
07
Explain cardinality constraints. List different types of cardinality constraints, and draw an example of each.
07
OR
Q.4
Discuss degree of relationships. Explain Unary, Binary and Ternary relationships in detail.
07
What is the difference between base table and virtual table? Discuss pros and cons of using dynamic views.
07
Q.5
Briefly describe problems that often arise in merging relation and common techniques for addressing those problems.
07
Explain relational database management system and also discuss the advantages gained by the adoption of the standardized relational language.
07
OR
Q.5
Define Referential Integrity Constraints. Explain Insert, Delete, Update anomalies with example.
07
Compare SDLC with RAD and Agile software development approach.
07
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)