DB Questions

Question 1

Create y

our business model

from your life or work.

Your ERD sho

uld include no more than 5 entities for

simplicity. This can be in word format at this point and does not need to be in diagram form

at unless

that’s easier for you.

1) Business Rules

2) ER Model

3) Sample Data (2

-

3 rows for each entity)

Note: that in database design business rules would always be defined first and the ER model would be

based on these rules. So, try to write the rules first but it might be an iterative process!

Question 2

Query Conditions: Discuss issues regarding the handling of conditions/operators

in a query. What are

some differences in handling different datatypes when including conditions/operators in a query?

In no more than 200 words, explain how different conditions/operators are used and there

implications.

Question 3

Cartesian Product: What is

a Cartesian product and why is it important? What are ways to prevent a

Cartesian product? When might you want to implement a Cartesian product?

In no more than 200 words, discuss the purp

ose of a a Cartesian Product and why it is important. Also

discuss why it should be avoided and how to accomplish that.

Question 1

Create your business model from your life or work. Your ERD should include no more than 5 entities for

simplicity. This can be in word format at this point and does not need to be in diagram format unless

that’s easier for you.

1) Business Rules

2) ER Model

3) Sample Data (2-3 rows for each entity)

Note: that in database design business rules would always be defined first and the ER model would be

based on these rules. So, try to write the rules first but it might be an iterative process!

Question 2

Query Conditions: Discuss issues regarding the handling of conditions/operators in a query. What are

some differences in handling different datatypes when including conditions/operators in a query?

In no more than 200 words, explain how different conditions/operators are used and there

implications.

Question 3

Cartesian Product: What is a Cartesian product and why is it important? What are ways to prevent a

Cartesian product? When might you want to implement a Cartesian product?

In no more than 200 words, discuss the purpose of a a Cartesian Product and why it is important. Also

discuss why it should be avoided and how to accomplish that.