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.
let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation
what do you understand by enhanced entity-relationship
in an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the
By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which
What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s
Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c
Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce
Where does view definition stored? A view definition is permanently stored as part of the database.
Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute
Which database object does not physically exist? A view database object does not physically exist.
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd