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
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:
General Education Outcomes: Below is a listing of General Education Outcome(s) that this course supports.
Use analytical reasoning to identify issues or problems and evaluate evidence in order to make informed decisions
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:
Create databases according to specific requirements, use relationships, insert, retrieve, and delete data from databases using Access.
Generate single and multi-table queries to retrieve data from a database to satisfy complex ad hoc information requests.
Generate forms for manipulating and presenting data.
Create reports including aggregate data based on static or dynamic record sets.
Generate macros, menus, and simple programs for automating repetitive tasks.
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:
Hands on in-class lab assignments
Hands on project assignments outside the classroom
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).
Any student who feels that he or she may need an accommodation based upon the impact of a disability should contact the office of Services for Students with Disabilities in Science Building, Room S-132, 718-631-6257, to coordinate reasonable accommodations for students with documented disabilities. You can visit the Services for Students with Disabilities website.