Database Management System
iAREduce
CIS350Outline.pdf
NATIONAL UNIVERSITY
School of Technology and Engineering Department of Computer Science and Cybersecurity
CIS350 Database Management Systems
INSTRUCTOR: Mudasser F. Wyne, Ph.D., ([email protected])
Professor of Computer Science.
PROGRAM LEAD: Dr. Lu Zhang ([email protected])
DEPARTMENT CHAIR: Dr. Frank Appunn (@nu.edu )
Department of Engineering and Computing
E-Mail : [email protected]
COURSE TEXTBOOK:
Database Management and Design, Grove, A., Hansen, G., & Jackson, R. (2022). Database management
and design. MyEducator.
COURSE PREREQUISITE: None
COURSE DESCRIPTION:
Fundamentals of database systems. An introductory approach to developing database applications; students
learn to evaluate a business situation and then build and design a database application. The focus is from
systems design to distribution and integration of the system through hands-on experience. Core theories and
ideas of database management systems are also covered.
LEARNING OUTCOMES:
Upon successful completion of this course, the student will be able to:
• Describe database application development cycle.
• Understand disk and file storage for data.
• Explain queries and constraints in SQL.
• Explain transaction management and concurrency control.
• Integrate business intelligence and data warehouses.
COURSE REQUIREMENTS:
Students are expected to attend all class sessions, participate in all class activities, complete exams and
quizzes as scheduled, and turn in all assignments on time. Failure to do so may result in the loss of points.
Students are required to not completely rely on lecture notes and read their text materials in addition to
CIS350 Database management Systems. Page 2 of 8
relevant materials from professional periodic publications. Details of other assignments and/or projects will
also be discussed in the class.
GRADES:
Under Graduate Grading Information
http://www.nu.edu/OurPrograms/StudentServices/AcademicPoliciesandP/DefinitionofGradesGr.html
Following is the breakdown that will be used for determining final grades:
• Quizzes (Two Quizzes) 10%
• Assignment (One Assignment) 5
• Database Design Project 15% (Deliverable #1 Due: April 9, 2023, Deliverable #2 Due: April 16, 2023, Deliverable #3 Due: April 23, 2023)
• Lab Exercises 10%
• Midterm Examination (Sunday, April 16, 2023) 30%
• Final Exam (Saturday, April 29, 2023) 30%
(Comprehensive)
FINAL LETTER GRADES:
96% - 100% = A 87% - 89% = B+ 77% - 79% = C+ 67% - 69% = D+
90% - 95% = A- 84% - 86% = B 74% - 76% = C 64% - 66% = D
80% - 83% = B- 70% - 73% = C- 60% - 63% = D-
00% - 59% = F
OFFICE HOURS: By Appointment only
CIS350 Database management Systems. Page 3 of 8
Following is a tentative schedule that may be changed per discussion and needs of the students. Times
specified are in Pacific Standard Time (PST). Each color represents a WEEK.
Session Starts Ends Lecture Topics Additional Activities
Session 1
Tuesday
April 4, 2023
5:30 PM 7:30PM Orientations.
Databases for an Information Rich,
Connected World
Project Del. #1
Due April 9, 2023, 11:55
PM
Assignment #1
Due April 9, 2023, 11:55
PM
Session 2
Thursday
April 6, 2023
5:30 PM 7:30PM
Principles of Conceptual Database
Design
Sunday
April 9, 2023
5:00AM 11:55PM All material for Week #1 Quiz #1
Session 3
Tuesday
April 11, 2023
5:30 PM 7:30PM
The Relational Data Model
Project Del. #2
Due April 16, 2023, 11:55
PM
Session 4
Thursday
April 13, 2023
5:30 PM 7:30PM From Conceptual Design to
Relational Implementation
Sunday
April 16, 2023
5:00AM 11:55PM All material for Week #1 and
Week #2
Midterm (25%)
Session 5
Tuesday
April 18, 2023
5:30 PM 7:30PM
Introduction to SQL
Project Del. #3
Due April 23, 2023, 11:55
PM
Lab Exercise #1.
Due April 19, 2023, 11:55
PM
Session 6
Tuesday
April 20, 2023
5:30 PM 7:30PM
Advanced SQL
Lab Exercise #2
Due April 21, 2023, 11:55
PM
Sunday
April 23, 2023
5:00AM 11:55PM All material for Week #3 Quiz #2
Session 7
Tuesday
April 25, 2023
5:30PM 7:30PM
Transaction Management and
Concurrency Control
Session 8
Tuesday
April 27, 2023
5:30 PM 7:30PM
Database Application
Architecture
Saturday
April 29, 2023
5:00AM 11:55PM All material for the course. Final Exam (30%)
CIS350 Database management Systems. Page 4 of 8
COURSE REQUIREMENTS
Students are expected to study the lecture notes and textbook, participate in all class activities, complete
exams as scheduled, and turn in all assignments, including labs as scheduled. Failure to participate in class
activities may result in the loss of points or the lowering of one’s grade. Attending ZOOM (Chat) sessions is
not mandatory; however, you are strongly recommended to attend all the chat sessions, if you miss a
session, it remains your responsibility to make sure you have not missed any Assignment or Announcement.
If you miss any of the chat sessions, you should try to watch the recording of this session before the next
chat session.
It is important that you on a daily basis, please log in to your class (and/or email) and check for any
additional information or requirement that might be necessary under the circumstances. Students are
also responsible for reading all the information in the course outline and announcements made on the
BrightSpace course shell. Please make sure to read the “Course Policy” document to get a better
understanding of how the course will be run.
If you change your email address published on SOAR to a new one, you will also be responsible for
updating SOAR with the new email address. For the proper progress of all class-related work, decisions
made during a class session will be counted as valid decisions for all class members regardless of whether
they are present at that time or not. Not being in the class session means one forfeits the right of
participating in that decision-making process (if the students are invited to make that decision collectively).
Students who miss any class session are responsible for the lecture contents, any material covered, handouts
distributed, or announcements made in that session.
CLASS PREPARATION AND PARTICIPATION
Since the material is extremely technical, please read the lecture slides and assigned textbook chapters
before class time. Your attention (not just attendance) and participation in class are extremely important for
you to understand the material and follow along. National University policies dictate that we must give
flexibility to students who cannot attend an online session therefore, ONLINE ZOOM sessions are not
mandatory. However, it is strongly recommended that you review the recorded session for your own
progress before the next chat session. To do well during exam time, you must know all class material,
including lecture slides, homework material, and class project material.
Online ZOOM Sessions:
Week 1 Tuesday, April 4, 2023 5:30 to 7:30 PM Pacific (California) Time
Thursday, April 6, 2023 5:30 to 7:30 PM Pacific (California) Time
Week 2 Tuesday, April 11, 2023 5:30 to 7:30 PM Pacific (California) Time
Thursday, April 13, 2023 5:30 to 7:30 PM Pacific (California) Time
Week 3 Tuesday, April 18, 2023 5:30 to 7:30 PM Pacific (California) Time
Thursday, April 20, 2023 5:30 to 7:30 PM Pacific (California) Time
Week 4 Tuesday, April 25, 2023 5:30 to 7:30 PM Pacific (California) Time
Thursday, April 27, 2023 5:30 to 7:30 PM Pacific (California) Time
The class sessions will be learning chats, not just chats without any direction or desired outcomes. Class
CIS350 Database management Systems. Page 5 of 8
sessions are not repeated sessions. I will record each online ZOOM chat session and save them for your
review later.
EXAMINATIONS
There will be two regular exams. The question format is designed to encourage studying and discourage
guessing. They are closed-book exams. All students must take all exams in the course as scheduled. Exam
material will be based on the chapters assigned from the book, ZOOM lecture sessions, lecture notes,
homework assignments, class projects, and any additional handouts that I may have uploaded to the course
shell and/or emailed. You are allowed to enter an exam ONLY ONCE. Once you have started, you will have
the actual amount of time allowed to finish it from the time you entered the exam. The system will
automatically stop a student when the time is up.
During the exam open time of an exam, to ensure that you can see the exam link properly, before logging on
to BrightSpace to take the exam, please delete your cookies and temporary Internet files via your browser. If
you are already in BrightSpace when you clear the files, you need to log off, close the browser, open a new
browser, and log on to D2L BrightSpace again. Then you should be able to see the exam link properly in
BrightSpace at the official start time. If you need technical help or if your browser blocks an exam, please
call the help desk number at 1-877-325-7778 or Online Learning and Instructional Support: [email protected]
Phone: (877) 533-4733 Option 2
ASSIGNMENTS
There will be assignments given throughout the course. Details are described in the relevant assignment
handouts. They will contribute proportionally to the final total assignment score. As course material is
cumulative, to successfully complete an assignment in a certain week, one may need to use concepts and
techniques taught in the previous or current weeks. According to NU policies, instructors have up to one
calendar week to return a graded assignment.
Assignment and Database Design Project deliverables are due at 11:59 PM Pacific (California) Time on the
specified dates. This is intended for you to have a whole weekend for working on the assignment. However,
you are advised to work on homework assignments and project deliverables as soon as possible.
In order to be fair to every student, each assignment is to be submitted once only, and please submit your
file for each assignment to the correct Dropbox in BrightSpace for grading. All time stamps will be
according to the time stamps of D2L Brightspace. If one turns in more than one version of the same
assignment, I will only accept and grade the first version received and grade according to the policies
described here. Each accepted assignment is to be graded once only. Grades will be posted on the grade
book of the course. After the assignment has been graded and returned to some or all students, and/or a
solution to the assignment has been posted or emailed no assignment will be accepted.
POLICY ON POINTS LOST DUE TO LATE SUBMISSION OF ANY ASSIGNMENT (OR ANY
CIS350 Database management Systems. Page 6 of 8
PORTION OF AN ASSIGNMENT)
Assignments must be handed in on the announced dates. Late submission will carry 20%
penalty for each day, including weekends and holidays. No assignment will be accepted once
the solution to the assignment has been discussed and/or posted/emailed.
This policy also does not apply to quizzes and exams. They should be taken as scheduled and
according to the relevant policies as described above.
I: Incomplete A grade given at the discretion of the instructor when a student who has completed at least
two-thirds of the course class sessions and is unable to complete the requirements of the course because of
uncontrollable and unforeseen circumstances. The student must convey these circumstances (preferably in
writing) to the instructor prior to the final day of the course. If an instructor decides that an “Incomplete” is
warranted, the instructor must convey the conditions for removal of the “Incomplete” to the student in
writing. A copy must also be placed on file with the Office of the Registrar until the “Incomplete” is
removed or the time limit for removal has passed. An “Incomplete” is not assigned when the only way the
student could make up the work would be to attend a major portion of the class when next offered.
An “I” that is not removed within the stipulated time becomes an “F.” No grade points are assigned. The
“F” is calculated in the grade point average.
W: Withdrawal Signifies that a student has withdrawn from a course after beginning the third class session.
Students who wish to withdraw must notify their admissions advisor before the beginning of the sixth class
session in the case of graduate courses. Instructors are not authorized to issue a “W” grade.
Plagiarism:
Plagiarism is the presentation of someone else’s ideas or work as one’s own. Students must give credit for
any information that is not either the result of original research or common knowledge. If a student borrows
ideas or information from another author, he/she must acknowledge the author in the body of the text and on
the reference page. Students found plagiarizing are subject to the penalties outlined in the Policies and
Procedures section of the University Catalog, which may include a failing grade for the work in question or
for the entire course. The following is one of many websites that provide helpful information concerning
plagiarism for both students and faculty: http://www.indiana.edu/~wts/pamphlets/plagiarism.shtml
GENERAL RULES/INFORMATION
Attendance Procedures
http://library.nu.edu/
http://www.nu.edu/OurPrograms/StudentServices/AcademicPoliciesandP/AcademicDishonestyan.ht ml
CIS350 Database management Systems. Page 7 of 8
http://www.nu.edu/OurPrograms/StudentServices/WritingCenter.html
DIVERSITY:
Learning to work with and value diversity is essential in every program. Students are required to act
respectfully toward other students and instructors throughout the course. Students are also expected to
exhibit an appreciation for multinational and gender diversity in the classroom and develop management
skills and judgment appropriate to such diversity in the workplace.
ETHICS:
Ethical behavior in the classroom is required of every student. Students are also expected to identify ethical
policies and practices relevant to course topics.
COMMUNICATION SKILLS:
Both written and oral communications are required in the classroom.
TECHNOLOGY:
Students are expected to be competent in using a DBMS, word-processing, spreadsheet, and presentation
software in this course. The use of the Internet and email also be required.
APA REFERENCE GUIDE:
The APA's official page for information on APA format and style:
http://www.apastyle.org/pubmanual.html
GENERAL RULES/INFORMATION
Attendance Procedures
http://www.nu.edu/OurPrograms/StudentServices/AcademicPoliciesandP/AttendanceProcedures.html
Library Resources
http://library.nu.edu/
Plagiarism Policy
http://www.nu.edu/OurPrograms/StudentServices/AcademicPoliciesandP/AcademicDishonestyan.html
Writing Across the Curriculum
CIS350 Database management Systems. Page 8 of 8
http://www.nu.edu/OurPrograms/StudentServices/WritingCenter.html
DIVERSITY:
Learning to work with and value diversity is essential in every program. Students are required to act
respectfully toward other students and instructors throughout the course. Students are also expected to
exhibit an appreciation for multinational and gender diversity in the classroom and develop management
skills and judgment appropriate to such diversity in the workplace.
ETHICS:
Ethical behavior in the classroom is required of every student. Students are also expected to identify ethical
policies and practices relevant to course topics.
COMMUNICATION SKILLS:
Both written and oral communications are required in the classroom.
TECHNOLOGY:
Students are expected to be competent in using a DBMS, word-processing, spreadsheet, and presentation
software in this course. The use of the Internet and email also be required.
APA REFERENCE GUIDE:
The APA's official page for information on APA format and style:
http://www.apastyle.org/pubmanual.html
