Database Engineering

Instructions:

1. Using Chen’s or Crow’s Foot notation or any case tool, devise an Enhanced Entity Relationship (EER) model for the TPS database. All entity types, their attributes and relationships must be clearly shown. You will also be required to show all cardinality and participation constraints. [Note, marks will be deducted for inconsistent use of your chosen notation]. Any assumptions above the basic business rules or any temporal data semantics captured on your EERD must be clearly stated and justified.
2. Map the EER model devised in (1) into a set of relations in the relational data model. You may use object-relational features to support the enhanced features in your model. Clearly state any de-normalization, if any, in all your relations and clearly state the reasons for de-normalizing relations in your implemented solution. All temporal semantics must be clearly explained and justified.
3. Using appropriate SQL commands, create a set of database tables in Oracle. Your tables should also show all constraints applied at either column or table level. All table level constraints must be given unique names.
4. By querying the relevant data dictionary views, produce a listing of the TPS database metadata.
5. Create an appropriate user interface using Oracle Apex to allow users to input data into your tables easily. To allow for automatic computation of totals during data entry, you will need to attach some stored procedures to the relevant fields on your form.
6. Create sample reports to demonstrate overall system functionality. For example, you may want to show all pending cases before a given judge, or all cases that have had more than one adjournment, etc.
• A report covering requirements 1 – 6

ORDER THIS ESSAY HERE NOW AND GET ADISCOUNT !!!