Advance Database Essay Example | Topics and Well Written Essays - 1000 words

Advance Database - Essay ExampleThe report gives a detailed skilful description of the systematic formation of the systems data stupefy. The endives of the report intend to encompass the important details related to the four major phases regard in building the proposed database design4. Implementation of the database design in Oracle and testing of the design through scenario specific SQL queries. The rightness of the result would prove the correctness of the proposed database design.The major constraint in designing a class diagram of a scheduling management database is in relation to a large event of variants brought about by the seasonal change of train journey, planned and unplanned maintenance of trains and rearrangement of weekdays and the holiday. Though the calendar stating of each train, the entry number description for a particular day, time and station makes the whole process cumbersome. The approach requires not less than 2 million records to accommodate the train s cheduling the proposed relational database. In addition, to hold the schedule for a long time raises the number of records the key issue is the operation of updating changes in the schedule.Another key constraint is the issues relating to objects that establish overlapping lifespan. This is very profound when this object overlaps. The situation is peculiar since the object maintains its state actuality even after changing (IBM 2003). It only takes place in that effrontery a short time during the replacement. This will result in a situation where we have multiple real time tuple which describes the different versions that the same object has. This idea does not merge the previous RDBMS concept, therefore it is inherent to develop special data queries which will solve this situation.To form a structural model for the system, all critical entities of the TFR for which data is stored and that are part of the daily business operations were