database

profileaboodi777
query_group_assignment.docx

Query Individual Assignment

Prepare a query to report courses that need to be completed for a Computer Science Minor, given a student ID.

Computer Science Minor

Students may minor in computer science by completing 18 credits of computer science courses. Those considering a minor in computer science should seek guidance from the CS undergraduate coordinator as early as possible. Students must complete the following courses:

Required Courses

• CSCI 2210 - Java Programming

• CSCI 2212 - Intermediate C Programming

• CSCI 2226 - Data Structures and Algorithms

• CSCI 3326 - Algorithm Design and Analysis

• Plus two CS electives at the 350 level or higher

Computer Science, B.S.

http://catalog.newhaven.edu/return.gifReturn to: Tagliatela College of Engineering

Program Coordinator: Alice Fischer, Ph.D.

The bachelor’s degree program in computer science is nationally accredited by the Computing Accreditation Commission of the Accreditation Board for Engineering and Technology (CAC/ABET).  Its objectives are to inform, challenge, and train our diverse student body for a constantly changing world of technology. This program develops a solid body of knowledge and understanding of computer hardware, software, and theory, as defined by the Association for Computing Machinery (ACM) curriculum guidelines.

At the time of graduation, every student should have achieved the following program outcomes:

· An ability to apply knowledge of computing and mathematics appropriate to computer science.

· An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution.

· An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.

· An ability to function effectively on teams to accomplish a common goal.

· An understanding of professional, ethical, legal, security, and social issues and responsibilities.

· An ability to communicate effectively with a range of audiences.

· An ability to analyze the local and global impact of computing on individuals, organizations, and society.

· Recognition of the need for and an ability to engage in continuing professional development.

· An ability to use current techniques, skills, and tools necessary for computing practice.

· An ability to apply mathematical foundations, algorithmic principles, and computer science theory in the modeling and design of computer-based systems in a way that demonstrates comprehension in the tradeoffs involved in design choices.

· An ability to apply design and development principles in the construction of software systems of varying complexity.

· Have a substantial body of knowledge and understanding of computer hardware, software, and theory, as defined by the Association for Computing Machinery (ACM) guidelines.

The program consists of a required core that exposes students to a wide range of computing and technology topics, including the study of databases, hardware, networks, programming, software design, and security.  Advanced courses and the senior design project are selected from one of several areas: software development, web and database applications, mobile applications, cyber forensics, or cyber security.

Typical initial job titles include applications developer, software engineer, digital forensic examiner, cyber security analyst, or security engineer. Later titles might be system analyst, team leader, software consultant, or system administrator.

Internship Requirement

An internship enriches the academic experience of the student, providing exposure to a working computing environment and the interpersonal relationships of a workplace. Each internship is a partnership between the student and an employer or organization, with oversight by the academic advisor.  Students must complete 60 credits toward the bachelor’s degree before an internship is attempted.  To complete the internship, a student must perform at least 200 hours of relevant computer or network-oriented work, submit an essay about the experience, and submit evaluations completed by both the student and the work supervisor.  The internship requirement may be satisfied through employment, community service, or some other activity that is approved by the student’s advisor.

UPE Honor Society

UNH has a chapter of the national honor society for computer science, Upsilon Pi Epsilon.  Outstanding juniors and seniors are invited by the chapter to join this organization and participate in its service projects.

 

Required Courses

A total of 127 credits, including the University Core Curriculum, is required for the degree of bachelor of science in computer science.

Freshman Year

· ENGL 1105 - Composition

· ENGL 1110 - Composition and Literature

· HIST 1101 - Foundations of the Western World

· or

· HIST 1102 - The Western World in Modern Times

·  

· MATH 1117 - Calculus I

· MATH 1118 - Calculus II

· CSCI 1110 - Introduction to C Programming

· CSCI 1166 - Discrete Mathematics for Computing

· CSCI 2210 - Java Programming

Sophomore Year

· CC 1.2 Communication core elective

· CC 4.2 Citizenship core elective

· CC 5.2 Global Perspective core elective

· CSCI 2212 - Intermediate C Programming

· CSCI 2215 - Introduction to Databases

· CSCI 2226 - Data Structures and Algorithms

· ELEC 1155 - Digital Systems I

· CC 2.1 Laboratory Science I

· Laboratory Science II

· Business Elective

Junior Year

· CC 6 Aesthetic Responsiveness

· CSCI 2214 - Computer Organization

· CSCI 2216 - Computer Organization Lab

· CSCI 3316 - Social & Professional Issues in Computing

· CSCI 3320 - Operating Systems

· CSCI 3326 - Algorithm Design and Analysis

· CSCI 3347 - Network Essentials and Technologies

· ENGL 3300 - Writing Proficiency Assessment

· CSCI Security Elective

· CSCI Junior/Senior Elective

· Mathematics Elective

· Elective

Senior Year

· CSCI 3398 - Computer Science Internship

· CSCI 4497 - Software Project Analysis and Design

· CSCI 4498 - Senior Software Project

· CSCI 4536 - Structure of Programming Languages

· CSCI 4547 - Systems Programming

· Two CSCI Senior Electives

· Mathematics or Science Elective (4 credits)

· Mathematics or Science Elective (3 credits)

· Two Restricted Electives

Definitions of elective categories

· CSCI Junior/Senior Elective: any CSCI course with a number above 3000.

· CSCI Senior Elective: any CSCI course with a number above 4000.

· CSCI Security Elective: CSCI 4446  or CSCI 4534  .

· Laboratory Science I, II, and Science Elective: a laboratory science course that is intended for scientists or engineers.

· Mathematics Elective: a mathematics course beyond the level of MATH 1118 Calculus II, or EASC 3345 Applied Engineering Statistics or ELEC 3320 Random Signals.

· Business Elective: one of the following:EASC 2232  , ECON 1133  ,ECON 1134  ACCT 1101  , MGMT 2210  , or BUSL 1101  .

· Restricted Elective: any course approved by the advisor that supports the student’s academic focus.

· Elective: any college course that is beyond the level that is considered remedial in this program, and does not duplicate material of another required or elective course.  Remedial courses are those below the level of ENGL 1105, MATH 1117, CHEM 1115, PHYS 1150, and BIOL 2253.