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

Benefits of data protection controlsbased on what you have

Benefits of Data Protection Controls Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience tha ...

Assignmentthis assignment requires you to design a video

Assignment This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ...

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 ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

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 ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Database normalizationnormalize the below orders table to

Database Normalization Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of ...

Data warehouse1 review the submission hokie resort

Data Warehouse 1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below) 2. Write the three most important questions that management must answe ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen