M/s ABC Ltd. is a consumer electronics item manufacturing company. The management of the company wants to use advanced IT system solution to enhance its presence in the market. Therefore the company hired a consultancy f

The DBMS (like Oracle, FoxPro, SQL Server etc.) should meet the following requirements: Provide data definition facilities: It should support Data Definition Language (DDL) and provides user accessible catalog Known as Data Dictionary. Provide facilities for storing, retrieving and updating data: It should support Data Manipulation Language (DML), so that required data can be inserted, updated, deleted and retrieved. Supports multiple view of data: The end user should have the facility of flexible query language so that required information can be accessed easily. Provides facilities for specifying Integrity constraints: It should support the constraints like Primary key, try to insert any incorrect information it should display the error message. Provide security of data: It should have the facilities for controlling access to data and prevent unauthorized access and update. Provide concurrency control mechanism: It should allow simultaneous access and update of data by multiple users. Support Transactions: It should support all the properties of transaction known as ACID properties. It means a sequence of operations to be performed as a whole. In other words all operations are performed or none. Provide facilities for database recovery: It should bring database back to consistent state after a failure such as disk failure, faulty program etc. Provide facilities for database maintenance: It should support maintenance operations like unload, reload, mass insertion, deletion and validation of data. Master and transaction file: A master file stores relatively static data. It changes occasionally and stores all the details of the object. Support ACID Properties: DBMS should follow the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as ACID) in order to ensure accuracy, completeness, and data integrity. These concepts are applied on transactions, which manipulate data in a database.