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

1 draw and explain erm diagram andnbsp explain what is

1. Draw and explain ERM diagram and  explain what is REM 2. Explain what is Normalization . what is 0NF,1NF, 2NFand ,3NF and explain what is in the tables Entity Relationship Modeling and Normalization: 1 System Analysis ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

Fundamentals of databases assignment 1 -q1 explain the

Fundamentals of Databases Assignment 1 - Q1. Explain the distinction between total and partial constraints. Q2. Explain the difference between a weak and a strong entity set. Q3. Explain the distinction between disjoint ...

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Assignmentthis assignment consists of two sections a design

Assignment This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file nam ...

At this point you decide to implement a hash structure for

At this point, you decide to implement a Hash structure for the contributor data to prepare for searches. You will read the contributor information from a file provided; it is a comma delimited (CSV) file. As each record ...

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro