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: nan.wang@usm.edu
• 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% A
– 80% - 89% B
– 70% - 79% C
– 60% - 69% D
– 0% - 59% F
Dr. Nan Wang 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