Course Information
Instructor
- Use the institutional learning management system email instead of regular emails for threaded email correspondences.
- Emails are generally responded to within 24 hours.
- If needed, the instructor's email address is tychen@university.edu.
Learning Objectives
Upon successful completion of this course, students will be able to:
- Operate the selected functional features of a database management system.
- Understand data management concepts and explain the role of databases in organizations.
- Analyze the role of databases in a functional information system.
- Explain how a database management system supports common functional information systems in organizations.
- Work successfully individually and in a group on a database-driven application system.
Course Materials
General Introduction
SQL Practice
- Laptop Computer: You are encouraged to bring a laptop computer to the class meetings for use in the hands-on activities.
- Software: Software applications needed for this course is available via https://labs.university.edu.
- Help Desk: If you need help using the applications or have issues accessing the virtual machines, speak with the personnel at the Help Desk (https://helpdesk.university.edu) in the Department building or create a support request ticket.
Course Assignments
Examination
Exams are comprehensive assessments of student learning over a period of time. An exam will include all the content learned prior to the exam.
Homework
There will be multiple homework assignments for the students to practice conceptual and technical topics covered in class. Homework assignment instructions are detailed separately in each assignment and are due on the dates identified in the course summary.& nbsp ;
Lab
Lab assignments and quizzes are quick formative assessments of student learning. Lab exercises are given for students to practice technical skills and increase conceptual understanding of the concepts and skills covered.
Project
The project will require you to work individually or as a group to develop a three-tier web-based application. The details on the project will be issued in a separate handout and will cover how your work will be evaluated.
Quiz/Participation
In-class assignments and quizzes serve as records of class attendance. Quizzes serve to assess a student 's prior knowledge and diagnose student learning during a short period of time.
Note: No late or makeup submissions for in-class assignments / quizzes are allowed as they are meant to be your attendance records and to evaluate whether you are following the class closely.
Grading Scheme
Course Requirement | Number of Items | Points per Item | Total Points |
---|---|---|---|
Homework | 10 | 15 | 150 |
Lab | 7 | 10~15 | 100 |
Project | 1 | 50 | 50 |
Exam | 3 | 50 | 150 |
Attendance/Participation | 50 | ||
500 |
Letter Grade | Range |
---|---|
A | 100% to ≥ 93% |
A- | < 93% to ≥ 90% |
B+ | < 90% to ≥ 87% |
B | < 87% to ≥ 83% |
B- | < 83% to ≥ 80% |
C+ | < 80% to ≥ 77% |
C | < 77% to ≥ 73% |
C- | < 73% to ≥ 70% |
D+ | < 70% to ≥ 67% |
D | < 67% to ≥ 63% |
D- | < 63% to ≥ 60% |
F | < 60% to ≥ 0% |
Course Policies
Late Assignment Submission
Communications
- Treat others with respect.
- Please communicate with your instructor and peers in a timely manner and avoid last-minute requests whenever possible.
- Report any inappropriate communication considered to be of a serious nature, as it may be a violation of University policy, to your instructor.
- Text messaging for technical help:
- When permitted by institutional policy, text messaging is considered a professional channel for administering quick problem-solving sessions.
- Please include screenshots of your full code, and briefly describe the issue and how you have tried to solve the problem.
- Phone numbers of current students are not added to the instructor's contact list for privacy concerns.
- Text messages are deleted periodically. The instructor does not keep prior problem-solving conversations.
- Avoid giving personal information when seeking technical assistance. Just:
- state the course and topic,
- describe the problem and your thoughts, and
- present screenshots.
- Emailing: Typically, emails are responded to within 24 hours. If you do not see a response in 24 hours, assume the email is lost and resend the email or text a reminder message the instructor.
- Grading: Assignments are typically graded within 3 days after each due date.
- Please place a headshot in your online learning system profile, so the instructor can better match names and faces.
Attendance
- Expectation: Class meetings are business meetings. You are expected to attend all class meetings and participate in the class activities.
- Definition of Absence: Excused absences, per university policy, include documented illness, deaths in the family, and other documented crises, call to active military duty or jury duty, religious holy days, and official University activities. These absences will be accommodated in a way that does not arbitrarily penalize students. Consideration will also be given to students whose dependent children experience serious illness.
- Communication: Please communicate with the instructor professionally in a timely manner (which usually means notifying the instructor 24 hours or more, unless it's an emergency, before the absence) and with clear message and required documentation .
- Excuse Documents: In case of an excused absence, please attach your excuse documents in your communication with the instructor for recordkeeping purposes.
- Attendance Assignments/Quiz: The in-class attendance assignments/quiz are for formative assessment and taking attendance. Points from these assignments/quizzes are for the students who attend the class meetings only.
- Free Passes: Two to three lowest scores from the attendance assignments may be discounted at the end of the semester.
- Multitasking: Unless you are being disruptive, multitasking (e.g., googling for fast fact-checks) is allowed in class. However, you are expected to take a seat in the back of the classroom if you intend to multitask often to avoid distracting the instructor and your peers.
Academic Honor
We follow the University 's Academic Honor Policy to prohibit:
- plagiarism,
- cheating,
- unauthorized group work,
- fabrication, falsification, and misinterpretation,
- multiple submission,
- abuse of academic materials,
- complicity in academic dishonesty, and
- attempting to commit any above offense.
Course Schedule
Week | Module | Topic | Technology | Reading | Assignment |
---|---|---|---|---|---|
1 | Course Overview |
|
|
||
2 | Technology Overview |
|
|
HVT01 | |
3 | Database Operations w/ SQLite 1/2 |
|
|
HVT06 | LinkedIn SQLite jobs |
4 | Database Operations w/ SQLite 2/2 |
|
|
HVT06 | |
5 | Database Management 1/2 |
|
|
HVT02 | |
6 | Database Management 2/2 |
|
|
|
|
7 | Conceptual DB Design |
|
|
|
|
8 | Logical DB Design 1/3 |
|
Midterm | ||
9 | Logical DB Design 2/3 |
|
|
||
10 | Logical DB Design 3/3 |
|
|
||
11 | Database Application Development 1/3 |
|
|
Project plan (scenario, BP, business rules, DB model, schema) | |
12 | Database Application Development 2/3 |
|
IDE vs Editor: PhpStorm vs VSCode | ||
13 | Database Application Development 3/3 |
|
|||
14 | NoSQL |
|
|||
15 | XML |
|
Final Exam | ||
16 | Project Presentation | Final Project PPT |
Assignment Schedule
Date | Assignment | Due |
---|---|---|
Assignment VM List | 11:59pm | |
SCP test.txt to the VM and local class directory | 11:59pm | |
VM Account Info | 11:59pm | |
Assignment SQLite-chnook.db Screenshot | 11:59pm | |
Assignment SQLite CRUD Lab 01 | 11:59pm | |
Assignment SQLite CRUD Lab 02 | 10:30am | |
Assignment SQLite CRUD Lab 03 | 10:30am | |
Assignment SQL Keywords of Different DBMS | 11:59pm | |
Assignment Syllabus and Course Policies | 11:59pm | |
Assignment MySQL Admin | 10:30am | |
Assignment CRUD with Workbench | 11:59pm | |
Assignment CRUD Lab 3 | 11:59pm | |
Assignment CRUD with Workbench HW | 11:59pm | |
Assignment CRUD Lab SQL Script | 10:30am | |
Assignment source employees.sql | 9am | |
Assignment Attendace 02-11 | 10:30am | |
Assignment IBM HR Employees DB | 11:59pm | |
Assignment MySQL Example employee DB CRUD w07 | 10:30am | |
Assignment MySQL employees DB CRUD w07 HW | 11:59pm | |
Assignment DB SQL Queries w07-2 (MySQl employees DB) Retake | 10:30am | |
Assignment ER Conceptual Model with Relationships University DB | 11:59pm | |
Assignment Midterm | 10:10am | |
Assignment ERD Physical Model & Implementation | 11:59pm | |
Assignment Mary vs. FBI (INNER JOIN) | 11:59pm | |
Assignment Salary Report | 11:59pm | |
Assignment Current Employees Salary Report | 11:59pm | |
Assignment Order & Customer Tables | 11:59pm | |
Assignment Joint Table Mini Lab (Reverse Engineering) | 11:59pm | |
Assignment SQL Query Review | 11:59pm | |
Assignment The Car Table | 11:59pm | |
Assignment SELECT Stmt | 11:59pm | |
Assignment index.html Products Orders page | 11:59pm | |
Assignment something/test.html | 11:59pm | |
Assignment SQL Practice | 11:59pm | |
Assignment PHP MySQL Connection Script | 11:59pm | |
Assignment SQL Review w12 | 11:59pm | |
Assignment Project Ideas | 11:59pm | |
Assignment Insert Form Data to DB | 11:59pm | |
Assignment SQL Practice: INNER JOIN | 11:59pm | |
Assignment inventory.php | 11:59pm | |
Assignment processing.php | 11:59pm | |
Assignment SQL Practice 04-08 | 11:59pm | |
Assignment Your True Color | 11:59pm | |
Assignment Workflow | 10am | |
Assignment Create DB/Tables | 11:59pm | |
Assignment UNION/UNION ALL | 11:59pm | |
Assignment Project Workflow Pages | 11:59pm | |
Quiz Final Exam | 10:10am | |
Assignment Project Presentation/Review | 11:59pm | |
Assignment Project Report | 11:59pm | |
Assignment ER Conceptual Model University DB | ||
Assignment Extra Credit |