CPSC-350/551-11 Advanced Database Design

  Spring 2021

[Announcements]  [ Syllabus ]  [Schedule]  [ Lecture notes ]  [ Project/Exercise Lab/Assignment ]

Class: Tuesday, Thursday 9:30 AM ~ 10:45 PM (Carlson Hall 152)

　

Instructor: Dr. Jeongkyu Lee

E-Mail: jelee@bridgeport.edu

Website: http://www.bridgeport.edu/~jelee/courses/CS551_S21/CS551_S21.htm 

Phone: (203) 576-4397

Online Office :  https://bridgeport.zoom.us/j/5346018351 (Personal Zoom Link)

Office Hours: Online office hour only using Zoom. To make an appointment with Prof. Lee: https://appoint.ly/s/jelee0408/office

GA: Vamsi Varma Datla
E-Mail: vdatla@my.bridgeport.edu

Office Location: Online using Zoom

Office Hours: Make a reservation for meeting at https://appoint.ly/s/vamsivarma/officehours

Announcements

1/21/2021

 CPSC551 class website open. All files are available at Canvas (https://bridgeport.instructure.com/)

　


[ Back ]

Syllabus

Text Book

Fundamentals of Database Systems, 7th Edition, by Elmasri/Navathe, published by Addison-Wesley, 2016. (6th Ed. is fine)

ISBN-10: 0133970779, ISBN-13: 978-0133970777

　

Course Objective and Outcome:

This is an advanced level course of database design.  The prerequisite should cover Conceptual Modeling, Relational Modeling, Database design theory and methodology. In this course, we plan to cover Relational model, Advanced SQL and DB programming,  Indexing structure, Query processing, Database tuning, Transaction processing concepts.

　

Grading Policy:

，         Projects                                     20%

，         Exercise Lab Homework          15%

，         Homework/Quiz                          5%

，         Mid-term Exam                         25%

，         Final Exam                                30%

，         Attendance                                 5%

Grade Distribution:

A = 100 to 90, B = 89 - 75, C = 74 - 60, D = 59 - 50, F = 49 and Below

　

Attendance and Drop Policy

Attendance required and will be scored.

　

General Policies:

，         Students are responsible for checking this web site frequently for course related material and announcements. This site will be the primary form of communication for the course unless otherwise specified.

，         Please include "CPSC551" in the Subject line of all e-mail correspondence.

，         Any homework or projects assigned is due at midnight on the due date. There is a 10% penalty for every 24 hours being late, or fraction thereof, beyond the deadline. Maximum latency is 5 days beyond which a grade of zero will be assigned.

，         No make up exams or assignments will be given.

，         You may select any language/system to implement your labs. In general, there will be more support for C/C++/VB and Microsoft's Visual Studio environments. 

，         All exams are closed book.

，         The instructor reserves the right to modify the policies, calendar, assignments, point values and due dates. 

，         All submission should be free from Plagiarism. For more information, see below articles:

- Committee of Academic Honesty at UB [ DOC ]

- "Avoiding Plagiarism" in Rules for Writers by Diana Hackers [ PDF ]

[ Back ]

Schedule

Note: Some sections of certain chapters may be omitted in case we run out of time. The lists of excluded sections will be specified during lectures, if any. Lecture material and due dates may be adjusted as the course progresses.

Week

Date

Covered Topics

Comments
1 1/26 and 1/28
Chapter 1& 2: Introduction to database systems 　
2 2/2 and 2/4
Conceptual Data Modeling using ER
Chapter 3: Data Modeling Using the Entity-Relationship Model
3 2/9 and 2/11
Chapter 4: Enhanced Entity-Relationship
Database Exercise Lab 1
Project A- Phase 1 Due: Feb 12 (Friday)
Exercise lab #1 on 2/11
HW-Ch3 on Canvas by 2/12
4 2/16 and 2/18
Relational Database Modeling
Chapter 5: The relational data model.
Database Exercise Lab for GCP
 HW-Ch4 on Canvas by 2/19
Exercise lab for GCP on 2/18
5 2/23 and 2/25
Chapter 9: Conceptual to Relational Mapping
SQL and Database Programming
Chapter 8: Relational algebra and Relational calculus 		HW-Ch9 on Canvas by 2/26
Project A- Phase 2 Due: Feb 26 (Friday)
6 3/2 and 3/4
Chapter 6&7: The SQL database language
Database Exercise Lab 2
Exercise lab #2 on 3/4
7 3/9 and 3/11
Database Exercise Lab 3
Mid-term Exam:  March 11, 2021		 Exercise lab #3 on 3/9
Mid-term:  Chapter  1, 2, 3, 4, 5, 6, 8, and 9
8 3/16 and 3/18
Chapter 6&7: The SQL database language
Database Exercise Lab 4
 		Exercise lab #4 on 3/18
HW-Ch6-8 on Canvas by 3/19
 Project A- Phase 3 Due: March 19 (Friday)
9 3/23 and 3/25
Chapter 13: Database programming techniques.
10 3/30 and 4/1
Database Exercise Lab 5
Data Structure for DBMS
Chapter 16 (Chapter 17 in 6th): Disk Storage, Basic File Structures and Hashing
 Exercise lab #5 on 3/30
Project A- Phase 4 Due: April 2 (Friday)
11 4/6 and 4/8
Chapter 17: Indexing Structures for Files HW-Ch17 on Canvas by 4/9
12
4/13 and 4/15
Advanced Database Modeling
Chapter 14 (15 in 6th): Functional dependencies, and normalization
Chapter 15 (16 in 6th): Relational Database Design Algorithm		 HW-Ch14 on Canvas by 4/16
13 4/20 and 4/22
Advanced Topics of Database Management
Chapter 18: Strategies for  Query Processing		 Project A- Phase 5 Due: April 23 (Friday)
14 4/27 and 4/29
Chapter 19 (19 in 6th): Query Optimization
Chapter 20 (21 in 6th): Introduction to Transaction Processing Concepts and Theory
15
5/3 ~ 5/7
Final Exam: TBA
 		Final exam: Chapter 6, 7, 13, 14, 15, 16, 17, 19 and 20

　

　

[ Back ]

Lecture notes

* All lecture notes are available at Canvas

　

[ Back ]

Exercise Lab

            　

　

[ Back ]

Credit Hours: This course is a 3 credit hours course. For each of the three credit hours, there is three hour of classroom or direct faculty instruction each week for approximately fifteen weeks for one semester.