Go to Main Content

SCT WWW Information System

 

HELP | EXIT

Syllabus Information

  

Fall 2024 Semester
Nov 21, 2024
Transparent Image
Information Use this page to maintain syllabus information, learning objectives, required materials, and technical requirements for the course.

Syllabus Information
CS 3200 - Introduction to Databases
Associated Term: Fall 2024 Semester
Learning Objectives: Describe how data may be acquired, stored, transmitted, and processed.Analyze at least one important type of data and summarize the results of an analysis in ways that provide insight.Use mathematical methods and/or computational tools to perform analysis.Evaluate and critique choices made in selection, analysis, and presentation of data.The focus of student effort in Database Design is 100% in the zone of data and all 4 Learning Objectives are emphasized throughout the course.Recognize when examination of a phenomenon or situation can benefit from problem solving techniques and analyses that use formal reasoning.Use their expertise in some applications of formal reasoning and know when to call upon domain experts when a problem is beyond their personal expertise.Generate artifacts that require formal reasoning and planning. These artifacts might include logical proofs, mathematical computations, software, simulations, problem solutions, or plans/analyses in a variety of disciplines that require a formal, systematic component.The entity-relationship model is a formal model that permits the database designer to guarantee that no item of data will be duplicated in multiple cells of the database. Prior to the theoretical work on this model, many databases had the flaw that the same item would occur in several different cells so that an update to the item needed to be done in multiple places. This led to serious bugs when a data item was not properly updated. Understanding the entity-relationship model and its application to building a clean (normalized) database is a central theme of the course. Students must apply this formal theory over and over to properly design databases.
Required Materials:
Technical Requirements:


Return to Previous New Search
Transparent Image
Skip to top of page
Release: 8.7.2.4