This course revolves around the concepts and structures to design
and implement a Database Management System.
Relational and document-oriented databases
will be covered, as well as Advanced SQL programming such as procedures and triggers.
In addition, Cloud Computing platform of Microsoft Azure will be required
to store database and work remotely with group members.
This course might lead to an entry level web developer position in PHP or SQL Developer
|PHP/MySQL Development Environment||XAMPP/WAMP Server||
WAMP (windows only):
| Visual Database Design/Database Modeling Tools
Entity Relationship Diagram (ERD)
Or, ERDPlus (recommended)
|IDE/Editor|| PHP Storm by JetBrains
JetBrains Free Students Licence:
|Cloud Platform||Microsoft Azure|| Get started (we will go over this together in class):
MS Azure - Students
|Chapter 1:||Getting Started||None|
|Chapter 2:||Database Requirements and ER Modeling||None|
|Chapter 3:||Relational Database Modeling||
|Chapter 4:||Relational Algebra||None|
Connect to Remote Database
Please note that, the followings are approximate.
Homework assignments: 15%, quizzes: 15%, midterm exam: 20%, final exam: 25%, final project: 25%
Final gradings will be given according to the following scale:
|A-||90 - 95|
|B+||85 - 89|
|A-||90 - 95|
|B+||85 - 89|
|B||75 - 84|
|C||65 - 74|
|F||0 - 64|
Mobile Devices (i.e., phones, laptops, and tablets):
Out of courtesy for all those in class, cell phones and text messaging are not permitted.
Laptops can only be used for note taking in class. All other uses are not permitted in class.
Accommodations for Disabilities:
Reasonable academic accommodations may be provided to students who submit appropriate
documentation of their disability. Students are encouraged to contact Dr. Christine Mecke in the Office
of Student Disability Services, Bellarmine, B-10, at firstname.lastname@example.org; or at 610.660.1774 for assistance
with this issue. The university also provides an appeal/grievance procedure regarding requested or
offered reasonable accommodations through Dr. Mecke's office. More information can be found at:
Class room and meetings: Go back to the main page or click here for classrooms, meeting times, and office hours. If you have any other inquiries, please do not hesitate to contact me via email or come in to my office during office hours. If you need to see me urgently and office hours are not suitable for you, please email me and we will organize an online meeting.
Email your assignments to me and our TA on or before midnight on the day they are due. If the assignment
is a coding assignment, please be sure to include your source code as well as the output of sample test runs.
Work may be turned in up to one week late. Late work will be penalized by 50%.
After one week late, work will not be accepted.
In case of an emergency, please contact me and I will examine whether I can postpone your assignment.
Academic Honesty: This course will follow the University's standard policy on academic honesty.
In particular, any cheating (including plagiarism) or assisting another student's cheating on any
assignment, test, or the final exam will be penalized by either a zero on the test, or by failure of
the course, at my discretion. Finally, if you cheat twice during this course, you will fail the course.
Remember that the University may inflict further penalties other than those listed here under the
provisions of the published Academic Honesty Policy. Clarification: Webster.com defines plagiarizing as,
"to steal and pass off (the ideas or words of another) as one's own : use (another's production) without
crediting the source." Therefore, if you cut-and-paste something from the web, you are plagiarizing.
If you copy another student's work, you are plagiarizing. If you have someone else do your work for you,
you are plagiarizing.
You may work as a partner with another student on an assignment to an extent. Two identical solutions are not considered. If I receive identical solutions from two students, both students will be lose credit for their homework or might not get any credit for it. Note, I consider copying solutions from online sources to be cheating. Please contact me whether you have any queries in regard to assignments due. If you have any questions or face any difficulties, ask me before the deadline
Attendance: You are encouraged to attend every lecture. Attendance is not mandatory. However, if you do not attend lectures/classes, I will consider this as you are comfortable with the materials and able to write exams and pass the course. Note, if you do not attend regularly, I will not be able to go over the materials again during office hours. However, if you attend, make an effort, work hard, I will be delighted to explain and go over any topics or solve any difficulties encountered during the course.