This is actually the very first time i'm dealing with the item oriented databases.I had been connected using the RDBMS for past couple of years. However.. visiting our planet of object oriented databaseS, I'm type of worried about the aftermaths from the creation or style of the db. My problem is the populace or Migration of the object oriented databases in the RDMS database. That's likely to be among my tasks.

I'm wondering what type of challenges must i be ready for the migration piece , when we're creating these databases.

Any inputs ??

Making this a real SQL database? I do not think the question has anything related to what many people will understand like a "Object Oriented" database.

It appears much like your database is useless within the form you published it. You can't place rows unless of course you remove or disable among the foreign key constraints - for the time being. One method to do that's to utilize a "deferable" constraint. However, it appears just like you might be using Microsoft SQL Server, which doesn't support deferable constraints.

I'm a approaching DBA, i'm not writing any java code, but.. you will find is really much inheritance happening, tight coupling between tables, as well as i'm able to give a good example, like

 CREATE TABLE [dbo].[A](
[application] [varchar](50) NULL,
[category] [varchar](50) NULL,
[corporateCode] [varchar](50) NULL,
[critical] [bit] NULL,
[initialCondition] [varchar](50) NULL,
[initialLossOfLife] [decimal](3, 2) NULL,
[installationDate] [date] NULL,
[lotNumber] [varchar](50) NULL,
    [BID] [int] NOT NULL,

  CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED 
 (
[AID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY =              OFF,           ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY]

GO

SET ANSI_PADDING OFF GO

  ALTER TABLE [dbo].[A]  WITH CHECK ADD  CONSTRAINT [FK_BID] FOREIGN KEY([B])

REFERENCES [dbo].[B] ([BID]) GO

     CREATE TABLE [dbo].[B](
[BID] [int] NOT NULL,
    CONSTRAINT [PK_B] PRIMARY KEY CLUSTERED 
   (
[BID] ASC
   )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,          ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]

 GO

  ALTER TABLE [dbo].[B]  WITH CHECK ADD  CONSTRAINT [FK_B_A] FOREIGN KEY([BID])
  REFERENCES [dbo].[A] ([AID])
  GO

  ALTER TABLE [dbo].[B] CHECK CONSTRAINT [FK_B_A]
  GO

Wouldso would be an place possible within this type of design even in the Presentation layer?