A presentation of the fundamental concepts and theories used in organizing and structuring data. Coverage includes the data modeling process, basic relational model, normalization theory, relational algebra, and mapping a data model into a database schema. Structured Query Language is used to illustrate the translation of a data model to physical data organization. Modeling and programming assignments will be required. Note: students should have one course in object-oriented programming.

This course provides an introduction to the topic of information assurance as it pertains to an awareness of the risks inherent in protecting digital content in today’s networked computing environments. Topics in secure data and information access will be explored from the perspectives of software development, software implementation, data storage, and system administration and network communications. The application of computing technologies, procedures and policies and the activities necessary to detect, document, and counter unauthorized data and system access will be explored. Effective implementation will be discussed and include topics from other fields such as management science, security engineering and criminology. A broad understanding of this subject is important for computing students who are involved in the architecting and creation of information and will include current software exploitation issues and techniques for information assurance.

A study of the component approach to clinical information systems. Students will learn about the evolution of Health Information Systems, and the variety of systems offered by vendors at the present time. The importance of the Electronic Health Record (EHR), the Computerized Physician Order Entry (CPOE) and Clinical Decision Support will be stressed as they become the focal points in clinical information systems. The following components will be studied in detail: patient, activity, health record, knowledge, and security components. The role of imaging management and integration will also be reviewed.

This course provides an introduction to wired network infrastructures, topologies, technologies, and the protocols required for effective end-to-end communication. Basic security concepts for TCP/IP based technologies are introduced. Networking layers 1, 2, and 3 are examined in-depth using the International Standards Organization’s Open Systems Interconnection and TCP/IP models as reference. Course topics focus on the TCP/IP protocol suite, the Ethernet LAN protocol, switching technology, and routed and routing protocols common in TCP/IP networks. The lab assignments mirror the lecture content , providing an experiential learning component for each topic covered.

This course will investigate the protocols used to support network based services and the tasks involved in configuring and administering those services in virtualized Linux and Windows internet working environments. Topics include an overview of the TCP/IP protocol suite, in-depth discussions of the transport layer protocols, TCP and UDP, administration of network based services including the Dynamic Host Configuration Protocol (DHCP), Domain Name Service (DNS), Secure Shell (SSH), and Voice Over IP (VoIP). Students completing this course will have thorough theoretical knowledge of the Internet Protocol (IP), the Transport Control Protocol (TCP), and the User Datagram Protocol (UDP), as well as experience in administering, monitoring, securing and troubleshooting an internet work of computer systems running these protocols and services.

This course will provide an overview of IT and networking fundamentals critical in emerging digital media workflows. Emphasis will be placed on the architecture of modern digital media production and post-production facilities. Media industry technology standards for cinema, television, internet and mobile consumption will be introduced. This course is designed for students in the College of Art and Design and the Golisano College of Computing and Information Sciences who are interested in mastering the basic principles of IT and networking infrastructures used in digital media and broadcast applications.