1. Discuss the theoretical and physical aspects of a relational database.
2. Describe the Oracle implementation of the RDBMS and ORDBMS
3. Describe the use and benefitsof PL/SQL

  We are sure to get one question in this category.

  Oracle basically wants us to know the important key terms which make up
  a relational database.
  Basically the key concepts to know here are
  entity -- which is a table
  Relation --

  Crow foot    ==>  A crow foot is used to depict a one to many relationship.
  Solid Line   ==>  A solid line is used to depict a Must Have relationship.
  Dotted Line  ==>  A dotted line is used to depict a May Have relationship.

  It would be very useful to know the difference between a must and
  may at this point.(Time to open up our dictionaries and look up
  the meanings of the keyword).

  The key point which drives home is that we design a ER diagram
  first based on which we assign entities ( Tables ) and Relations
  (primary key, foriegn key and constraints) to the design and
  code accordingly. Therefore it is very important to understand the
  ER Diagram of your organisation very clearly. If possible take
  a print out from your DBA and paste the diagram on your board where
  you can take a look at very easily.
  You will get all the answers about the business of the organisation
  throught the ER Diagram. Also always ask and maintain the soft copy
  of the diagram it will come handy at a time when you least expect it.

  The famous front end tools for designing of diagrams are through
  E-R Win
  and
  Oracle Designer.

• Design and development
• Build and Documentation
• Testing
• Implementation
• Production Stage

  In this model entities are mapped to tables and we can assign
  relations to the various tables.

  PL/SQL is the language of choice for Oracle programmers. It has become
  the most widely used programming language of choice for many a developers.