CS3743 Syllabus

Instructor:

Larry Clark

Email:

larry.clark@utsa.edu Please include cs3743, your section, and your name in the subject.

 

Please feel free to send me an email about your assignments; however, I cannot guarantee an immediate response (especially after 9pm).  Start on your assignments early to allow for time to receive help from a TA or me.

Office Hours:

(Effective March 23 thru May 7 )

I will be available only remotely via Discord.

TuTh 10am-11am,

TuTh 1-2pm.

W 2-4pm

MF (I will usually be available) 2-4pm.  Some exceptions:

  • F March 27th - I will be grading midterm exams.
  • F April 17th - I will be hosting a Career Development session
  • F April 25th - Faculty meeting
  • F May 8th - I will be out of town.

My Webpage:

http://www.cs.utsa.edu/~clark/

Class Hours:

Section 1: TuTh 8:30-9:45am, BB 3.04.08 Now in BlackBoard Collaborate Ultra.

Section 2: TuTh 4:00-5:15pm, NPB 1.202 Now in BlackBoard Collaborate Ultra.

Textbooks:

Title: Fundamentals of Database Systems

Authors: Elmasri and Navathe

Publisher: Pearson

ISBN-13: 978-0133970777

ISBN-13 for paperback: 978-9332582705

Prerequisite:

CS2233 (Discrete Math) and CS3423 (Systems Programming)

CS3743 assumes you are very familiar with the C and Java programming languages.  There will be programming assignments using C and Java.

Course Objectives:

Study of the fundamentals of database systems. Topics include:

> database management concepts

> file structures, hashing, indexes, secondary keys, and physical performance

> data modeling and normalization

> relational data manipulation languages: relational algebra, relational calculus, SQL

> data definition and control languages

> source code integration with a DBMS (use of JDBC)

> implementation issues including integrity control, views, query optimization, concurrency control and backup/recovery

> big data

There will be one or more C programming assignments involving file structures.  The SQL assignment will use Java.  Additional programming assignments, may be assigned. There will be homework assignments (approx 7) for many of the other topics.    

Grading:

300 Programs, Quizzes, Homework, Class Participation

Tentative list of programs:

> Pgm #1 - C file structures

> Pgm #2 - C file structures

> Pgm #3 - Java using MySQL and JDBC

Tentative list of homework:

> Hwk #1 - B-tree manipulation

> Hwk #2 - Physical performance

> Hwk #3 - Data Modeling

> Hwk #4 - Relational Algebra

> Hwk #5 - Relational Calculus

> Hwk #6 - SQL

> Hwk #7 - Normalization

There will be additional practice exercises to better prepare you for exams.  I am giving approx 7 homework assignments and 3 programming assignments to better prepare you for tests. 

Scholastic dishonesty will not be tolerated.

 

300 Midterm Exam (tentatively scheduled for the 7th week)

You will probably need an approved calculator for the midterm.  (It cannot be programmable and cannot have accessible memory beyond an accumulator.)

 

400 Final Exam

Late Policy:

Programs:

10% off per day late (not accepted after 5 days late). 
Programs will be turned in via Blackboard.  Some assignments may involve group work.

Homework:

late homework not accepted

Quizzes:

no makeup except for university sanctioned excused absences.

Exam Policy:

If a Midterm Exam is missed, the Final Exam will count for a missed exam.  There will only be makeup exams for university-sanctioned excused absences.

Final Exam :

Section 1: Th May 14, 9am-10:50am

Section 2: Tu May 12, 3-4:50pm

Attendance:

Attendance in the lecture is required. Prior to Spring Break, please record your attendance with iClicker. After the extended Spring Break, attendance in taken via Blackboard Collaborate Ultra.

Important:

Your education is very important to me.  If there is anything (reasonable) we can do to make it better, please let me know. 

 

Ask questions.  It is important to ask questions; others probably have the same question.  In some circumstances, I may postpone an answer until necessary material is covered.

Distractions hurt your education.  Please be considerate of others:

>      Please turn OFF (do not just silence) your cell phones and pagers. If you have a potential emergency, please inform me before the class begins. In that circumstance, you can leave your mobile device on vibrate; quietly exit the class room to take your call.

>      Please arrive to class on time.  When someone arrives late, they distract many of the students who were on time.

 

Consulting electronic devices is not allowed during exams.  During exams, such consultation may result in a zero.

 

Programs must be written based on my programming standards.

 

Scholastic Dishonesty will not be tolerated.

Miscellaneous:

All students are expected to understand the general rules and regulations of UTSA including the information at http://provost.utsa.edu/syllabus.asp

 Black Board:

After the semester begins, most course information will be available only through Black Board. 

Course Notes:

My notes will usually use a two column format and will be provided in Microsoft Word (use web view), allowing you to edit them to fill in exercise information which will be intentionally blank.   To print the notes, use print view, landscape orientation, and narrow margins.  Some of the notes will use Microsoft PowerPoint.

Fine Print:

This Syllabus is provided for informational purposes regarding the anticipated course content and schedule of this course. It is based upon the most recent information available on the date of its issuance and is as accurate and complete as possible. I reserve the right to make any changes I deem necessary and/or appropriate. I will make my best efforts to communicate any changes in the syllabus in a timely manner. Students are responsible for being aware of these changes.