Transcript Test Your Knowledge Powerpoint

Microsoft Enterprise Consortium
Database Fundamentals
Test Your Knowledge
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
1
Microsoft Enterprise Consortium
Test what you know about relational
database fundamentals


This presentation has questions to test what you
understand about relational databases—the
models and the construction.
The answers are not provided. If you’re not
certain about your answers, review the
presentations about database fundamentals.
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
2
Microsoft Enterprise Consortium
A few questions …
1.
What is the data model term that has this
definition? “A person, place, thing, or event
about which we need to keep information.”
______________
2.
What is a field called if it is used to link to a
primary key field in another table?
______________
3.
A field (or fields) that uniquely identifies each
row in a table is called a(n) ____________ ?
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
3
Microsoft Enterprise Consortium
A few more questions …
4.
If a relationship in the data model has a
maximum cardinality of “one” on one end and
“crows feet” on the other end, what type of
relationship is this? _____-____-______
5.
Which of the following could be a primary key
for the EMPLOYEE table?
a. First Name + Last Name
b.
c.
d.
e.
Phone Number
Job Title
Social Security Number
Birth Date
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
4
Microsoft Enterprise Consortium
A few more questions …
6.
E. F. Codd proposed the principles for
__________ databases, which is the type of
database most widely used today.
7.
An attribute that might have more than one
value for each entity _________, is called a
__________ attribute.
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
5
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.

Now, you’ll see some data models and answer
questions about them.

You don’t have to know the business setting in
order to read these models; just interpret what
the data model depicts.
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
6
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
8.
In the data model shown, how many tables
would you build in the database?
in
for
CUSTOMER
ORDER
has
Prepared by Jennifer Kreie, New Mexico State University
INVENTORY
of
Hosted by the University of Arkansas
7
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
9.
Which of these would get a foreign key? Check
all that apply.
CUSTOMER
ORDER
INVENTORY
None would.
All would.
in
for
CUSTOMER
ORDER
has
Prepared by Jennifer Kreie, New Mexico State University
INVENTORY
of
Hosted by the University of Arkansas
8
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
10. In
the data model shown, how many tables
would you build in the database?
EMPLOYEE
ASSIGNMENT
Prepared by Jennifer Kreie, New Mexico State University
PROJECT
Hosted by the University of Arkansas
9
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
11. Which
of these would get a foreign key? Check
all that apply.
EMPLOYEE
ASSIGNMENT
PROJECT
None would.
All would.
EMPLOYEE
ASSIGNMENT
Prepared by Jennifer Kreie, New Mexico State University
PROJECT
Hosted by the University of Arkansas
10
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
12. In
the data model shown, how many tables
would you build in the database?
VENDOR
VendID
VendName
{Phone}
PART
PartID
PartDesc
Prepared by Jennifer Kreie, New Mexico State University
BILL OF MATERIALS
BOM_ID
BOM_Title
Hosted by the University of Arkansas
11
Microsoft Enterprise Consortium
Test your understanding of data
models and databases.
13. In
the data model shown below, which of these
would get a foreign key? Check all that apply.
VENDOR
PART
BILL OF MATERIALS
None would.
All would.
VENDOR
PART
Prepared by Jennifer Kreie, New Mexico State University
BILL OF MATERIALS
Hosted by the University of Arkansas
12
Microsoft Enterprise Consortium
How did you do?
If you couldn’t answer all these questions, you
should review the database fundamentals videos.
It is very helpful to understand these concepts
and terms when you work with databases.
Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
13
Microsoft Enterprise Consortium
Resources
Microsoft Enterprise Consortium:
http://enterprise.waltoncollege.uark.edu/mec.asp
 Microsoft Faculty Connection—Faculty Resource Center
http://www.facultyresourcecenter.com/

Prepared by Jennifer Kreie, New Mexico State University
Hosted by the University of Arkansas
14