Docstoc

Assignments

Document Sample
Assignments Powered By Docstoc
					                                             ITT
                                    Course Assignments
                          Database Design and Implementation CS330
Assignments

Assignments are to be emailed to chris.wagner@expertpcpros.com by the start of class when
assignments are due. You may work ahead but you will not be allowed to fall behind. Any assignments
not received on or before the due date will receive a score of “0”. Textbooks are allowed to complete all
assignments. You are allowed to collaborate with other students on Assignments, but copying is not
allowed. Copying will result in 0’s being assigned to each student with out regard to “who copied from
who”.

Assignment 1.1:
1. Complete Review Questions 1.1, 1.2, 1.3, 1.6, and 1.7 on page 34 of the textbook.
2. Write a short paragraph comparing bottom-up and top-down database design approaches.
3. Complete Review Questions 2.1, 2.2, 2.3, 2.4, 2.8, and 2.9 on page 63 of the textbook.
4. Complete Exercise problem 2.10 on page 63 of the textbook.
5. Write a short paragraph explaining when you would use a composite key value as an entity’s primary key.

Submit your written answers to your instructor at the beginning of Unit 2.

Assignment 2.1:
1. Complete Review Questions 3.1-3.10 on page 93-94 of the textbook.
2. Complete Exercise 3.15 on page 94-95 of the textbook.
3. Write a paragraph comparing the 2NF and 3NF definitions based on primary keys to the general 2NF and
3NF definitions. Provide specific examples of each in your comparisons.
4. Research the Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form
(5NF). Write a brief description of each and when each might be used.

Submit your written answers to your instructor at the beginning of Unit 3.

Assignment 3.1:
1. Complete Exercise 5.15 on page 155 of the textbook.
2. Complete Exercises 5.22 and 5.23 on page 164 of the textbook. Format the solutions for both MySQL and
SQL Server use.
3. Write a short paragraph discussing table creation. Include the role of column names, data types, and
primary and foreign keys. Justify why some columns might allow NULL values.
4. Write a short paragraph comparing the roles of tables and views.

Submit your written answers to your instructor at the beginning of Unit 4.

Assignment 4.1:
1. Complete Exercises 6.3-6.6 on page 187 of the textbook.
2. Complete Exercises 7.2 and 7.3 on page 221 of the textbook.
3. Write a paragraph comparing inner and outer joins. Include each of the outer join types and why they
differ from a cross join.
4. Describe a situation where you might use a subquery as the data source in the FROM clause. Include
guidelines on whether or not you would need to specify a table pseudonym.
5. Compare using join conditions in the FROM clause versus using join CONDITIONS in the WHERE
clause. What are the advantages, if any? What are the requirements?
6. Compare including additional conditions in the WHERE clause and as part of the ON statement in the
FROM clause during a join.

Submit your written answers to your instructor at the beginning of Unit 5.

Assignment 5.1:
1. Write a short paragraph explaining the potential problems when using comparison operators on columns
that contain NULL values and how to avoid them.
2. Write a short paragraph comparing the use of EXISTS, ANY, and ALL with at least one example of each.
3. Complete Exercises 8.18 and 8.21 on page 297 of the textbook.
4. Complete Exercises 8.29 and 8.30 on page 311 of the textbook.
5. Complete Exercise 9.13 on page 395 of the textbook.

Submit your written answers to your instructor at the beginning of Unit 6.

Assignment 6.1:
1. Navigate to SQL Server 2005 Express Edition Books Online:
http://msdn.microsoft.com/en-us/library/ms165706(SQL.90).aspx and research supported data types.
How do these compare to the data types listed in the text? What additional data types, if any, are
included?
2. Write a paragraph comparing the use of primary, unique, and foreign key constraints.
3. Compare how referencing actions are supported by MySQL and SQL Server. Describe situations
where you might use each of the supported actions.
4. Complete exercises 10.3 and 10.4 on page 415.
5. Write a paragraph describing when you would want to copy rows from two tables, as a join, into a
temporary table. Provide a sample SQL statement in MySQL syntax that could accomplish this.

Submit your written answers to your instructor at the beginning of Unit 7.

Assignment 7.1:
Complete the following assignments in short but complete paragraphs.
1. Compare using a clustered or non-clustered index to improve performance when retrieving values in a
specific order. Indicate which is more efficient and why.
2. Compare and contrast default database data storage organization and b-tree index organization.
3. Describe how a view can be used to create a virtual denormalized table from two or more normalized
tables.
4. Explain why some views cannot support data modification.

Submit your written answers to your instructor at the beginning of Unit 8.

Assignment 8.1:
1. Write a short paragraph describing the advantages of using stored procedures. Include explanations of
how parameters and flow-control statements help to make stored procedures more useful.
2. Write a paragraph comparing the use of stored procedures, functions, and triggers. Include a practical
example of when you might use each in a database application.
3. Write a scalar function that accepts a two-digit state abbreviation and returns a count of that state's
occurrences in a table named Customer.
4. Describe a situation where it would be necessary to use a trigger as an integrity constraint.

Submit your written answers to your instructor at the beginning of Unit 9.

Assignment 9.1:

1. Complete Exercise 17.2 on page 583 of the textbook.
2. Write a short paragraph comparing and contrasting the standard isolation levels.
3. Write a paragraph comparing data allocation methods for distributed database environments. Include
a scenario where each would be appropriate.

Submit your written answers to your instructor at the beginning of Unit 9.

Assignment 10.1:

1. Complete Self Review Exercises 19.2 and 19.3 on page 665 in the textbook.
2. Write a short paragraph explaining the use of CDATA sections in your own words. Include at least
two examples where you might use a CDATA section.
3. Complete Self Review 20.1 and 20.2 on page 695 in the textbook.
4. Write a short paragraph justifying the use of schemas when designing business-to-business
applications.
5. Describe how XPath represents an XML document.

Submit your written answers to your instructor at the beginning of Unit 9.

Extra Credit
The total amount of Extra Credit that will be awarded for this course can not exceed 10% of the total
grade. Every lab, assignment and the Course Project offers the opportunity for extra credit.

In many of the labs, assignments, and the Course Project there is not one single answer that is
considered “correct”. Many answers are acceptable as long as they answer the question. Going above
and beyond in answering a question or providing a solution that is more elegant than provided by the
text will result in awarding of extra credit of up to the value of the assignment or lab.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:9/25/2011
language:English
pages:3