Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe
Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.
When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.
Type of views : Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One
Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a
What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini
How to use Oracle
Define tuple variable? Tuple variables are used for comparing two tuples in the same relation. The tuple variables are explained in the from clause by way of the as clause.
Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or
Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd