Summer 2023
Introduction to database systems. Comparison to file processing systems. Data models. Relational, hierarchical, and network systems. Database design. Normal forms. Study of several real-world database management systems, with an emphasis on microcomputer applications. Database recovery query and transaction processing, concurrency. Distributed and object-oriented databases.
Instructor: Harry Goldberg
Email: Harry.Goldberg@brooklyn.cuny.edu
Virtual office hours: Mondays 12:30-1:30pm.
Zoom Link is listed in print syllabus
Instruction Method: Live lectures on campus
Day(s): Mondays-Thursdays
Time: 9:55 am – 11:40am (Need update)
Location: Room: IA 236. (Need update)
There is no required textbook for this class.
This course is a zero cost/open educational resources (ztc/oer) course. That means there is no textbook students need to purchase. All materials are available freely to students. All reference materials for the course can be found on the website you are currently on CISC 3810 Database Systems (https://libguides.brooklyn.cuny.edu/cisc3810
)
Please notify the Professor RIGHT AWAY if you discover any broken links. Professor will try to provide you with updated links as soon as they are made aware of the problem.
After successful completion of this course, students will have achieved proficiency in data modeling use the Entity-Relationship Model, Relational Database Design Techniques, Basic and Intermediate SQL query creation, and Database access techniques from current programming languages.
Creately, H2, Microsoft SQL, PostgreSQL, and Microsoft Access. Instructions on how to acquire these software products will be provided in class and in the Homework Guidelines document in the Homework Guidelines section on Blackboard.
Grade Components:
Attendance: Attendance is mandatory.
Homework:
The Brooklyn College Center for Student Disability Services is back to working in-person on campus, though you can still reach out via email and phone. Please email them at testingcsds@brooklyn.cuny.edu for assistance.
Location: 138 Roosevelt Hall
Phone: 718.951.5538
FAX: 718.951.4442
Department Office Hours:
Note: Office hours during summer and winter intersession breaks varies.
Students should inform the professor if they have a disability or any other situation that may require Section 504/ADA accommodations. The faculty and staff will attempt to work out whatever arrangements are necessary.
Please provide your professor with your course accommodation form and discuss your specific accommodation with your professor as soon as possible to ensure accommodations are met in a timely fashion.
In order to receive academic accommodations students must first be registered with the Center for Student Disability Services. Students who have a documented disability or who suspect that they might have a disability are invited to set up an appointment with the Director of the Center for Student Disability Services, Ms. Valerie Stewart-Lovell or the Assistant Director, Josephine Patterson or their general email testingcsds@brooklyn.cuny.edu
Center for Student Disability Services (CSDS) Mission:
It is the mission of the Center for Student Disability Services (CSDS) to ensure that students with disabilities have equal access to all campus facilities, curricula, and activities. The program’s objective focuses on providing students with reasonable disability-related accommodations and the opportunity to maximize their academic success at Brooklyn College. The goal is to ensure an inclusive environment while maintaining and enhancing the college’s academic excellence by providing students with disabilities the opportunity to achieve their highest possible academic potential.
Academic dishonesty of any type, including cheating and plagiarism, is unacceptable at Brooklyn College. Cheating is any misrepresentation in academic work. Plagiarism is the representation of another person’s work, words, or ideas as your own. Students should consult the Brooklyn College Student Handbook for a fuller, more specific discussion of related academic integrity standards.
Academic dishonesty is punishable by failure of the “…test, examination, term paper or other assignment on which cheating occurred” (Faculty Council, May 18, 1954).
In addition, disciplinary proceedings in cases of academic dishonesty may result in penalties of admonition, warning, censure, disciplinary probation, restitution, suspension, expulsion, complaint to civil authorities, or ejection (Adopted by Policy Council, May 8, 1991).
NOTE: If you have a question about how to cite correctly ask your teacher BEFORE submitting your work.
Numerical grade | Letter Grade |
---|---|
97-100 | A+ |
93-96 | A |
90-92 | A- |
87-89 | B+ |
83-86 | B |
80-82 | B- |
77-79 | C+ |
73-76 | C |
70-72 | C- |
67-69 | D+ |
63-66 | D |
60-62 | D- |
Below 60 | F |
To access some items you need to login with your Brooklyn College ID and others you will need to enter a password given to you by your professor.
The following icons will let you know what you will need to do to access the items.
If an item has no icon, then you don't need to do anything to access it.
Off-campus access. Use your CUNYfirst Username and Password to log in (same credentials for logging into Blackboard).
Password protected item. You will be prompted to enter the password given to you by your Professor.
Need assistance with off-campus access? Go to the library's Library Remote Access page for assistance and instructions.
The Brooklyn College Library's electronic resources (e.g. journals, ebooks, databases, etc.) are available to registered students, faculty, and staff when off-campus, including while abroad.
All CUNY members have free access to The New York Times, The Wall Street Journal and the Chronicle of Higher Education.
NY Times: Anyone who initiates an account will have an active subscription for one year from the date she/he creates the account. If you already have an annual subscription to the NYTimes, you can cancel it and will receive a refund. However, if you only have a monthly subscription, the New York Times will not issue a refund for that month.
Newspaper Icons
Returning Safely Together resources for students, faculty, staff and visitors.