Relationship between two tables-strategic decision making, Database Management System

In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a single operating database. In addition, all of the reporting is done from a single data warehouse using SAP Business Intelligence software. Due to the bank's reliance on databases, the branch manager asks you the following questions to gauge your understanding of databases.

1. Operating database includes a Customers table and a Loans table. List some of the fields in each of these tables and indicate the key field in each table. What is the relationship between these two tables?

2. What actions will you be able to perform on the operating database using the bank's database application?  Explain the relationship of the data warehouse to the business intelligence tools?

4. Bank's senior management will be using SAP business intelligence software for strategic decision making. Give an example of a strategic decision that the bank's senior management may make and the information that may be used for this decision.

 

Posted Date: 2/15/2013 4:55:40 AM | Location : United States







Related Discussions:- Relationship between two tables-strategic decision making, Assignment Help, Ask Question on Relationship between two tables-strategic decision making, Get Answer, Expert's Help, Relationship between two tables-strategic decision making Discussions

Write discussion on Relationship between two tables-strategic decision making
Your posts are moderated
Related Questions
A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ

Which method is used to key transformation ? A hash method is used to key transformation.

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.