• Database System Technology
    • School of Electronic, Information and Electrical Engineering
    • Credit. 3
    • SE305
    • Enroll
    • Fall , 2015
    • 4763
    • 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
  • C++ Programming
    C++ Programming
    This course introduces and emphasizes object-oriented programming (OOP). OOP is a currently popular and powerful programming technique. The main characteristics of OOP are encapsulation, inheritance, ...
    Yao Tianfang
  • Principles of Automatic Control (A)
    Principles of Automatic Con...
    As an important course for students majoring in Automation, the goals of the course Principle of Automatic Control Systems are as follows. After complete this course, students will be able to master t...
    Chen Cailian
  • Software Engineering
    Software Engineering
    Software engineering is the branch of computer science that creates practical, cost-effective solutions to computing and information processing problems, preferentially by applying scientific knowledg...
    Sheng Bin
  • Digital Signal Processing
    Digital Signal Processing
    Digital signal processing is a new-rising subject. It’s developing rapidly now and widely applied to many fields of science and engineering. It’s important knowledge for all informatics workers. As a ...
    Wu Kan
  • Computability Theory
    Computability Theory
    Computability theory, also called recursion theory, is a branch of computation theory in theoretical computer science. It is the foundation of algorithm design and analysis. It briefly introduces the ...
    Gao Xiaofeng
  • 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
  • Compiler Principles
    Compiler Principles
    This course considers the principles that underlie a wide variety of compilers, and focuses on the problem of translating programs written in a high-level language into semantically equivalent program...
    Guo Minyi
  • Artificial Intelligence
    Artificial Intelligence
    AI is the science of getting computers to act without being explicitly programmed. This course will introduce modern theory and techniques enabling Ai, mainly on machine learning, graphical model and ...
    Yuan Bo
  • Digital Signal Processing
    Digital Signal Processing
    Signal processing using digital computers and special purpose digital hardware has taken on major significance in the past decade. The inherent flexibility of digital elements permits the utilization ...
    Huang Zhenyu

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