Databases and Information Models

ACC 682 Analysis & Design of Accounting Databases (3)

Basics of relational database theory in the accounting contest. Semantic modeling of accounting data including the REA model. Use of CASE tools for the analysis, design & documentation of accounting databases. Languages for retrieval of information from accounting databases. Controls in accounting databases. Prerequisites: BACC 681 and BACC 512 or equivalent. Intended to be taken concurrently with BACC 681. http://www.albany.edu/acc/courses/ia/acc682/

EAPS 614 Quantitative Methods for Educational Management (3)

Introduction to the basic methods of quantitative analysis for management in educational settings. Topics include methods for description, modeling, forecasting, inference, and presentation of data relevant to monitoring, assessment, and planning in education. Includes use of spreadsheet and other analytical tools. Offered fall & spring semesters.

EAPS 714 - Introduction to Research Methods in Educational Administration & Policy Studies (3)

Survey of research methods and designs applicable to topics in educational administration, decision making, and policy analysis with emphasis on how to choose effective methods and the consequences of those choices. Prerequisites: EAPS 614 or passing department's statistics qualifying examination. Open to doctoral students only. Normally offered fall semesters.

EAPS 764 - Computer Applications in Educational Administration & Policy Studies (3)

Use of the computer as a tool in the management of an educational institution. Students are expected to apply the computer to real/simulated management problems.

CSI 102 Microcomputer Software (3)

Theory and practice of general purpose microcomputer software systems such as spreadsheet and relational database packages. Query languages for database access. Word processing with emphasis on spelling and grammar checking. Normally offered spring semester only.

CSI 310 Data Structures (3)

Commonly used abstract data structures and their implementation. The use of pointers and recursive programming. Stacks, queues, lists and trees, and their application to such problems as sorting and searching. Analysis of algorithms for using these structures. Prerequisite(s): ICSI 201. Normally offered spring semester only. http://www.cs.albany.edu/~sdc/CSI310

CSI 410 Database Management Systems (3)

Introduction to database management systems (DBMS) with emphasis on the relational model. Physical and logical database design, rollback and recovery techniques, access methods and query language concepts. The design and use of microcomputer-based relational systems and spreadsheets. The hierarchical and network DBMS models. Prerequisite(s): ICSI 310. Normally offered fall semester only.

CSI 418 Software Engineering (3)

Software engineering principles, the role of abstraction in programming, abstract data types, modularization and module interfaces, specifications, and teamwork. Project work in contemporary concurrent and object-oriented languages. Prerequisite(s): ICSI 333. Normally offered fall semester only. http://www.cs.albany.edu/~lydoco/CSI418/index.htm

CSI 431 Data Mining (3)

A course on data mining (finding patterns in data) algorithms and their application to interesting data types and situations. We cover algorithms that addresses the five core data mining tasks: prediction, classification, estimation, clustering, and associations. Course projects will involve advanced topics such as algorithm developments for handling large data sets, sequential, spatial, and streaming data. Prerequisite(s): ICSI 310.

CSI 435 Introduction To Artificial Intelligence (3)

An introduction to the broad spectrum of approaches and techniques of Artificial Intelligence. Emphasis on how to represent knowledge in a computer and how to process that knowledge to produce intelligent behavior. Topics include expert systems, heuristic search, natural language processing and logic-based approaches. Programming assignments using artificial intelligence languages. Prerequisite(s): ICSI 311.

CSI 445 Topics in Computer Science: Object Oriented Programming in Java (3)

The contents of this course will vary from semester to semester. Each offering will cover an advanced senior-level topic in Computer Science. Prerequisite(s): ICSI 333 (or ICSI 205 & 310) or permission of instructor. May be repeated for credit when content varies.

CSI 508 Database Systems I (3)

Basic concepts of a database system, with emphasis on database schema design, data manipulation languages, and query languages. Data models. Relational databases, functional dependencies, normal forms. Relational calculus, relational algebra, SEQUEL, Query-by-Example. The CODASYL network model: data definition and data manipulation languages. Computer project using a database system. User viewpoint of concurrent access. Prerequisites: ICSI 310, departmental examination in discrete mathematics.

CSI 511 Programming Languages and Systems Concepts (3)

Principles of program design, documentation, and software engineering. Assembly language, machine design, and the fetch-execute cycle at all levels of hardware and software. Introduction to software development, compiler design, operating systems design, and program verification. Prerequisite: ICSI 310

CSI 518 Software Engineering (4)

Software engineering principles, the role of abstraction in programming, abstract data types, modularization and module interfaces, specifications, and teamwork. Concurrent programming models, synchronization and interprocess communication. Project work in contemporary concurrent and object-oriented languages. Prerequisites: Graduate CSI standing or permission of instructor, and ICSI 310.

CSI 535 Artificial Intelligence I (3)

A first course in artificial intelligence (AI) introducing basic concepts and techniques. Topics include problem representation, production systems, heuristic search, predicate logic, and structured representation of knowledge. Techniques of sample search and sample problem solving systems are represented. Exercises in a selected AI programming language. Prerequisites: ICSI 310, departmental examination in discrete mathematics.

