Tutorial8

Tutorial8 - C0278A INTRODUCTION TO DATABASE MANAGEMENT...

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
12/2/10 Teaching assistants Chui Chun Kit (Kit) Office: 317C Chow Yei Ching Building Email: ckchui@cs.hku.hk Tel: 2857 8435 Jin Yifan (Yvonne) Consultation hour: Wednesday 16:00-17:00 Office: HW520 Email: yfjin@cs.hku.hk Tel: 2857 8273 Zhang Peiwu (Paul) Consultation hour: Monday 14:00-15:00 Office: HW335A Email: pwzhang@cs.hku.hk Tel: 2859 2713 22 Please feel free to seek for help from us when you Written assignments Quiz Lecture materials Tutorial materials Final examination Programming assignment Mid-terms
Background image of page 2
12/2/10 OUTPUT BASED LEARNING (OBL) Outcome 1. Information Modeling Able to understand the modeling of real life information in a database system. Outcome 2. Query Languages Able to understand and use the languages designed for data access. Outcome 3. System Design Able to understand the design of an efficient and reliable database system. 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
12/2/10 IN THIS TUTORIAL… Outcome 1. Information Modeling Able to understand the modeling of real life information in a database system. Outcome 2. Query Languages Able to understand and use the languages designed for data access. Outcome 3. System Design Able to understand the design of an efficient and reliable database system. Outcome 4. Application Development Able to implement a practical application on a real database 44
Background image of page 4
12/2/10 IN THIS TUTORIAL… p Midterm solutions ER-Diagram Relational Tables Relational Algebra SQL p Assignment2 solutions
Background image of page 5

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

View Full DocumentRight Arrow Icon
12/2/10 Part I. Review of Basic Concepts Part I. Midterm Solutions
Background image of page 6
12/2/10 Question 1 (ER-Diagram)
Background image of page 7

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

View Full DocumentRight Arrow Icon
12/2/10 Common mistakes p keyword(s) and comment(s) are multi-value attributes p Miss the share relationships ……All data items can be shared among members…… keywor d keyword Memb er Shar es Data Item
Background image of page 8
12/2/10 Common mistakes p Weak-entity p Notation Membe r friendsh ip request accept fdate ……to identify an item, the name of the item has to be used together with the installation ID of the program…… Progr am associa tes Data Item Total participation Don’t miss the notation
Background image of page 9

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

View Full DocumentRight Arrow Icon
12/2/10 Relationals table Member (mid , name, birthday) Foreign key: none friendship (request.mid, accept.mid , fdate) Foreign key: {request.mid} referencing Member {accept.mid} referencing Member installs (mid, installation_id ) Foreign key: {mid} referencing Member {installation_id } referencing Member Program (installation_id , prog_name) Foreign key: none DataItem (installation_id, item_name , c_date) Foreign keys: {installation_id } referencing Program Photo (installation_id, item_name , image_file) Foreign key: {installation_id } referencing Program Blog (installation_id, item_name , main_tex) Foreign key: {installation_id} referencing Program
Background image of page 10
12/2/10 Relationals table Keyword (installation_id, item_name, keyword ) Foreign key: {installation_id } referencing Program Comment (installation_id, item_name, comment
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
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 / 41

Tutorial8 - C0278A INTRODUCTION TO DATABASE MANAGEMENT...

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

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