|
Course Code: |
CMPSC 431W (Spring 2017) |
||
|
Course Title: |
Introduction to Database Management Systems |
||
|
Class Meetings: |
|
||
|
Instructor: |
Wang-Chien Lee |
||
|
Office: |
360D IST Building West |
||
|
Office Hours: |
M W F 8:00 – 8:50 a.m. |
||
|
Email: |
|||
|
Course web site: |
|||
|
Teaching Assistant: |
Yu-San Lin and Hui-Ju Hung |
||
|
Office: |
337 IST Building |
||
|
Office Hours: |
(L) M T F 11am – 12pm; (H) T W R 1:00 – 2:00 pm |
||
|
Email: |
(L) yul189@cse.psu.edu; (H) hzh131@cse.psu.edu |
This course introduces the student to the design, use, and application of database management systems. Topics include: the relational data model, relational query languages, design theory, and conceptual data design and modeling for relational database applications. Broad introduction of database internal issues that is important to database designers (such as views, integrity constraints, triggers, authorization, data storage, indexing, query processing, and transactions) will also be covered. If time allows, we will consider some new and advanced topics.
At the completion of this course, the students shall have a good understanding of relational model, how to transform Entity-Relationship designs to relations, learn the standard query language for relational databases, i.e., Structured Query Language (SQL), and how to use a relational database system to create a database applications. Students will be expected to form project teams to design and implement database applications. In addition, as part of the University’s writing across the curriculum, students are expected to report their project in a clear and well-written document.
1. Introduce the student to the design, use, and application of database management systems.
2. Obtain broad knowledge in concepts of database management systems.
Computer science and computer engineering majors, as well as others interested in studying the development of software applications with large data management requirements.
Presentations and Review