/
Questions/
Coursework/
Suppose that a relation factory contains 800 tuples and Each tuple is comprised of a header: Database Systems Coursework, UOS, UK
Looking For Plagiarism Free Answers For Your UK College/ University Assignments.
BUY NOWSuppose that a relation factory contains 800 tuples and Each tuple is comprised of a header: Database Systems Coursework, UOS, UK
University | University Of Salford (UOS) |
---|---|
Subject | Database Systems |
Assessment set by Dr. Bryant
- Dr. Bryant’s surgeries take during the teaching part of the semester. The time of his next surgery is shown on Blackboard’s calendar. Please note that this is a drop-in service. In other words, there is no need to make an appointment. Please simply give him a call via MS Teams during his surgery hours. Please remember to have your microphone switched on if you want him to hear you and to have your camera switched on if you want him to see you.
- If you are new to MS Teams then please note that you can find an introduction to MS Teams at https://www.linkedin.com/learning/microsoft-teams
- If you just want to send him an email, then do not use MS Teams or Blackboard to do this. Instead, please send it to his usual email address
Questions
1) (a) Suppose that a relation factory contains 800 tuples. Each tuple is comprised of a header (24 bytes) and four attributes: ID (5 bytes), name (10 bytes), street (20 bytes), and postcode (6 bytes). The size of each disc block is 1024 bytes and the size of the header of each disc block size 24 bytes.
(i) How many blocks would be required to store the whole of this relation?
(ii) How many blocks would be required to store a projection that does not include the attribute street?
(iii) Explain why such a projection could be used to optimize a query whose
results do not include data for the attribute street.
(b) Consider the SQL query shown in Table 1.
(i) Draw a near-optimal query tree for the SQL query.
(ii) Identify the root and leaf nodes in the tree that you drew for part (i).
(iii) Write down a justification for the position of the root node and each of the internal nodes in the tree that you drew for part (i) in terms of the heuristic steps that optimizers apply to reduce the cost of optimization. Explain why the position of the nodes should make the query efficient.
Buy Answer of This Assessment & Raise Your Grades
Get help by expert
Attention University of Salford (UOS) students studying Database Systems! Are you struggling with your coursework? Our Assignment Writing Help UK and Report Writing Help services are here to assist you. Whether it’s dealing with relations, headers, or any other aspect of your coursework, our experts are ready to lend their expertise. Don’t let academic stress weigh you down – invest in our professional services and excel in Database Systems at the University of Salford, UK. Your success is just a click away
Recent solved questions
- ILM: Assess own leadership behaviours and potential in the context of a particular leadership model and own organisation's working practices and culture: Leadership skills and development, Assignment, UOA, UK
- ILM: Describe the factors that will influence the choice of leadership styles or behaviours in workplace situations: Leadership skills and development, Assignment, UOA, UK
- ATHE Level 7 Unit 5 : You Have Been A Senior Manager For Several Years And Have Decided That Your Next Career Move Should Be To Take Responsibility: Personal Development for Leadership and Strategic Management Assignment, UK
- You are required to prepare a 5-year strategy review to shareholders for evaluating the business simulation: 5-year strategy review to shareholders, Report, UOEL, UK
- CMI Unit 502: Approaches to achieving a balance of skills and experience in a team: Principles of Developing, Managing and Leading Individuals and Teams, Assignment, UK
- CMI Unit 502: Principles of Developing, Managing and Leading Individuals and Teams, Assignment, UK
- UNIT-701: How the principles of strategic leadership can be applied to respond to complex organisational challenges: Strategic Leadership, Assignment, CMI, UK
- UNIT- 701: The leadership behaviours and skills required to deliver strategic goals: Strategic Leadership, Assignment, CMI, UK
- UNIT- 701: Understanding of how the organisational context influences management and leadership practice: Strategic Leadership, Assignment, CMI, UK
- Evaluate the concept of evidence-based practice and assess how approaches to evidence-based practice: Evidence - based practices, Report, UOH, UK