csen5314 database systems spring semester, 2015 01/20/2015 overview instructor: ashraf yaseen...
Post on 19-Dec-2015
217 Views
Preview:
TRANSCRIPT
CSEN5314 DATABASE SYSTEMSSpring Semester, 2015
CSEN5314 DATABASE SYSTEMSSpring Semester, 2015
01/20/2015
OverviewInstructor: Ashraf Yaseen
DEPARTMENT OF ELECTRICAL ENGINEERING & COMPUTER SCIENCE
1
Outline
Course Administration Course Overview
2
Administrivia
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
3
Administrivia-cont.
E-Mail ashraf.yaseen@tamuk.edu
Instructor: Ashraf Yaseen Office location: EC, 354 Office hours:
MW: 12-2pm, 3-5pm. T: 4-5pm. F: 12-1pm. by appointment
Office phone: TBA
4
Administrivia-cont.
Textbook Fundamentals of Database Systems. 6th
Edition. By Ramez Elmasri & Shamkant Navathe, Pearson Education. ISBN: 9780133001655
http://www.pearsonhighered.com/elmasri/
5
Administrivia-cont.
Grading Policy
Late Assignment Policy 00~24 hrs: -10% 24~48 hrs: -20% >48 hrs: grade = 0
Class participation and presentation quality will also impact final grade
6
Activities/Evaluation Methods
Number
Percentages
Homework 5 20%Quizzes 5 10%Project 1 20%
Midterm Exam 1 20%Final Exam 1 30%
Total 100%
>=90% A Excellent80-89% B Very Good70-79% C Good60-69% D Failed<60% F Failed
Honor Code 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
7
How to get help?
Ask questions in class (or after class) Attend office hours Email me
Make sure that you put “CSEN5314” in your subject line
Send it from your tamuk.edu account It wouldn’t come to my spam folder
State clearly what you need in your email
8
How to Get an A in this Class 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
9
What You Will Learn
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
10
Topics
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
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
Part4: Object, Object-Relational, and XML: Concepts, Models, Languages, and Standards
11
More Topics
Part5: Database Programming Techniques Introduction to SQL Programming Techniques Web Database Programming Using PHP
Part6: Database Design Theory and Normalization Functional Dependencies & Normalization
(extra-not included in this course) Part7: File Structures, Indexing, and Hashing Part8: Query Processing and Optimization, and Database
Tuning Part9: Transaction Processing, Concurrency Control, and
Recovery Part10: Additional Database Topics: Security and Distribution Part11: Advanced Database Models, Systems, and
Applications
12
Greater Expectations
Class Attendance & Participation: mandatory In-Class exercises/discussion questions
Solidify your understanding
Help gauge your understanding
Increase interactivity (reduce boredom)
You are expected to try your best in class
By attending, you work less out class.
If you miss class, you are responsible for learning what you missed
13
Greater Expectations-cont.
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!”
14
Greater Expectations-cont.
Student Presentations: Prepare/practice and cover all material clearly
and concisely (set time limit) Refresh/integrate course material before exams Student explanation benefits audience, presenter Practice: presentation skills are a key to success
Submitted work: neat, complete, well-organized logic, programming, math: clearly show steps
towards solution, comment programs Explanatory paragraphs: thoughtful, legible,
grammatical, full sentences
15
Greater Expectations-cont.
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.
16
While in Class,
No Facebook No Cell phone No Music players No Topic unrelated to class. No Sleep No Food No bad jokes
17
About Me
Bachelor’s from JUST (Jordan University of Science & Technology)
Master’s from NYiT (New York Institute of Technology)
Ph.D. ODU (Old Dominion University) My Research
Computational Biology High Performance Computing
18
How about you?19
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
Get started early! Review Chapter 1 and Class Slides Enjoy your new semester
20
top related