Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

California State University, San Bernardino
The School of Computer Science and Engineering
CSE 5720-60: Database Systems
Winter 2025

Course and Instructor Information

Course Description

If you need technical assistance at any time during the course or to report a problem with Canvas, you can visit: https://www.csusb.edu/canvas.

Important Note: This syllabus, along with course assignments and due dates, are subject to change. It is the student’s responsibility to check Canvas for corrections or updates to the syllabus. Any changes will be clearly noted in a course announcement on class Discord and through email.

Course Goals/Objectives and Student Learning Objectives/Outcomes

• Understand terms related to database design and management

• Understand the objectives of data and information management

• Understand the database development process

• Understand the relational model and relational database management system

• Assess data and information requirements

• Construct conceptual data models

• Develop logical data models

• Evaluate the normality of a logical data model, and correct any anomalies

• Develop physical data models for relational database management systems

• Implement relational databases using a RDBMS

• Retrieve data using SQL

• Understand database performance issues

• Understand the basics of data management and administration ƒ Understand the basics of data warehousing

• Work as a valuable member of a database design and implementation team.

Homework (10%)

There will be five homework assignments which must be submitted. The due dates for the assignments are final and there will be no make-ups or individual extensions.

Electronic copies should be submitted on Canvas on the date they are due. File names should clearly identify the course and the assignment.Quizzes (10%)

There will be five closed-book quizzes each of 30-minute duration. The quizzes cannot be taken after the dates scheduled, except in the case of emergencies.

Students will participate in a practical team project during the entire course. Groups will consist of two students each. It will involve the design and implementation of a real-world database, using the techniques learned in class.

As an initial collaboration effort, each group of two students will develop a database using MySQL, import data into the database, and form SQL queries.

Final Exam (50%)

Late Policy: Deadlines for homework and scheduled times for quizzes and exams are strict — no late homework or exams will be accepted. However, if unusual circumstances that are truly beyond your control prevent you from submitting an assignment or attending an exam on time, you should discuss this with the instructor, preferably in advance.

The grades received in this class will be added and averaged as follows: Homework 10% +

Quizzes 10% + Project 30% + Final Exam 50% = 100%.

http://bulletin.csusb.edu/academic-regulations/

Plagiarism and Cheating

Students are expected to be familiar with the University’s Policy on cheating and Plagiarism. Instances of academic dishonesty will not be tolerated. Cheating on exams or plagiarism (presenting the work of another as your own, or the use of another person’s ideas without giving proper credit) will result in a failing grade and sanctions by the University. For this class, all assignments are to be completed by the individual student unless otherwise specified.

Students are to complete assignments individually. Students may discuss the assignment in general terms, but the code they write must be their own. Students are encouraged to discuss ideas, approaches, concepts, bugs, etc., in English, but may not show or give their code to anyone except this course’s TAs and instructor. Students are not allowed to write code with another student on an assignment or to show another student their solution to an assignment.

The course Canvas message board is a good medium for getting help on assignments. Students can also email the instructor or TAs or go to office hours.

All homework, quizzes and exams are individual assignments. No cheating or plagiarism will be tolerated. A tool that detects plagiarism will be employed which is very effective at detecting improper collaboration/ sharing of code. Assignments where evidence of cheating is conclusive will be given a grade of 0, irrespective of correctness. In addition, students who actively seek to hurt the performance of other students by using the department/academic computing resources in any manner that is incompatible with the stated policies will be assigned a final grade of F for the course.

2. If you are sending email to the instructor, please include "CSE 5720:" at the beginning of the subject. It is recommended that you always send email messages from your csusb.edu email account. Class announcements will be sent to your CSUSB account. There will be no reply to any free web-based email accounts, Hotmail, Gmail, or Yahoo, for instance.

4. Homework and projects are submitted on Canvas on or before the due date and time. Also, do NOT turn in any homework or project by email.

5. Quizzes and exams will be held online. They are closed book, closed notes and should be done individually. Please refer to ‘Plagiarism and Cheating’ for additional information.

6. Extra credits will be offered only to those who haven’t committed plagiarism or cheating. 

Support for Students with Disabilities

If you are in need of an accommodation for a disability in order to participate in this class, please see the instructor and contact Services to Students with Disabilities at (909) 537-5238.

If you require assistance in the event of an emergency, you are advised to establish a buddy system with a buddy and an alternate buddy in the class. Individuals with disabilities should prepare for an emergency ahead of time by instructing a classmate and the instructor.Statement on Inclusion, Diversity, and Equity

As a university community, these core values are the driving force that moves us to accomplish our mission and goals:

Social Justice and Equity

We believe in, affirm, and are committed to the equal value and dignity of all people. Fairness and equity are more than equality. We actively seek to eliminate barriers for those who are disadvantaged and disempowered so they may participate fully in university life.

Innovation

We affirm and are committed to the truth. We demonstrate our integrity by being ethical, matching what we say with what we do, and by ultimately taking responsibility for our actions.

Sustainability

We affirm and are committed to the sustainability of our university by forward thinking, learning from both successes and mistakes, being proactive in moving our university forward, and by providing opportunities for continued growth and development.

We affirm and are committed to the importance of transparency both internally and externally. We believe in honesty and openness in our decisions and processes, subject to legal and ethical confidentialities. Understanding we are a public institution, we are also up front and open to the community and residents that we serve about the decisions we make and the actions we take.

We affirm and are committed to protecting and enhancing the health, wellness and safety of ourselves, our colleagues, our students and our stakeholders. We believe a healthy university is one in which there is collegial collaboration and uses continuous improvement processes that ensure a safe and healthy workplace for all.

Course Schedule