• Database System Technology
    • School of Electronic, Information and Electrical Engineering
    • Credit. 3
    • SE305
    • Enroll
    • Fall , 2015
    • 1754
    • 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
  • 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
  • Communication Principles
    Communication Principles
    The primary objective of this course is: (1) to introduce the basic techniques used in modern communication systems, and (2) to provide fundamental tools and methodologies in analysis and design of th...
    Tao Meixia
  • Digital Image Processing
    Digital Image Processing
    Digital image processing is ubiquitous, with applications ranging from television to tomography, from photography to printing, from robotics to remote sensing. This course will emphasize general princ...
    Xiong Hongkai
  • Computer Communications and Networks
    Computer Communications and...
    What is computer communication? What are computer networks? What is the Internet? Packet-switched networks; Network architecture; The Web and HTTP; File transfer and FTP; Electronic mail and SMTP; Dir...
    Ma Dianguang
  • 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
  • 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
  • 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
  • Image Based Measurement: Principle and Applications
    Image Based Measurement: Pr...
    This course will be taught in English and all lecture notes and assignments will be written also in English. Today, digital images are all around us, such as on the web, DVDs, industry and digital sa...
    Liu Manhua
  • 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, ...
    Dong Xiaoju

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