CSI 539 Advanced Data Structures (3)

Data structures for efficient retrieval in the context of problems relating to aggregation, reporting, quantifier evaluation, and range queries in both dynamic and static settings. K-d trees, k-fold trees, balanced trees, and other advanced topics. Prerequisite: ICSI 503.

CSI 583 (INF 523, PAD 523) Fundamentals of Information Management (1-9)

Consists of two seven-week modules teaching basic skills in information management. Topics include: introduction to programming, data structures, and overview of data base applications. Students may elect up to two additional modules in topics such as UNIX, networking, and software development tools. May not be used for degree credit in Computer Science. Prerequisite: RPAD 504 or equivalent.

INF 703 Proseminar in Information Organization (4)

Examination of the organization of information from the perspectives of data base systems conceptualization, structure and design; classificatory and data ordering principles that facilitate information retrieval; informetrics, including knowledge production and representation patterns, cognitive, semantic and citation/consultation factors. Prerequisite: Consent of Ph.D. program director or instructor.

IST 466 Web Database Programming (3)

This course is intended to equip students with the concepts and skills in developing a database backed, dynamic and feature-rich Web site. Course covers techniques of gathering data from users through Web forms, storing data in a database on the server, retrieving data from database, formatting and displaying the data on the browser. The class will also learn the basic concepts and implementations of Web services. This is a project-based course where practical applications of PHP, SQL, JavaScript, XML and SOAP are studied. Prerequisite: IIST 361.

IST 523 Fundamentals of Information Technology (1-6)

This course consists of three five-week modules teaching basic skills in information management. Topics include: introduction to programming, data structures, and overview of data base applications. In addition, students may elect up to three additional modules chosen from topics such as UNIX and networking, UNIX software development tools (for students who already have significant prior programming), introduction to programming in C, and new directions in information science.

IST 658 Microcomputer Database Development (3)

Database principles for microcomputers, with emphasis on relational database management systems (DBMS) for applications development in the library and information fields. Database design, creation, and maintenance: the user interface; programming concepts. Creation of the working database system.

ITM 331 Business Application Development (3)

Introduction and application of object-oriented and Web programming to business problems. Application-driven approach and tools such as Java and XML will be employed. This course will introduce basic syntax and semantics, classes, objects, arrays and pointers, graphics and GUI through business cases and solutions. The course will introduce cutting-edge topics and applications of emerging technologies in such areas as e- and m-commerce. Prerequisite(s): BITM 215 or its equivalent, pre or co BITM 330. Offered spring. Capped at 40.

ITM 415 Systems Analysis and Design (3)

This course covers the planning, design, and implementation of computer-based information systems. Topics include techniques for analyzing and specifying system requirements, advanced concepts in database management with applications as well as behavioral and economic aspects of system design and implementation. Prerequisite(s): BITM 331 and BITM 322. Offered each fall. Capped at 40.

ITM 520 Database Management (1)

This is an introductory course in database modeling, design and implementation for business applications. The role of database systems in the management of information and the procedures for modeling the data resource to support managerial/executive needs are presented. It includes principles of database theory, query languages, and forms of data organization. Students gain hands-on experience through developing one or more database applications using one of the standard database packages. Capped at 40.

ITM 611 Analysis & Design of Information-Dec (3)

Techniques are presented for analyzing the information needs and existing flows in an organization. The process of systems analysis and design is discussed with special emphasis on the interdependency between decision models and their supporting information systems. Prerequisite: BITM 521. Capped at 40.

PAD 623 Management Information Systems (4)

Introduction to the design of mechanisms for gathering, storing, retrieving, and analyzing information needed by organizations. Emphasizes alternative techniques and the merits of applying those techniques to particular information handling problems. Areas to be studied may include manual and automated processing; general purpose and single purpose systems; batch processing and time-sharing, system evaluation and modification procedures.

SOC 220 Introduction to Social Research (3)

Examination of the assumptions and techniques of social research: problems of design, data collection, quantitative and qualitative analysis; review of current research in professional journals; the uses of survey research; application of concepts through individual and class projects. For Sociology majors and intended majors, ASOC 220 is restricted to A-E grading after matriculation at Albany. Prerequisite(s): ASOC 115M or 115G.

SOC 221 Statistics for Sociologists (3)

Introduction to quantitative analysis of sociological data: methods of summarizing and describing univariate distributions including the use of tables and graphs; methods of examining relationships between two or more measures; statistical inference and hypothesis testing. For Sociology majors and intended majors, ASOC 221 is restricted to A-E grading after matriculation at Albany. Prerequisite(s): ASOC 115M or 115G.

SOC 509 Research Methods (3)

Theory construction and verification use of statistics in social research, qualitative research techniques, sampling, measurement, data collection and analysis, policy research, and use of computer in research. A research paper is required. Prerequisite: Admission to graduate study or consent of instructor.

SOC 552 Demographic Techniques (3)

Overview of basic methods and data sources for the analysis of demographic processes. Topics include measures of fertility, mortality and migration, life tables, demographic standardization, population estimates and projections, and stable and stationary populations. Prerequisite: ASOC 551.