CASE:
Identify any organisation of your own choice with a number of departments
interacting with each other. Imagine that the organisation has an open policy
which enables employing and dealing with people who are both nationals and non-
nationals. You are advised to take assumptions where necessary based on your
experience with oracle database systems.
QUESTION ONE
a) Design the database using an enhanced entity relationship diagram (EERD).
Make it as detailed as possible, reflecting; entity integrity, referential
integrity, inheritance, and numeric multiplicity.
b) Clearly state all the different business rules/ processes that you will make
use of to derive the numeric multiplicity in the above model. NB, while
stating the rules, they should be Bi-directional i.e cardinalities on both
entities in the relationship should be reflected.QUESTION TWO
Using the oracle database system, Transform the model developed in (question
one) and develop an oracle database application which can be used to manage
information within the organisation. Make the oracle entry forms as user friendly
as possible. Your creativity and logical thinking will be of great advantage. Make
use of constraints to ensure that you reduce garbage-in and garbage-out
challenges and uphold integrity of the database. Ensure that information is
accessed by authentic users and actions performed are privileged.
Note: The application above should show evidence of implementation of the
following aspects:
i.The different data retrieval aspects using the select key word.
ii.Make use of constraints to ensure that you reduce garbage-in and garbage-
out challenges and uphold integrity of the database
iii.
Implementation of different Joins (Natural, Left-outer, Right-Outer, Full
Join)
iv.Logical relationships
v.Data security, user account management and roles, granting and revoking
object privileges
vi.Data independence
vii.User Views
viii.Validation
ix.Reports
x.End user convenience
xi.Triggers