INSS 421 DATABASE MANAGEMENT SYSTEMSSpring 2018 Assignment 3 DUE DATE: May 1, 2018 (new Date) 40 points The following form provides course requirements for BS in MIS =================================================================================== PROGRAM CHECKLIST – B.S. in Management Information Systems 4/5/2018 Name: Student ID Number: Semester: Degree RequirementsUB CourseCreditsTransferredUBGeneral Education and University RequirementsUniversity Requirements Note: This course is only required of UB freshmen.Seminar – Applied Learning & Study SkillsIDIS 1012na Lower Division Gen Ed Requirements (22) English CompositionWRIT 1013 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 SocietyIDIS 3023 Advanced Expository Writing (by 2nd semester )WRIT 3003 BUSINESS REQUIREMENTSLower–Division Core Requirements (27)Introduction to Financial AccountingACCT 2013 Business Law IBULA 1513 Oral CommunicationsCMAT 201/303*3 The Economic Way of ThinkingECON 200*3 Introduction to Programming LanguageINSS 209**3 Struct. Programming Using Procedural Lang.INSS 225**3 College AlgebraMATH 111*3 Introduction to Business StatisticsOPRE 2013 Statistical Data AnalysisOPRE 2023 Upper-Division Core Requirements (24)Management Information SystemsINSS 300*3 Management & Organizational BehaviorMGMT 3013 Human Resource ManagementMGMT 3153 Business Application of Decision ScienceOPRE 3153 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 TechnologyINSS 3153 Program Design & Data StructureINSS 3273 Systems Analysis & Logical DesignINSS 4063 Design of Database Management SystemsINSS 4213 Business Data CommunicationsINSS 4273 Component-Oriented ProgrammingINSS 4603 MIS Capstone ProjectINSS 4903 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 tablesNormalize 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) NO HAND WRITTEN SUBMISSIONS BONUS (5 points) Develop the tables in ORACLEInsert data in tablesCreate the view (part C above)give the query and output of part C
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
