Business Data Communication Networks
This course presents the foundations of data communications and takes a bottom-up approach to computer networks. It begins with an overview of modern data communication requirements and basic distributed data concepts. A brief history of the Internet is presented followed by the basics of the OSI and TCP/IP computer networks models. The Physical Layer is presented in the form of basic data communication concepts over various transmission media, wireless transmission, and the telephone system. The Data Link Layer presentation deals with design issues and error detection and correction, and the Medium Access Sub-layer covers channel allocation problems, multiple access protocols, IEEE standard 802 for LANs and WLANs, as well as bridges, switches, and high-speed LANs. The basic functions of the Network Layer are explained in the context of design issues, internetworking, and the network layer in the Internet. The Transport Layer includes the transport service and elements of transport protocols, as well as the TCP and UDP Internet transport protocols. The Application Layer issues cover the main distributed applications, such as electronic mail, DNS, ftp, www, etc. The course concludes with an overview of basic network security and management concepts. (MET CS 625; 4 credits)
Database Design and Implementation for Business
Students learn the latest relational and object-relational tools and techniques for persistent data and object modeling and management. Students gain extensive hands-on experience using Oracle or Microsoft SQL Server as they learn the Structured Query Language (SQL) and design and implement databases. Topics covered include: the relational and entity-relational models, data modeling, normalization, object modeling, SQL, advanced SQL, stored procedures, triggers, database design, database lifecycle, and transactions. Students are introduced to advanced topics including performance tuning, distributed databases, replication, business intelligence, data warehouses, internet databases, database administration, security, backup, and recovery. Students design and implement a database system as a term project. Laboratory course. (MET CS 669; 4 credits)
Information Systems Analysis and Design
Prereq: Basic programming knowledge. Object-oriented methods of information systems analysis and design for organizations with data-processing resources. System feasibility, information requirements analysis, database utilization, including data dictionaries, software design and implementation management, project control, and systems-level testing and installation. Laboratory course. (MET CS 682; 4 credits)
IT Strategy and Management
Prereq: MET CS 682 or consent of instructor. This course provides an overview of contemporary information systems technology (IT) management. It explains the relevant issues of effective management of information services activities and highlights the areas of greatest potential application of the technology. No assumptions are made concerning the reader’s experience with IT, but it is assumed that the reader has some coursework or work experience in administration or management. (MET CS 782; 4 credits)