CS4342: Database Management
From Minas
CS4342 Database Management
Contents |
General Course Information, Spring 2009
Course Objective & Topics
The course provides students with an understanding of database design principles and the use of database management systems for applications. Entity-Relationship (E/R) diagrams and Uniform Modeling Language (UML)-based object-oriented diagrams are used to discuss conceptual modeling in support of database design. Relational algebra is used to introduce SQL for querying and modifying databases. XML is used to introduce database support for semi-structured data • Introduction to database systems • Introduction to database design using E/R diagrams • Introduction to the relational model and SQL operations • Introduction to XML and database support to XML • Lab instruction on the use of database management systems • Database system development project
Course Days, Time and Location
Mondays and Wednesdays, 11:30am to 12:50pm, Room 308
Course Instructor
Dr. Paulo Pinheiro da Silva, Assistant Professor
Rm 222B (915)747-6373 paulo@utep.edu
Instructor's Office Hours
Mondays, 4pm to 6pm
Course TA
Jitin Arora
Email: jarora@miners.utep.edu
Jitin will have the following office hours for this class:
Fridays: 5:00 - 7:00 pm
Office: CS 300
Textbook
A First Course in Database systems, Second Edition,
by Jeff Ullman, and Jennifer Widom.
Grade Guidelines
Your grade is based on homework assignments, course project, class participation, a middle-term exam and a final exam.
Grade Calculation
| Class and lab participation | 10% |
| Homework/Quiz | 10% |
| Project | 40% |
| Three Exams | 40% |
| TOTAL | 100% |
Grade Guidelines for Graduate Students
Additional work is required for graduate students attending CS4342. "Extra" questions in homework assignments, which are optional for undergrad students, are mandatory for graduate students.
Homework Assignment Guidelines
There will be six homework assignments, which will include a mixture of written work and database programming.
- Late homework will be subject to a grade penalty of 20%
- No homework will be accepted if it is more than two days late.
Project Guidelines
TBA
Attendance
Your attendance is critical to your success in this course. You are expected to attend and actively participate in class and labs. This includes being prepared for class. You are expected to read the assigned pages from the text and to hand in all homework on time.
Standards of Conduct
Students are expected to conduct themselves in a professional and courteous manner, as prescribed by the UTEP Standards of Conduct and you must maintain academic integrity (http://www.utep.edu/dos/acadintg.htm).
Students may discuss assignments in a general way with other students, but the solutions must be done independently. Graded work should be unmistakably your own. You may not transcribe or copy a solution taken from another person, book, or other source, (e.g., a web page). Professors are required to–and will–report academic dishonesty and any other violation of the Standards of Conduct to the Dean of Students.
Disabilities
If you feel you may have a disability that requires accommodation, contact the Disabled Student Services Office at 747-5148, go to Room 106 E. Union, or e-mail to dss@utep.edu
Schedule
| Date | Weekday | Topic | Reading |
| Jan 21 | Wed | Introduction to information systems 1/2 | |
| Jan 23 | Fri | Introduction to information systems 2/2 | Ch. 2.1 and 2.2 |
| Jan 26 | Mon | Entity-Relationship Model 1/3 | |
| Jan 28 | Wed | Entity-Relationship Model 2/3 | Ch. 2.3 and 2.4 |
| Feb 2 | Mon | Entity-Relationship Model 3/3 | |
| Feb 4 | Wed | Homeland Security and Project overview | Ch. 3.1 and 3.2 |
| Feb 9 | Mon | Relational Model | Ch. 3.1 and 3.2 |
| Feb 11 | Wed | Project discussion / exam review | |
| Feb 16 | Mon | 1st EXAM | |
| Feb 18 | Wed | Functional dependencies/ Normalization | Ch. 3.4, 3.5, 3.6 |
| Feb 23 | Mon | Relational Design and Normalization | Ch. 3.7 |
| Feb 25 | Wed | Project presentation - Part I: E/R design | |
| Mar 2 | Mon | Relational Algebra | Ch. 5.2 |
| Mar 4 | Wed | Relational Algebra | |
| Mar 9 | Mon | SQL - Select-From-Where | Ch. 6.1 and 6.2 |
| Mar 11 | Wed | SQL - Select-From-Where | Ch. 6.3 and 6.4 |
| Mar 23 | Mon | Project presentation - Part II: Relational Model | |
| Mar 25 | Wed | SQL - Database Modification | Ch. 6.5, 6.6 and 6.7 |
| Mar 30 | Mon | exam review | |
| Apr 1 | Wed | 2nd EXAM | |
| Apr 6 | Mon | Database and PHP | |
| Apr 8 | Wed | Project presentation - Part III: Query implementation | |
| Apr 13 | Mon | ||
| Apr 15 | Wed | Semistructured Data/XML Transactions | Ch. 4.6 and 4.7 |
| Apr 20 | Mon | XQuery | |
| Apr 22 | Wed | Transactions | |
| Apr 27 | Mon | Project presentation - Part IV: Web Interface Implementation | Ch. 8.7 |
| Apr 29 | Wed | final exam review | |
| May 4 | Mon | 3rd EXAM |
