DB Terminology
DB Techniques
 | Learn the uses of databases in modern business organizations. |
| Understand the terminology used in database design and management. |
| Learn the basic theory and techniques of database design and modeling. |
| Through practice, be able to design and develop a database management system from the initial planning phase through to the final implementation. |
| Experience the team approach to the phases of database design |
| each student will work on a different self-selected term-long project | ||||
| students are required to help each other by reviewing the work of classmates, making suggestions and actually changing a copy to improve/correct it | ||||
| work will be shared by posting it on a bulletin board | ||||
| grades derived from
|
Working knowledge of Windows, Microsoft (MS) Office, and MS Access
Comfort in taking a course over the Internet
A combination of required text
Database Systems: Design, Implementation, and Management, Fifth Edition
by
Peter Rob, Carlos Coronel, Course Technology 2002,
ISBN
061906269xoptionally other texts, and Internet websites.
Course
Direct gives you at least 10% off ($66.55) and they
provide a link to
complete Chapter 1 so you can start reading before the book arrives.
Software: Microsoft Word 2000, Microsoft Access 2000, Shareware Diagram Drawing Tool, SmartDraw
This course has multiple components, be sure to sample all of them, and then make the most use of the ones you find most helpful.
| the text |
| selected web sites |
| the message board |
| FAQs |
| Glossary |
| Self Tests |
(see UCC 1999-2001 catalog page 38)
Students are expected to uphold the school's standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the honor code if they:
-
Represent the work of others as their own.
-
Use or obtain unauthorized assistance in any academic work.
-
Give unauthorized assistance to other students.
-
Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.
-
Misrepresent the content of submitted work.
The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and may be subject to disciplinary action as described in the Student Handbook. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the instructor to discuss the situation.
General advice and interaction between students is encouraged. Each person, however, must develop his or her own solutions to the assigned homework and laboratory exercises. Students may not "work together" on graded assignments. Such collaboration constitutes cheating, unless it is a grouped assignment. A student may not use or copy (by any means) another's work (or portions of it) and represent it as his/her own. If you need help on an assignment, be sure to contact your instructor.
Get the book. Skim the book (Parts 1, 2 an 3 pages 1 to 210)
This is a chance to get comfortable with the message board. When to use compose message and when to use reply. Please read (study) the message board carefully because it makes the entire term more difficult for all students if you use it improperly.
| Become familiar with course site. |
| Go to the Message Board and Introduce Yourself. Respond to the introduction of 3 fellow students. If possible, respond to their responses, etc. |
Practice designing databases by naming the entities in several typical database systems:
| To identify and describe basic Entity Relationship (E-R) diagram components: entities, attributes, and relationships. |
| To develop data modeling skills. |
| To learn how to use business rules to develop the E-R diagram components. |
| To create E-R diagrams as database blueprints. |
| To interpret E-R diagrams. |
| To use SQL to implement a database from an E-R diagram. |