PPTX - University of Connecticut
Download
Report
Transcript PPTX - University of Connecticut
CSE4701 Introduction to Databases
CSE4701
Prof. Steven A. Demurjian
Computer Science & Engineering Department
The University of Connecticut
371 Fairfield Way, Box U-255
Storrs, CT 06269-3255
[email protected]
http://www.engr.uconn.edu/~steve
(860) 486–4818 (Office)
(860) 486-3719 (CSE Office)
OV-1.1
Course Goals
CSE4701
Provide a Practical Introduction to Database
Models, Theory, and Systems
Focus on Both Theory and Practice
Theory Demonstrates Strong Mathematical
Basis of Databases (Relational Model and
Concurrency Control)
Practice Provides Experimental Framework for
Illustrating Theory (Actual Database Systems
and their Usage)
Exposure to Research Problems and Real-World
Experiences
OV-1.2
Course Philosophy
CSE4701
Introduction to Fundamental Database Concepts
Promotion of Knowledge-Acquisition, SelfLearning, and Independence
Rapid Evolution of Computing
Always Must Keep Skills Up-to-Date
“Learn how to Learn”
Relevance of Database Concepts in Computing
Software Engineering
Object-Oriented Computing
Operating Systems and Networks
Almost Every Computer Science Area
Practical Exposure to SQL, JDBC, and DB
Platform (MySQL or Oracle)
OV-1.3
Textbooks and Class Materials
CSE4701
UConn COOP has One Required Text …
Fundamentals of Database Systems, Elmasri
and Navathe, Addison-Wesley, 3rd (2000) or
4th (2003), 5th (2006), or 6th (2009) editions
CSE255 Web Site at …
www.engr.uconn.edu/~steve/Cse4701/cse4701.html
All Course Notes, Project Materials, Web Site
Links, Available On-Line
Other Class Materials
Various other Web Sites
OV-1.4
Syllabus: Weekly Topic Coverage
Weeks
Topic
Chapters
FOCUS ON CHAPTER TOPIC - NUMBERS FOR 3rd ed.
1
Introduction/Overview
Ch 1,2
CSE4701
1.5 Conceptual DB/ER Model
Ch 3,4
1.5 Relational Model/Algebra
Ch 7
1
Data Flow/ER-Relational
Ch 9
1
Relational Calculus/SQL
Ch 8
1
DB Design, Normal Forms
Ch 14-16
0.5 Internal Data Storage
Ch 5-6
1
Query Processing in RDB
Ch 17-18
1
DB Impl/Concurrency Cont. Ch 19,20
1
Oracle and Embedded SQL
Ch 10
1
Concurrency Control - II
Ch 19,20
1
Security
Ch 22, 11, 12
1
Databases, Web, Mining
Ch 26, 27
1
One Semester Exams + Final Exam
OV-1.5
Course Projects and Exams
Must Pass Both Projects And Exams to PASS!!!
CSE4701
Projects: Individual &/or Team (30-50% of Grade)
In Process of Being Defined
See Next Slide
Exams (40-50% of Grade)
Likely Two Exams and Final
Open Book and Open Notes
Home works (0-20%)
Throughout the Semester - In Class also
If no credit, Up to 2 Bonus Pts. Per Handed in
Assignment
Fall 2007 – 40%P, 50%E, 20%H
Note: All Subject to Change – Use Breakdown
that Most Benefits Students
OV-1.6
Potential Course/Semester Project
Some combination of Following
CSE4701
Research Project on Advanced Database Topic
5-7 page paper, 10 slide PPT, proof of concept demo
XML DBs, Big Data DBs, OO DBs, Genomic DBs,
Web DBs, Statistical DBs, Public Health Surveillance
DBs, Databases/AI, Multimedia DBs, Temporal &
Spatial DBs, Real-Time DBs, Embedded DBs
Programmatic Exercises
Access to Databases using ODBC/JDBC and/or
Hibernate (http://hibernate.org/)
Extracting info from via REST-APIs, JSON, XML, etc.
Database Loading/Conversion – Schema Level,
Instance Level, Importing Data from csv and other
files, etc.
Mobile Apps and Databases
OV-1.7
Main Software for Class
MySQL and MySQL Workbench
CSE4701
OV-1.8
Loading a Database Schema
CSE4701
OV-1.9
The Database Tables
CSE4701
OV-1.10
Extended Entity Relation Diagram
CSE4701
OV-1.11
Querying the Database
CSE4701
OV-1.12
Query Results Window
CSE4701
OV-1.13
Cheating/Collaboration
CSE4701
Not Tolerated in Any Form!!!
Severe Penalties are Likely!!!
See University of Connecticut Student Conduct
Code
All Homeworks/Some Project Represent
Individual Effort!
Remaining Projects Represent Team Effort
Cooperative Problem Solving and Sharing Code is
NOT Permitted and Will Likely Lead to Fs!
Electronic Information is More Accessible!
Use Protection Capabilities on your Account to
Protect your Files!
OV-1.14
Lateness Policies/Exams
CSE4701
Late Assignments (Projects) will Not be Accepted
Except with Prior Permission or Emergencies
Prior Permission: Contact the Instructor Three
Days Before the Due Date
Emergencies: Illness, Death in the Family, etc.
Contact
S. Demurjian at ITE265, x6-4818, by
[email protected], or via the CSE Office,
ITE250, x6-3719
A Late Assignment is Recorded as a Zero Grade
Assignment Due Date Means Start of Class!!!
Makeup on Absent Exam at Instructor’s Discretion
OV-1.15
Class Attendance and Computing
CSE4701
Attendance in Class is …
Responsibility of each Student
May Result in Missing Hint/Clarification/Error
on Class Project
Change in Due Date or Exam Date
I Won’t Guarantee that All Information Makes
it to Web!
Computing for Class is …
Predominately PCs - ITE Concourse Level or
Engineering Learning Center (ITE 1st floor)
Take Files with You!
Your Responsibility to Protect Your Files
OV-1.16