cs 440 lecture 1

cs 440 lecture 1 - 1/16/2009 CS 440: Database Management...

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

View Full Document Right Arrow Icon
1/16/2009 1 CS 440: Database Management Systems Class Information z Instructor: Eugene Zhang (zhange@eecs.oregonstate.edu ) 2111 KEC Office hour: MWF 4:00 5:00 Office hour: MWF 4:00 – 5:00 z TA: Tuan Pham (pham@eecs.oregonstate.edu ) BAT 349 Office hour: MWF 1:30 – 3:00 z Class web site: http://classes.engr.oregonstate.edu/eecs/winter2009/cs440/ Textbooks z Required z Optional Grading z Homework 5x10=50 z Midterm 25 z Final project 25 ------------- 100 Final Project z A group of two students z Project idea needs to be agreed upon between the students and the instructor z Possible topics available after the midterm Grading z Notes: – Late assignments – Grading problems
Background image of page 1

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

View Full DocumentRight Arrow Icon
1/16/2009 2 Learning Objectives z Collect, analyze, and decompose system requirements. z Create a data model diagram for a complex, realistic database system. z Use advanced database tools such as application generators and form generators. z Apply methods and tools for web-based database applications. Learning Objectives z Use advanced features of query languages. z Design, implement and test database applications of realistic complexity. z Convert data to/from various proprietary database formats. z Participate effectively in team development of a marketable database application. Other Class-Related Issues z Academic dishonesty z Expectations Attend lectures – Attend lectures – Be on time z Students with disabilities Database Access z Visit http://secure.engr.oregonstate.edu/phpMyAdmin/ z Choose server mysql.cs.orst.edu and log in z Database name: your ONID z User id: your ONID z Password: last four digits of your OSU ID Questions? Topics To Cover z Relational algebra and calculus z Normal forms z Physical data storage and retrieval z Indexes z Query processing and optimization z Transactions z New types of databases
Background image of page 2
1/16/2009 3 What We Have Covered In 275 (for Prof. Minoura’s and my classes) z Relational databases z ER modeling z Relational algebra z SQL Review of Relational Databases z Database is a coherent collection of data with some inherent meaning and is designed, built and populated with data for specific built, and populated with data for specific purpose . Review of Relational Databases z A database can be of any size and varying complexity , which requires the database to be well-organized and managed. Review of Relational Databases z Database management systems (DBMS) is a collection of programs that allows users to create and maintain a database, e.g., – construction – manipulation – sharing – protection – maintenance Review of Relational Databases z Database management systems (DBMS) is a collection of programs that allows users to create and maintain a database.
Background image of page 3

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

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

This note was uploaded on 06/28/2009 for the course CS 440 taught by Professor Staff during the Spring '08 term at Oregon State.

Page1 / 12

cs 440 lecture 1 - 1/16/2009 CS 440: Database Management...

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

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