Transcript Fundamentals of Database Systems

is422- Course Overview
1
Prepared by L. Nouf Almujally
Course Objectives
• Fundamental concepts of database systems, in particular,
relational database systems
• You should have a good understanding of these
concepts
• Use of database languages, in particular, SQL
• You should be able to use SQL to create, maintain, and
query a relational database.( Oracle RDBMS)
• Relational database design principles, methodology, and
tools
• you should be able to design a good relational
database, given the data requirements.
2
Assessment
Dues
LECTURES
Mid 1( 12 %)
Mid 2 ( 13 %)
LAB
Project ( 10% )
Homework ( 5 % )
FINAL
Final lab ( 10 % )
Final ( 50 % )
Total
Due date
Marks
Week 7
Week 12
10
10
Week 14
Check course website
10
5
Refer to IS department
Refer to IS department
10
50
100
3
Contact Information
• Email: [email protected]
• Office No.: 1-501-15
• Office hour: Check my schedule
• Course website : aalarfaj.yolasite.com
• Make an appointment to see me except during consultation
time
4
Textbook and Other Resources
Main reference :
• “Database Systems: A Practical Approach to Design,
Implementation and Management.” Thomas Connolly, Carolyn
Begg. 5th Edition, Addison-Wesley, 2009
• "Fundamentals of Database Systems", Ramez Elmasri,
Shamkant B. Navathe, Addison Wesley, The Latest Edition.
Other :
• "DATABASE MANAGEMENT SYSTEMS", by Raghu
Ramakrishnan, JohannesGehrke, The Latest Edition.
• "MODERN DATABASE MANAGEMENT",by Jeffrey A. Hoffer,
Mary B. Prescott, Fred R. McFadden, Prentice Hall, The Latest
Edition
5
Course Website
You will find :





Announcements
Lectures
Homework
Assignments and projects
Grades
You have to check your blackboard daily
http://422db.blog.com
6
Course Communication
• Questions are encouraged
• Discussion/collaboration (not copying) among
students are encouraged
• feedback on the course is always welcome!
7
Is this course difficult?
• Yes
• Some technical material may be hard for some
students
• Some stuff may seem simple, but you need to
practise with many exercises before you can
successfully apply them to practical problems
• No
• Not too deep in theory
• Not too broad in scope of content
• You can successfully complete it if you study
8
software you may have for this course
•
•
•
•
Oracle 10g
Notepad++
Visio
Microsoft office, PowerPoint
9
What we do in this course?
• Train you as a database designer
• Focus on basic concepts, SQL and logical design
• Physical design is related to DBMS product and will be
briefly introduced
• Major Contents
• Basic concepts
• SQL
• ER modelling
• Normalization ( is the process of efficiently organizing
data in a database )
10
General information
• Attendance will be taken by the end of the class. If you
are absent for a reason it is your responsibility to submit
your sick leave by the next class.
• Mobiles are not allowed to be used in class at all.
Therefore, please keep it off or silent during class time.
• No late submissions AT ALL !!
• Copying from another student will result in a ZERO mark
for all involved students
11
• Exams will cover materials from the textbook, as well as
material presented in the class.
• Students who are absent on Midterm exam day due to
illness are required to bring a signed medical excuse
letter.
• It is the student’s responsibility to contact the instructor
if the midterm exam was missed within one (1) week
following the scheduled exam date
• Make-up exams will be offered for valid reasons only
signed by the head of the department.
• Make-up exams may be different from regular exams in
content and format
12