Transcript CPS3320-Overview - ODU Computer Science

1
CPS3320
DATABASE SYSTEMS
Spring Semester, 2014
Overview
Instructor: Ashraf Yaseen
01/13/2014
DEPARTMENT OF MATH & COMPUTER SCIENCE
CENTRAL STATE UNIVERSITY, WILBERFORCE, OH
Outline
2


Course Administration
Course Overview
Administrivia
3


Class Website

http://www.cs.odu.edu/~ayaseen

Syllabus: Class Policy

Class Notes: Posted before class, Read notes before class

Assignments: Pay attention to the due dates

Announcements, clarifications, FAQs posted
Blackboard

Posting grades

Sending out emails to class
Administrivia-cont.
4

E-Mail


[email protected]
Instructor: Ashraf Yaseen

Office location: Henderson Hall, 139

Office hours:
 M,W,F:
 by

11:00AM-2:00PM
appointment
Office phone: 937-376-6365
Administrivia-cont.
5

Textbook
 Fundamentals
of Database Systems. 6th Edition. By
Ramez Elmasri & Shamkant Navathe, Pearson
Education. ISBN: 9780133001655
 http://www.pearsonhighered.com/elmasri/
Administrivia-cont.
6

Grading Policy
Activities/ Number Percentages
Evaluation Methods
First Exam
1
15%
Second Exam
1
20%
Quiz
5
15%
Project
1
15%
Final Exam
1
35%
Total
100%

Late Assignment Policy




0~24 hrs: -5%
24~48 hrs: -10%
>48 hrs: grade = 0
>=90%
80-89%
70-79%
60-69%
<60%
A
B
C
D
F
Excellent
Very Good
Good
Passed
Failed
Class participation and presentation quality will also impact final grade
CSU Honor Code
7





The Honor Code applies to your conduct in this course. If you
have questions, talk to me
HOMEWORK:
 All submitted work must be your own
 Do not copy another student’s work
 Do discuss material and homework with classmates, professor
EXAMS: Do not give assistance to or receive assistance from
anyone but professor
Violations of this Code are treated seriously
Evidence of cheating, plagiarism, or unauthorized collaboration
will result in a 0 grade for quiz/assignment/exam

May have further consequences
How to get help?
8



Ask questions in class (or after class)
Attend office hours
Email me
 Make
sure that you put “CPS3320” in your subject line
 Send it from your .odu account
 It
wouldn’t come to my spam folder
 State
clearly what you need in your email
How to Get an A in this Class
9

Attendance
 Attend
class regularly and on time
 Ask questions
 Work on in-class exercises and assignments

Notes
 Read
over class notes before class
 Review class notes after class

Homework
 Get
started as early as possible
 Contact me if you encounter problems
What You Will Learn
10



Define the basic terms associated with database systems (such as database,
database management system, primary key, foreign key, database
administrator, benefits of database systems, factors to consider when
buying a DBMS).
Create a conceptual design for a database based on problem
specifications and user-requirements.
Choose a suitable DBMS; and mapping the conceptual design of a
database into the selected DBMS’s format.

Build queries using Relational Algebra.

Create queries using SQL and display the query output.

Model databases using the ER and EER models.

Normalize data and transform it into forms that are most suitable to the
applications at hand
Topics
11

Part 1: Introduction to Databases



Databases and Database Users
Database System Concepts and Architecture
Part 2: Relational Data Model and SQL




The Relational Data Model and Relational Database
Basic SQL
More SQL
The Relational Algebra

Part 3: Conceptual Modeling and Database Design

Data Modeling Using the Entity-Relationship (ER) Model
 The Enhanced Entity-Relationship (EER) Model
 Mapping a Conceptual Design into a Logical Design
Database Design Theory: Functional Dependencies & Normalization

Greater Expectations
12

Class Attendance & Participation: mandatory
 In-Class
exercises/discussion questions
 Solidify
 Help
gauge your understanding
 Increase
 You
 By
 If
your understanding
interactivity (reduce boredom)
are expected to try your best in class
attending, you work less out class.
you miss class, you are responsible for learning what you
missed
Greater Expectations-cont.
13

Arrive on time to class
 your

grade will be affected if you are consistently late
If you are absent, first check the course webpage
for missed notes and/or assignments
 Don't
come ask me, “Did I miss anything important?”
 The answer is “Yes!”
Greater Expectations-cont.
14

Student Presentations:
 Prepare/practice
and cover all material clearly and
concisely (set time limit)
 Refresh/integrate
 Student
explanation benefits audience, presenter
 Practice:

course material before exams
presentation skills are a key to success
Submitted work: neat, complete, well-organized
 logic,
programming, math: clearly show steps towards
solution, comment programs
 Explanatory
full sentences
paragraphs: thoughtful, legible, grammatical,
Greater Expectations-cont.
15


Behave and perform in a professional manner
 Be punctual, dress appropriately and be attentive
 Respect the rights of all participants by turning off any
device that could cause a disturbance during class (this
includes pagers, cell phones, personal alarms and music
players).
Negative behavior patterns in class (e.g. unexcused absences,
tardiness, and class disruptions, wearing hats, eating, drinking,
smoking and sleeping) will be treated seriously
 could result in a reduction of a student’s final grade.
While in Class,
16







No Facebook
No Cell phone
No Music players
No Topic unrelated to class.
No Sleep
No Food
No bad jokes
About Me
17




Bachelor’s from JUST (Jordan University of
Science & Technology)
Master’s from NYiT (New York Institute of
Technology)
Ph.D. (in process) ODU (Old Dominion
University)
My Research
 Computational Biology
 High Performance Computing
How about you?
18

Tell us your name and year

In a few sentences, tell us about you, e.g.
 Where
are you from?
 What is your major?
 Career plans or after-college plans?
 Favorite hobby, sport?
 Something interesting about yourself

Expectation in this class
What I want you to do
19



Get started early!
Review Chapter 1 and Class Slides
Enjoy your new semester