phase I: Info. Gethering
Lab 1: Get ready
Form 2-person team and work as team for the quarter.
Send your project to firstname.lastname@example.org
Use last 4 digits of ID to read your grades and comments.
Verify your email address registered with CUSB.
Lab 2: Use E-R model to design a conceptual database.
Midterm Date: 10/25
Phase II: Relation
vs. E-R Model
Lab 3: Study the reasons and methods of converting ER to Relational Database.
Lab on Relational Algebra
Lab 4: Answer the Hotel related queries in Relational Algebra.
Lab 5: Answer the Hotel related queries in Relational Calculus.
Phase III: Implementation of
Oracle Create Table
Oracle Table Creation 1
Oracle 8.0 Data Types
Comparisons of ANSI and Oracle Data Types
Phase IV: Stored Procedures
PL SQL Files
Final Phase: User Interface Design and Implementation
Important: Make sure you answer each of the 4 questions in your final report.
3/13/2016 Sunday (2:00pm ... ) Room 311 Final presentations
3/14/2016 Monday (Midnight) The final written report document.
Put your major and track by your name on the front page of the project document.