Conceptual data modelling, Entity-Relationship Diagrams, Relational Model, SQL, Relational Database Developement using any of the following platforms - Microsoft Access & Visual Basic, Foxpro, and ORACLE. Currently, we are exclusively using ORACLE installed in a client/server mode as our common platform for Database Management courses as part of the ORACLE ACADEMIC ALLIANCE program.
Topic Selection, Feasibility, Systems Analysis, Systems Design, Programming, Unit and Integration Testing, Final Report and system submission for grading. Students develop system from topic selection to the final product on several platforms. I supervise and help them in project planning, software product design principles, systems analysis, systems and program design. I also conduct structured walkthroughs and testing of their systems and help them in the creation of the user manual. Students choose several platforms that have included Visual Basic, Microsoft Access, C++ among others. Again the most popular platform is IBM PCs.
Topics include Network Applications, Data Communication Hardware, Data Transmission, Data Link Layer, Network Layer, Networks - LAN, WAN, Backbone Networks, Network Design and Implementation, Network Management, Network Security. Students do a computer-based learning tutorial on Windows NT server.
In-depth analysis and discussion of Conceptual Data Models, ANSI/SPARC, Database Analysis and design, Relational, Semantic, and Object-oriented Data Models, Distributed databases, Data replication and partitioning, and Data Warehousing. Students conduct Database Analysis, Database Design, and use ORACLE, Developer 2000, and Designer 2000 software for their project work. Students also develop a research paper.
Topics covered include Software production and life cycle, software planning, costs, and project management. Software metrics and models, CASE tools, Objects and Object-oriented Developement, Specification methods, Design methods, Programming and Implementation, Software Quality Assuarance, and Software Maintenance. Students use a CASE tool for their research project.
Topics covered include datawarehousing lifecycle, requirements gathering, using query graphs, dimensional modeling, OLAP, data warehousing architecture, logical database design, front-end and back-end architecture, infrastructure and metadata. Students use a OLAP tool and ORACLE 8 database. I have applied and obtained ORACLE EXPRESS, DISCOVERER, FINANCIALS and SALES ANALYZER software for use in my data warehousing class in Fall 2000.