Tutorial5

Tutorial5 - C0278A Introduction to Database Management...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style C0278A Introduction to Database Management Systems Tutorial 5 SQL and MySQL Teaching Assistants : Chui Chun Kit (Kit) Jin Yifan (Yvonne) Zhang Peiwu (Paul) 11
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Assignment 2 n Programming assignment n Deadline : 1 November 2010 12:00 noon n To develop an application on a database system. ¨ Implement a database using MySQL. ¨ Design SQL for specific tasks ¨ Create the user interface that executes the SQL and displays the result using PHP. 22
Background image of page 2
In this tutorial… n Outcome 2. Query Languages ¨ Able to understand and use the languages designed for data access. n Outcome 3. System Design ¨ Able to understand the design of an efficient and reliable database system. n Outcome 4. Application Development ¨ Able to implement a practical application on a real database 33
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
In this tutorial… 44 n Database – MySQL n Database Interface - PhpMyAdmin n How to access MySQL database with PHP n SQL query exercises n Assignment 2
Background image of page 4
Teaching assistants n Chui Chun Kit (Kit) Office: 317C Chow Yei Ching Building Email: ckchui@cs.hku.hk Tel: 2857 8435 n Jin Yifan (Yvonne) Consultation hour: Wednesday 16:00-17:00 Office: HW520 Email: yfjin@cs.hku.hk Tel: 2857 8273 n Zhang Peiwu (Paul) Consultation hour: Monday 14:00-15:00 Office: HW335A Email: pwzhang@cs.hku.hk Tel: 2859 2713 Please feel free to seek for help from us when you have any problem with the course & 55 Written assignments Quiz Lecture materials Tutorial materials Final examination Programming assignment Mid-terms
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Click to edit Master subtitle style Introduction MySQL 66
Background image of page 6
Dynamic web page request process 77 HTTP request (e.g. http://www.facebook.com/index.php) E.g. facebook news feed page Execute server-side programme, Generate a web page for that particular request. Application server Database system SQL Web server Client (web browser) The generated web page E.g. my personal facebook news feed The generated web page E.g. my personal facebook news feed Result
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction to MySQL n MySQL is a successful relational database management system (RDBMS). n MySQL is fast, multi-user and robust SQL system, it supports time-critical and heavy load system. n It can be embedded into different kinds of software and be accessed using various programming languages.
Background image of page 8
Limitation about MySQL n In the old version, MySQL doesn’t support checking of the referential constraints ¨ E.g., foreign key constraints. ¨ In MySQL Server 3.23.44 and up, it begins to support checking constraints. n Currently not supported by the MyISAM storage engine. n It is supported by the InnoDB storage engine. ¨ The MySQL version we use is 5.1.41 . ¨ http://dev.mysql.com/doc/refman/5.1/en/differences-from-ansi.html n In MySQL, || and “OR” are equivalent. It doesn't support the standard SQL || operator for string concatenation.
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/01/2010 for the course CS 0278 taught by Professor Dr during the Spring '10 term at HKU.

Page1 / 63

Tutorial5 - C0278A Introduction to Database Management...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online