Database Systems

Home Syllabus Schedule Resources Extensions Contact

 

Course Number and Title: IT320 Database Systems

Credit Hours: 6 Qtr

Course Prerequisites: 100/200 level database or programming course

Instructor Name and Credentials: Mark Bromwich

Instructor Contact Information: mabromwich@hamiltoncf.com

Course Materials: Rob, Coronel, (6 th ) Database Systems: Design, Implementation, and Management . Thomson Learning, 2004

Course Day and Time: Thursday evenings from 6:00 PM to 9:45 PM.

Course Description:

This course provides practical instruction in business database requirements, design and management with particular emphasis on the use of relational database systems.

Program Outcomes:

The graduate of the Bachelor of Science degree in Management with concentration in Management of Information Systems shall be able to:

  1. Organize and communicate thoughts, ideas, and information to create effective and efficient communication skills through written documents and verbal presentations.
  2. Use critical thinking skills to assess new situations and develop further skills for lifelong learning.
  3. Demonstrate the ability to solve mathematical problems.
  4. Analyze and resolve complex business issues utilizing a decision-making process.
  5. Identify, research and evaluate the alternatives in terms of operational, strategic, and business situations.
  6. Function effectively in a group environment utilizing conflict resolution techniques.
  7. Analyze business and productivity systems requirements in terms of the various affected stakeholders and specify IT solutions to assist in pursuing strategic objectives.
  8. Evaluate and recommend alternatives for data communication, storage retrieval and security in a modern business environment.
  9. Consider the impact of technology in terms of the human factors in productivity systems including such issues as ethics, privacy, and fair use.

Course Outcomes:

Upon completion of this course, students will be able to:

  1. Compare relational database designs to other modern and historical approaches.
  2. Evaluate table designs to produce the required degree of normalization.
  3. Formulate queries in a high level query language to retrieve and manipulate data.
  4. Interpret business requirements and relate them to table design.
  5. Illustrate data collection and movement with data flow and entity-relationship diagrams.

Learning Activities:

Learning activities include lectures, homework assignments, quizzes, hands-on labs and group project. Attendance and class participation are very important. Students will be given the opportunity to take a real world problem and implement the solution for that.

Outside of Class Learning Activities:

1. Students will complete a database implementation. During the course, students will produce four documents:
•  A written description of the database you plan to implement. This should be considered a design document for the project. 2 pages minimum.
•  An ER diagram for the database.
•  A Normalized ER Diagram
•  A completed database that expresses your chosen topic.
2. During the course, datasets will be provided against which to write queries.

Course Evaluation:
Mid-term examination : 22.5% 1 x 45
Final Examination : 22.5% 1 x 45
Quizzes (2 * 5%) : 20% 2 x 20
Database Presentation : 15% 1 x 30
Class work and participation : 20% 2 x 20
-----------
200 points

Participation and Professionalism are part of each student's grade. As an educational institution designed to help students acquire and maintain viable employment, we strive to teach professionalism to our students. To be professional, a sense of responsibility and accountability must be displayed. Each student is expected to:
•  Arrive on time to each class session.
•  Be prepared for each class session.
•  Complete all assigned work on time.
•  Participate in each class session.
•  Show respect for diversity of people, opinions and cultures.
•  Dress appropriately for an academic setting.
•  Turn off cell phones, pagers and other distracting devices during class.
•  Not engage in disruptive behavior in the classroom including arguments, quarreling, or fighting.
•  Treat all persons at Hamilton College , whether fellow students, administrative staff or faculty, with the same respect and understanding they would like to receive.
•  Not display behavior, speech, or body language that would make anyone feel threatened.
•  Refrain from using profane, offensive or inflammatory language.

Late work policy:

  • Missed class work and participation points cannot be made up, unless discussed with instructor.
  • Missed written quizzes and midterm tests will be in the library for one week. You may make them up before the class period one week after the test or quiz at a reduction of 10%. After that time, they may not be made up because all quizzes and tests will be handed back and reviewed one week after they are taken.
  • The final exam may not be made up.

Attendance:

All Hamilton College students are expected to attend every scheduled class session and exam. If you experience a conflict or illness, you are expected to contact your instructor prior to the absence. If your first absence is not documented, you will receive an e-mail, postcard or call from your instructor. If you miss two or more class sessions, you will be contacted by a Hamilton administrator or academic advisor. If you miss more than a 10-day period, you will risk withdrawal and potential financial implications. Please bring any unavoidable conflicts or absences to the attention of your instructors and advisors immediately so we can assist you in your academic success.

Cheating and Plagiarism:

Policies will be enforced in accordance with the academic “Conduct” section in the current Hamilton College catalog.

Hamilton College Grading Scale : Students at Hamilton receive grades based on course participation, course assessment, written papers, presentations, and projects. The following grading system is in effect:

Grade

Scale

Points

 

Grade

Scale

Points

 

Grade

Scale

Points

A

93% - 100%

4.0

 

D+

67% - 69%

1.3

 

CC

Clep Credit

N/A

A-

90% - 92%

3.7

 

D

60% - 66%

1.0

 

EC

Experient. Credit

N/A

B+

87% - 89%

3.3

 

F

0% - 59%

0.0

 

I

Incomplete

N/A

B

83% - 86%

3.0

 

W

withdrawal

N/A

 

P

Pass

N/A

B-

80% - 82%

2.7

 

WP

withdrawal pass

N/A

 

S

Satisfactory

N/A

C+

77% - 79%

2.3

 

WF

withdrawal fail

0.0

 

U

Unsatisfactory

N/A

C

73% - 76%

2.0

 

No Grade

 

N/A

 

TC

Transfer Credit

N/A

C-

70% - 72%

1.7

 

AU

Audit

N/A

 

R

Repeat

N/A

Instructor's Comments:

There are 10 principle aims to this course:
•  Learning how relational databases are designed.
•  Creating Entity Relationship diagrams and using other documentation and design methods.
•  Normalization, including converting flat files into relational databases.
•  Learning to write freeform queries.
•  Database management principles.
•  The uses of databases in industry.
•  Emerging databases methods.
•  Data management strategies.

We will use a variety of methods to achieve our objectives including lectures, discussions, computer assignments and independent projects. Substantial outside study may be required, and some homework will be needed to allow students to participate fully in class assignments.

Library Resources:

Use of the library is encouraged. You may need to use other libraries as well, along with the Internet, the EBSCO database and field resources to complete the research presentation assignment.

Academic Success Center :

Students who find they are falling behind in classes who need some assistance with time management, need a little extra help with an assignment or project for class, or need someone to proofread compositions should make an appointment with an Academic Success Center staff member. Instructors may make a formal referral to the Academic Success Center if they feel that a student needs additional assistance and support in any subject area. The Academic Success Center Director will follow up with students when such a referral is made. Services are free, and there are many software resources available as well.

 
Home        Courses        Interaction        Resources        Grades        Contact