Internet Explorer 7, 8, and 9 are no longer supported. Please use a newer browser.
Concourse works best with JavaScript enabled.
University of West Georgia logo

Main Campus · Richards College of Business · Management

Data Resr Management & Design
CISM-3340

  • Fall 2020
  • Section 01D
  • 3 Credits
  • 08/12/2020 to 12/05/2020
  • Modified 08/09/2020

Description

Application of development tools and languages (e.g., DBMS, Visual Basic, etc.) for business problem solving in a database environment.

Requisites

Prerequisites:
CISM 3335 Minimum Grade: C and Richards Col Upper Division RCUD
Corequisites:

Contact Information

Professor: Dr. Joan Deng

Online Office Hours

T  01:00 PM – 03:30 PM; W 10:00 AM – 11:00 AM, 12:30 PM – 02:00 PM

(Join from PC, Mac, Linux, iOS or Android: https://zoom.us/j/365290896

Or Telephone: (408) 638 0986 or (646) 558 8665

Meeting ID: 365 290 896)

Meeting Times

Materials

Database Concepts

  • Author: David Kroenke, David Auer, Scott Vandenberg, and Robert Yoder
  • Publisher: Prentice Hall
  • Edition: 8/E
  • ISBN: ISBN-10: 013460153X, ISBN-13: 978-0134601533
  • Availability: Campus Bookstore

Additional readings will be posted on CourseDen.

Software

You must have access to the following software.

* To download software from Microsoft Azure, please login using your UWG email address and password, then type education in the Search box at the top of the screen, select Education (Preview), click Software, and you will find the required software in a list of software packages.

  • Availability: MILLER HALL computer labs

Outcomes

Evaluation

Criteria

Grading Item

Maximum Points

Database Project (Individual Student Grade)1

65

Assignment #1

15

Assignment #2

20

Assignment #3

35

Assignment #4

15

Assignment #5

20

In-Class Group Work Participation

(Individual Student Grade)2

20

Quizzes

30

Total

220

1 Database Project Grading

Database Project Group Grade (max of 65 points)

5          Deliverable #1 (Proposal)         

10        Deliverable #2 (Conceptual Design)

10        Deliverable #3 (Logical Design)

30        Deliverable #4 (Final Report)

10        Presentation

Database Project Individual Student Grade (max of 65 points)

(Database Project Peer Evaluation Grade /10) * Database Project Group Grade

2 In-Class Group Work Participation Grading

In-Class Exercises Group Grade (max of 20 points)

20        The group completed all the required in-class exercises & presentations

10        The group had one absence

0          The group had two or more absences

In-Class Group Work Participation Individual Student Grade (max of 20 points)

(In-Class Group Work Peer Evaluation Grade /10) * In-Class Exercises Group Grade

Breakdown

Resulting grade and related performance levels
Grade Range Notes
A 198 and above
B 176 – 197.999
C 154 – 175.999
D 132 – 153.999
F 131.999 and below

Assignments

Individual Assignments:

There are five individual assignments. They are not group assignments. They are made available on the first day of class. All assignments must be submitted through the Assignment Submission Folders on CourseDen. No additions or corrections will be accepted once assignments have been submitted for grading.  Assignment due dates are specified in the course calendar in CourseDen. All assignments are due at 05:30 PM on the days they are due.  Late assignments will be accepted up to only one day later.  There is a 20% penalty assessed against late assignments that are unexcused. Assignments not turned in by 05:30 PM the day after the due date will be marked MISSED and will not receive any credit. All assignments must be reviewed within one week of their return during class or when grades are posted, whichever is later.

NOTE:  Good practices to adopt when using Lab computers is "Save and Save Often" and "Save to more than one place / media".

Group Project:

The group project will consist of designing and developing a database-system application.  The project will require you to analyze user requirements, develop and document a database design to support the user requirements, implement the database in SQL Server or Oracle Database Express Edition 11g Release 2, and finally implement the web-based database application for users to access the database.  Details of the project will be posted on CourseDen and discussed in class.  The group size is set to be 3-4 students, with a goal of building a functionally complete application by allocating appropriate manpower. Please note the same amount of work is still expected if your group is smaller than 3 people. Each group must submit your project application choice to me via email at [email protected] by the deadline specified in the course calendar in CourseDen.  

