100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
SER 322 MIDTERM REVIEW EXAM QUESTIONS AND ANSWERS $11.49   Add to cart

Exam (elaborations)

SER 322 MIDTERM REVIEW EXAM QUESTIONS AND ANSWERS

 4 views  0 purchase
  • Course
  • SER 322
  • Institution
  • SER 322

SER 322 MIDTERM REVIEW EXAM QUESTIONS AND ANSWERS...

Preview 2 out of 5  pages

  • November 8, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Unknown
  • ser 322
  • ser322
  • ser 322 midterm review
  • SER 322
  • SER 322
avatar-seller
luzlinkuz
SER 322 MIDTERM REVIEW EXAM
QUESTIONS AND ANSWERS

What is a Composite attribute? - ANSWER An attribute composed of
multiple components each with individual existence

A condition that an entity can be a member of at most one of the
subclasses of the specialization is called ______________. - ANSWER
disjointness constraint

A condition that every entity in the superclass must be a member of
some subclass in the specialization/ generalization is called
______________. - ANSWER completeness constraint

An entity is ____________. - ANSWER a distinct object or thing in a
mini-world

An entity that does not have sufficient attributes to form a primary key is
termed a __________. - ANSWER Weak entity

In an E-R diagram entities are represented by _______________. -
ANSWER rectangles

Relationship types of degree 3 are called _______________. -
ANSWER ternary

Suppose:
VEHICLE is a superclass {CAR, TRUCK} are subclasses of
VEHICLEVEHICLE is a _____________________of {CAR, TRUCK}. -
ANSWER generalization

What is Specialization? - ANSWER the process of defining a set of
subclasses of a superclass

What is a Derived attribute? - ANSWER An attribute that represents a
value that is derivable from a related attribute or set of attributes, not
necessarily in the same entity

, What is a Single-valued attribute? - ANSWER An attribute that holds a
single value for a single entity

What is a Multi-valued attribute? - ANSWER An attribute that holds
multiple values for a single component

What is a Simple attribute? - ANSWER An attribute composed of a
single component with an independent existence

What type of relationship is described by the following rule? For one
instance of entity A, there exists zero, one, or many instances of entity
B; and for one instance of entity B, there exists zero, one, or many
instances of entity A. Select the best answer.

1:1 relationship
1:N relationship
M:N relationship
No answer text provided. - ANSWER M:N relationship

What type of relationship is described by this rule? For one instance of
entity A, there exists zero, one, or many instances of entity B; but for one
instance of entity B, there exists zero or one instance of entity A. Select
the best answer.

1:1 relationship
1:N relationship
M:N relationship
No answer text provided. - ANSWER 1:N relationship

_____ is a attribute (or a set of attributes) in a database relation that has
a unique value. - ANSWER Super Key

_____ constraint dictates that the foreign key must contain values that
match the primary key in the related table, or must contain null. -
ANSWER Referential Integrity

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 luzlinkuz. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $11.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

62890 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.49
  • (0)
  Add to cart