CSE 5330 Database Systems (Fall 2018, SH 121)
Sharma Chakravarthy
TA: Ms. Kanthi Komar, email: kanthisannappa@mavs.uta.edu
office hrs: ERB 514, M/W noon to 1:30pm + by appointment
Instructor Sharma Chakravarthy, email: sharma@cse.uta.edu,
office hrs: Tu/Th 11:15 am to 12:15pm + by appointment; ERB 632
This web site contains course notes ONLY!
See blackboard for project descriptions and submission details.
PLease send email to Both of us.
- Course Information
- Course Notes
- Project Information
- Exam & H/W Information
- Library Links
- Feedback Information
- Project Feedback slides
Announcements
see blackboard (elearn.uta.edu) for ALL project related information including submission.
please see project descrciption for percentage of grade for each phase (totals to 40%)
possible SQL project: 5%
test 1 12%
test ii 18%
test 3 20%
total is 50%
class participation and project presentation 5%
Module 1:
– Homework1:-
1. Draw the EER diagram for the problem statements given –
university_DB_ER.pdf (10/24/2018) – Solution
musicstore_ER.pdf (10/24/2018) – Solution
2. Solve the following problems from the book (depending on your book edition, select the problems listed below)-
4th Edition:
3.16, 3.17, 3.19, 3.21, 3.22, 3.23, 3.24, 3.25, 3.26
4.17, 4.18, 4.19, 4.20, 4.21, 4.22, 4.23
5th Edition:
3.16, 3.17, 3.19, 3.21, 3.22, 3.23, 3.24, 3.25, 3.28
4.17, 4.18, 4.19, 4.20, 4.21, 4.26, 4.27
Module 2:
– Homework2:–
5th Edition:
6.2, 6.4, 6.7, 6.17, 6.19, 6.20, 6.21, 6.22, 6.23
8.10, 8.11, 8.13, 8.14, 8.16, 8.17, 8.20, 8.21
(The tables for this homework are created in Dr. Sharma’s Oracle schema in omega and populated with the sample data. You can log into your Oracle account and use SHARMAC.tablename to reference a table.)
https://www.uta.edu/library/internet/computer.html
https://www.uta.edu/library/research/rt-cse.html
Feedback Information
Any Comments or Questions?
Drop a line to me – sharma@cse.uta.edu
Last Updated: 10/24/18