1 / 16

Instructors: Prof. Xu Jianliang ( 徐建良 ) Dr. Chen Rui ( 陳睿 )

COMP 1160/2016 Database Management http://www.comp.hkbu.edu.hk/~comp2016 user name: db / password: db. Instructors: Prof. Xu Jianliang ( 徐建良 ) Dr. Chen Rui ( 陳睿 ). A Proposal: Class Rules. Turn off your cell phone or keep it on vibrate/silent mode

shafira-campbell
Download Presentation

Instructors: Prof. Xu Jianliang ( 徐建良 ) Dr. Chen Rui ( 陳睿 )

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. COMP 1160/2016Database Managementhttp://www.comp.hkbu.edu.hk/~comp2016user name: db / password: db Instructors: Prof. Xu Jianliang (徐建良) Dr. Chen Rui (陳睿)

  2. A Proposal: Class Rules • Turn off your cell phone or keep it on vibrate/silent mode • Keep listening, thinking, taking notes, … • But NO TALKING PLEASE! • to respect your fellow students, your instructor, and yourself • Agreed on???

  3. What is a database? Where do we have databases?

  4. Bear & Rabbit’s activities on 10 Sept, 2013 • In School • Submitted a course add/drop form to AR • Paid tuition fee in Hang Seng Bank • Borrowed the textbook from the library • Ordered the textbook of COMP1160 • Went to Mongkok • Purchased Smartphone for O’night

  5. Database is everywhere • Student / Course records • Banking transactions • Library book records (http://www.hkbu.edu.hk/lib) • Online bookshop (http://www.amazon.com/) • DC community (http://www.dcfever.com/)

  6. Database • is more than just a data base… • is a collection of data that is organized so that its contents can easily be accessed, managed, and updated

  7. Example database Students Courses Enrolled

  8. Database concepts Attribute • A database consists of one or more tables • Eachtable is made up of a number of records (a.k.a tuples) • Each record contains several attributes cid grade sid 00001 comp1160 B courses comp1160 00002 A Record students enrolled Table

  9. Extract information from a database • We can ask a database questions. For example: • Who has student id ‘1001’? • Which courses has Bob taken? • How many students are enrolled in COMP1160? • But a database doesn’t speak English…

  10. Database language (SQL) • Who has student id ‘1001’? • SELECT name • FROM Students • WHERE sid = ‘1001’;

  11. Course Objectives • To learn how to manage such a database, emphasize on • How to design a database (using ER Model) • How to query a database (using SQL language)

  12. Text Textbook • R. Ramakrishnan and J. Gehrke, Database Management Systems, 3rd Edition (ISBN 0-07-115110-9), McGraw-Hill, 2003. References • A. Silberschatz, H. F. Korth, and S. Sudarshan, Database System Concepts, McGraw-Hill, 2010. • J. A. Hoffer, M. Prescott, and F. McFadden, Modern Database Management, Prentice Hall, 2007.

  13. Assessment • Continual Assessment: 30% • Home/In-lab Assignments: 12% • One online assignment • Two take-home assignments • Six in-lab assignments (starting from mid-October) • Mid-term test: 9% • Group Project: 9% • Final Exam: 70%

  14. Assessment Guides • Criterion-Referenced Assessment • Intended Learning Outcomes & Rubrics • To pass this subject, final exam must be >= 30%; overall score must be >= 35%

  15. BEWARE!!! • Unless otherwise stated, all work submitted by you should be your own. • Copying or sharing of assignments or any submitted work constitutes cheating. • If there is any doubt about the appropriateness of your actions, please contact the instructor for explicit clarification.

  16. Cost of Plagiarism • Plagiarism is an offense and will result in appropriate disciplinary action against those involved. • Penalty will be applied indiscriminatingly among those who involve (the one who copy and the one being copied). The minimum penalty would be receiving zero mark for the submitted work. • Please refer to the following URL for the university’s guideline on penalizing plagiarism: http://buar.hkbu.edu.hk/uploads/files/avoiding_plagiarism/V_The_Cost_of_Plagiarism.pdf

More Related