Top » Catalog » IMT-CDL-Old »


IMT-37: Data Base Management System-MT1

IMT-37: Data Base Management System-MT1

















Q1. Classify various database models used in database programming. Explain ER model in detail.

Q2. Explain how various normalization rules helps in removing redundancy from a database design. Differentiate between 3rd and BCNF rules.

Q3. How the implementation and design of object oriented database systems is different from non object oriented database systems.

Q4. Explain how data retrieval can be improved using Table Indexes and Table partitioning.

Q5. Name and explain various Database schema object.




Q1. How the problems of transaction failures can be checked using Redo Log files? Also explain the significance of Commit and Rollback statements.

Q2. Explain how the architecture of Distributed database management system is different from client server architecture.

Q3. What do you understand by Oracle Instance? Explain oracle memory structure in reference to all processes in Oracle instance.

Q4. Explain Oracle database schema in reference to Physical and Logical layer. Also explain relationship between tablespaces and data files.

Q5. Explain the role of Oracle Enterprise Manager in configuring and managing Oracle database.




Q1. What is the role of init.ora file in Oracle database? Explain various parameters in init.ora file.

Q2. What is the role of database triggers? Explain various different types of triggers including instead of triggers.

Q3. Explain the role of SYS and SYSTEM User ID in Oracle database. What all privileges are given to new user created in Oracle. Give supporting SQL command.

Q4. Explain Oracle database schema in reference to Physical and Logical layer. Also explain relationship between tablespaces and data files.

Q5. Explain the role of Oracle Enterprise Manager in configuring and managing Oracle database.



A$100 million chain of general stores is struggling to implement information system. Due to lack of proper information system, the store management is unable to maintain the daily records of customers, products sold, and there is a total confusion on reports like demand and supply of products in various retail outlets, etc leading to a poor supply chain management. The basic requirement of the information system is to manage data for customers, products, demand and supply records in particular retail outlets, quantity supplied and available, payments made by customers, etc. That is to develop a small supply chain management system.




1. Suggest the database design for above system with ER model using UML notations.





A big manufacturing industry in consumer goods located in different countries is facing huge loses due tomismanaged data. Existing system is not capable enough to tackle the integration of various key departments like: stores, shop floor, plant maintenance, manufacturing, quality, sales and distribution, etc. One department is not in a position to know the status of process and items available in other. E.g. sales department while bidding for the orders, can not calculate the existing capacity, product balance in warehouse, etc. Management want to integrate at least purchase, manufacturing and sales department of the organization to start with.



1. Purpose process flow of purchase, manufacturing and sales departments.


Quick Find
Use keywords to find the product you are looking for.
Advanced Search
1 x IMT-59: Financial Management-MT1
1 x IMT-63: Group Dynamics & Managing Change-MT1
1 x IMT-00: Computer in Management CAM-MT1
1 x IMT-24: Quantitative Techniques-MT1
1 x IMT-10: Business Communication-MT1
1 x IMT-57: Financial Accounting-MT2
1 x IMT-13: Management Union Relations-MT2
1 x IMT-70: Marketing of Service Industries-MT2
1 x IMT-12: Human Resource Management-MT1
1 x IMT-54: Business Law-MT3
1 x IMT-12: Human Resource Management-MT3
1 x IMT-50: Consumer Behavior-MT1
1 x IMT-81: Retail Management-MT1
1 x IMT-36: Java Programming-MT1
1 x IMT-68: Labor Law-MT1
1 x IMT-100: Software Project Management-MT1
1 x IMT-93: Different Types of Attacks-MT1
1 x IMT-81: Retail Management-MT2
1 x NLU-06: IT Act and Internet Governance-MT1-14
1 x IMT-77: E-Business-2016
1 x IMT-17: International Marketing-2014
1 x IMT-62: Strategic HRD-2014
1 x IMT-70: Marketing Of Service Industry-2014
1 x IMT-74: Managing Human Resource in Global Environment-2014
1 x IMT-15: Production and Operations Management-2014
1 x IMT-13: Management Union Relation-2014
1 x IMT-86: International financial management-2014
1 x IMT-01: Management Process and Organization-2014
1 x IMT-36: Java Programming-2014
1 x IMT-101: Networking and Telecom Management-16
1 x IMT-12: Human Resource Management-2014
1 x IMT-57: Financial Accounting-2014
1 x IMT-98: System Forensics-2014
1 x IMT-75: Brand Management-2014
1 x IMT-20: Managerial Economics-2014
1 x IMT-139-Enterprise Response Planning-16
1 x IMT-63: Group Dynamics and Managing Change-2014
1 x IMT-24: Quantitative Technique-2014
1 x IMT-40: Marketing management-2014
1 x IMT-54: Business Law-2014
1 x IMT-14: Organization Structure and Behaviour-2014
1 x NLU-08: CyberCrimesComputerForensicsAndDigitalEvidence-14
1 x IMT-31: Web Technology-2014
1 x IMT-60: Training And Development-2014
1 x IMT-102: Database Adminitration-2014
1 x IMT-58: Management Accounting-2014
1 x IMT-72: Rural Marketing-2014
1 x CAM-Computer Aided Management-2014
1 x IMT-95: Security Solutions-2014
1 x IMT-41: Indian Financial Services-2014
1 x IMT-92: Network Security-2014
1 x IMT-49: Business Ethics-2014
1 x IMT-93: Different Types of Attacks-2014
1 x IMT-18: Export Finance and Documentation-2014
1 x IMT-96: Software Hacking-2014
1 x IMT-48: DOT Net Programming-2014
1 x NLU-07: Informational Technology Management-14
1 x IMT-65: MIS-Management Information Systems-2014
1 x NLU-03: Intellectual Property Rights in Digital Environment-I-14
1 x IMT-10: Business Communication-2014
1 x IMT-97: Mobile Platforms Security-2014
1 x IMT-94: Network Security Threats Attacks and Loopholes-2014
1 x IMT-05: Advertisement and Sales Promotion-2014
1 x IMT-09: Security Analysis and Portfolio Management-2014
1 x IMT-91: Basics of Security-2014
1 x IMT-100: Software Project Management-2014
1 x IMT-61: Corporate Finance-2014
1 x IMT-11: Managing People-2014
1 x IMT-59: Financial Management-2014
1 x IMT-16: International Trade-2014
1 x IMT-07: Working Capital Management-2014
1 x NLU-04: E-Banking n Electronic Payment System-14
1 x NLU-05: Intellectual Property Rights in Digital Environment-II-M
Share Product

osCommerce Online Merchant Copyright © 2010 osCommerce
osCommerce provides no warranty and is redistributable under the GNU General Public License
Note: We provide all Solutions and Contents for Reference/Study purpose only.