$20.00 Course Reflection Paper 2-3 pages Due in 10 Hours
University of North America
Course Syllabus
|
INST 522: Database Design and Processing This course is delivered ONLINE Fall Quarter 2019, Sep 30, 2019 – Dec 14, 2019
Professor: Ms. Betty Koo
E-Mail: [email protected] |
Course Description:
In this course, students gain a solid understanding of data base system concepts and architecture; data models, schema, and instances; data independence and data base language and interface; data definition languages; and overall data base structures. Students will explore relational data model concepts, integrity constraints, data manipulation, functional dependencies, transaction processing concepts and concurrency control techniques.
Credit Hours: 4.5
Class Instruction: 45 Hours
No prerequisites.
Course Objectives:
At the conclusion of this course students will be able to:
· Demonstrate the design methodology for databases and verify their structural correctness.
· Evaluate databases and applications software in relational models.
· Apply normalization steps in database design and removal of data anomalies.
· Develop applications using querying languages such as SQl and other database supporting software.
· Transform various database models into database designs.
· Analyze database processing principles in business intelligence systems.
Course Text and Supporting Materials:
Database Systems: Design, Implementation, and Management, 13th Edition Coronel; Morris. ISBN-10: 1-337-62790-9; ISBN-13: 978-1-337-62790-0
Course Outline
The outline provides a weekly overview for the term. Carefully review the instructional methods and course grading, late assignment, plagiarism, and other policies provided on the subsequent pages.
For courses delivered online all lessons, assignments, and assignment due dates are posted on the Moodle platform; for courses delivered on campus specific guidelines will be distributed by the instructor at the initial class session. Email/contact the course instructor if further clarification is needed.
|
Week |
Lecture |
Time |
Topics/Discussions |
Readings/ Assignments |
|
1 |
09/30/19-10/05/19 |
Online |
Database Systems Data Models |
Read Chapters 1 and 2 Moodle Discussion 1 |
|
2 |
10/06/19-10/12/19 |
Online |
Relational Database Model ER Modeling |
Read Chapters 3 and 4 Moodle Discussion 2 Homework 1 due on 10/26/2019 |
|
3 |
10/13/19-10/19/19 |
Online |
Advanced Data Modeling Normalization of Database Tables |
Read Chapters 5 and 6 Moodle Discussion 3 Practicum 1 due on 11/02/2019 |
|
4 |
10/20/19-10/26/19 |
Online |
Introduction to Structured Query Language (SQL) Advanced SQL |
Read Chapters 7 and 8 Moodle Discussion 4
|
|
5 |
10/27/19-11/02/19 |
Online |
Database Design |
Read Chapter 9 Moodle Discussion 5 Homework 2 due on 11/16/2019 |
|
6 |
11/03/19-11/09/19 |
Online |
Transaction Management and Concurrency Control Database Performance Tuning and Query Optimization |
Read Chapters 10 and 11 Moodle Discussion 6 Practicum 2 due on 11/23/2019 |
|
7 |
11/10/19-11/16/19 |
Online |
Distributed Database Management Systems Business Intelligence and Data Warehouses |
Read Chapters 12 and 13 Moodle Discussion 7
|
|
8 |
11/17/19-11/23/19 |
Online |
Big Data Analytics and NoSQL |
Read Chapter 14 Moodle Discussion 8 Homework 3 due on 12/07/2019 |
|
|
11/24/19-11/30/19 |
|
Thanksgiving Holiday (No Class) |
|
|
9 |
12/01/19-12/07/19 |
Online |
Database Connectivity and Web Technologies Database Administration and Security |
Read Chapters 15 and 16 Moodle Discussion 9
|
|
10 |
12/08/19-12/14/19 |
Online |
Final presentation and Reflection |
Presentation due on 12/14/2019 Reflection Paper due on 12/14/2019 |
Course Grade and Deliverables: The grade for this course is based on multiple exercises, assignments, and interactions with your peers and the instructor, which are referred to as “deliverables.” The deliverables are assigned the following percentage of the course grade:
|
COMPONENT |
% OF GRADE |
|
Moodle Discussions |
25 |
|
Homework Assignments (3 @ 10% each) |
30 |
|
Practicum Project Deliverable 1 |
10 |
|
Practicum Project Deliverable 2 |
15 |
|
Presentation |
15 |
|
Reflection Paper |
5 |
|
Total |
100 |
Timely submission of assignments
· Submission of in-class and out-of-class work by the due date are critical to the UoNA applied learning / curricular practical training approach whether assigned in on campus or online courses.
· Assignments throughout each course increase in depth and breadth as students becomes more familiar with the topics and rely on reinforcement of recently acquired knowledge with applications, and individual and team exercises.
· Weekly peer and faculty feedback support each student’s achievement of course objectives.
Make-up work
If an on-campus class session is missed , all work for the missed session made up prior to the next class session will result in no point loss OR if an online posted DUE date is missed, all work uploaded within the week of when the online assignment was due will result in no point loss.
Late assignments submitted Weeks 2 – 7
· Beyond 7 but within 14 days on campus OR beyond the week but within 2 weeks of when the assignment was due online will receive a reduction of 10% of the assignment’s points
· Beyond 14 days on campus OR beyond 2 weeks when the assignment was due online will receive a reduction of 20% of the assignment’s points
Late assignments submitted Weeks 8, 9, or 10 on campus / online will receive a reduction of 25% of the assignment’s points. No assignments will be accepted after the last day of the quarter.
The following Grading Scale, based on the percentage of total points earned, is used to calculate the course grade:
|
Letter Grade |
Range |
|
A |
93.00 – 100.00 % |
|
A- |
90.00 – 92.99 % |
|
B+ |
87.00 – 89.99 % |
|
B |
83.00 – 86.99 % |
|
B- |
80.00 – 82.99 % |
|
C+ |
77.00 – 79.99 % |
|
C |
70.00 – 76.99 % |
|
F |
< 70.00 % |
Course delivery and Instructional Strategies
Each course is developed to be delivered on campus or online. The campus is approved to deliver up to 50 percent of each program's sequence of courses or course online.
The instructional / learning approach includes a variety of strategies including, but not limited to, the following: (1) synchronous/asynchronous lectures; (2) in-class or online presentations, oral, visual, video, and audio; (3) real / simulated exercises; (4) small and large group discussions, which may be held in-class or via online forums; (5) practice sets; (6) quizzes and exams; (7) team or individual case study analyses; and (8) modeling.
For every hour of on campus or directed online instruction, students can expect to spend 2 hours outside of instructor-led lectures/presentations on homework assignments, projects, and preparation, which includes reading, writing, and research.
Course Methodology
Online courses include 10 scheduled weeks of delivery using the Moodle platform. An online course has the same content and student learning outcomes as when the course is delivered in an on-campus modality.
On-campus courses include 10 scheduled weeks of on-campus class sessions. On-campus courses may be supplemented with online activities using the Moodle platform allowing students to maximize their time during the scheduled class sessions and to support collaborative activities outside of the class sessions.
Moodle Learning Management Platform (LMS):
Each course has a web page in Moodle referred to as a course shell. The course shell allows students to:
· review the course syllabus; resources, including the virtual library; instructor/peer email links; and UoNA announcements for both online and on-campus courses
· access all reading lists; weekly schedules; assignments; assignment submission links and due dates; instructor-directed presentations and related resources; and instructor postings, notes, and feedback for all online courses
All students are assigned a University of North America email account for their use. It is critical for students to use their UoNA student email account for all course and campus communications.
Instructor Availability:
Responsive communication is a key objective of delivering quality service to our students. As your instructor, I will make every attempt to deliver a level of service within the following guidelines:
· Respond to emails within 48 hours
· Post feedback online for “progressive” assignments (those that subsequent assignments are reliant on) within 5 days of assignment submission (provided it is submitted on time)
· Post grades for online course assignments or return graded assignments in on-campus class sessions no later than the deadline of the following assignment.
In addition, I am available to support you in your efforts to succeed. You may contact me:
· On campus, during weekly scheduled on-campus class sessions if applicable or posted office hours
· Online via the Open Forum discussion board in Moodle
· Via my UoNA e-mail (preferred for individual questions).
Applied Learning Strategies
The methods provided below outline the strategies utilized in this course. the strategies utilized in this course. Carefully review the course grading, late assignment, attendance, plagiarism, and other policies stated on this syllabus.
For courses delivered online refer to the posted announcements, materials, and assignment due dates on the Moodle platform; for courses delivered on campus refer to the guides/handouts distributed during the initial class session and throughout the course. Email/contact the course instructor if further clarification is needed.
Moodle Discussion Forums
Student participation in a Moodle Discussion Forum or interactive exercise is required for each week of the term for all courses delivered online. Students in online courses are required to participate in the discussion within the week it is posted by responding to the instructor-posted directive and responding to posts from their peers as specified by the course instructor. Substantive and relevant responses are expected to earn substantial points for discussion forum participation.
A non-graded “Open Forum” discussion is also available in all courses delivered online for students to post inquiries for their instructor or peers.
On campus course instructors may utilize Moodle Discussion Forums to supplement on-site learning; refer to the course outline or instructor directives if this optional feature will be utilized.
Homework
Homework assignments for all courses delivered online are posted in the Moodle course shell and must be submitted via the Moodle dropbox by the due date. Any assignments submitted via email will not be accepted.
On campus course instructors may utilize the Moodle dropbox or accept assignments submitted each week during the scheduled class sessions; refer to the course outline or instructor directives to ensure the timely submission of assignments in on-campus courses.
Project Guidelines
Practicum projects are group or individual activities which directly relate the course materials to work environments and real-world situations. Students may be assigned to work in groups or individually, draw from the experiences of their colleagues and associates, and incorporate meaningful examples and strategies that can be applied within their own work environment.
Project Presentation Guidelines
PowerPoint presentations of projects or project reports may be a required course deliverable. If a group project is assigned, each group will prepare one PowerPoint presentation/report that includes contributions from each group member. The major components of the project should be presented in the PPTs or report.
Reflection Paper
Students are required to submit a short reflection paper at the end of the course in which they identify the relevance of the course materials and their learning to the workplace. Students are encouraged to identify direct links between course topics to specific work situations or experiences occurring during the academic term or recent employment.
Academic Integrity Policy
At UoNA, academic integrity helps to ensure learning in an atmosphere that is free of intellectual dishonesty including, but not limited to, the following elements:
a. Plagiarism -
i. deliberate submission or representation of the thoughts, ideas, or words of another as a student’s own work for any assignment or component of an assignment;
ii. quoting or paraphrasing another’s words or ideas without properly citing the source for any assignment or component of an assignment; and
iii. re-submitting a verbatim copy of my own work from a previous course, assignment, or publication.
b. Cheating - giving or receiving assistance or resources to and from peers for assignments and during exams that are not authorized in advance by the instructor.
c. Unauthorized collaboration - work that has been completed by more than one individual student for an assignment that has not been designated or authorized as a team assignment, in advance by the instructor.
d. Fabrication - intentional creation or falsification of data or information for inclusion in an assignment.
e. Copyright infringement – submitting assignments that include copyright materials or ideas, or file sharing networks, which make copyright material or ideas available, without the expressed consent of the author.
Academic integrity includes plagiarism and all elements as defined above. Faculty are required to submit a record of all violations and penalties to the VP of Academic Affairs. Violations of academic integrity will result in the following consequences, which impact assignment grades and, ultimately, the course grade:
|
Academic Integrity Violation Consequences |
|
1st violation of policy - The course faculty will choose to allow the student to resubmit the assignment (to be used as a “teaching opportunity”) or after consultation with the VP of Academic Affairs assign a reduced grade for the re-submission. Follow-up may include required outside of class session tutorials with an academic staff member or faculty. |
|
2nd violation of policy - The course faculty will choose to allow the student to resubmit the assignment with a reduced grade of 20% assigned or after consultation with the VP of Academic Affairs assign an “F” for the assignment. Follow-up will include required outside of class session tutorials. |
|
3rd violation of policy - After consultation with the VP of Academic Affairs and course faculty, the student may be allowed to resubmit the assignment with a reduced grade of 30% or be assigned an “F” for the assignment or for the course. Follow-up will include placing the student on academic warning and fulfillment of required remedial actions as determined by VP of Academic Affairs. |
|
Further or continued intentional violations of policy may result in dismissal from the university. |
Attendance and Class Participation
Attendance is critical to the applied learning / curricular practical training approach. Attendance includes presence and participation in scheduled class sessions and online activities for distance education courses, and engagement in individual / group presentations, exercises, or projects.
Attendance Policy and Consequences
There are no excused absences; a student is either present or absent from a class session. Students are expected to attend and actively engage in all class sessions and/or online activities as assigned throughout each 11-week term. Students who do not complete a minimum of 70% of all course requirements will receive a failing grade (F) for the course whether delivered on campus or through distance education.
If a student must miss a class session or is unable to participate for an entire week in an online course, they are required to contact their professor or UoNA via email prior to the beginning of the class session or at the beginning of the week in an online course.
Students will be issued a warning from the academic department in the following circumstances:
· After 2 consecutive absences (two class sessions or two weeks in a row online).
· After 3 non-consecutive absences in a course.
Students will be issued a failing grade (F) for the course in the following circumstances:
· After 3 consecutive absences (three class sessions or three weeks in a row online).
· After 4 non-consecutive absences.
Students who earn a failing grade will be required to repeat the course if the course is required for graduation. International students on an F1 Visa are required to continue attending classes for the remainder of the term in order to maintain their enrollment status with the University.
Students with excessive absences may face additional consequences, including withdrawal from UoNA as required by the university’s regulatory agency requirements.
Appeals Process
Students may submit a written request and supporting documentation to the university’s administration if they feel they have extenuating circumstances for not adhering to the academic integrity, late assignment, grading, or attendance policies within two weeks of the occurrence. The request will be reviewed by a committee that includes a minimum of one academic representative, one administrator, and the university’s president, who will determine the best option for the student while still maintaining compliance with all regulatory agencies. In addition, if a student thinks the request has not been satisfactorily resolved by the committee, they may follow the UoNA Grievance Policy as published in the current catalog to address their dispute.
6
1
INST 522 Last Comprehensive Update: June 2019