The following form provides course requirements for BS in MIS:

Using below 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)

Degree Requirements Credits Transferred UB Course GENERAL EDUCATION AND UNIVERSITY REQUIREMENTS University Requirements Note: This course is only required of UBfreshmen Seminar Applied Learning & Study Skills IDIS 101 Lower Division Gen Ed Requirements (22) 3 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 hysical Science 2 (1 with lab) Upper Division Gen Ed Requirements (6) Ethical issues in Business and Society DIS 302 Advanced Expository Writing (by 2nd semester WRIT 300 BUSINESS REQUIREMENTS Lower-Division Core Requirements (27) Introduction to Financial Accounting ACCT 201 3 BULA 151 Business Law I CMAT 201/303* 3 Oral Communications 3 The Economic Way of Thinking ECON 200 3 Introduction to Programming Language INSS 209 3 Struct. Programming Using Procedural Lang. INSS 225 3 MATH 111* College Algebra 3 Introduction to Business Statistics OPRE 201 3 OPRE 202 Statistical Data Analysis Upper-Division Core Requirements (24) UB Degree Requirements Credits Transferred UB Course GENERAL EDUCATION AND UNIVERSITY REQUIREMENTS University Requirements Note: This course is only required of UBfreshmen Seminar Applied Learning & Study Skills IDIS 101 Lower Division Gen Ed Requirements (22) 3 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 hysical Science 2 (1 with lab) Upper Division Gen Ed Requirements (6) Ethical issues in Business and Society DIS 302 Advanced Expository Writing (by 2nd semester WRIT 300 BUSINESS REQUIREMENTS Lower-Division Core Requirements (27) Introduction to Financial Accounting ACCT 201 3 BULA 151 Business Law I CMAT 201/303* 3 Oral Communications 3 The Economic Way of Thinking ECON 200 3 Introduction to Programming Language INSS 209 3 Struct. Programming Using Procedural Lang. INSS 225 3 MATH 111* College Algebra 3 Introduction to Business Statistics OPRE 201 3 OPRE 202 Statistical Data Analysis Upper-Division Core Requirements (24) UB