1 / 23

CMPT 258 Database Systems

CMPT 258 Database Systems. Instructor: Tina Tian. General Information. Email: tina.tian@manhattan.edu Office: RLC 203A Office Hour: Mon, Thur 1:30 - 2:30PM Wednesday 12:00 - 1:00PM or by appointment Website: home.manhattan.edu/~ tina.tian. About the Course.

wynter-haney
Download Presentation

CMPT 258 Database Systems

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. CMPT 258 Database Systems Instructor: Tina Tian

  2. General Information • Email: tina.tian@manhattan.edu • Office: RLC 203A • Office Hour: Mon, Thur 1:30 - 2:30PM • Wednesday 12:00 - 1:00PM • or by appointment • Website: home.manhattan.edu/~tina.tian

  3. About the Course • Mon, Wed, Thur 11:00 - 11:50 • Textbook: • Database Management Systems, 3rdEdition by Raghu Ramakrishnan and Johannes Gehrke

  4. Grading • Class performance and participation 5% • 1st Midterm Exam (in class, 5th week) 15% • 2nd Midterm Exam (in class, 10th week) 15% • Final Exam 30% • Homework 35%

  5. Attendance policy • Attendance is required. • Students are expected to attend all classes and will be held responsible for all material covered during each class.

  6. Electronic Devices • Please do not check e-mail or visit websites that are not relevant to the course during class. • It is a distraction, both for you and (more importantly) for your fellow classmates. • Please keep your phones silent during class.

  7. About the Homework • Only hard copy is accepted. (Complicated ER diagrams can be drawn by hand) • Make a cover page (name, homework number) • Due in a week after being announced • Late work will not be accepted

  8. Homework Policy • You may discuss the homework/projects with other students. • However, you must acknowledge the people you worked with. • And you must independently write up your own solutions. • Any written sources used (apart from the text) must also be acknowledged.

  9. Advises • Keep monitors off! • Take notes • Start the homework and programming assignments early

  10. What will be covered • This course introduces the fundamental concepts of database management • Introduction to database management (Chap 1) • The entity relationship data model and conceptual schema design (Chap 2)

  11. What will be covered • The relational data model and relational database design (Chap 3) • Relational algebra (Chap 4) • SQL queries, constraints and triggers (Chap 5)

  12. Q6: Find sid’s of sailors who’ve reserved a red boat but not a green boat: SELECTS.sid FROM Sailors S, Boats B, Reserves R WHERES.sid=R.sidANDR.bid=B.bidANDB.color=‘red’ ANDS.sidNOT IN (SELECT S2.sid FROM Sailors S2, Boats B2, Reserves R2 WHERE S2.sid=R2.sid AND R2.bid=B2.bid AND B2.color=‘green’)

  13. What will be covered • Application development (Chap 6 & Chap 7 & supporting material) • JDBC (Java) • Web (PHP) • Schema refinement and normal forms (Chap 19) • Redundancycauses several problems associated with relational schemas. • Functional dependencies, can be used to identify schemas with such problems and to suggest refinements.

  14. Software • MySQL 5.6 • MySQL is a relational database management system. • free and open source

  15. Download MySQL • http://dev.mysql.com/downloads/

  16. Readings • Chapter 1

More Related