CIS-208: Database Management Systems

Course, prefix, number, & title: CIS-208 Database Management Systems

Hours (Class, recitation, Laboratory, studio): 2 class hours, 2 lab hours

Credits: 3

Pre-requisites (if any): CIS-101

Course Description in college catalog:

In this course, students will learn database management system concepts, apply them to practical business situations and develop solutions using database software. Emphasis is on relational database design and implementation. Topics include creation of database objects for data storage, retrieval and analysis, table structures and relationships using primary and foreign keys, object dependencies, and importing and exporting of data. Also discussed are the formation of complex queries using SQL (Structured Query Language), joins, indexing, as well as automating repetitive procedures with the use of macros. 

Academic programs for which this course serves as a requirement or an elective:

A.A.S. Computer Information Systems

A.A.S. Office Administration and Technology

Certificate Program – Computer Information Systems

General Education Outcomes: Below is a listing of General Education Outcome(s) that this course supports.

1. Use analytical reasoning to identify issues or problems and evaluate evidence in order to make informed decisions

2. Apply information management and digital technology skills useful for academic research and lifelong learning

Course-specific student learning outcomes:

At the end of this course the students will be able to:

1. Create databases according to specific requirements, use relationships, insert, retrieve, and delete data from databases using Access.

2. Generate single and multi-table queries to retrieve data from a database to satisfy complex ad hoc information requests.

3. Generate forms for manipulating and presenting data.

4. Create reports including aggregate data based on static or dynamic record sets.

5. Generate macros, menus, and simple programs for automating repetitive tasks.

Program-specific outcomes

Use business application software and analytical reasoning and apply technological tools to solve business problems by creating and analyzing databases, developing and evaluating spreadsheets and constructing web pages.

Methods by which student learning will be assessed and evaluated; describe the types of methods to be employed; note whether certain methods are required for all sections:

1. Student participation

2. Hands on in-class lab assignments

3. Hands on project assignments outside the classroom

4. Hands on examinations

Academic Integrity policy (department or College):
Academic honesty is expected of all students. Any violation of academic integrity is taken extremely seriously. All assignments and projects must be the original work of the student or teammates. Plagiarism will not be tolerated. Any questions regarding academic integrity should be brought to the attention of the instructor. The following is the Queensborough Community College Policy on Academic Integrity: "It is the official policy of the College that all acts or attempted acts that are violations of Academic Integrity be reported to the Office of Student Affairs. At the faculty member's discretion and with the concurrence of the student or students involved, some cases though reported to the Office of Student Affairs may be resolved within the confines of the course and department. The instructor has the authority to adjust the offender's grade as deemed appropriate, including assigning an F to the assignment or exercise or, in more serious cases, an F to the student for the entire course." Read the University's policy on Academic Integrity opens in a new window(PDF).

Disabilities
Any student who feels that he or she may need an accommodation based upon the impact of a disability should contact the Office of Accessibility Services in Science Building, Room S-132, 718-631-6257, to coordinate reasonable accommodations for students with documented disabilities. You can visit the Office of Accessibility Services website.