LIBR 242
Database Management
Course Calendar

• Course overview and logistics

• What is a database (vs. textbase)
• Database approach vs. file approach
• Database models
• Database Life Cycle vs. System Life Cycle

Relational Database Model

• Relational database model
• The tabular look vs. underlying structure
• Redundacy and anomalies
• Entity, attirbute, relation, and keys
• Relational algebra and operators

R.C. Ch. 3

Assignment DUE
2/6 11:30pm

• What is a database management system
• System architecture and componets
• Typical functions of a DBMS
• Data dictionary: a system view
• The Oracle database system

• Business (case scenario) analysis
• Conceptual/logical design steps
• Implementation stages & strategies
• Design process of the group project

• What is an entity and what is a relation
• E-R diagrams vs. data flow charts
• From case scenario to E-R diagram
• 1:1, 1:M, and M:M relationships
• Cardinality

(Lab Session 1: Analysis of E-R Diagrams)

Elluminate Meeting
2/18 9:00-11:45am

GP-1 Final DUE  
2/20 11:30pm

• Anomalies and controlled redundancy
• Functional dependency
• Normalization
• Heuristic procedure of normalizing
• Schema & Table dependency 
• Designer's data dictionary

R.C. Ch. 5
L.K. p.20-24

GP-2 DUE
3/5 11:30pm

GP-3 DUE 
3/12 11:30pm

SQL for Database Implementation in Oracle 

• SQL and Oracle's PL/SQL
• Concepts of DDL, DML, and data dictionary
• Creating, viewing, modifying, and deleting tables
• Populate tables with records
• Viewing, modifying and deleting records from a table

R.C. 7.1-7.3, 7.5
L.K. p.44, Ch. 18

GP-4 DUE
4/2 11:30pm

SQL for Database Querying in Oracle

• Simple SELECTing of records from on table
• Basics of conditioning with WHERE clause
• Records correlation & foreign key expansion
• Use of built-in aggregate functions
• creating, using, and dropping a VIEW

R.C. 7.4, 7.6-8
R.C. Ch. 8

Web-Based Access to Relational Databases

• Basics of implementing web-based DB access
• Oracle's xSQL servlet technology: architecture & process
• Quick demo of xSQL, XML, HTML integration
• Review of XML Basics: XML documents, external DTD, & internal DTD
• What is xSQL and how it works

R.C. Ch. 14
L.K. Ch. 5 & 41

GP-5 DUE
4/16 11:30pm

xSQL-Based Web Access to Oracle Databases

• xSQL servlet installation and configuration
• Querying database with xml-embedded xSQL (.xsql file)
• Stylesheet (.xsl file) for xSQL-to-HTML conversion
• Stylesheet (.xsl file) for xSQL-to-XML conversion
• Inserting data/records gathered from HTML form (.xsql file)
• Deleting rows/records from table (.xsql file)
• HTML document with link to xSQL pages
• Lengthy documentation of Oracle's XSQL servlet

• DB administrator's responsibilities
• Database security issues
• Concurrency control, COMMIT, and phase lock
• Concept of data warehousing

R.C. Ch. 10, 13, 15
L.K. Ch. 40

GP-6 DUE
5/1 11:30pm