1 / 15

Welcome to GC311 Database Concepts

Learn about database concepts and architecture, data models, schemas and instances, and program data independence. Understand database languages, SQL queries, and database design.

sylviae
Download Presentation

Welcome to GC311 Database Concepts

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. Welcome to GC311Database Concepts First Semester 1437/1438H

  2. Getting to know me • Instructor:Huda Alomair • Office Location: BLd 26 ,  level # 1 , ward A , office 7 • Email Address: halomair@ksu.edu.sa

  3. Course Description

  4. Course Description • Characteristics of the database approach. • Database concepts and architecture; Data models, schemas and instances; Program data independence, Database languages and interfaces. • Data models for database systems; The E-R DM, Relational DM and Relational Algebra. • Relational model constraints; Domain, key, and integrity constraints. • SQL-relational DB language; Data definition, queries, update statements, and views in SQL. • Database design; functional dependencies, Normal forms.

  5. What will we learn? We will learn HOW to Design and implement Normalized Databases

  6. Course Syllabus • Introduction to Databases and Database Environment • Entity Relationship and Enhanced Entity Relationship Modeling • Relational Model • Relational Algebra • SQL: Data Manipulation Language • SQL: Data Definition Language • Normalization • Methodology – Conceptual Database Design • Methodology – Logical Database Design • Methodology – Physical Database Design • Object Oriented DBMSs • Object Relational DBMSs

  7. Assessment & Course Policies

  8. Policy • No phone/chatting during class time, any violation will be asked to leave the classroom. • No talking or disturbing others during the class • It is better to contact me using “KSU-email”, form other domain , your name it should be clear , others will be deleted. • Email related to Labs should be sent to TA.

  9. Assessment Methods & Grading Scheme

  10. Exams & Classes Policies • You will be able to access the class 10 minutes after the lecture starts, however, you will be marked absent. • Mobiles should be turned off/silent during class/exam. • NO make up exams, exceptions will be considered with evidence and the approval of the depatment committee. • No changes in the announced exam dates after 3rd week. • Exams are closed book so do not bring any external notes or papers. • The using of dictionary is allowed. • More than one answer is not acceptable for a single question unless admitted by instructor. • Academic dishonesty is strictly prohibited, and both parties will be penalized.

  11. Assignments Policies • No sheet will be accepted after due date. • Cheating is prohibited; so if we caught any identical assignments both will take 0.

  12. Course Resources

  13. Textbooks • “Database Systems: A Practical Approach to Design, Implementation and Management.” Thomas Connolly, Carolyn Begg.   5th Edition, Addison-Wesley, 2009.

  14. Required Software • Database Management System • Oracle SQL • ER Diagram Tool • Microsoft Visio 2007-2010 or upper ( Free trial – 60 days ) • OR Easy Entity Relationship Diagram Software from Smart draw.

  15. You are advised to follow the text book for this course during the entire semester. In case the instructor is teaching some extra topics which are not covered in the text book, photocopy material will be provided. • Daily studying and doing your course work by yourself lead to successful . How to Study for this Course

More Related