Sign Up ›
  • patric.jennifer
  • NEWBIE
  • -1 Points
  • Member since 2013
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
1 replies

Database design question. Help me please, this report writing is my life?

You are the Project Manager of a team of database designers working for a Facilities Management IT Company who will produce a database application for USA Travel. At the moment the department uses standard ER diagrams and normalisation techniques when designing any database systems. The Head of Department wants to invest in some tools to aid with database design and to consider using more advanced design techniques. The Head is also concerned about the security of the application.

Write a report for your Head of Department that discusses:
• The advantages and disadvantages of using advanced techniques such as the Enhanced Entity Relationship (EER) model compared to the traditional approach of using standard ER diagrams and normalisation.
• Evaluates the Oracle Data Modeler and Designer tools. 
This section should discuss the tools and how they aide the development of a database system. Discuss what advantages and disadvantages such tools have.
• Reviews what database specific security issues could affect a database application.
This section should give an overview of what problems could affect a database and what steps can be taken to prevent them.
Include examples where appropriate, which should be based on the USA Travel scenario as far as possible
1 replies

need accurate answer

What is a capability of Visual Workflow?

Choose 3 answers

 

A. Create a copy of an Existing element

B. Activate multiple versions of a flow

C. Sort and limit dynamic choices

D. Redirect flow users to an external website

E. Build reusable flows for common tasks

 

Which option is available when editing a chart component in the Dashboard Builder?

Choose 3 answers

A. Change the filter for the data displayed

B. Change the chart to a combination chart

C. Change which groupings to show

D. Change the time frame for date field groupings

E. Change which summery field to show


When creating a non-required lookup field, which option is available to control what happens when the lookup record is deleted?

Choose 2 answers

A. Clear the value of this field

B. Do not delete this record

C. Don’t allow deletion of lookup record that’s part of lookup relationship


What is a capability of joined reports?

Choose 2 answers

A. Multiple blocks can be scheduled for emailing.

B. Data from multiple blocks can be exported to Excel.

C. Values from multiple blocks can be displayed on a chart.

D. Summary values can be calculated using data from multiple blocks.