|
Database
Management, (Internet-Based Delivery)
Department of Computer and Information Technology | College of Science
Fall 2017
Instructor
|
Brian M. Morgan
|
Office
|
Morrow 114
|
Phone Number
|
(304) 696-6469
|
Text Questions to |
(304) 634-6736 |
Office Hours
|
You can
email me by sending an email to the address below.
|
E-Mail
|
brian.morgan@marshall.edu
|
This
course begins on August 21, 2017 and ends on December 15, 2017.
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 CIT 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 (12th ed.), by Coronel and Morris; Course Technology; ISBN: 978-1-305-62748-2, 2017.
The
book can be found at the Marshall
University bookstore and is approximately $254.75 (new) or $191.25 (used) with rental optionals available.
- 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/cit365/
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 2016 (or similar product), which is available in nearly
all public campus computer labs or for free to students enrolled in CIT
courses (see http://www.marshall.edu/cos/software/ for specifics) or alternatively, you can use LucidChart, also free (https://www.lucidchart.com/pages/usecase/education-request) . 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, 4, and 6 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, 4, and 6 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 9, 10, 12, 13, and 16 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 16 (minus chapters 5, 11, 14, and 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 16. 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 15, 2017. 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 2 hours 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 December 15, 2017.
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 December 15, 2017, 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 December 15, 2017. 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 work and research effort is required of the student, especially since the technologies/practices used in the course build upon each other. With programming, you cannot start learning the different languages we will be using at different tiers without practice. This means you may have to play around with in-class examples, experimenting to see if something you are curious about really works like you think, doing further research on topics of interest, and so on. Programming courses can be notorious time eaters. Occasionally, a problem with code will take large amounts of time to locate and fix.
For every one hour in class, the student is expected to put in an effort of at least 2-3 hours outside the class for studying and completing assignments and projects. 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 have become very large problems in college classes, and is often a bad approach to life. Prioritize, schedule, and take responsibility for your actions and you should do very well in this class. Starting early enough so that you have time to ask me questions when you run into problems can help with this (why spend 4 hours struggling with a frustrating roadblock the night before the assignment is due, when you can spend 10 minutes composing an e-mail early in the week, work on other problems while waiting for the answer, and then get a reply that makes everything clearer as soon as you read it?)
A Successful Student will:
- Attend every lecture
- Participate in class (asking questions, paying attention, taking notes, being attentive)
- Complete reading assignments in a timely fashion.
- Practice and "play" with posted examples.
- Ask specific questions -- in class, in lab, in office-hours, and in e-mail
- Read through each homework assignment as soon as it is posted
- Start working on each homework assignment early
- E-mail me with specific homework-related questions starting early in the week both to clarify what a question is asking for and when hitting roadblocks (being sure to include both the code involved and any error messages or descriptions of odd behavior)
- Always submit SOMETHING for an assignment, even if it is not complete
- Study with others for exams, practice explaining concepts to one another.
- Attempt every exam problem, and carefully study exams when they are returned.
- Practice programming at the different levels as much as possible
You are encouraged to ask me questions in class, in office hours, and by e-mail. The most successful students are those who are not afraid to ask questions early and often, who do the assigned reading, who attend lecture regularly, who start homework promptly after the required topics are covered in lecture, and who practice course concepts as much as possible.
It is better to ask a question sooner than later -- for example, it is better to send an e-mail with a specific question as soon as you think of it than it is to wait a day or two until the next class meeting or office hour. If you wait to ask such questions, you may not have time to complete an assignment. It is not a problem if you end up sending me several questions in separate e-mails (as you work on different parts of a project while awaiting earlier answers). That being said, I expect you to ask specific questions as overly vague or broad questions are very problematic. An example of an overly vague or broad question is: "Here's my assignment. Is it right?” I will not simply tell you if something is right. Be specific.
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
Professor, Computer and Information
Technology
Marshall University
Brian
Morgan is a resident of Chesapeake, 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
Professor, Computer and Information Technology,
Marshall
University
,
Huntington
,
WV
. (May 2017 - Present)
.
Chair, Computer and Information Technology Department,
Marshall
University
,
Huntington
,
WV
. (July 2016 - Present).
Associate
Professor, Computer and Information Technology,
Marshall
University
,
Huntington
,
WV
. (July 2016 - May 2017).
Chair, Integrated Science and Technology Program,
Marshall
University
,
Huntington
,
WV
. (May
2012-June 2016).
Associate
Professor, Integrated Science and Technology Program,
Marshall
University, Huntington,
WV
. (May
2008-June 2016).
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
|