CSCI 4710 Databases
Course Syllabus, Fall 2019
PROFESSOR INFORMATION
Name: Dr. Yao
Office:
Atk 317
Telephone: (478) 445-5483
Email:
jf.yao@gcsu.edu
URL:
http://abacus2.gcsu.edu
Office Hours: 8:20 AM-9:20 AM, 10:50 AM-12:20 PM
on Tu. and Th. and by appointments only.
· Emails that are not urgent only will be answered during the office hours
CLASSROOM AND LAB: ATK310 and A&S143
REQUIRED TEXT: Principles of Database
Management, by
Bart Baesens, Seppe vanden
Broucke, and Wilfried Lemahieu (ISBN: 9781107186125),
Hands-on Oracle Database 10g Exp Ed for Windows, by Bobrowski
PREREQUISITES: C or above in CSCI 3410 - Data Structures
COURSE DESCRIPTION :
An introduction to basic concepts, design techniques, and theories in database
management systems. The primary emphasis is on the relational database
management systems. The goal is for students to be able to design and maintain
a relational database management system as a DBA after taking this course. Some other database systems will be
introduced as well.
EXPECTED COURSE OUTCOME:
· Students will become acquainted with basic principles, structure, and functions of database management systems.
· Students will be able to use SQL comfortably.
· Students will be able to develop a relational database on a real world DBMS.
· Students will be able to refine schema and to tune a DBMS
· Students will be able to create and modify storage structures and access methods
SATISFIED
PROGRAM STUDENT OUTCOMES:
·
Outcome 1. Students will be able to demonstrate
and apply knowledge of mathematical functions to analyze a given algorithm.
·
Outcome 2: An ability to apply design and development principles in the
construction of software systems.
·
Outcome 3: An ability to function effectively on teams to accomplish a
common goal.
ENABLED ABET STUDENT OUTCOMES:
·
Outcome (a) An
ability to apply knowledge of computing and mathematics appropriate to the
program’s student outcomes and to the discipline
·
Outcome (b): An ability to analyze a problem, and identify and define the
computing
·
Outcome (c): An ability to design, implement, and evaluate a
computer-based system, process, component, or program to meet desired needs
·
Outcome (d): An ability to function effectively on teams to accomplish a
common goal
·
Outcome (h): Recognition of the need for and an ability to engage in
continuing professional development
·
Outcome (i): An ability to use current
techniques, skills, and tools necessary for computing practice.
·
Outcome (k): An ability to apply design and development principles in the
construction of software systems of varying complexity.
COURSE TOPICS INCLUDED BUT NOT LIMITED TO:
·
Introduction to Databases
·
The Relational Model
·
Entity-Relationship Modeling
·
Relational Algebra
·
Relational Calculus
·
SQL: Data Manipulation & Data Definition
·
Advanced SQL
·
Schema Refinement and Normal Forms
·
Advanced Normalization
·
Conceptual Database Design
·
Logical Database Design for the Relational Model
·
A Real World DBMS: Oracle
GRADING CRITERIA:
Students learning will be assessed primarily through participation in programming homework, written homework, written responses to tests, and a cumulative final exam.
A-level work will meet the following criteria:
· A demonstrated proficiency and mastery in basic principles, structure, and functions of database management systems
· A demonstrated proficiency and mastery in developing and modifying a database management system with the basic features of a database management system learned in the course
· A demonstrated proficiency and mastery in using SQL
· Attend class regularly, complete homework assignments in time, and actively participate in classroom activities
· Demonstrate an understanding of the applications problems studied in the course
· Exceptional performance on all tests, and the cumulative final examination
GRADE DISTRIBUTION:
Percentage
Date
Exam
I
25%
Sept. 24, 2019
Exam
II 25%
Oct. 31, 2019
Final
Exam 25%
Tuesday, Dec 10, 2019 1:00 PM - 3:15 PM
Projects 25%
-------------------------------------------------------------------------
Total
100%
FINAL GRADES:
Grade
Percentage
A
90% and up
B
80% - 89.99%
C
70% - 79.99%
D
60% - 69.99%
F
59.99% or less
COURSE POLICY:
· You are expected to read the textbook prior to and after each class.
· Class and lab participation is essential in learning computer technology. It is your responsibility to attend the class/lab in order to achieve good learning, therefore obtain a good grade.
· You must NOT miss an exam unless you have a verifiable written excuse. An unexcused absence from an exam will result in a numerical grade of zero for that exam.
· The homework material will be included in the exams. Therefore, doing the homework assignments by yourself is essential in obtaining a good score in an exam.
· In order to train you for the real-world working situation, late assignments will be penalized 10% per day after the assignment due date.
· Prior to mid-semester, you will receive feedback on your academic performance in this course. Your overall grades are updated on a regular basis on GeorgiaView (D2L) throughout the semester.
ACADEMIC HONESTY:
The
integrity of students is a critical component of the academic process. All
written work submitted in this course must be individual work unless the
instructor assigns a team of students to work on an assignment. Students must
properly document all outside sources used for projects, programs, and
homework. The submission of another’s work as one’s own is plagiarism, and will
be dealt with using the procedures outlined on the Undergraduate
Catalog.
ENTATIVE COURSE OUTLINE:
WEEK
TOPICS
=============================================================
Part I Databases and Database Design
1.
Fundamental Concepts of Database
Management
2.
Architecture and Categorization of
DBMSs
3.
Conceptual Data Modeling Using the
(E)ER Model and UML Class Diagram
4.
Organizational Aspects of Data
Management
Part II Types of Database Systems
5.
Legacy Databases
6.
Relational Databases: The Relational
Model
7.
Relational Databases: The Relational
Model
8.
Relational Databases: The Relational
Model
9.
Relational Databases: The Relational
Model
10. Relational
Databases: Structured Query Language (SQL)
11. Relational
Databases: Structured Query Language (SQL)
12. Object-Oriented
Databases and Object Persistence
13. Extended
Relational Databases
14. Extended
Relational Databases
15. XML
Databases
16. NoSQL
Databases
·
Fall Break: Oct.
14-15, 2019
· Oct. 17, 2019 (5 PM) is the last day to drop without academic penalty (Unless if maximum number of dropped courses has been exceeded)
· Thanksgiving Holidays (Nov. 27-29, 2019)
· Last Day of Classes: Dec. 9, 2019
INTELLECTUAL PROPERTY POLICY
The intellectual property of class
assignments and other materials developed using university resources that are
commercialized are reviewed under the USG and GC policies to determine
ownership and/or payment rights. USG policies can be found at http://www.usg.edu/policymanual/section6/policy/6.3_intellectual_properties/ and
GC policies can be found at http://www2.gcsu.edu/policies/overall/intellectual-property-polic.htm.
Electronic video and/or audio recording is not permitted
during any class unless the student obtains permission from the instructor and
every student present. If permission is granted, any distribution of the
recording is prohibited. Violation of this policy is grounds for removal from
the class and referral for disciplinary action. Students granted specific electronic
recording accommodations from Disability Services do not require special
permission; however, the instructor must be notified. Any distribution is
prohibited.
ASSISTANCE FOR STUDENT NEEDS RELATED TO
DISABILITY
If you have a disability as described by the Americans with Disabilities Act (ADA) and the Rehabilitation Act of 1973, Section 504, you may be eligible to receive accommodations to assist in programmatic and physical accessibility. Disability Services, a unit of the GCSU Office of Institutional Equity and Diversity, can assist you in formulating a reasonable accommodation plan and in providing support in developing appropriate accommodations to ensure equal access to all GCSU programs and facilities. Course requirements will not be waived, but accommodations may assist you in meeting the requirements. For documentation requirements and for additional information, we recommend that you contact Disability Services located in Maxwell Student Union at 478-445-5931 or 478-445-4233.
STUDENT OPINION SURVEYS
Given the technological sophistication of Georgia College students, the student opinion survey is being delivered through an online process. Your constructive feedback plays an indispensable role in shaping quality education at Georgia College. All responses are completely confidential and your name is not stored with your responses in any way. In addition, instructors will not see any results of the opinion survey until after final grades are submitted to the University. An invitation to complete the online opinion survey is distributed to students near the end of the semester. Your participation in this very important process is greatly appreciated.
FIRE DRILL PROCEDURE
Fire
drills will be conducted annually. In the event of a fire alarm, students will
exit the building in a quick and orderly manner through the nearest hallway
exit. Learn the floor plan and exits of the building. Do not use elevators. If
you encounter heavy smoke, crawl on the floor so as to gain fresh air. Assist
disabled persons and others if possible without endangering your own life.
Assemble for a head count on the front lawn of main campus or other designated
assembly area.
RELIGIOUS OBSERVANCE POLICY
Students are permitted to miss class in observance of religious holidays and other activities observed by a religious group of which the student is a member without academic penalty. Exercising of one’s rights under this policy is subject to the GC Honor Code. Students who miss class in observance of a religious holiday or event are required to make up the coursework missed as a result from the absence. The nature of the make-up assignments and the deadline for completion of such assignments are at the sole discretion of the instructor. Providing verifiable proof of the religious affiliation and activities are at the sole discretion of the instructor as well. Failure to follow the prescribed procedures voids all student rights under this policy.
ACADEMIC GRIEVANCES OR APPEALS
An academic grievance or appeal is an allegation by a student of substantial and/or unjustified deviation, to the student’s detriment, from policies, procedures and/or requirements regarding admission, grading policies, special agreements, instructor’s requirements and academic requirements of the University. Students shall have the right to file academic grievances or appeals according to the procedures approved by the University and outlined in the University Catalog. This information is also available on the Georgia College Intranet.