The following form provides course requirements for BS in MIS
PROGRAM CHECKLIST - B.S. in Management Information Systems
|
Name: Student ID Number: Semester:
|
|
Degree Requirements
|
UB Course
|
Credits
|
Transferred
|
UB
|
|
GENERAL EDUCATION AND UNIVERSITY REQUIREMENTS
|
|
University Requirements
|
Note: This course is only required of UB freshmen.
|
|
Seminar - Applied Learning & Study Skills
|
IDIS 101
|
2
|
na
|
|
|
Lower Division Gen Ed Requirements (22)
|
|
English Composition
|
WRIT 101
|
3
|
|
|
|
Literature
|
|
3
|
|
|
|
History or Philosophy
|
|
3
|
|
|
|
Fine Arts
|
|
3
|
|
|
|
Social Science 1 (Other than ECON)
|
|
3
|
|
|
|
Biological & Physical Science 1
|
|
3
|
|
|
|
Biological & Physical Science 2 (1 with lab)
|
|
4
|
|
|
|
Upper Division Gen Ed Requirements (6)
|
|
Ethical Issues in Business and Society
|
IDIS 302
|
3
|
|
|
|
Advanced Expository Writing (by 2nd semester )
|
WRIT 300
|
3
|
|
|
|
BUSINESS REQUIREMENTS
|
|
Lower-Division Core Requirements (27)
|
|
Introduction to Financial Accounting
|
ACCT 201
|
3
|
|
|
|
Business Law I
|
BULA 151
|
3
|
|
|
|
Oral Communications
|
CMAT 201/303*
|
3
|
|
|
|
The Economic Way of Thinking
|
ECON 200*
|
3
|
|
|
|
Introduction to Programming Language
|
INSS 209**
|
3
|
|
|
|
Struct. Programming Using Procedural Lang.
|
INSS 225**
|
3
|
|
|
|
College Algebra
|
MATH 111*
|
3
|
|
|
|
Introduction to Business Statistics
|
OPRE 201
|
3
|
|
|
|
Statistical Data Analysis
|
OPRE 202
|
3
|
|
|
|
Upper-Division Core Requirements (24)
|
|
Management Information Systems
|
INSS 300*
|
3
|
|
|
|
Management & Organizational Behavior
|
MGMT 301
|
3
|
|
|
|
Human Resource Management
|
MGMT 315
|
3
|
|
|
|
Business Application of Decision Science
|
OPRE 315
|
3
|
|
|
|
Business Core Electives - Choose four of the following courses: ECON 305, ENTR 300, FIN 331, MGMT 302, MGMT 339, or MKTG 301
|
|
|
|
3
|
|
|
|
|
|
3
|
|
|
|
|
|
3
|
|
|
|
|
|
3
|
|
|
|
MANAGEMENT INFORMATION SYSTEMS REQUIREMENTS (30)
|
|
Information Technology
|
INSS 315
|
3
|
|
|
|
Program Design & Data Structure
|
INSS 327
|
3
|
|
|
|
Systems Analysis & Logical Design
|
INSS 406
|
3
|
|
|
|
Design of Database Management Systems
|
INSS 421
|
3
|
|
|
|
Business Data Communications
|
INSS 427
|
3
|
|
|
|
Component-Oriented Programming
|
INSS 460
|
3
|
|
|
|
MIS Capstone Project
|
INSS 490
|
3
|
|
|
|
Approved INSS Elective (see current catalog)
|
|
3
|
|
|
|
Approved INSS Elective (see current catalog)
|
|
3
|
|
|
|
Approved INSS Elective (see current catalog)
|
|
3
|
|
|
|
Electives - Number of electives may vary and will be determined at initial advising meeting. ( 9 -12cr total degree)
|
|
|
|
|
|
|
|
Total Transfer Credits:
|
Total Credits Required:
|
Total Credits Earned:
|
Minimum of 120 credits
|
|
* These courses also satisfy the following general education requirements: Math, Computer Literacy, Oral Communications, and one Social Science, as well as UB's Information Literacy requirement.
**These courses may be replaced by 6 credit hours of programming language approved by the Merrick Advising Center.
|
ignore the *'s
Ignore the rules
a. Using above BS in MIS degree requirements, perform the following
? Develop tables
? Normalize them
b. Draw a single ERD - clearly identify Primary and Foreign keys (state any assumptions made)
c. Create a view that would list all MIS required courses
d. Create a view that will give a total count of courses with course ID above 300 or more (ex: INSS 300, INSS421, MGMT 315 etc should be included in the count)
c. Assignment MUST be typed in WORD (or similar processor)
? Develop the tables in ORACLE
? Insert data in tables
? Create the view (part C above)
? give the query and output of part C.