|
Database
Systems, (Internet-Based Delivery)
Department of Integrated Science and Technology | College of Science
Summer I 2016
Instructor
|
Brian M. Morgan
|
Office
|
Morrow 114
|
Phone Number
|
(304) 696-6469
|
Text Questions to |
(304) 634-6736 |
Office Hours
|
You can
email me with the Blackboard
Mail Tool or send an email to the address below. 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 May 16, 2016 and ends on August 5, 2016.
Please note that all times are Eastern.
Please
see the University
Academic Calendar for course withdrawal dates.
Course Materials and Cost
|
The
required textbook is the same one that will be used in the traditional,
classroom-based IST 365 course. The book is available in the Marshall
University Bookstore on the Huntington campus, or can be ordered online at http://www.marshall.bkstr.com/.
Database Systems Design, Implementation and Management (11th ed.), by Coronel and Morris; Course Technology; ISBN: 9781285196145, 2015.
The
book can be found at the Marshall
University bookstore and is approximately $269.25 (new), $202.00 (used), or $94.24 (rented).
- For minimum hardware/software requirements and student support information, please see:
http://www.marshall.edu/muonline/student-resources/
- Be sure to run the free web browser Tuneup:
https://en-us.help.blackboard.com/Learn/9.1_2014_04/Student/015_Browser_Support
- Academic Policies
http://www.marshall.edu/academic-affairs/policies/
- If you have technical problems, please go to the Help Desk:
http://www.marshall.edu/it/departments/it-service-desk/
- Help Desk Phone Numbers:
(304) 696-3200 ( Huntington , WV )
(304) 746-1969 ( Charleston , WV )
(877) 689-8638 (Toll free)
- Supplemental materials can be found contained within the Blackboard Learn environment (http://www.marshall.edu/muonline/). I will be sending class announcements, updates, etc. using your Blackboard account. Access to a WWW browser is required as is Adobe Acrobat Reader (available for download free from Marshall University's Computing Services software page at http://www.marshall.edu/it/services/availablesoftware/.
- 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://isat-cit.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).
- In this course,
you will be completing Entity Relationship Diagrams (ERDs) (homework
assignments, semester project deliverable #2, and some exam questions on Exam #2). For
ERD diagrams, you will need
Microsoft Visio 2013 (or later), which is available in nearly
all public campus computer labs or for free to students enrolled in IST
courses (see http://www.marshall.edu/isat/software/ for specifics). PLEASE ENSURE THIS SOFTWARE IS
INSTALLED BEFORE STARTING YOUR EXAMS/PROJECTS.
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 Blackboard, exams, homework assignments from
reading materials from the text, and a semester-based project. Students will participate
in various aspects of assessments 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:
Course Student Learning Outcomes |
How Practiced in this Course |
How Assessed in this Course |
Students will Identify problems for which database solutions are suitable |
In-class examples, discussions, Chapter 1 review questions |
Exam 1; Project Deliverable 1 |
Students will construct conceptual and logical data models based upon a set of information requirements |
In-class examples, discussions, Chapters 2, 3, and 4 review questions |
Homeworks 1, 2, and 3; Exams 1 and 2; Project Deliverable 2 |
Students will translate data model specifications for a relational database |
In-class examples, discussions, Chapters 3 and 4 review questions |
Homeworks 3 and 4; Exams 1 and 2; Project Deliverable 2 |
Students will discuss and show and understanding of the fundamentals of SQL |
In-class examples, discussions, Chapters 7 and 8 review questions |
Homework 5; Exam 3; Project Deliverable 3 |
Students will discuss the significance of database security and integrity |
In-class examples, discussions, Chapters 10, 11, 12, and 15 review questions |
Exam 4 |
Students will implement a database application using MySQL |
In-class examples, discussions |
Project Deliverable 3 |
Students will identify requirements for and analyze a problem, implement a solution for that problem, and verify their solution, using computer and information technology. |
In-class examples, discussions, Chapters 1 through 15 examples |
Project Deliverables 1, 2, and 3 |
Instruction method:
Students should read the lecture notes that are contained within Blackboard and read
the corresponding chapters from the textbook. Homework assignments, exams,
and project deliverables 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–120pts,
Exam 2–120pts, Exam 3–100pts, Exam 4-110pts)
|
450 points
|
5 Homework Assignments (equally
weighted)
|
150 points
|
Semester Project (Deliverable
1 – 100pts, Deliverable 2 – 150pts, Deliverable 3 – 150pts)
|
400 points
|
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,including any and all web 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:
895 - 1000 points
|
A
|
795 - 894 points
|
B
|
695 - 794 points
|
C
|
595 - 694 points
|
D
|
Less than 595 points
|
F
|
The
instructor reserves the right to change these values depending on the overall
class performance and/or extenuating circumstances.
There are FOUR exams worth 45% of your overall grade. The
first comes after Chapter 3’s content, the second after Chapter 6, the third
after Chapter 8, and the fourth after Chapter 15. 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 August 5, 2016. The exams are taken within
Blackboard
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
Course Schedule link within the Course Content section of the course. 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. Exams are, however, closed book and closed notes.
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 in Blackboard. 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 Blackboard Assignment Tool, and the description of each
project/assignment is currently found within
Blackboard's
Assignments Tool, linked to the course homepage. Please
do not procrastinate in working on your projects or trying to submit through
Blackboard
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 August 5, 2016.
The
Discussions tool within Blackboard will be used
to make any general announcements, last minute changes, etc. It is mandatory
that you monitor your Blackboard 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.
Because
this is an online course, there is absolutely no requirement that you come to
campus. You can communicate with me via the course's Discussion Board or via email.
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 August 5, 2016, 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 Blackboard. 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. Also, please note this is a highly suggested timeline to follow, but is not mandatory. The only mandatory date is the course completion date of August 5, 2016. All assignments and exams MUST be completed by this date
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.
Me: Do not hesitate to
contact me directly with questions or concerns. You can reach me via E-mail 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:
BRIAN
M. MORGAN, BS, MS
Chair and 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
Chair, Integrated Science and Technology Program,
Marshall
University
,
Huntington
,
WV
. (May
2012-Current).
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
|