• Database System Technology
    • School of Electronic, Information and Electrical Engineering
    • Credit. 3
    • SE305
    • Enroll
    • Fall , 2015
    • 1695
    • Course Description:
    • ( Exchange Programme )
    • This course is a first course in database systems for undergraduates at SJTU/CS. It covers the fundamantal concepts of modern database management including database design, database languages and database system implementation. It assumes only familiarity with basic data structures, computer organization and a high level programming language such as Java or C. The concepts and algorithm presented in this course are based on commercial or experimental database systems. The idea is not to tie these concepts to a particular database system but to present it in a general setting. Most of the assignments and projects are done using Java/C and the open source MySQL, which is widely available. Topics covered in this course include: relational databases, database design, data storage and querying processing, transactions, system architecture, data mining and information retrieval, and optionally, XML and a case study on a particular database system.
    • Course Syllabus:
    • After completing the course, students should be able to:
      1. write database queries in relational algebra and SQL
      2. design a relational database using ER model
      3. understand the design principles in relational database
      4. understand the concept in database system implementation such as transactions, indexing and query processing/optimization.
    • Schedule:
    • Topics / Credit hours / Teaching methodology / Tasks / Intended learning outcomes / Assessment methods

      1. Introduction / 2 / Lecture / Assignment / NA / Assignment
      2. Relational model / 2 / Lecture / Assignment / NA / Assignment
      3. SQL / 6 / Lecture / Assignment / NA / Assignment
      4. ER Model / 4 / Lecture / Assignment / NA / Assignment
      5. Relational DB Design / 4 / Lecture / Assignment / NA / Assignment
      6. Indexing / 4 / Lecture / Assignment / NA / Assignment
      7. Transaction / 2 / Lecture / Assignment / NA / Assignment
      8. Query Processing / 4 / Lecture / Assignment / NA / Assignment
      9. Project / 16 / Tutorial & Lab Practice / Project / NA / Project report and presentation
  • Reading list
  • Other Materials
  • Discussion
  • Homework download/submit
    • Zou Weiwen
    • Read more
    • Male
    • E-mail:
    • wzou@sjtu.edu.cn
    • Profile
    • Kenny Qili Zhu
    • Associate Professor
    • Read more
    • Male
    • E-mail:
    • kenzhu@sjtu.edu.cn
    • Profile
    • Kenny Qili Zhu is an Associate Professor and Distinguished Research Professor at Department of Computer Science and Engineering at Shanghai Jiao Tong University. He graduated with B.Eng (Hons) in Electrical Engineering in 1999 and PhD in Computer Science in 2005 from National University of Singapore. His PhD advisors were Joxan Jaffar and Roland Yap. He was a postdoctoral researcher and lecturer from 2007 to 2009 in the programming language group at Princeton University working on the PADS project with David Walker from Princeton and Kathleen Fisher from AT&T Labs. Prior to that , he was a software design engineer in the Windows Live Identity group of Microsoft in Redmond, WA. From Feb 2010 to Aug 2010, he was a visiting professor at Microsoft Research Asia in Beijing. Kenny was the winner of the 2013 Google Faculty Research Award and DASFAA 2014 Best Paper Award.
  • Prerequisite Course:

    Discrete Math, Data structures, basic programming in Java or C

  • Textbooks:

    1. Database Systems: The Complete Book (2nd Edition) by Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom(Jun 15, 2008).
    2. Advanced Database Systems (The Morgan Kaufmann Series in Data Management Systems) by Carlo Zaniolo, Stefano Ceri, Christos Faloutsos and Richard T. Snodgrass(May 15, 1997).
    3. Data Mining: Concepts and Techniques, Third Edition (The Morgan Kaufmann Series in Data M
  • Grading:

    Assignments + Project + Exam
Other courses
  • Flat Panel Display Technologies
    Flat Panel Display Technolo...
    This course is an introduction to the principles, specifications, design, and fabrication of flat panel displays. Topics that will be covered include: (1) human visual system and the requirements it p...
    Chen Chaoping
  • Database System Technology
    Database System Technology
    This course is a first course in database systems for undergraduates at SJTU/CS. It covers the fundamantal concepts of modern database management including database design, database languages and data...
    Kenny Qili Zhu
  • 3D Display Technologies
    3D Display Technologies
    Three-dimensional (3D) display is an ultimate display technology. From the theaters to TVs at home, to naked eye mobile devices, 3-D displays have been gaining popularity in our daily lives. This co...
    Li Yan
  • Fundamental of Optoelectronics
    Fundamental of Optoelectron...
    Course content: This course includes wave optics basics, waveguides, semiconductor devices, stimulated emission lasers, detectors, modulators, photovoltaic devices, optical sensor, medical photonics...
    Jiang Chun
  • Multicore Architecture and Parallel Computing
    Multicore Architecture and ...
    Multi-core era is here to stay and many programmers will be developing parallel software. But still not everyone is trained in parallel programming. In this course, students will study the state-of-ar...
    Jiang Li
  • Digital Electronics Technology
    Digital Electronics Technol...
    This course is designed to teach the students the fundamentals of digital circuits, including basic concepts, principles, and the basic methods for circuit analysis and design. Upon completion of the ...
    Bao Qilian
  • Operating System Computer Security and Cryptography
    Operating System Computer S...
    Understanding the information security with main focus on cryptography and its application in computer security and network security, including classical and modern cryptography, security protocols, a...
    Lai Xuejia
  • Data Mining Techniques
    Data Mining Techniques
    Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. ...
    Yuan Bo
  • Discrete Mathematics (2)
    Discrete Mathematics (2)
    The course introduces to the students the fundamentals of Discrete Mathematics and its applications. It aims to enhance the logic and analytic abilities of the students to model and solve computatio...
    Huan Long

Shanghai Jiao Tong University The English Course Catalog | School Counseling:021-34206468-102

沪ICP备05052060 © Shanghai Jiao Tong University all rights reserved. | Address: 800 Dongchuan Road, Shanghai