Saiwu Lin
Senior Lecturer
Department of MIS, Marketing, and Analytics
Saunders College of Business
585-475-4713
Office Location
Saiwu Lin
Senior Lecturer
Department of MIS, Marketing, and Analytics
Saunders College of Business
Education
MS, University of Arizona
585-475-4713
Currently Teaching
ACCT-445
Accounting Information Systems
3 Credits
This course combines information systems concepts and accounting issues. In this course, we discuss the conceptual foundations of information systems, their applications, the control and auditing of accounting information systems, and the system development process. Topics include the business process, e-business, relational database, database design, computer fraud and security, accounting cycle, system analysis and AIS development strategies. Students analyze accounting information systems topics through problem solving, group project, presentations, exams, and case studies.
MGIS-320
Database Management Systems
3 Credits
Transforming data into information is critical for making business decisions. This course introduces students to the concepts of data, information and the business database management systems (DBMS) used by modern organizations. Exercises and hands-on projects are used to model the information needs of an organization and implement and query databases using applications such as Microsoft Access and SQL.
MGIS-330
Systems Analysis and Design
3 Credits
Successful organizations utilize a systematic approach to solve real-world business problems through the use of computing resources. Students who complete this course will be able to design and model business processes. They will learn how to conduct requirements analysis, approach the design or redesign of business processes, model system functions, effectively communicate systems designs to various levels of management, work in a project-based environment, and approach the implementation of a new organizational information system.
MGIS-425
Database Systems Development
3 Credits
This course builds upon the basic concepts from Database Management Systems. Students work in a real-world business database development environment and gain hands-on experience in advanced database querying language, such as Oracle PL/SQL. Students learn to analyze business processes and, using tools such as Oracle, develop fully functioning database prototype systems to support them.
MGIS-725
Data Management and Analytics
3 Credits
This course discusses issues associated with data capture, organization, storage, extraction, and modeling for planned and ad hoc reporting. Enables student to model data by developing conceptual and semantic data models. Techniques taught for managing the design and development of large database systems including logical data models, concurrent processing, data distributions, database administration, data warehousing, data cleansing, and data mining.