1. Create following views: (5 points)

• Create a view that would list all MIS required courses
• Create a view that will give a total count of courses with course ID above 300 or more (ex: INSS300, INSS421, MGMT315 etc. should be included in the count)

PROGRAM CHECKLIST-B.S. in Management Information Systems 5/3/2020 Name: Student ID Number: Semester: wwwwwwww Degree Requirements UB Course Credits Transfer GENERAL EDUCATION AND UNIVERSITY REQUIREMENTS University Requirements Note: This course is only required of UB freshmen. Seminar - Applied Learning & Study Skills IDIS 101 na Lower Division Gen Ed Requirements (22) English Composition WRIT 101 Literature History or Philosophy Fine Arts Social Science 1 (Other than ECON) Biological & Physical Science 1 Biological & Physical Science 2 (1 with lab) Upper Division Gen Ed Requirements (6) Ethical Issues in Business and Society IDIS 302 Advanced Expository Writing (by 2nd semester) WRIT 300 BUSINESS REQUIREMENTS Lower-Division Core Requirements (27) Introduction to Financial Accounting ACCT 201 Business Law ! BULA 151 Oral Communications CMAT 201/303* The Economic Way of Thinking ECON 200* Introduction to Programming Language INSS 209** Struct. Programming Using Procedural Lang. INSS 225** College Algebra MATH 111* Introduction to Business Statistics OPRE 201 Statistical Data Analysis OPRE 202 Upper-Division Core Requirements (24) Management Information Systems INSS 300* Management & Organizational Behavior MGMT 301 Human Resource Management MGMT 315 Business Application of Decision Science OPRE 315 wwwwwwwwwwwww Business Core Electives - Choose four of the following courses: ECON 305, ENTR 300, FIN 331, MGMT 302, MGMT 339, MANAGEMENT INFORMATION SYSTEMS REQUIREMENTS (30) Information Technology INSS 315 Program Design & Data Structure INSS 327 Systems Analysis & Logical Design INSS 406 Design of Database Management Systems | INSS 421 | 3 | | PROGRAM CHECKLIST-B.S. in Management Information Systems 5/3/2020 Name: Student ID Number: Semester: wwwwwwww Degree Requirements UB Course Credits Transfer GENERAL EDUCATION AND UNIVERSITY REQUIREMENTS University Requirements Note: This course is only required of UB freshmen. Seminar - Applied Learning & Study Skills IDIS 101 na Lower Division Gen Ed Requirements (22) English Composition WRIT 101 Literature History or Philosophy Fine Arts Social Science 1 (Other than ECON) Biological & Physical Science 1 Biological & Physical Science 2 (1 with lab) Upper Division Gen Ed Requirements (6) Ethical Issues in Business and Society IDIS 302 Advanced Expository Writing (by 2nd semester) WRIT 300 BUSINESS REQUIREMENTS Lower-Division Core Requirements (27) Introduction to Financial Accounting ACCT 201 Business Law ! BULA 151 Oral Communications CMAT 201/303* The Economic Way of Thinking ECON 200* Introduction to Programming Language INSS 209** Struct. Programming Using Procedural Lang. INSS 225** College Algebra MATH 111* Introduction to Business Statistics OPRE 201 Statistical Data Analysis OPRE 202 Upper-Division Core Requirements (24) Management Information Systems INSS 300* Management & Organizational Behavior MGMT 301 Human Resource Management MGMT 315 Business Application of Decision Science OPRE 315 wwwwwwwwwwwww Business Core Electives - Choose four of the following courses: ECON 305, ENTR 300, FIN 331, MGMT 302, MGMT 339, MANAGEMENT INFORMATION SYSTEMS REQUIREMENTS (30) Information Technology INSS 315 Program Design & Data Structure INSS 327 Systems Analysis & Logical Design INSS 406 Design of Database Management Systems | INSS 421 | 3 | |