Transcript CS 195 Course Outline & Introduction to Java

CSC 411/511:
DBMS Design
Course Outline
Dr. Nan Wang
CSC411_L0_Outline
1
Instructor
• Instructors:
– Nan Wang
• Office: TEC 232
• Phone: (601) 266-6286
• Email: [email protected]
• Meeting time and location:
– 1:00PM – 2:15PM Tu/Th
– Classroom: MCL160
Dr. Nan Wang
CSC411_L0_Outline
2
Course Home Page
• Course URL [link]
– www.cs.usm.edu/~nwang/teaching/csc411
• Office hours
– 9:30AM – 11:30AM Tu/Th
• Course announcements
– Available online or in classroom
• About lecture notes
– Usually available on the course homepage
Dr. Nan Wang
CSC411_L0_Outline
3
Prerequisites
• CSC 307 Data Structure and Algorithm Analysis
• Some programming language background
• C++
• Java
• PHP
• Perl
• etc
Dr. Nan Wang
CSC411_L0_Outline
4
Textbook
• Textbook
–
–
–
–
Database Management Systems, 3rd Ed.
by Raghu Ramakrishnan
McGrw-Hill Science/Engineering/Math
ISBN: 0-07-246563-8
Dr. Nan Wang
CSC411_L0_Outline
5
Course Description
• This course introduces the fundamental concepts
of database management
–
–
–
–
–
Data models
Database design
Database languages (SQL)
Storage
Development
Dr. Nan Wang
CSC411_L0_Outline
6
Topics
• Topics to be covered include:
– Introduction to database management
– The entity relationship data model and conceptual schema
design
– The relational data model and relational database design
– SQL and relational algebra
– Storage and indexing
– MySQL and Oracle database
– Application development
– Other selected topics
Dr. Nan Wang
CSC411_L0_Outline
7
Objectives
• Upon completion of the course, students will be
able to:
– become proficient at modeling databases at conceptual and
logical levels of design
– be able to develop database schemas with principled design
that enforce data integrity
– become knowledgeable in the creation, altering, and
manipulation of tables, indexes, and views using relational
algebra and SQL
– become proficient at writing queries in SQL to retrieve data
from database
– be able to develop and maintain Oracle database, and write
application programs
Dr. Nan Wang
CSC411_L0_Outline
8
Use Oracle 10g Database
• Use MySQL 5.0
Dr. Nan Wang
CSC411_L0_Outline
9
Schedule
• See course home page
– Available
Dr. Nan Wang
CSC411_L0_Outline
10
Grading
• Your course grade consists of 4 components:
–
–
–
–
–
Attendance 5%
Assignments 15%
Projects 30%
Exams 30%
Final exam 20%
• Course grading scale:
–
–
–
–
–
90% - 100%
80% - 89%
70% - 79%
60% - 69%
0% - 59%
Dr. Nan Wang
A
B
C
D
F
CSC411_L0_Outline
11
Homework Policy
• Homework policy
– The requirements are given on the course homepage
– All assignments and projects are mandatory for all students
– Assignments must be handed in by the due time.
• No late assignment will be accepted unless compelling
reasons can be supplied and verified.
• Late assignments will receive no grade.
• Grader
Dr. Nan Wang
CSC411_L0_Outline
12
Honesty
• Students are expected to do their own work on all
assignments
• The code, writing and final result that you hand in
must be your own effort but you are welcome to
discuss general issues with instructor and other
students
• Cheating or plagiarism of any kind will not be
tolerated
• This doesn’t apply to the group assignment
Dr. Nan Wang
CSC411_L0_Outline
13
Attendance
• Students are expected to attend all classes
Dr. Nan Wang
CSC411_L0_Outline
14
CSC 411/511:
DBMS Design
Questions?
Dr. Nan Wang
CSC411_L0_Outline
15