I suggest that you use Google Meet (https://meet.google.com/) to work with your group members on the database group project. Google Meet is a free video conferencing tool that allows a group of people to meet online, share screens and work together. You can find a quick start guide for Google Meet at this link: https://support.google.com/a/users/answer/9282720?hl=en .  

QUIZZES:

  • There are five quizzes, taken on-line, and open book.
  • Each quiz is limited to 15 minutes. You will only have one opportunity to take each quiz, once you start the quiz you are committed to finish.
  • All quizzes are due at 05:30PM (est) on the respective scheduled due dates (see the course calendar in CourseDen for specific dates).
  • Make up quizzes are not offered.

 

Schedule

Course Schedule will be posted in CourseDen. 

Course Policies and Resources

  • Students WILL receive individual e-mails concerning course updates and changes.
  • Students should check their UWG email accounts on a daily basis.
  • You are responsible to find out about any changes in due dates and course content.
  • As UWG e-mail is the official means of communication, only UWG issued e-mail addresses will be answered by the Professor. CourseDen mail is not utilized by the Professor (neither read nor answered).
  • Please be sure you have adequate space available in your UWG e-mail in box account, as only one attempt will be made to contact a valid UWG address.
  • I prefer to use the CourseDen discussion board for questions so the entire class can benefit from the answer. Before posting a question, make sure that you read through the questions and answers that have been posted on the discussion board. Often, you will find the answer to your question there. The discussion board is essential to this course. Please be sure to check it every day. Everyone can read the discussion forum postings; therefore, do not post private information. 
  • Please contact me directly through my UWG email ([email protected]) for anything that is confidential or private. All e-mails to the Professor are to be sent to [email protected]. If you would like to ask questions via email, please make sure you use CISM3340 as the subject line, so that I recognize that it is from one of you, and so that my spam filter do not accidentally delete your message. Emails will be answered within hours if not immediately. Although attempts will be made to reply as quickly as possible, you should not assume that all the emails sent after 10:00 PM or over the weekend will be replied on the same day. I REPLY TO ALL EMAILS. IF YOU DO NOT GET A REPLY WITHIN A 24-HOUR PERIOD, ASSUME I DID NOT RECEIVE IT AND PLEASE RESEND.

College/School Policies

Wolf Pact

Having read the Honor Code for the University of West Georgia, I understand and accept my responsibility to uphold the values described therein and to conduct myself in a manner that will reflect the values of UWG and the Richards College of Business so as to respect the rights of all UWG community members. As a UWG student, I will represent myself truthfully and complete all academic assignments honestly and within the parameters set by my instructor.

I understand and accept that if I am found guilty of violations (through processes due me as a UWG student and outlined in the UWG Student Handbook), penalties will be imposed.

I also recognize that my responsibility includes a willingness to confront members of the UWG community if I feel there has been a violation of the Honor Code.  

Ultimately, I will conduct myself in a manner that promotes UWG as the best place to work, learn, and succeed for my generation, and those to come!

About the Richards College of Business

Vision
To become a globally recognized college of business preparing forward-thinking, responsible leaders.

Mission
We are in the business of transforming lives through education, engagement, and experiences.

Strategic Goals and Values

Student Success
Admit quality students and provide them with an education that is rich in experiences and engagement opportunities to prepare them to be effective and ethical professionals.

Academic Success
Recruit, retain and develop faculty and staff by providing sufficient resources to support dynamic and up-to-date bachelor and master-level curricula, to conduct research and other professional activities, and to support engagement with all stakeholders.

Operational Success
Recruit, retain and develop administrative management and staff personnel to manage, develop and support infrastructure and those activities that build internal and external partnerships while working in an ever-changing environment.

Ethical Values
The Richards College of Business community (administrators, faculty, staff, students, and business partners) share a commitment to the principles of honesty and integrity in interactions and undertakings, accountability for personal behavior, and respect for the rights, differences, and dignity of others. In addition, we strive to continuously improve our abilities to recognize unethical behavior and to make ethical and moral decisions.

Institutional Policies

Academic Support

Accessibility Services: Students with a documented disability may work with UWG Accessibility Services to receive essential services specific to their disability. All entitlements to accommodations are based on documentation and USG Board of Regents standards. If a student needs course adaptations or accommodations because of a disability or chronic illness, or if he/she needs to make special arrangements in case the building must be evacuated, the student should notify his/her instructor in writing and provide a copy of his/her Student Accommodations Report (SAR), which is available only from Accessibility Services. Faculty cannot offer accommodations without timely receipt of the SAR; further, no retroactive accommodations will be given. For more information, please contact Accessibility Services.

Center for Academic Success: The Center for Academic Success provides services, programs, and opportunities to help all undergraduate students succeed academically. For more information, contact them: 678-839-6280 or [email protected]

University Writing Center: The University Writing Center assists students with all areas of the writing process. For more information, contact them: 678-839-6513 or [email protected]

Online Courses

UWG takes students’ privacy concerns seriously: technology-enhanced and partially and fully online courses use sites and entities beyond UWG and students have the right to know the privacy policies of these entities. For more information on privacy and accessibility for the most commonly used sites, as well as technology requirements visit the UWG Online site.

Students enrolled in online courses can find answers to many of their questions in the Online/Off-Campus Student Guide.

If a student is experiencing distress and needs help, please see the resources available at the UWG Cares site. Online counseling is also available for online students.

Honor Code

At the University of West Georgia, we believe that academic and personal integrity are based upon honesty, trust, fairness, respect, and responsibility. Students at West Georgia assume responsibility for upholding the honor code. West Georgia students pledge to refrain from engaging in acts that do not maintain academic and personal integrity. These include, but are not limited to, plagiarism, cheating, fabrication, aid of academic dishonesty, lying, bribery or threats, and stealing. 

The University of West Georgia maintains and monitors a confidential Academic Dishonesty Tracking System. This database collects and reports patterns of repeated student violations across all the Colleges, the Ingram Library, and the School of Nursing. Each incidence of academic dishonesty is subject to review and consideration by the instructor, and is subject to a range of academic penalties including, but not limited to, failing the assignment and/or failing the course. Student conduct sanctions range from verbal warning to suspension or expulsion depending on the magnitude of the offense and/or number of offenses. The incident becomes part of the student’s conduct record at UWG.

Additionally, the student is responsible for safeguarding his/her computer account. The student’s account and network connection are for his/her individual use. A computer account is to be used only by the person to whom it has been issued. The student is responsible for all actions originating through his/her account or network connection. Students must not impersonate others or misrepresent or conceal their identities in electronic messages and actions. For more information on the University of West Georgia Honor Code, please see the Student Handbook.

UWG Email Policy

University of West Georgia students are provided a MyUWG e-mail account. The University considers this account to be an official means of communication between the University and the student. The purpose of the official use of the student e-mail account is to provide an effective means of communicating important university related information to UWG students in a timely manner. It is the student’s responsibility to check his or her email.

Credit Hour Policy

The University of West Georgia grants one semester hour of credit for work equivalent to a minimum of one hour (50 minutes) of in-class or other direct faculty instruction AND two hours of student work outside of class per week for approximately fifteen weeks. For each course, the course syllabus will document the amount of in-class (or other direct faculty instruction) and out-of-class work required to earn the credit hour(s) assigned to the course. Out-of-class work will include all forms of credit-bearing activity, including but not limited to assignments, readings, observations, and musical practice. Where available, the university grants academic credit for students who verify via competency-based testing, that they have accomplished the learning outcomes associated with a course that would normally meet the requirements outlined above (e.g. AP credit, CLEP, and departmental exams).

HB 280 (Campus Carry)

UWG follows University System of Georgia (USG) guidance: http://www.usg.edu/hb280/additional_information#

You may also visit our website for help with USG Guidance: https://www.westga.edu/police/campus-carry.php

Mental Health Support

If you or another student find that you are experiencing a mental health issue, free confidential services are available on campus in the Counseling Center. Students who have experienced sexual or domestic violence may receive confidential medical and advocacy services with the Patient Advocates in Health Services. To report a concern anonymously, please go to UWGcares.

ELL Resources

If you are a student having difficulty with English language skills, and / or U.S. culture is not your home culture, specialized resources are available to help you succeed. Please visit the E.L.L. resource page for more information.

COVID-19

Proctored Exams/Online Instruction: Students should be aware and plan ahead for the possibility of having to complete all courses and/or exams online or in a proctored environment. This means talking with your instructors about what minimum technical requirements (software and hardware) will be required should your class move online or a student's personal needs dictate. This also includes making plans for internet access at whatever location participation may occur.

Virtual or in-person proctored exams, if your instructor should require them, may result in an additional cost to the student. Please discuss these details with your instructor or see the information provided here.

Face Coverings: Effective July 15, 2020, University System of Georgia institutions, including the University of West Georgia, will require all faculty, staff, students, and visitors to wear an appropriate face covering while inside campus facilities/buildings where six feet social distancing may not always be possible. Face covering use will be in addition to and is not a substitute for social distancing.

Face coverings are not required in campus outdoor settings where social distancing requirements are met. Anyone not using a face covering when required will be asked to wear one or must leave the area.

Reasonable accommodations may be made for those who are unable to wear a face covering for documented health reasons.

Student FAQs: For more information about UWG COVID-19 guidance for students visit the Student FAQ webpage

 

Additional Items