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.

An introduction to the theory and practice of designing and implementing database systems. Current software environments are used to explore effective database design and implementation concepts and strategies. Topics include conceptual data modeling, methodologies, logical/physical database design, normalization, relational algebra, schema creation and data manipulation, and transaction design. Database design and implementation projects are required.

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 is a course in the basics of network communication for software developers. Topics will include the OSI 7-layer model and its realization in the TCP/IP protocol stack. Students will also learn about naming and name resolution as it is used in the internet, plus the basics of routing and switching. The focus in all of this will be on an analysis of how name resolution, routing and switching operate at the developer's perspective. The specifics of how the socket transport layer appears to the programmer and operates will be a key topic. Finally, an overview of authentication mechanisms and number of examples of the security vulnerabilities of existing communication protocols will be provided to instruct students on the inherent risks of communication via the INTERNET.

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.