Exam (elaborations)
Hands-On Database 2nd Edition By Steve Conger (Instructor Manual)
- Course
- Institution
Hands-On Database 2e Steve Conger (Instructor Manual) Hands-On Database 2e Steve Conger (Instructor Manual)
[Show more]
Content preview
(Hands-On Database 2e Steve Conger )(Solution Manual, For Complete File, Download link at the end of this File)
Chapter 1
Outcomes
• Define relational databases
• Understand the position of relational databases in the history of databases
• Identify major relational database management systems
• Identify main characteristics of relational databases
• Understand SQL’s role in relational database
• Recognize some indications of where a database could be useful
• Define a statement of work for a given database scenario
Outline
I. Database Overview
A. What is a Database?
B. Flat File Databases
1. Delimited
2. Fixed width
3. Spreadsheets
C. Hierarchical Databases
II. Relational Databases
A. All data is stored in tables
B. Each row has a primary key
Copyright © 2014 Pearson Education, Inc.
, C. Foreign Keys
D. SQL
III. Relational Management Systems
A. Definition
B. Functions
C. Some Popular RDMSs
IV. Opportunities for Database Development
V. Initial Interview
A. Being Prepared
B. Listening to the Client
C. Focusing on the Broad Topics
VI. Identifying the Big Topics
A. Identify nouns
B. Group by themes
C. Entities and Attributes
VII. Statement of Work
A. History
B. Scope
C. Objectives
D. Tasks and Timeline
VIII. Documentation
A. Importance
B. Documenting the Structure
C. Documenting the Process
D. Project Notebook
1-2
Copyright © 2014 Pearson Education, Inc.
,IX. Things We Have Done
X. Things to Look Up
XI. Vocabulary
XII. Practices
XIII. Scenarios
Vocabulary
1. Attribute l. Things that define aspects of entities
2. Foreign Key i. This key is the primary key repeated in another
table to create a link between the tables.
3. Statement of Work n. A document including the scope, objectives,
and timelines for a given project
4. Primary Key h. This key uniquely identifies each row in the
table.
5. Data Integrity f. Refers to the accuracy and the correctness of
the data in the database
6. Redundancy g. Refers to storing the same data in more than
one place in the database
7. Delimited Files d. These files have some sort of character
separating columns of data. The delimiter is often a
comma or tab, but can be any non-alphanumeric
1-3
Copyright © 2014 Pearson Education, Inc.
, character.
8. Relational Database a. A type of database that uses “relations,” tables,
to store and relate tables
9. Entity k. Something that the database is concerned with,
about which data can be stored
10.Relational Design b. The process of organizing data into tables or
entities and then determining the relations among
them
11. SQL c. The language relational databases use to create
their objects and to modify and retrieve data
12. Constraints m. Limits on what the database will do
13. Fixed Width Files e. Files where the length in characters of each
column is the same
14. Statement of Scope j. A short statement of one or more paragraphs
that says in clear, but general, terms what the
project will do
Things to Look Up
The Things to Look Up section is meant to spur discussion. Many of the questions do not have precise
answers. All links provided can change or go away.
1. Look up Codd’s twelve rules. Choose one of the rules to explain to your fellow students.
1-4
Copyright © 2014 Pearson Education, Inc.
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 tutorsection. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now