Download CS 342 Fall 2014 Database Project

3
5. Normalization of Relations....................................................36
5.1 What is normalization?........................................................36
5.3 Check Your Relations.........................................................38
5.4 What is SQL * PLUS?.........................................................39
5.5 Oracle/Schema Objects......................................................40
5.6 Relation Schema.................................................................44
5.7 SQL Queries........................................................................56
Phase 4.....................................................................................64
6.1 Common Features of PL/SQL and T-SQL..........................64
6.2 Purpose of Stored Subprograms........................................65
6.3 Benefits of calling stored subprogram over sending a
dynamic SQL.............................................................................66
6.4 Oracle PL/SQl.....................................................................66
6.5 Oracle PL/SQL Subprogram...............................................73
Phase 5.....................................................................................75
7.1 Description of Daily activities..............................................75
7.2 Relation...............................................................................76
7.3 Screenshots........................................................................81
7.4 Major steps of designing a user interface...........................85
7.5 Descriptions of major classes.............................................86
7.6 Learning a new development tool in a new language.........88
7.7 Major Steps of Designing and Implementing a Database. .89