1 / 12

is321- Course Overview

is321- Course Overview. 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

glenna-hunt
Download Presentation

is321- Course Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. is321- Course Overview Prepared by L. NoufAlmujally

  2. 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.

  3. Assessment

  4. Contact Information • Email:naalmujally@pnu.edu.sa • Office No.: 1-501-33 • Office hour: Check my schedule • Course website : http://422db.blog.com • Make an appointment to see me except during consultation time

  5. 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", RamezElmasri, 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

  6. Course Website You will find : • Announcements • Lectures • Homework • Assignments and projects • Grades • You have to check your blackboard daily http://422db.blog.com

  7. Course Communication • Questions are encouraged • Discussion/collaboration (not copying) among students are encouraged • feedback on the course is always welcome!

  8. 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

  9. software you may have for this course • Oracle 10g • Notepad++ • Visio • Microsoft office, PowerPoint

  10. 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 )

  11. 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

  12. 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

More Related