• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Exam (elaborations)

CSE 512 Midterm Exam Study Guide.

Document preview thumbnail
Preview 1 out of 4 pages

©THESTAR EXAM SOLUTIONS 2024/2025 ALL RIGHTS RESERVED. 1 | P a g e CSE 512 Midterm Exam Study Guide. Levels of Abstraction - answerViews: How the user sees the data Conceptual: Defines logical structure Physical: Describes files and indexes used Data Independence - answerApplications ask a process to query for them Atomicity - answerEither all actions or no actions in a transaction must complete DBMS Players - answerEnd Users Vendors Programmers Admin Scientist What does scalability improve? - answerMore users More data Latency Transparency - answerA distributed system should be perceived as a whole by both user and application programmer Completeness - answerEach data item can be found in some fragment Reconstruction - answerThere should exist some relational operator that reconstructs the original table Disjointness - answerIf some data item exists in one fragment, it should exist in no other fragment Derived Horizontal Fragmentation - answerFragment a table based on the fragment of another table i.e. equijoin EMP with Pay1 and Pay2

Content preview

©THESTAR EXAM SOLUTIONS 2024/2025

ALL RIGHTS RESERVED.



CSE 512 Midterm Exam Study Guide.

Levels of Abstraction - answer✔Views: How the user sees the data
Conceptual: Defines logical structure
Physical: Describes files and indexes used

Data Independence - answer✔Applications ask a process to query for them

Atomicity - answer✔Either all actions or no actions in a transaction must complete

DBMS Players - answer✔End Users
Vendors
Programmers
Admin
Scientist

What does scalability improve? - answer✔More users
More data
Latency

Transparency - answer✔A distributed system should be perceived as a whole by both user and
application programmer

Completeness - answer✔Each data item can be found in some fragment

Reconstruction - answer✔There should exist some relational operator that reconstructs the
original table

Disjointness - answer✔If some data item exists in one fragment, it should exist in no other
fragment

Derived Horizontal Fragmentation - answer✔Fragment a table based on the fragment of
another table i.e. equijoin EMP with Pay1 and Pay2



1|Page

Document information

Uploaded on
November 24, 2024
Number of pages
4
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$10.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TheStar
3.7
(142)
Sold
744
Followers
178
Items
28821
Last sold
23 hours ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions