Database Design and Development
CIT
320 Database I, Summer 2008
Prerequisites: IS 203
|
Faculty Name: |
|
Michael
J McLaughlin, D.CS. Computer Information Technology Department Schedule: Office,
Office Hours Email: mclaughlinm@byui.edu |
Textbook
The class will make extensive use of the assigned textbook
and slides and supplemental note web pages. The web pages can be accessed at
the bottom of this syllabus. Most multiple choice and true/false quiz/exam
questions will be based on topics presented in the slides or text book.
Questions may also be based on lab assignments.
The quiz/exam review questions are drawn from Oracle
SQL by Example, lecture, and lab. The following are assigned and
recommended textbooks:
Learning SQL, A. Beaulieu, 2005, ISBN
0-596-00727-2
[OPTIONAL] Mastering
Oracle SQL,
ISBN 0-596-00632-7
You may use the Learning SQL in the two exams but
not the final. You may include margin notes in the text and feel free to print and
take a copy of the syllabus with you to the testing center. Do not use sticky
notes because they’re not allowed in the testing center. There is a comprehensive final exam. No other material should accompany
you into the testing center.
Course
Description
The
course deals with concepts and principles of database theory, application and
management technologies. It focuses on the logical and physical database design
and implementation. The course covers the use of UML semantic to describe
entity-relationship designs (ERDs) and SQL to implement relationships between
entities. SQL will be used to query and transact against a sample database.
Course
Objectives
Database
Management Systems Goal (20% of course)l
·
Obtain
a database overview: history, environment and development.
·
Understand
how a database management system works.
Database
Modeling Goal (20% of course)
·
Learn
fundamental modeling concepts in different symbolic representations.
·
Analyze
modeling concepts, including normalization and binary relationships.
Database
Programming Goal (60% of course)
·
Introduce
the structured query language (SQL) and develop basic proficiency in SQL.
·
Demonstrate
the ability to build a well-designed database structure (schema).
Course Requirements
Classes will be held on all scheduled days except those
covered below and designated school holidays. Arrangements will be made to make
the classroom available for any lab activities scheduled for these days. Concurrent enrollment in the lab section is
required.
|
Date |
Purpose |
|
5/13-16/2008 |
Chicago Internship Trip |
Course syllabus, outline, quiz bank questions and
supplemental materials are or will be posted
on http://emp.byui.edu/mclaughlinm
web page where possible. All lab assignments will be found on the web site, and
you should review them before coming to lab.
Materials for the course are
organized as noted below:
|
Item |
Location |
|
Textbook |
Course Syllabus |
|
Class Schedule |
Course Outline |
|
Assignments |
Course Syllabus |
|
Labs |
Accessible from Instructor’s Home
Page |
|
Aids |
Accessible from Instructor’s Home
Page |
|
Quiz/Exam Bank Questions |
Accessible from Instructor’s Home
Page |
Assignments
All quiz and exam grades will be posted on the
|
Assignment |
Due Date |
Bubblesheet |
Write-on |
Total |
Group Points |
Composition |
|
Exams: |
|
|
|
|
500 |
60% |
|
Exam #1 Text – 1, 2, 3, 4,
13 Quiz banks – 1, 2,
3, 4 |
27 May 2008 thru 29 May 2008 |
100 |
50 |
150 |
|
|
|
Exam #2 Text – 5, 6, 7, 8,
9, 10, 11 Quiz banks – 5, 6,
7, 8 |
1 Jun 2008 thru 3 Jun 2008 |
100 |
50 |
150 |
|
|
|
Comprehensive Final
Exam Text – All previously
covered Quiz banks – All
plus whys |
16 Jul 2008 thru 18 Jul 2008 |
100 |
100 |
200 |
|
|
|
Lab Assignments: |
|
|
|
|
350 |
35% |
|
Lab #1 |
2 May 2008 |
25 |
|
|
|
|
|
Lab #2 |
9 May 2008 |
25 |
|
|
|
|
|
Lab #3 |
16 May 2008 |
25 |
|
|
|
|
|
Lab #4 |
23 May 2008 |
25 |
|
|
|
|
|
Lab #5 |
30 May 2008 |
50 |
|
|
|
|
|
Lab #6 (3 week
duration) |
20 Jun 2008 |
100 |
|
|
|
|
|
Lab #7 (Dependency Lab 6) |
2 Jul 2008 |
75 |
|
|
|
|
|
Lab #8 (Dependency Lab 7) |
11 Jul 2008 |
75 |
|
|
|
|
|
Participation: |
|
|
|
|
100 |
35% |
|
Total |
|
|
|
|
1,000 |
100% |
All reading is due at the beginning of the week as noted in the
class outline. Lectures assume you have done the reading. You should also read lab assignments
before coming to the lab each week.
The instructor provides a few minutes
during the beginning of class to answer questions on course content and
material. It is the student’s responsibility to review the material, prepare
and ask questions. The
student will need to work in the BYU-Idaho laboratory on the Oracle database or
install a copy of the Oracle Database 10g Express Edition (available on
Blackboard or from the www.oracle.com web
site) on their personal computer. Hands-on knowledge can only be developed by
doing the exercises and labs in an Oracle environment.
All class administration will be
covered at the beginning of each meeting. If you are late, it is your
responsibility to get the information from a classmate or visit my office
during posted office hours or by arrangement.
The
details of the assignments and class policies are:
Lab
Assignments
The
lab assignments develop programming knowledge of using SQL in an Oracle dialect.
The labs are supported by the exercises in the Oracle SQL by Example
textbook. The best preparation is to complete all exercises and
problems found in the Oracle SQL by Example reading assignments. The exercises in the book are assigned as homework, they are
not graded directly but completing them is critical to your success in the
course. As stated by Elder Bednar, students should be enabled to
act not be acted upon (Seek
Learning by Faith). Objectives are noted on each lab assignment.
Exams
Exams
have 50 questions. Most are multiple choice and true/false questions and will
be modeled on the quiz/exam review notes posted on the instructor’s web pages.
The final exam has 25 multiple choice and 10 short essay questions. Questions
may be taken from any textbook, lecture and lab. The questions check your exposure to concepts, SQL syntax and problem
solving developed by attending class, reading the book and doing the assigned
exercises found in the textbook and labs.
All
referenced material including HTML links to external web sites are considered supplemental
material. A few questions may be drawn from supplemental material and/or
require integration of concepts. Careful reading and active participation in
lecture are the best preparation for the exams.
Exams
are scheduled in the testing center. All exam grades are posted on the
Exams
are open book only, cover the material indicated, and are scheduled as noted in
the previously referenced table.
If you
are unable to take a scheduled exam or quiz because of a qualifying emergency,
you must notify the instructor by email no later than the Wednesday of that
week. A qualifying emergency includes serious illness, personal injury, death
of an immediate family member, et cetera.
If you
miss a scheduled exam or quiz for reasons
other than a qualifying emergency, you lose the opportunity to earn
those points. Exams are 65% of your course grade. You are responsible for your
education and should use the course to help develop skills that will help you
in the job market or graduate school.
Grades
The
following shows the grading matrix for the course:
|
Grade |
At or above |
Below |
|
A |
93% |
100% |
|
A- |
90% |
93% |
|
B+ |
87% |
90% |
|
B |
83% |
87% |
|
B- |
80% |
83% |
|
C+ |
77% |
80% |
|
C |