* Ex 10-1 *
To test choices of type, create a table with various types like this:
CREATE TABLE Test4
Then, INSERT values into the ta
Target material equi-join basics, ER
When do we perform
-When the information we want is contain in >1
-When we want results from one table, but based on criteria in
How do we perform joins?
-Always on primary key/fore
# Exercise 1 #
You are given the following table:
EMP_PROJ(ssn, pnumber, hours, ename, pname, plocation)
And you are given the following functional dependencies:
(ssn, pnumber) hours
This means: hours in dep
Guidelines for ER Exercises Turn-in
All ER exercises are available in the respective chapters in the ER book (see ER
Homework List). ER exercises are due at 11:59pm (Central Time) on the date shown in
the dropbox. All assignments must be read
* Ex 5-1 *
Develop and execute a query to find the names of students who had HERMANO as an
instructor and earned a grade of B or better in the class. Develop the query by first
finding sections where HERMANO was t
Consider the following tables:
Student (StudentID, Name, SS#, GPA)
StudentID is a primary key
Name is required
SS# is not required, but must be unique
GPA is required and must be greater than or equal to zero
Course (CourseID, Title)
Consider a database that must be designed for a small Lawn Maintenance Business. You need to maintain information
Customer name and address information so that you can mail bills at the end of each month and/or call them if
ER Chapter 6
1) What are structural constraints?
a) Structural constraints are the information that dictates how two or more entities are related to
2) What kind of information does the cardinality ratio give us?
ER Chapter 5
1. Can the nature of an entity change over time? Explain. I think that with the building of
databases our goal as builders is to develop relationships between entities and attributes that
are attached to each entity.
ER Chapter 8
1) In Figure 8.6 (pg. 204), why is BUILDING an entity and not an attribute of another entity?
a) Building evolved into an entity because there was more information was to be recorded about
2) In Figure 8.6,
ER Chapter 9
What is a ternary relationship?
It is when three entities participate in the relationship
What is an n-ary relationship?
Is when a relationship is connected by three or more entities.
Using three entities present
Chapter 4 Checkpoint and Chapter Exercises
1. Of the following items, determine which could be an entity and state why: automobile, college
class, student, name of student, book title, and number of dependents.
a. Automobile and s
Chad Hoye |1
1. If you write about the two trees on a piece of paper, you are creating a database as long as there
is a common trees having something in common. For example, if you were recording the trees in
a certain part of the
Chad Hoye |1
1. When a field has a unique value it is to say that each entry in the database will have a unique
notation in that field. In the book it gave the example of a record number and another would be
a transaction number f