Syllabus: IST 365

Database Systems, (Internet-Based Delivery)
Department of Integrated Science and Technology | College of Science
Fall 2008

Instructor

Brian M. Morgan

Office

Morrow 104

Phone Number

(304) 696-6469

Fax Number

(304) 696-6533

Office Hours

You can email me with the VISTA Mail Tool or use the Who's Online tool. Should you ever find yourself on campus during the semester, you can also look me up in person.

E-Mail

brian.morgan@marshall.edu

This course begins on August 25, 2008 and ends on December 16, 2008.

Please note that all times are Eastern.


Please see the University Academic Calendar for course withdrawal dates.

Course Materials and Cost

The following textbook is required for the course:

Database Systems Design, Implementation and Management (8th ed.), by Rob and Coronel; Course Technology; ISBN:  1-4239-0201-7, 2009..

The book can be found at the Marshall University bookstore and is approximately $137.50.

Technical Requirements

  • Supplemental materials can be found contained within the Blackboard Vista environment (http://www.marshall.edu/muonline/). I will be sending class announcements, updates, etc. using your Blackboard Vista account. Access to a WWW browser is required (Internet Explorer 7.0 or higher or FireFox 2.0 or higher) and Adobe Acrobat Reader (available for download free from Marshall University's Computing Services download page at http://www.marshall.edu/computing/). You will also be using an online interface to a mySQL server to complete your semester project (project deliverable 3). The server is located at http://ist.marshall.edu/ist365/ and your login username and password are both your MUNet login ID (not your 901 number – the first part of your e-mail address). The first time you login, you should change the password.
  • In this course, you will be completing Entity Relationship Diagrams (ERDs) (homework assignments, semester project deliverable #2, and even exam questions). For ERD diagrams, you will need Microsoft Visio 2003 or Visio 2007. This software is available for free to those enrolled in IST courses through our Microsoft Agreement (MSDNAA). Please see http://www.marshall.edu/isat/msdn.asp for access information.  PLEASE ENSURE THIS SOFTWARE IS INSTALLED BEFORE STARTING YOUR EXAMS/PROJECTS.

 

Course Details

Course Description:
Covers the logical and physical structures of data stored and retrieved from a relational database. Exposure to distributed databases, database administration and structured query language will also be provided.


Credit:
The course is three (3) credit hours. It includes lecture notes in Vista, exams, homework assignments from reading materials from the text, and a semester-based project. Students will participate in various aspects of projects that illustrate the implementation of concepts in general applications. 

Pre/co-requisites:
None.

Desired Objectives/Outcomes:
By the end of this course, you should be able to:

  • Identify problems for which database solutions are suitable
  • Construct conceptual and logical data models based upon a set of information requirements
  • Translate data model specifications for a relational database
  • Discuss and show and understanding of the fundamentals of SQL
  • Discuss the significance of database security and integrity
  • Implement a database application using mySQL

 

Course Grading

Instruction method:
Students should read the lecture notes that are contained within Vista and read the corresponding chapters from the textbook. Homework assignments, exams, and projects covering major topics are part of the course. Students may work on their assignments/projects from home with an Internet connection.

Evaluation method:
Evaluation of student's performance will be based on the quality of your performance on projects, homework assignments, and exams.  

Grading Policy:
Final grades are based on performance on projects and a final exam as indicated below.

4 in-class Exams (Exam 1–11%, Exam 2–11%, Exam 3–9%, Exam 4-11%)

42%

Final Exam

18%

Homework Assignments (equally weighted)

15%

Semester Project (Deliverable 1 – 7%, Deliverable 2 – 8%, Deliver 3 – 10%),

25%

Assessment of Projects:

The grading of all homework assignments and projects will take into account:

1.      Although the most important attribute of an assignment is correctness, grading will take into consideration efficiency, documentation, etc.

2.      Although interactions with other students are encouraged, you must compose your own answers, unless otherwise noted.

 

Individuals who utilize other people’s thoughts or ideas must provide appropriate references to said resources. Failure to provide such documentation will result in a failing grade for the assignment, and may result in a failing grade for the course.

Final letter grades are determined based on the following grading scale:

90-100%

A

80-89%

B

70-79%

C

60-69%

D

Below 60

F

The instructor reserves the right to change these values depending on the overall class performance and/or extenuating circumstances.

Exams and Quizzes

There are FIVE exams worth 60% of your overall grade. The first comes after Chapter 3’s content, the second after Chapter 5, the third after Chapter 8, the fourth after Chapter 13 and a comprehensive Final exam. The exams can be taken at any time once you have completed the reading and homework for the chapters listed herein, but all exams must be completed before the end of the day on December 16, 2008. The exams are taken within Vista through the Assessments tool, whose link can be found on the course’s homepage. A schedule of when you should take each exam is found under the Schedule link on the course's homepage. A proctor will not be required for any of the exams, nor will any other special arrangements be required other than access to a computer with Internet access for a minimum of 1 hour for each exam (2 hours for the final exam). Exams are, however, closed book.

Projects

The course includes a number of projects. All projects should be completed by the suggested due date that is listed within the course schedule link on the course’s homepage here in Vista. By doing so, you will ensure that you will complete the course on-time without having to be rushed at the end of the semester. All projects must be submitted through the Vista Assignment Tool, and the description of each project/assignment is currently found within Vista's Assignments Tool, linked to the course homepage. Please do not procrastinate in working on your projects or trying to submit through Vista as many others have done in the past. If you wait until the last night to start on the project or the last minute to submit, chances are, you will fail. As with the exams, all projects must be completed and submitted by the end of the day on December 16, 2008.

Discussions

The Discussions tool within Vista will be used to make any general announcements, last minute changes, etc. It is mandatory that you monitor your Vista course messages at least once a day. You as a student can also use the discussions tool to post any questions/comments that you have about the course content, projects, specifics of what is to be done, etc.

On-Campus Requirements

Because this is an online course, there is absolutely no requirement that you come to campus. You can communicate with me via the course Mail tool or the Who's Online tool.

Course Policies

My Academic Honesty Policy

Academic Dishonesty is defined as any act of a dishonorable nature which gives the student engaged in it an unfair advantage over others engaged in the same or similar course of study and which, if known to the classroom instructor in such course of study, would be prohibited. Academic Dishonesty will not be tolerated as these actions are fundamentally opposed to "assuring the integrity of the curriculum through the maintenance of rigorous standards and high expectations for student learning and performance" as described in Marshall University's Statement of Philosophy.

If you are found cheating on projects or plagiarizing answers from the Internet or other sources (among other things), there will be no second chance. Your penalty is that you will receive a failing grade for the course. In those cases in which the offense is particularly flagrant or where there are other aggravating circumstances, additional, non-academic, sanctions may be pursued through the Office of Judicial Affairs. Notice of an act of academic dishonesty will be reported to the Department Chair, Dean of the College of Science, and to the Office of Academic Affairs. Please refer to the Marshall University Undergraduate Catalog for a full definition of academic dishonesty.

Make-up Exams and Late Penalty: No make-up exams will be given after December 16, 2008, except under unusual circumstances and satisfactory written justification. Any student who fails to complete the exams and projects by this date due to an unexcused reason will receive a grade of zero for that assessment with no opportunity for make-up or substitution. The decision whether to give a make-up exam rests with the instructor.

Withdrawal Policy: The University withdrawal policy is followed in this course.

Topics and Methodologies / Schedule

A detailed schedule of topics covered in this course can be found under the schedule link on the course homepage in Vista. Please refer to this schedule as it contains the suggested dates for which you should read over the notes, complete the course projects, and the final exam.

For each topic discussed in the notes, specific experience of other students and the instructor will be posted to the discussions forum to enhance the characteristics involved. Projects for the course will be based on creating a fully-functional database solution for a sample application.

Effort Required:
As a 300-level course, a considerable amount of development and research effort is required of the student. Students are expected to put in an effort of at least 10 hours per week studying, trying examples, and programming. Upon background and preparedness, some students may have to put in additional effort. Please do not procrastinate. Procrastination and the placing of blame on other factors than yourself has become very large problems for college students. Prioritize, schedule, and take responsibility for your actions and you should do very well in this class.

Resources

Me: Don't hesitate to contact me directly with questions or concerns. You can reach me through the VISTA Mail Tool or if necessary by phone at (304) 696-6469. Please don't let your questions hang out there and simmer. If you are not sure about something the best thing to do is to ask about it right away! Something that may seem obvious to me may not be obvious to you at all! I answer e-mails every evening before going to bed, so if you do not hear from me within 24 hours of sending your message, it may not have reached me.

Support Services
Marshall University offers a variety of support services to students enrolled in online courses:

About Me - Biography

BRIAN M. MORGAN, BS, MS

Associate Professor, Integrated Science and Technology
Marshall
University

Brian Morgan is a resident of Proctorville, OH and holds a Bachelor of Science degree in Computer Science from Marshall University and a Master of Science Degree in Technology Management from the Marshall University Graduate College.

Professional Experience

Associate Professor, Integrated Science and Technology Program, Marshall University, Huntington, WV. (May 2008-Current).

Assistant Professor, Integrated Science and Technology Program, Marshall University, Huntington, WV. (July 2000-May 2008).

Director, Center for Instructional Technology, Marshall University, Huntington, WV. (October 1997-June 2000). Responsible for everyday duties of the Center, as well as managing Instructional Technology and World Wide Web Development on both the Huntington and South Charleston campuses of Marshall University, and coordinating faculty and staff IT development training programs.

Part-Time Faculty, Marshall University Community and Technical College, Huntington, WV. (August 1997-Current). Have taught Computer Technology 107, 107E, and 108; Information Technology 107E, and have designed the electronic versions of Computer Technology 107E and Information Technology 107E.

Instructional Technologist, Marshall University, Huntington, WV. (November 1996-October 1997). Responsible for working with Information Technology staff and faculty from a variety of disciplines on the selection and production of CD-ROM-based and WWW-based multimedia instructional materials, assist faculty and staff, through training and consulting, in integrating computing and information resources into the curriculum, track current and emerging Internet and development technologies, and aid in the progression and completion of technology grants. I have created distributable Computer Based Training modules for both Distance Education and Faculty Training, as well as worked with several Internet course creation tools for placing classes "on-line."

Computer Programming, Marshall University College of Liberal Arts and College of Science, Huntington, WV. (April 1996-May 1997). Responsible for developing and programming multimedia tutorial programs for the University as well as programming multimedia modeling software for science laboratory courses.

Computer Programming and Research, NASA and National Science Foundation Grant through Marshall University, Huntington, WV. (Spring 1996-Fall 1996). Responsible for developing and programming lecture-room demonstration educational project programs through a NASA and NSF grant for Marshall University.


Marshall University