ITEC 3335
Database Development
Fall 2017
by K. Yue
1. General Information
ITEC 3335.1
Class number: 26514 MW 1:00-2:200pm Delta 202.
1.1 Instructor
Dr. Kwok-Bun Yue, Professor of Computer Science and Computer Information Systems
Delta 163, 281-283-3864, yue at uhcl.edu; URL: http://dcm.uhcl.edu/yue/
Office hour: MW 2:20PM to 4:00PM, T 2:00-4:40PM, walk-in or appointment.
1.2 Teaching Assistant
Rohit Nethi:
Because of UHCL mailbox size limitation, please send your homework to rohityadavnethi at gmail dot com. Set up the UHCL spam filter server for your UHCL account to accept this email address as an approved sender. Otherwise, your email may be quarantined by the spam filter server. Spam server: https://myspam.uhcl.edu:28443/.
For regular correspondence, send it to NethiR3416 at UHCL dot edu.
Office hours at Delta PC Lab D201-D205 or Delta 238 (TA room):
Monday - 11am to 1pm
Tuesday- 4pm to 7pm
Wednesday- 4pm to 7pm
Thursday- 4pm to 7pm
Friday- 2pm to 5pm.
UHCL Student Success Center also provides Computer Science Tutoring service:
CS Tutor: Sumanjali Tirunagaru,
Email Id: tirunagarus7318 at uhcl dot edu, location:Delta Lab
Hours:
Mon: 2:00pm - 7:00pm
Tues: 3:00pm- 6:00pm
Wed: 9:00am-12:00pm
Fri: 1:00pm-5 :00pm
1.3 UHCL Quality Enhancement Plan (QEP) Motto: Applied Critical Thinking (ACT) for Lifelong Learning and Adaptability
This course has been authorized by UHCL as an Applied Critical Thinking (ACT) Course which means that in addition to learning about the specified course content, students will be engaged with some or all of the Elements of Thought and Universal Intellectual Standards of critical thinking. The objective of an ACT course is to develop the student's ability to become skilled at analysis and evaluation by applying a set of intellectual tools that may be effectively used across all disciplines (as well as to the student's personal life). Based on the Foundation for Critical Thinking model (http://www.criticalthinking.org/), critical thinking involves thinking for a purpose, asking questions, using information, applying concepts, drawing inferences and conclusions, identifying assumptions, anticipating implications and consequences, and recognizing points of view. The Universal Intellectual Standards that are applied to these Elements of Thought of critical thinking in order to develop Intellectual Traits include clarity, accuracy, precision, relevance, depth, breadth, logic, significance, and fairness.
Critical Thinking In Information Technology in General and Database Development in Particular
Information Technology is concerned with the applications of computing and communications technology to solve practical problems. For example, in Wikipedia, it is defined as "the application of computers to store, study, retrieve, transmit, and manipulate data, or information, often in the context of a business or other enterprise." The Association of Computing Machine (ACM), the professional association for computing sciences in US, defines the problem space for IT in the following diagram. IT is highly applicative in nature, with its targeted areas spanning from the organization issues and information systems level to the systems infrastructure level. Consequently, a thorough and accurate understanding and precise specification of the problem domain through modeling, with a clear understanding of all assumptions and relevant information is a prerequisite for effectively using IT to construct an effective solution. In fact, all elements of thought of critical thinking are essential in every step of the elaboration and modeling of the problem, and the design, implementation, and maintenance of an IT solution.
In particular, information is usually stored permanently in database. In database development (the subject of this course), critical thinking is integrated in the process. Database developers use principles of data modeling, such as the Entity-Relationship Model (ERM), to clearly and accurately understand the purposes, assumptions and the different points of views of the various types of users, to precisely specify the problem. Concepts of relational theory and data manipulation are applied to infer and construct suitable logical solutions. The implications and consequences of the design are assessed through the cost effectiveness of the database solutions.
The central question in database development is how to store and retrieve permanent data effectively for specific problems.
Fundamental and Powerful Concepts (FPC) of the Course
In ACT vocabulary, fundamental and powerful concepts form the foundation that permeates and unites a course. In this course, these concepts are:
Please see Section 5 below for more details.
1.4 Laboratory Administrations
You may address account and software problems of the DCM server to the systems administrator, Ms. Krishani Abeysekera. Copy your email to me.
1.5 Other Useful Information
1.6 Textbooks
Hoffer, Jeff, Ramesh Venkataraman, and Heikki Topi. Modern database management, 12th edition. Pearson Education, 2016: https://www.vitalsource.com/referral?term=9780133544770.
1.7 Course Description
From Catalog: Introduces database theory, design and implementation. Topics covered will include business data
modeling using the entity-relationship (ER) model, logical database design using the relational data
model and database querying using structured query language (SQL). Database management systems
are studied with database design issues in the context of solving business problems. Laboratory
instruction.
Corequisite: ITEC 3312 Introduction to Scripting.
1.8 Student Learning Outcomes (SLO)
After completing the course, the students are expected to be able to
For ACT assessment, SLOs #3, #4 and #5 will be used. Please see Section 5 for more details.
1.9 Prerequisites
Corequisite: ITEC 3312 Introduction to Scripting.
Languages: The course uses SQL and a high level programming language, such as Python. No prior SQL is assumed. Some background in Python assumed.
1.10 Course Format
Traditional lecture, demonstration, homework, and programming assignments.
2. Course Policies and Guidelines
2.1 General PoliciesTips:
2.2 Attendance
Students are expected to attend class regularly and actively participate in classroom discussions.
2.3 Academic Honesty
Penalty on cheating will be extremely severe. Standard academic honesty procedure will be strictly followed. Use your best judgment. If you are not sure about certain activities, consult the instructor. See: http://prtl.uhcl.edu/portal/page/portal/PRV/FORMS_POLICY_PROCEDURES/STUDENT_POLICIES/Academic_Honesty_Policy
The UHCL Academic Honesty Policy will be strictly adhered to. The honesty code section state:
The Honesty Code is the university community's standard of honesty and is endorsed by all members of the University of Houston-Clear Lake academic community. It is an essential element of the University's academic credibility. It states:
I will be honest in all my academic activities and will not tolerate dishonesty.
Academic honesty is integral to university education. Students are advised to thoroughly understand UHCL academic honesty policy.
2.4 Academic Adjustment Policy
The University of Houston System complies with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, pertaining to the provision of reasonable academic adjustments/auxiliary aids for students with a disability. In accordance with Section 504 and ADA guidelines, each University within the System strives to provide reasonable academic adjustments/auxiliary aids to students who request and require them. If you believe that you have a disability requiring an academic adjustments/auxiliary aid, please contact your University's student disability services center.
2.5 Assessment for Accreditation
The School of Science and Computer Engineering may use assessment tools in this course and other courses for curriculum evaluation. Educational assessment is defined as the systematic collection, interpretation, and use of information about student characteristics, educational environments, learning outcomes, and client satisfaction to improve program effectiveness, student performance, and professional success. This assessment will be related to the learning objectives for each course and individual student performance will be disaggregated relative to these objectives. This disaggregated analysis will not impact student grades, but will provide faculty with detailed information that will be used to improve courses, curriculum, and student performance.
3. Grading Policy
Grades will be assigned based solely on homework and examination scores. No other factors will be considered. In particular, students have requested me to reconsider their grades using the following reasons in the past:
These requests had all been declined politely but firmly in the past.
There will also be no 'special project' that you can work on to improve your grades after the final examination. Anything I offer to one student will be offered to the entire class.
Total score is computed using the following percentages:
Homework: 30%
Mid-Term Exam: 35%
Final Exam: 35%
Last Day to Drop/Withdraw: November 13, 2017
Grade Assignment Table
[92..100] | A |
[90..92) | A- |
[87..90) | B+ |
[83..87) | B |
[80..83) | B- |
[77..80) | C+ |
[73..77) | C |
[70..73) | C- |
[67..70) | D+ |
[63..67) | D |
[60..63) | D- |
[0..60) | F |
4. Course Syllabus and Schedule
The syllabus is tentative. Actual contents and order of coverage may change. There will be around 9 homework assignments, the actual number is subjected to changes.
Date |
Contents |
Comments |
Week #1: 8/28 & 30 | Introduction to the course Persistent Data Introduction to Database Systems Introduction to Microsoft Access |
Read Hoffer Chapter 1 and the companion PPT How to be successful in ITEC 3335 Introduction to ITEC 3335 Introduction to MS Access HW #1 due on 9/14 (Thursday) 5:00pm |
Week #2: 9/4 & 9/6 | 9/4: Labor Day Holiday Critical thinking in computer science and database Database basics |
Read Hoffer Chapter 1 Critical Thinking in IT and DB DB Basics HW #2 due on 9/21 (Thursday) 5:00pm |
Week #3: 9/11 & 9/13 | An introduction to the relational model and SQL. |
Read Hoffer Chapter 4 pp 155-160. Read Hoffer Chapter 6 Processing Single Table (pp. 261-274) Introduction to the relational model and SQL HW #3 due on 10/3 (Tuesday) 5:00pm |
Week #4: 9/18 & 9/20 | An introduction to Concept Map The relational model |
A brief introduction to Concept Map Syllabus in concept maps The Relational Model Read Hoffer Chapter 2 A RDB Relational Example of Concept Map in the context of critical thinking. |
Week #5: 9/25 & 9/27 | An introduction to data modeling The ER model |
Read Hoffer Chapter 2. ER Modeling ER Modeling Exercise ER in Concept Map HW #4 due on 10/12 (Thursday) 5:00pm |
Week #6: 10/2 & 10/4 |
The Extended ER (EER) model Conversion of EER model to the relational model |
Read chapter 3, only the concept of subtyes and subclasses are necessary. Read Hoffer Chapter 4, pp 155-181. Extended ER Modeling Conversion of ER Model to Relation Schema HW #5 due on 10/30 (Monday) 2:00pm |
Week #7: 10/9 & 10/11 |
Logical database design |
Read Hoffer Chapter 4 pp.182-205 Introduction to Database Design Introduction to Normalization Theory HW #6 due on 11/6 (Monday) 5:00pm |
Week #8: 10/16 & 10/18 |
10/16 (Monday): Mid-term examination Logical database design |
Read Hoffer Chapter 4 pp.182-205 |
Week #9: 10/23 & 10/25 | Physical DB Design SQL/ SQL Client/MySQL |
Read Hoffer Chapter 5 and 6 Physical DB Design An introduction to SQL and MySQL |
Week #10: 10/30 & 11/1 | More SQL |
Read Hoffer Chapter 6 pp 289-313. HW #7 due 11/9 (Thursday) 5:00pm |
Week #11:11/6 & 11/8 | More SQL Python Review |
Read Hoffer Chapter 8, general 2-tier and 3-tier architecture only. Introduction to Python |
Week #12: 11/13 & 11/15 | Database Application Development in Python |
MySQL programming in Python HW #8 due on 11/21 (Tuesday) 5:00pm |
Week 13: 11/20 & 11/22 |
11/22 Thanksgiving Holiday Database Application Development in Python |
MySQL programming in Python |
Week #11/27 & 11/29 | Introduction to Data Visualization Analysis Tableau |
Data Visualization in Tableau HW #9 due on 12/1 (Friday) 5:00pm |
Week #15: 12/4 & 12/6 | Simple Database Administration Additional Topics Review and Questions |
Simple DB Administration HW #10 due on 12/7 (Thursday) 5:00pm |
Week #16: 12/13 |
Final Examination (Wednesday) |
1:00-2:30pm |
5. Applied Critical Thinking (ACT)
5.1 Vocabulary of Critical Thinking
We use the vocabulary of critical thinking described by Drs. Richard Paul and Linda Elder, including the eight elements of thought and nine universal intellectual standards:
Eight elements of Thought of Critical Thinking:
Nine Universal Intellectual Standards for Critical Thinking:
For more details, see:
[1] Paul, R. and Linda Elder, L., The Miniature Guide to Critical Thinking-Concepts and Tools (Thinker's Guide), 7th edition, Foundation for Critical Thinking, 2014.
[2] Paul, R. and Linda Elder, L., Critical Thinking: Tools for Taking Charge of Your Learning and Your Life, 3rd Edition, Prentice Hall, 2011.
5.2 Critical Thinking Process (CTP)
According to the ACT vocabulary we used, there are four major aspects of the Applied Critical Thinking Process, termed as the 4 C's: curiosity, connection, creativity and communication. In this course, the C in the student learning objectives is connection:
5.3 Critical Thinking Activities and Assessment
Critical thinking activities are integrated in the course. Lectures and demonstrations will include examples to highlight CT elements and intellectual standards, and their applications. This includes the uses of the CT techniques such as SEE-I, Concept Maps, and visualization tools. The instructor will highlight the relevant elements of thought in classroom examples. Homework and programming assignments contain various ACT components. Both the mid-term and final examinations include ACT-oriented questions.
In particular, data of three assessment activities (AA) on ACT will be collected to assess how well critical thinking is incorporated into the course. These assessments will be used as input to the UHCL Critical Thinking database for internal assessment of Critical Thinking, and will not directly affect your grade of the course. (However, there seems to be a positive correlation between CT assessment results and grades.)
The course assesses connections out of the four C's. The related Student Learning Outcomes (SLO) and Fundamental and Powerful Concepts (FPC):
ACT Assessment Activity |
ACT SLO |
FPC |
HW-ER |
3 |
1 |
HW-REL |
4 |
2 |
HW-SQL |
5 |
3 |
The assessment criteria for the AA:
ACT Assessment Activity |
Assessment Outcome |
||
Unacceptable |
Acceptable |
Excellent |
|
HW-ER |
[0%,80%) |
[80%,92%) |
[92%,100%] |
HW-REL |
[0%,80%) |
[80%,92%) |
[92%,100%] |
HW-SQL |
[0%,80%) |
[80%,92%) |
[92%,100%] |
Overall, if 70% or above of students are evaluated to be acceptable or excellent in each activity, as well as the average of all activities, the outcomes will be deemed acceptable. To close the loop of assessment, the instructor will evaluate the ACT content, activities, and assessment of the course, and make necessary adjustment.