Databases | SQL | Oracle | MS Access Answers

discuss and identify the various security
assessment tools and their features that are supported by Oracle. The critical discussion
must cover security configuration issues and their solutions, location, type, quantity of
data, user privileges and so on.

Multidimensional database empowers any analytical data mining capability. Explain with examples about the growing demand for data mining tools.

List the reason code, reason description, block code, block minutes for the appt detail row with the highest number of minutes in each appointment. Show the minutes formatted as “# minutes” and use the following column headings: Reason Code, Description, Block Code, Minutes. Hint: use a GROUP by and nested SELECT.
In oracle

Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many‐to‐many relationships. Tip: Pay attention to the mark allocation shown below. Movie meta‐data – business rules:  A website about the film industry wants to store data about movies.  A movie contains several scenes (at least one), and a scene will never be used in more than one movie. (20)

Draw an ERD based upon the following Scenario. Also mention the attributes name and relationship between the entities.

I am the manager of a training company that provides instructor-led courses in management techniques. We teach courses, each of which has a code, a name, and a fee. Introduction to UNIX and C Programming are two of our more popular courses.
Courses vary in length from one to four days. Paul Rogers and Maria Gonzales are two of our best teachers. We need each instructor’s name and phone number. The students can take several
courses over time, and many do this. Jamie Brown from AT&T took every course we offer!
We like to have each student’s name and phone number.

a. Let Computer A is creating an object, which is on the spot and automatically delivered to
computer B , So both computers have the same updated record each time
Write the name and purpose of this type of DBMS?

Purpose of an index

How to get the best out of an index?

What are the four scenarios Cleveland and Cleveland noted when an information seeker consults an index and abstract

What are the four scenarios Cleveland and Cleveland note, when an information seeker consults an index or abstract? How do information professionals ensure that information seekers get the best of the four scenarios?