T. Andrew Yang
|
Last updated: 6/3/2024: first posted |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CSCI 4333
Design of Database Systems summer 2024 (6/3 – 7/27)
Time
(Classroom) Tuesdays
& Thursdays, 9:00am – 11:50am (Delta 201) Course Description: Design of database systems, data
description and manipulation languages, data models, entity-relationship
model, relational model, SQL, relational algebra, normalization theory, DBMS,
Internet, data base design, data flow diagrams and implementation of data
base systems. Prerequisite:
CSCI 2315 Data Structures. Learning Outcome:
-
Describe the stages of database design, various
database architectures and data models. -
Explain the concepts of the entity-relationship
model, and the relational model. -
Explain the theoretical background of relational
database, including relational algebra and relational calculus. -
Implement relational database systems using DBMS,
SQL, embedded SQL, including both data definition and manipulation languages -
Explain the importance of normalization of
databases, and convert a given relational database into different normal
forms. Class Format: Lectures are combined with discussions. Students
are expected to be active participants, by studying the relevant chapters
and/or research papers, and participating at in-class discussions. Lifelong learning “Education is not
something you can finish.” (Isaac Asimov) Effective learning: A note about Bloom's Taxonomy and your learning … (source:
https://tips.uark.edu/using-blooms-taxonomy/
) Instructor:
Dr. T. Andrew Yang -
Email address: yang@uhcl.edu -
Web site: https://sceweb.uhcl.edu/yang -
Office: Delta
174 -
Phone: (281)
283-3835 (Please leave a message if the phone is not answered.) -
Drop-in
Office Hours Feel free
to stop by my office during the above hours; alternatively, you may click
this link: https://uhcl.zoom.us/j/93285948037?pwd=U3NJMmhMaWVjZy9INUxwbS9ENDBvZz09
to chat with me online during the office hours. -
To communicate with the
professor, you are
encouraged to email your questions or issues to yang@uhcl.edu
and, if necessary, set up a time with the professor to have an online
meeting. Emails are typically replied within 24 hours. If you have not
received a response within 24 hours, either send a reminder email or leave a
message at (281) 283-3835. -
Using emails
effectively: Emailing
has become an indispensable tool in most work places. Emails
without a subject line or the signature line will be considered as
potentially malicious and be discarded.
Here is a sample subject line: "CSCI 1320 assignment #1, question
3". The signature line should have your full name and the name of the
class. Although
email messages tend to be informal, please check the grammar and spelling of
your messages to ensure their legibility. Try
to provide sufficient details in your email message, such as the problem(s)
you have encountered, the solution(s) you have tried, and the outcome you
have got from these solution(s). Teaching assistant info and office hours
Required Text: Ricardo, Urban, and Davis. Databases
Illuminated, 4rd Edition. 2022. Jones & Bartlett (ISBN-10 :
1284231585; ISBN-13 : 978-1284231588) + Instructor's handouts in the class and/or on the Web NOTE:
The following schedule will be adhered to as closely as possible,
although changes are probable. Always check with your instructor if you are
not sure about what would be covered next week.
Attendance Policy: You are
expected to attend all classes. If you have ever missed a class, be sure to
watch the recorded session to learn what had been covered. It is your
responsibility to get hold of whatever may have been discussed in the class.
+ Class
Participation: Participating in
the class is expected. You should ask or answer questions during the in-class
or online discussions. Grading Scale: The
accumulated points from all the categories determine a person's final grade. There
will be no extra-credit projects.
Grading
policy: ·
All students are graded the same way according to the grading scale
posted above. ·
Unless a grading error is found in an exam or assignment, a student’s
grade will NEVER be changed once it is assigned. ·
No extra projects or assignments would be given to an individual
student to help improve his/her grades. Advices: ü Your grades will be
continually updated in the Canvas. It is your obligation to monitor your
grade-in-progress regularly, and immediately ask questions or seek help if
you are concerned. ü Once a grade is assigned
and posted (in the Canvas), a student may appeal for correction of the
assigned grade (if a grading error is found) within a week. After that, the
grade is finalized. ü Never bother to appeal for
a change of your grade once it is finalized; the best and proper time of
improving your chance of earning a good grade is before it is finalized. Quizzes,
Tests, and Exams: Both analytic and synthetic abilities are emphasized. Being able
to apply the learned knowledge toward problem solving is also highly
emphasized in the tests. No
makeup quiz will be given. Unless
due to unexpected, documented emergency, no makeup tests or exams will be
given. Assignments
will be posted on the class web site as well as in the Canvas. The due
date and time of each assignment is specified when it is published in the Canvas. ·
Identification
page: All assignments must have
your name, and course name/number/section number (e.g., CSCI 4323) at the top
of the first page. ·
Proper
organization of submitted material: If
your submission include multiple documents, combine all of them into a single
document (for example, a single PDF or ZIP). ·
Order!
Order! Arrange the solutions
following the sequence of the questions. Write the question number at the
top-right corner of each page. ·
Word
processing: It is required that you
type your reports (e.g., print them using a printer). Use a word processor
and appropriate typesetting and/or drawing tools to do the assignments. Spellcheck
the whole document before printing it. You may lose points due to spelling
or grammatical errors. A note about problem-solving: An important part of problem solving is correct understanding of the
given problem. ·
Try to have a good grasp of
the problem before starting the process of finding the solution(s). ·
Use any resources, including
the instructor, the TA, your classmates/friends, and online resources to
ensure that you have correctly understood the given problem. ·
While trying to figure out
the solution(s), continue to verify your understanding of the problem. ·
Read the given instructions
carefully before taking any action; while preparing
your solutions, be sure to follow the given instructions. NOTE: When a grade is assigned, the grade can
only be appealed within a week after
the grade has been posted. Always review a graded lab or test immediately and, if
needed, talk to the instructor within a week. Academic Honesty Policy: NOTE:
Unless
otherwise specified, all assignments, projects, quizzes, tests and exams are
individual work. Students should take caution not to violate the academic
honesty policy specified by the university. Per the UHCL
academic honesty policy, plagiarism is defined as follow. Plagiarism: a. Incorporating the work
or idea of another person into one’s own work without acknowledging the
source of that work or idea. b. Attempting to receive
credit for work performed by another person, including papers obtained in
whole or part from individuals or other sources. c. Copying copyrighted
computer programs or data files belonging to someone else. Visit http://cse.uhcl.edu/yang/citing.htm for more information about cited references. Instructor's Notes:
As
a starting point, listed below are some of the common behaviors that do not
conform to the codes of ethics: - Being
regularly late for the class. - Chatting
with another person while the instructor or someone is giving a speech in
class. - Being
regularly late when submitting assignments. - Asking
the instructor or the TA for a favor when submitting a late assignment. - Checking
out others’ answers during an exam. - Continuing
to write when an exam’s time is up, or submitting an online exam past the due
time. - Violating
academic honesty when working on the assignments or exams. - Using
others’ write-up without proper citing when writing a paper or report. - …
Go to the Index |