Database Management Systems Homework

$10-30 USD

Closed

Posted

about 9 years ago

$10-30 USD

Paid on delivery

This is not a programming homework but a theorical one about B+ trees, disks and files, file organizations and indexing. Please read the questions. There are only four. I don't only need solutions, I want explanations too. Thanks.

Database Development

Database Programming

Project ID: 7642979

About the project

4 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average $20 USD for this job

@ENRICOJ

hi. I am a certified ms sql server developer. I would like to assist. please feel free to contact me for further assistance. kind regards .enrico

$30 USD in 1 day

4.2

(1 review)

1.1

@evansmk

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@balajisunku

Hello, I am database developer having an exp of 5+ years. To gain your trust below are the answers provide for you ..Atleast give me some feed back and post a review on my account. Q1. Query 2,3,6 will run fast. Since we are creating the INDEXES on the SWORD_RANK,MAGIC_POWER and YEAR. Query 1 has where clause on the BIRTH_YEAR But we are indexing on YEAR. Q2.I have an answer i cannot attach the diagram. Q3. Since the system is failed at 60-70 None of the statements from 00 to 60 are commited. The DPT Table has below changes Character 1 weapon has changed to ring character 2 name has changed to white gandalf REDO all actions in log starting at earliest point when a change not on disk UNDO actions of all transactions not committed by the end of phase Q4. I need to do some research on the execution time ..

$15 USD in 1 day