SCHOOL OF BUSINESS, PUBLIC ADMINISTRATION AND INFORMATION SCIENCES LONG ISLAND UNIVERSITY, BROOKLYN CAMPUS
DEPARTMENT OF COMPUTER SCIENCE
CS 649 Database Management Systems
Fall 2011
Course Schedule: Thursday 6 - 8:35 PM Classroom: Cook Lab (LLC 207)
I. INSTRUCTOR INFORMATION Instructor: Prof. Ping-Tsai Chung
Contact Information - Office Room: LLC 203 Office Hours: Tuesday, Wednesday, Thursday 5:00 - 6:00 PM or by appointment
E-mail: [email protected] Tel: (718) 488-1073
Course Web Site: http://myweb.brooklyn.liu.edu/pchung/ Blackboard: http://blackboard.liu.edu/
Email access is essential in communicating with the instructor and your peers. Please activate your LIU e-mail account.
This course is offered in a blended learning format, which combines traditional face-to-face meetings with online activities involving synchronous discussions and asynchronous
communications. This leads to a more flexible and engaging experiences for both students and the instructor.
II. RESOURCES
Textbook: (Required) Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, 6th Edition, ISBN-10: 0136086209, ISBN-13: 9780136086208, Addison Wesley, 2011.
(Reference) Database Design, Application Development, & Administration, M. V. Mannino, 3rd Edition, ISBN 0-07-294220-7, McGraw-Hill/Irwin, 2007.
Databases or Software: All students need to download a free Oracle 11i Express Database Database Management System (DBMS). Also, students will exercise the ER Assist Tool provided by this course.
III. BUSINESS CONTEXT
Keywords: Database Management Systems, Relational Database Design and Implementation, Information Systems in Organizations.
IV. INSTRUCTIONAL DESIGN
Course Description: An examination of the concepts and practical aspects of database management systems and how data resources can be designed and managed to support
information systems in organizations. Topics include data models and data and storage structures and their relation to data access; use and management of database systems, data independence; and data sharing, availability, security, integrity and consistency. Students are required to design and implement a database using a relational database management system, such as SQL. Three hours lecture, one hour laboratory. Three credits. This course has an additional fee. Offered every Fall.
Course Rationale/Course Overview: This course is designed for both Computer Science graduate students and MBA students in Management Information Systems (MIS) concentration. Topics covered in this course include four major parts. Part I - Introduction and Fundamentals: Relational Database Management Systems. Part II - Entity Relationship (E-R) Modeling. Part III - the Structured Query Language –SQL in Oracle and Microsoft Access. PART IV - Normalization techniques. Students are expected to exercise an ER Assist Tool to be familiar with the E-R Modeling technique and to complete a hand-on project using SQL in Oracle Relational Database Management System Environment.
Prerequisites: It is assumed that students have some Computer Concepts such as CS 601 and CS 605.
Course Learning Objectives: The objective of this course is to provide graduate students an overview of Database Management Systems techniques. In particular, the Database techniques will be focused in Relational Database Management Systems, Developments and Applications. Student Learning Goals:
(O.1) Students will have a solid background in Relational Database Management Systems for both academic study and professional developments areas.
(O.3) Students are expected to exercise an ER Assist Tool to be familiar with the E-R Modeling techniques.
(O.4.) Students will be familiar with SQL – Schema Definition, Constraints, Queries and Views in both Oracle and Microsoft Access.
(O.5) Students will develop a hand-on project using SQL hand-on project using SQL in Oracle Relational Database Management System Environment.
(O.6.) Students will be familiar with Database Normalization techniques and apply Database Normal Forms into Practical Database Design.
V. PROGRAM –LEVEL ASSESSMENT OF LEARNING
Program Learning Objectives Assessment Vehicles Direct Assessment Measures Goal 1: Master the core
foundations of computer science.
Student learning objective 1.2: Students will understand the mathematical and logical foundations of computing
An evaluation of Database Project in CS649 will be chosen as a direct measure of this learning objective. (1) This activity is using an ER Assist Tool to draw the ER Diagram for a Database Application and to create the database tables in Oracle 11i Express Database Management System (DBMS) Environment for the Database Application
Developments.
(2) Students then need to populate the database records using SQL insert statements.
(3) Then students should complete and implement the SQL Queries for the given problems.
Grading rubric for the project assessing the analysis.
Goal 3: Students will be able to apply networking and database concepts to information technology
solutions
Student learning objective 3.2: Students will develop a data modeling design for a proposed database application.
VI. COURSE-LEVEL ASSESSMENT OF LEARNING
Learning Objective Assessment Vehicles Direct Assessment Measures The objective of this course is
to provide graduate students an overview of Database Management Systems techniques. In particular, the Database techniques will be focused in Relational Database Management Systems, Developments and Applications.
An evaluation of Database Project in CS649 will be chosen as a direct measure of this learning objective.
Grading rubric for the project assessing the analysis.
Student Learning Goals:
(O.1) Students will have a solid background in Relational Database Management Systems for both academic study and professional developments areas.
The Database Project of CS 649 contains the following activities:
(1) This activity is using an ER Assist Tool to draw the ER Diagram for a Database Application and to create the database tables in Oracle 11i Express Database
Management System
(DBMS) Environment for the Database Application
Developments. (2) Students then need to
populate the database records
using SQL insert statements. (3) Then students should complete and implement the SQL Queries for the given problems.
(O.2) Students will be able to analyze business requirements and apply Entity
Relationship (E-R) Modeling techniques to develop
database applications.
Same as the Part (1) of the Database Project of CS 649.
Grading rubric for the project assessing the analysis.
(O.3) Students are expected to exercise an ER Assist Tool to be familiar with the E-R Modeling techniques.
Same as the Part (1) of the Database Project of CS 649.
Grading rubric for the project assessing the analysis.
(O.4.) Students will be familiar with SQL – Schema Definition, Constraints, Queries and Views in both
Oracle and Microsoft Access.
Same as the Part (2) of the Database Project of CS 649.
Grading rubric for the project assessing the analysis.
(O.5) Students will develop a hand-on project using SQL hand-on project using SQL in
Oracle Relational Database
Management System Environment.
Same as the Part (3) of the Database Project of CS 649.
Grading rubric for the project assessing the analysis.
(O.6.) Students will be familiar with Database Normalization techniques and apply Database Normal
Forms into Practical Database Design.
An extension of Database Project in CS649 will be chosen as a direct measure of this Student Learning Goal.
Students will apply
Normalization techniques to the Relational Database Tables developed for the Database Project in CS649.
VII. GRADING CRITERIA, GUIDELINES, AND ASSIGNMENTS
Course Grading: Class Participation & Attendence: 15%, Assignments/Project: 35%, Midterm: 25%, Final: 25%
Note 1 (Grading Grid for Final Grades): 90% and higher (A), 75% – 89.99% (B), 60 -74% (C), below 60% (F)
Note 2 (Classroom): All face-to-face classes will meet at Cook Lab (LLC 207) in Computer Science Department.
Note 3 (Class Attendance): Student should attend all classes include all lectures, examinations.
Note 4 (Homework / Project Submissions): All homeworks and final project should be submitted through internet, please forward your homework to me at [email protected] before the specified deadline. No late homework will be accepted.
Note 5 (Expected Frequency of Online Participation): In addition to completing the scheduled activities on time for the on-campus sessions, students are expected to engage with the course (by logging in to the Blackboard, posting to discussion forums, or responding to email) at least twice a week. I will try to respond to email messages as soon as possible, usually within 24 hours, and be available for online appointments. Please let me know if you need special accommodations due to any type of disability.
Note 6 (Additional Online Content): Additional online content will be provided in the following form:
Lecture notes in Power Point or in PDF file. Design and Programming Samples.
Multimedia content.
VIII. WEEKLY OUTLINE
We are developing the following five modules for CS 649.
Module 1: Introduction and Fundamentals: Relational Database Management Systems. (This module will be implemented in Blended Learning format).
Module 2: Entity Relationship (E-R) Modeling (This module will be implemented in Blended Learning format).
Module 3: the Structured Query Language-SQL in Oracle and Microsoft Access (This module will be implemented in Blended Learning format).
Module 4: Normalization techniques
(This module will be implemented in Blended Learning
format).Schedule Module Topics Covered Resources Assignments (1) Face-to-face Meeting Sept. 8
Module 1:
Introduction
and
Fundamentals:
Relational
Database
Management
Systems.
Introduction - File System and Databases; Database Management System Functions; Database System Concepts and Architecture Ch 1.1 ~ 1.8, Ch 2.1 ~ 2.6 Additional notes will be post at Blackboard Reading Assignment 1 (2) Face-to-face Meeting Sept. 15 Lab Tour – Discuss the Course Development Environment:Oracle 11i
Express
Database
Management
System
Introduce Oracle SQL * Plus.Integrity Rules. Online notes and Discussions (4) Face-to-face Meeting Sept. 29 Create database Tables for a Database and Insert data records Online Discussions
Homework 1
(5) Face-to-face Meeting Oct. 6Module 2:
Entity
Relationship
(E-R)
Modeling.
Entity Relationship (E-R) Modeling and Relational Database Model; Enhanced Entity-Relationship (EER) Model Distribute Term Project sheet to student Ch 7.1 ~ 7.7, 3.9, Ch 8.1 ~8.5 Online notes and Discussions Reading Assignment 4 (6) Online Meeting Oct. 13 Relational Database Design by ER - and EER-to-Relational Mapping Ch 9.1 ~ 9.2 Online notes and Discussions Reading Assignment 5 (7) Face-to-face Oct. 20 Lab Tour –ER-Assist
Tool
–
Introduction & Class Review – Midterm Exam Contents will be discussed in the ClassOnline notes and Discussions Reading Assignment 6 (8) Face-to-face Meeting Oct. 27 ER Modeling using ER-Assist Tool
& Term Project Discussion
Online Discussions
Homework 2
(10) Face-to-face Meeting Nov. 10
Module 3: the
Structured
Query
Language-SQL.in Oracle
and Microsoft
Access.
SQL – Schema Definition, Constraints, Queries and Views & Midterm Exam Discussion Ch 4.1 ~ 4.5 Online notes and Discussions Reading Assignment 7 (11) Face-to-face Meeting Nov. 17 More on SQL Ch 5.1 ~ 5.5 Online notes and DiscussionsHomework 3
Reading Assignment 8 (12) Online Meeting Nov. 24 SQL & Term Project Discussion Online Discussions (13) Face-to-face Meeting Dec. 1Module 4:
Normalization
techniques.
Normalization - Normal Forms: 1NF, 2NF, 3NF, BCNF, 4NF Ch 15.1 ~ 15.5 Online notes and Discussions Reading Assignment 9 (14) Face-to-face Meeting Dec. 8 Normalization techniques & Class Review – Final Exam Contents will be discussed in the Class Online DiscussionsHomework 4
(15) Dec. 15In Class Final Exam
(16) Dec. 22
IX. COURSE SUPPLEMENTARY TIME COMMITMENT
Contact Hours and Supplementary Assignments Contact Hours Face-to-face Lectures &
Online Meetings
45
Lab Exercises 20
Reading Assignments
There are 9 Reading Assignments, each is 4 hour assignment.
36
Homework Assignments –
There are 4 Homework Assignments, each is 5 hour assignment.
20
CS 649 Project includes Part (1) 20 CS 649 Project includes Part (2) 30 CS 649 Project includes Part (3) 50 CS 649 Project includes Part (4) 20
Total Semester Hours 241
X. ACADEMIC INTEGRITY AND REGULATIONS
Plagiarism: Plagiarism is the use or presentation of ideas, works, or work that is not one's own and that is not common knowledge, without granting credit to the originator. Plagiarism is a practice that is not only unacceptable, but which is to be condemned in the strongest terms possible on the basis of moral, educational and legal grounds. Under University policy,
plagiarism may be punishable by a range of penalties from a failing grade in the assignment or course to dismissal from the School of Business, Public Administration and Information Sciences. All students are required to read the handbook on avoiding plagiarism by visiting the URL: www.liu.edu/~/media/Files/Brooklyn/Academics/Schools/Business/Plagiarism.ashx. Cheating: Cheating includes, but not limited to the following: falsification of statements or data; listing sources that have not been used; having another individual write your paper or do your assignments; writing a paper or creating work for another student to use without proper
expressly permitted by the instructor depending on the nature of the examination) or knowingly providing such assistance to aid other students.
Attendance and Participation: Attendance and participation are essential to learning and fulfilling the outcomes of the course. Students are advised to inform the instructor in advance of any anticipated absence(s). In some instances, you may be required to submit supporting
documents.
Punctuality: Classes will begin promptly as scheduled. It is important that you be present on time. As with absences, late arrival(s) will adversely impact your learning as well your grade.
XI. ACCOMMODATIONS FOR STUDENTS WITH DISABILITY
Long Island University seeks to provide reasonable accommodations for all qualified persons with disabilities. This University will adhere to all applicable federal, state and local laws, regulations and guidelines with respect to providing reasonable accommodations as required to afford equal educational opportunity. It is the student's responsibility to register with Special Education Services (SES) as early as possible and to provide faculty members with the formal communication from SES for suitable accommodations. All accommodations must be approved through SES. Contact Information: Special Education Services, Pharmacy Building Basement, 718-488-1221 or 718-488-1044.
XII. STUDENT RESOURCES
The School of Business, Public Administration and Information Sciences and the University have a wide range of resources which are available through the School of Business Advisement Page: http://www.liu.edu/Brooklyn/Academics/Schools/SBPAIS/Advisement.aspx and the University Resources Page: http://www.liu.edu/Brooklyn/About/Resources.aspx.
