File structure & database systems

File structure & database systems

Assignment Questions:

  • Insertany six search keys to B+ tree with n=3
  • Insert any ten search keys to B+ tree with n=4
  • Insert the following elements to hash table using Linear Probing
  • Write the relational algebra for the following from EMP table

14,37,63,67,91

79

69

98

72

50

0123456789101112

ID

Name

Dept

Salary

100

John

HR

1100

101

Peter

Sales

1000

102

Smith

Marketing

900

103

Brown

HR

1200

i.Select employee who has maximum salary

ii.Find the number of employees in each dept

iii.Find the total salary in HR dept

iv.Find the employee who has minimum salary.

please check the attached files to see the Question paper.

*Notice : when you finish from my assignment i have to submit in turnitin and that website its looking or searching in my assignment words if i taken from any resource of ( internet, students , books, newspaper …) so you have be careful in that to not become higher then 15%

*Notice: put citation in discussion and add references in Harvard Style also index please.

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper