Advanced Database Management Systems CSCI 42275227 - PowerPoint PPT Presentation

Loading...

PPT – Advanced Database Management Systems CSCI 42275227 PowerPoint presentation | free to download - id: cface-MzBhY



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Advanced Database Management Systems CSCI 42275227

Description:

Advanced Database Management Systems CSCI 4227/5227. Dr. Ron Zucker ' ... Relational DB rules. Tables. Keys. Foreign keys. Integrity constraints. How to map from ER ... – PowerPoint PPT presentation

Number of Views:492
Avg rating:3.0/5.0
Slides: 13
Provided by: donaldsa1
Learn more at: http://csciwww.etsu.edu
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Advanced Database Management Systems CSCI 42275227


1
Advanced Database Management Systems CSCI
4227/5227
  • Dr. Ron Zucker

2
  • What do such machines really do? They increase
    the number of things we can do without thinking.
    Things we do without thinking there's the real
    danger.
  • God Emperor of Dune, Frank Herbert (1981)

3
Goals for the Course
  • Introduce Meta-database Concepts
  • Data Dictionary Contents
  • Data Dictionary Use
  • Advanced PL/SQL
  • Physical Database
  • Data Storage
  • Indexing
  • DBMS Architecture

4
Goals for the Course
  • Query Optimization
  • Security Constraints
  • Data Warehouses
  • Data Mining

5
Learning
  • Lecture/ HW /Quiz / Exam Cycle
  • HW mix of design and implementation
  • In-Class projects
  • Small Group, Instructor Intervention
  • ORACLE used as implementation

6
Examinations
  • Drawn from HW/Notes
  • 25-40 percent short answer
  • 60-75 percent 3-4 problems

7
Quizzes?
  • Un-announced
  • Approximately 9 per term
  • 5 questions usually multiple choice
  • Drawn from
  • Assigned Readings
  • Prior lectures
  • HW

8
Class Schedule
  • See On-line

9
What You Need to Know (or Remember)
  • ER and EER
  • The concepts
  • How to build one from user requirements
  • How to edit them
  • Normal forms
  • Functional dependencies

10
What You Need to Know (or Remember)
  • Relational DB rules
  • Tables
  • Keys
  • Foreign keys
  • Integrity constraints
  • How to map from ER

11
What You Need to Know (or Remember)
  • SQL
  • Defining tables, keys and foreign keys
  • Using ORACLE
  • SQL plus
  • SQL commands
  • PL-SQL
  • Queries
  • Single level
  • Nested
  • Correlated

12
What you Need to Know (or Remember)
  • ORACLE 10
  • Server pythia.etsu.edu
  • Database SID csdb.etsu.edu
  • Your accounts will be the same as before
  • User Name is your Z account
  • Initial password dbms
About PowerShow.com