Exam (elaborations)
Database Design Exam 1 Study Guide With Complete Solutions Latest Update
- Course
- Institution
Database Design Exam 1 Study Guide With Complete Solutions Latest Update
[Show more]
Content preview
Database Design Exam 1 Study Guide WithComplete Solutions Latest Update
Entity - correct answers An instance of a type that is uniquely identifiable is called
an ________________.
conceptual - correct answers The entity relationship diagram is used to graphically
represent the _____________ database model.
Unary relationship - correct answers ______________________ exists when an
association is maintained within a single entity.
Foreign key needed only in Song table - correct answers Consider two tables:
Album and Song, that are related by a "1-to-Many" relationship. Given this type of
relationship, in which table should the corresponding foreign key be placed?
* The weak entity BANK_BRANCH depends on entity BANK and BANK_BRANCH has
total participation.
* The partial key of BANK_BRANCH is Branch_no. - correct answers Consider the
ER diagram shown in Figure below for part of a BANK database. Select what is
correct.
parent - correct answers In a one-to-many relationship, the entity that is on the
one side of the relationship is called a(n) ________ entity.
,In a row of a relational table, an attribute can have more than one value - correct
answers Given an ER model and its relational schema, which of the following is
INCORRECT?
* Section_identifier
* Course_number, Semester, Year - correct answers The candidate key(s) of table
SECTION is(are):
True - correct answers The degree of a relationship type is the number of
participating entity types.
True - correct answers A weak entity has no key among its attributes.
True - correct answers In a binary relationship the (min, max) denotes the
participation constraint of an entity.
True - correct answers The (min, max) are placed at the opposite side of the entity
in the ER diagram.
For example, in a binary relationship called "Depends", between entity
DEPENDENT and entity EMPLOYEE where an employee can have 0 or more
dependents the ( 0, N ) is placed at the side where the EMPLOYEE entity is.
, True - correct answers A many-to-many relationship of ER model can be simplified
into two one-to-many relationships.
True - correct answers Two or more superclasses that share a subclass have same
keys
True - correct answers A candidate key is an attribute or set of attributes that
uniquely identifies individual occurrences of an entity type.
* Table Y has all of its records participating in the relationship with table X.
* The diagram does not suggest which table might have more attributes in its
primary key.
* Entity X is not optional for entity Y
Explanation: Entity Y has total participation in the relationship which makes
necessary and not optional to relate one of the X records to a Y record. - correct
answers Which of the following statements is true?
weak entity - correct answers An entity whose partial key depends on the primary
key of another entity is called _____________.
degree - correct answers The number of entities participating in a relationship is
called _____________.
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 Schoolflix. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now