Exam (elaborations)
CSE 511 Data Processing at Scale - WK 1-4 With Complete Solutions Latest update
- Course
- Institution
CSE 511 Data Processing at Scale - WK 1-4 With Complete Solutions Latest update...
[Show more]
Content preview
CSE 511 Data Processing at Scale - WK 1-4 With CompleteSolutions Latest update
CSE 511 Data Processing at Scale - WK1
What characterizes scalable data processing?
Volume, velocity, and variety
What type of software should one utilize if he is in need to store data online, to make
certain parts of it accessible by different types of users, and searchable?
Database management software
In fact, database management software is designed to implement all of these tasks.
What is a characteristic of big data?
Data comes from different sources in different formats
Data formats can be very different between sources in the big data era.
What are components of Big Data?
Volume: Scale of data.
Variety: forms of data
velocity: speed of data
veracity: uncertainty of data
What does data independence mean for a DBMS?
Need not know how the data in an application is stored
Data independence is the form of data transparency that counts for a DBMS.
,What is a data model?
collection of concepts that can be used to describe the structure of a database
Schema
Description of a particular collection of data, using a given data model.
What is the relationship for the number of physical schemas to logical schemas in a
DBMS?
1:1
Logical schemas define all the logical constraints that need to be applied on the data
stored.
What is the most widely used data model today?
Relational Model
Which of the following is true about schemas of data?
A. There can be more than one physical schema for a given database.
B. There can be more than one external schema for a given database.
C. There can be more than one internal schema for a given database.
D. There can be more than one conceptual schema for a given database.
B
A database can have more than one external schema, which must be integrated in order
to develop the database.
, What is a characteristic of covering constraints?
Determine whether the entities in the subclass collectively include all superclass
entities
A university database records professors that taught subjects in courses. Based on the
entities participating in the relationship, what kind of relationship is this?
Ternary relationship.
A ternary relationship is an association among three entities. This kind of relationship
exists when binary relationships cannot capture the meaning of the association
properly. The ternary relationship construct is one diamond that is connected to three
entities
Consider a relation, STUDENT, with the following attributes: Name, ID number, Major,
Graduation Year, and GPA. Consider a query using this relation: "List the names and ID
numbers of students majoring in Computer Science." Which operator is absolutely
necessary for this query?
Projection
The projection operator is necessary to select just a subset of the attributes in that
relation i.e, names and ID numbers from STUDENT relation
What does the ϴ-Join function accomplish?
A. To join two tuples within the same relation
B. To join two relations in a database
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now