Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Answer the following problems.

problem 1) Consider the following schedule and describe which schedules are conflict-equivalent and complete.

S1={R2(z),W2(x),W2(y),C2,W1(x),R1(x),A1, R3(x),R3(z),R3(y),C3}

S2={R3(z),W2(x),W2(y),R1(x),R3(x), R2(z),R3(y),C3,W1(x),C2,C1}

problem 2)a) Simplify the following query and check whether it is semantically correct or not.

Select eno from
ASG where
Resp = “Analyst”
AND NOT ( pno = “p2"
OR DUR = 12 )
AND pno ≠ “p2
AND DUR = 12

b) Given the relation EMP (ENO, ENAME, TITLE)
Let P1 & P2 be the two simple predicates where
P1 : TITLE < “programmer”
 P2 : TITLE > “programmer”

Suppose that char strings has order amongs then based on alphabetical order.

i) Perform the horizontal fragmentation of EMP with respect to P1 & P2

ii) Describe whether the resulting fragmentation emp1& emp2 fulfils the correctness rules of fragmentation or not?

iii) Modify predicates P1 andP2. if needed to satisfy correctness rules.

problem 3) Apply the algorithm INGRES to the following query and show the successive detachment and substitutions by giving mono-relation sub queries generated.

Select ename, sal from EMP, ASG , PROJ, Pay
Where EMP. eno = ASG . eno
AND EMP. title = Pay, title
AND Budget > 200000
OR DUR = 24

problem 4) Define deadlock? How deadlock can be managed?

problem 5) Describe the problems why DBMS bypass OS buffer manager and manage the disk & main memory.

problem 6) Describe the issues of global directory.

problem 7) Describe the process of localization.

problem 8) Which drawbacks of PC2PL are removed by D2PL?

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Assignment business rules for sam symthes

Assignment: Business Rules for Sam Symthe's Database Overview Sam Smyth is an expert puppy trainer. His specialty is training troubled puppies to behave for their owners. The name of his business is Sam Smythe's Kennel f ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Some people used to believe that data warehouses would

Some people used to believe that data warehouses would quickly replace databases for both online transaction processing (OLTP) and online analytical processing (OLAP). Of course, they were wrong. Why can data warehouses ...

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

  • 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