0805-310 Microcomputer Database Software Creating, inquiring, reporting and other functions of databases. A leading database software product for microcomputers is studied. Students design a database, establish criteria for data to be accepted and coded, and prepare views of the database contents. Database utilization in the business environment and application to the student's expected work environment is presented. This course covers program logic, flowcharting, writing programs in RPG, and entering the programs and related files on a mid-range computer.
Students practice debugging and executing programs.
Break logic, exception reporting and the use of databases for input are presented. The mechanics of the use of software products to create and integrate text and graphics is presented. Technical topics including file formats and file exchange are stressed over design considerations. In this course, which uses a midrange computer system, students learn the basic criteria for data to be a relational database, the use of basic relational database commands such as record selection and joining of databases, SQL, and extraction and formatting of data for reports. Students design a database, establish criteria for data to be accepted and coded, and prepare views of the database contents.