Object Oriented Programming

Question

Can I get the Java Singleton Pattern Code for the following Problem Statement:

Assuming Database is not providing Referential Integrity Constraints support i-e Primary key, foreign key and Unique key, your task is to design a database engine with your own built in Referential integrity rules implementation and you need that only one database connection is maintained which an application should access.

Answer 1

Meta data file contains the following records:

Table name

Primary key names

# of records

Size of each record

Last auto increment values

Uupon addition of new records , checks for uniqueness amongst the primary keys