Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1: How is DBMS classified based on several criteria? Describe each one of them with some exs wherever required

problem 2: Distinguish between B+ tree and B- tree. Describe them with diagrams.

problem 3:

Using the above tables answer the given problem

a) If we want to see all the employees with salary between 40000 and 50000, which query can be used?

b) Select employee name from EMPLOYEE table, whose name begins with R.

c) Describe aggregate functions and grouping in detail.

problem 4: What are the problems and failures which might encounter with respect to the transactions in a database management system? Give illustrations.

problem 5: Consider any database of your choice (may be simple banking database/forecasting database/project management database). Show the deduction of the tables in your database to the different kinds of normal forms.

problem 6: Read the given case study thoroughly and answer the given problems:

XYZ bank is one of the largest private sector banks. It has an extensive network of more than 200 branches. It provides banking services to retail as well as corporate clients. The bank faced a challenge in integrating multi-pronged database management system into a centralized system. The IT department of the bank as well realized that the computing capabilities of its PCs and servers were not proportionately distributed among all its branches. Each branch had its database management system stored in a traditional way on the disk. The total cost of operating and maintaining the current IT infrastructure was very high and the fundamental shortcomings added to the costs. Furthermore, there were as well recurrent problems due to the malfunctioning of the currently operational database management system. Thus, the bank’s top management decided to fix the problem and operationalise a robust database management system. The bank hired an external database technology consulting firm termed as AKPY Info systems Limited.

AKPY divided the whole IT infrastructure of the bank around two verticals. The retail banking vertical and the corporate banking vertical. All the individual database servers from the individual branches were removed. The whole database system was made virtual such that the managers and the staff can access only the required information (related to retail banking or corporate banking) from the respective centralized data centers. There were only two such centralized data centers (one for retail banking and another for corporate banking) that were managed centrally. Staff and managers could access the information through their PCs and laptops. Centralized database management system complemented the security system by bringing in authentication through a unified ID management server. Managers and officers of the bank were able to process half a million transactions per month in real time after the new implementation. There were significant savings in the cost and as well in the consumption of power. Now there were no problems with regard to imbalances in the load across different network servers. Due to centralized data management, top management could keep an eye on the functioning of different branches. Therefore the cases of fraud and cheating reduced considerably. The bank managers could as well process the loan applications in reduced time as the customer’s previous records could be accessed at the click of the button and approval from the higher authorities could be obtained in real time. Furthermore the new system also brought in many applications which helped local managers in the decision making process.

a) List the uses of centralized data management.

b) What steps XYZ bank need to take if it were to change its centralized database system to a distributed database system in future?

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M93822

Have any Question? 


Related Questions in DBMS

Database design continueduse the attached database to

Database Design Continued Use the attached database to complete the following assignment: You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report. 1) Create ...

1 what is the difference between database and data

1. What is the difference between database and data warehouse? 2. What is OLAP? 3. What is a data cube? How do DSS take advantage of the structure?

1 what is the difference between a column constraint and a

1. What is the difference between a column constraint and a table constraint? 2. What is a recursive join? 3. Explain the difference between an ORDER BY clause and a GROUP BY clause. 4. What is a CROSS JOIN? Give an exam ...

Design a relational database for a video rental store the

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 supplier ...

Database management systems assignment-overview-for this

Database Management Systems Assignment- Overview- For this assignment you will implement and query a database from a supplied ER Diagram and Schema.  You will be required to write the SQL statements to create the databas ...

Part 1identify and explain the default logins or user

Part 1 Identify and explain the default logins or user accounts for one of the database vendors discussed in the chapter. Part 2. Case Project 6-1: Database Password Policies, page 199 Create and document a written passw ...

The purpose of the veterinary hospital registration system

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and appointments (open, clo ...

Home libraryisbntitleauthor Home Library I SBN Title Author LastName Author_FlrstName

Home Library I SBN Title Author LastName Author_FlrstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980   Book 741258 No Secrets Simon Carly Elektra 1972   CD 654789 Symphony No 3 Dur Eroica Op ...

Database reflectionuse the attached database and associated

Database Reflection Use the attached database and associated sheets to review and to make sure the forms are working. Review your project; make sure that all the forms are working. Write a one page report on how you coul ...

To prepare for the discussion read the article bridging the

To prepare for the discussion, read the article "Bridging the Gap: The Difference Between Data Analysis and Data Modeling." in the Module Resources folder on data manipulation. Next view the Power Point presentation "Dat ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate