Exam (elaborations)
Database Design And SQL With Complete Solutions Latest Update
- Course
- Institution
Database Design And SQL With Complete Solutions Latest Update
[Show more]
Content preview
Database Design And SQL With Complete SolutionsLatest Update
Info vs Data - correct answers Data: raw facts
Information: Information is based on conclusions that are drawn from data.
Information supports decision making which in turn supports organizational
efficiency and competitiveness. Good decision making requires relevant, timely,
and accurate information
MetaData and Schemas - correct answers MetaData: data about data; i.e. data
about data characteristics and relationships
Schema: A logical grouping of database objects, such as tables, indexes, views, and
queries, that are related to each other. Usually, a schema belongs to a single user
or application
Data Inconsistency - correct answers A condition in which different versions of the
same data yield different results
Data Redundancy - correct answers A condition in which a data environment
contains redundant data
Atomic Values - correct answers A value that cannot be divided
Data Integrity - correct answers In a relational database, a condition in which the
data in the database comply with all entity and referential integrity constraints
, Entity - correct answers A person, place, thing, concept, or event for which data
can be stored
Entity Set - correct answers In a relational model, a grouping of related entities
Tuple - correct answers In the relational model, a table row
Row - correct answers The horizontal part of the table
Attribute - correct answers A characteristic of an entity or object. An attribute has
a name and a data type
Constraints (PK, FK, CK, DK) - correct answers A restriction placed on data, usually
expressed in the form of rules
Business Rules and impact on DB Design - correct answers Are written rules that
define entities, attributes, relationships, and constraints
A good data model will not capture all aspects of the business rules but the data
model must reflect the business rules
Ie. A customer may generate many invoices, an invoice is generated for only one
customer, a training session cannot be scheduled for fewer than 10 employees or
for more than 30 employees.
Ie. Product discounts are awarded to customer accounts that have been in good
standing for over 2 years.
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 $12.19. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
