Contents
1 General Information ................................................................................................................ 2
2 Course Objectives ....................................................
...
Contents
1 General Information ................................................................................................................ 2
2 Course Objectives .................................................................................................................... 2
3 Course Information .................................................................................................................. 3
3.1 Course Organization ..................................................................................................... 3
3.2 Textbooks and Readings ............................................................................................... 5
3.3 Staff .............................................................................................................................. 5
4 Course Assessment .................................................................................................................. 5
4.1 Exams ........................................................................................................................... 6
4.2 Homework Assignments............................................................................................... 6
4.3 Software Project ........................................................................................................... 7
4.4 Oracle............................................................................................................................ 7
4.5 Grading ......................................................................................................................... 8
5 Other Important Issues ............................................................................................................ 9
5.1 Academic Honesty ........................................................................................................ 9
5.2 Commitment to a Safe and Inclusive Learning Environment .................................... 10
5.3 Students Requiring Accommodations ........................................................................ 10
5.4 Online Course Evaluation ........................................................................................... 10
5.5 In-Class Recording ..................................................................................................... 11
5.6 Software Use............................................................................................................... 11
5.7 Student Privacy ........................................................................................................... 11
5.8 Campus Resources: Health and Wellness .................................................................. 11
5.9 Campus Resources: Academic Resources .................................................................. 12
5.10 Specific Course Guidelines ........................................................................................ 12
5.11 Final Advice ............................................................................................................... 13
CIS 4301 UF Online Syllabus − 2 − Fall 2022
1 General Information
Credits
3
Course description from the under- graduate catalog
First part of a two-course sequence that studies the essential concepts, principles, and techniques of modern database systems. Topics include modeling and querying of data using conceptual data models as well as the development of a database application.
Course prerequisites
Formal: (COP 3504 or COP 3503) and COT 3100
Informal: Data structures and algorithms; web programming skills (e.g., PHP) needed (if a student does not have them, s/he must obtain them in self-study)
Instructor
Dr. Markus Schneider
Lecture times
Pre-recorded, 3 lectures posted per week
Office hours
Online with Zoom. See the course home page in Canvas for office hour times, Zoom URL, and password.
Individual appointments possible online with Zoom (please send an email to
[email protected] to set up a Zoom meeting)
Communication with student(s)
By using the UF email addresses of individual students or small groups of students, or by using the UF provided email address to the whole class; in all cases with the preceding special tag “[CIS 4301 UFO]” in the subject line
Communication with the instructor
By using the UF email address (
[email protected]) of the instructor with the preceding special tag “[CIS 4301 UFO]”, or by a personal Zoom meeting
Note: In emails students must use the tag “[CIS 4301 UFO]” in the subject line to indicate to the instructor to which course the student belongs; otherwise, the instructor takes the right to ignore the student’s email
2 Course Objectives
This course provides students with the essential concepts, principles, and techniques of modern database systems from a user perspective. This means that the course focuses on the functionalities that are offered by database systems and not on the methods to implement them. Specifically, the course teaches students the ability to develop (that is, design and implement) a solution to a real-world data management problem that requires the application of the theories and practices taught in this course.
From a theoretical point of view, this course covers the essential principles for the design, analysis, and use of computerized database systems. The design and techniques of conceptual modeling, database representation, and user/program interfaces are presented in a unified way. Specifically,
CIS 4301 UF Online Syllabus − 3 − Fall 2022
this course has the following overall learning objectives:
• Understand the differences between file systems and database systems
• Understand the features and advantages of database systems
• Perform conceptual database design based on the Entity Relationship (E-R) model
• Understand the relational data model
• Be able to transform an Entity-Relationship diagram into a relational database schema
• Comprehend the Relational Algebra and be able to formulate queries as algebraic expressions
• Learn the SQL query language (both relational and object-oriented components) and be able to formulate SQL queries of high complexity
• Comprehend the foundations of relational database design theory including functional dependencies and normalization as well as appreciate their relevance for database practice
• Learn possible technologies for database application programming
• Understand the main concepts and benefits of object-relational database systems and their difference to purely relational database systems
• Obtain general knowledge of advanced database systems
• Work and get experience with a commercial database system (e.g., Oracle)
• Design and implement a sophisticated web-based database application project that includes database design, user interface design, and their web-based connection
• Learn to work in a project group, argue, discuss, compromise, write technical documents, and solve arising social conflict situations at a professional level
From a practical point of view, students learn to deal with a commercial database system (Oracle). They learn how to apply theoretically understood concepts in a professional database environment. For example, they practice how to formulate ad hoc queries or how to write application programs in a database context. They also learn the complete process from devising a conceptual database design up to its transformation into the database schema of a concrete database management system.
By providing a balanced view of theory and practice, the material covered should allow the student to understand and use practical database systems. The student is provided with a basic under-standing of the issues and problems involved in database system development, knowledge of currently practical techniques for satisfying the needs of a database system, and an indication of the current research approaches that are likely to provide a basis for tomorrow's systems.
