Jul 20, 2025  
2025-2026 Undergraduate Bulletin 
    
Catalog Navigation
  Bulletin Home
  SUNY Geneseo Mission, Vision and Values
  College Policies
  History of SUNY Geneseo
  Academic Programs
  Course Descriptions
  Requirements for Baccalaureate Degree Programs
  General Education Curriculum
  Baccalaureate Degree Programs
  Pre-Professional Advisory and Partnership Programs
  Academic Policies, Standards, and Information
  Academic Services
  Student Services
  Academic Organizations
  Student Accounts
  Student and Campus Life
  Campus Auxiliary Services
  Advancement
  Enrollment Management & Admissions
  Financial Aid
  Emeriti/Emeritae
  Archived Catalogs
  My Favorites
HELP
2025-2026 Undergraduate Bulletin
Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Favorites (opens a new window)

DANL 330 - Database Systems and SQL

Credit(s): 3
Lecture: 3
Non-Lecture: 0


The course introduces the fundamental concepts of database systems, database modeling, and database programming using SQL. The Entity-Relationship (E-R) diagram is investigated as a means for modeling data relationships. The relationships described by the E-R model are then implemented using the relational data model. The SQL database language is used to support operations on the relational model. Normalization and functional dependencies are used for efficient database design and to optimize tables. This course presents an example of applying a database application development methodology to a real-world project. Finally, big data and big data analytics are introduced as a means to perform data analytics tasks. Students are required to design and implement some database projects.

Prerequisite(s): DANL 101  and DANL 210  
Class Restriction: Junior, Senior


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Favorites (opens a new window)