Transcript overview
CSE3330/5330 DATABASE SYSTEMS AND FILE STRUCTURES (DB I) CSE3330/5330 DB I, Summer2012 Lecture 1: Introduction Department of Computer Science and Engineering, University of Texas at Arlington ©Ning Yan, 2012 Self Introduction Ning Yan Http://idir.uta.edu/~nyan/ Research interests: databases, Web data management, data mining, information retrieval Courses that I TAed: CSE1310 (C programming) CSE5301 (Data Modeling) CSE5334 (Data Mining) CSE6339 (Data Exploration) Lecture 1: Introduction 2 Background Check Prerequisite: CSE 2320 ALGORITHMS & DATA STRUCTURES or CSE 2321 DATA STRUCTURES FOR NON-ENGINEERS Lecture 1: Introduction 3 Course Homepage http://idir.uta.edu/~nyan/cse3330 Announcements, Syllabus Schedule (lecture notes) Resources Accommodation Lecture 1: Introduction based on disability. 4 Basics Lectures: Tue/Thu 3:30-5:20pm, NH110 Office Hours: Wednesday 3:00-5:00pm ERB514 Contact: ning.yan [at] mavs [dot] uta [dot] edu, (682) 2279412 TA: ? Lecture 1: Introduction 5 Textbook Required Textbook: Ramez Elmasri and Shamkant Navathe. Fundamentals of Database Systems (6th Edition), Addison-Wesley Publishers, April 2010. ISBN 0136086209. Reference Textbook: Abraham Silberschatz, Henry Korth, and S. Sudarshan, Database System Concepts, McGraw-Hill Publishers, 2010. ISBN 0073523321. Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom, Database Systems: The Complete Book (2nd Edition), Prentice Hall. 2008. ISBN 0131873253. Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems (3rd Edition), McGraw-Hill Publishers, 2002. ISBN 0072465638. 6 Disclaimer: the slides The slides highlight the gist of the most important concepts and techniques. But It is not meant to be complete. Details may not be included. It may be simplified for ease of explanation in limited time and space. You may not do well in the course if you just read the slides. You need to read the book and study the slides carefully. Lecture 1: Introduction 7 Tentative Grading Scheme Midterm Final Homework (HW) 30% (Must be done independently) Course Project 20% (Must be done independently) 20% 30% Final Letter Grade: No pre-defined cutoffs. Will be based on bell curve of your performance. Lecture 1: Introduction 8 Homework (HW) – 30% Problem solving Focus on most important topics HW1,HW2, HW3, 10% each Lecture 1: Introduction 9 Projects (P1-P2) – 20% 2 Programming Assignments, 10% each More hands-on experience Mostly implementation Lecture 1: Introduction 10 Exams – 50% Midterm: (20%) Tuesday, July 10th, 3:30pm-5:20pm, NH110 Final: (30%) (comprehensive, covers the whole semester) Tuesday, August 14th, 3:30pm-5:20pm, NH110 Do mark your calendar! Lecture 1: Introduction 11 BlackBoard http://www.uta.edu/blackboard/ Student assignment submission (we don’t accept email submission or hard-copy) HW1-HW3 P1-P2 Grades Lecture 1: Introduction 12 Deadlines Everything will be submitted through BlackBoard. Due time: 11:59pm Late submission: 5-point deduction per hour, till you get 0. (The raw score of each assignment is 100. So there is no point to submit it after 20 hours). Lecture 1: Introduction 13 Regrading 7 days after we post scores in BlackBoard. TA will handle regrade requests. Won’t consider it after 7 days. If not satisfied with the results, 7 days to request again. Instructor will handle it, and the decision is final. Lecture 1: Introduction 14 Topics Lecture 1: Introduction 15 Topics -------------------10 lectures-------------------Database System Concepts and Architecture (2) Relational Model (2) Basic SQL & More SQL (6) --------------------10 lectures- ----------------Entity-Relationship Model (ER, EER) (2) Relational Database Design (2) Database Programming (2) File Structures and Indexing (2) (Relational Algebra & Normalization) (2) Lecture 1: Introduction 16 Check Your Email Make sure your MavMail works. We will only contact you by your MavMail. Check it on a regular basis. Lecture 1: Introduction 17 Setup MySQL We will use MySQL throughout this course Set up MySQL Use omega.uta.edu with NetID/Initial Passwd Install MySQL on your own laptop Read introduction to MySQL Practice SQL in/after class Lecture 1: Introduction 18 Statement on Ethics Please sign and date. Lecture 1: Introduction 19 Discuss The reason you take this course? What you expect to learn? What I expect … Lecture 1: Introduction 20