CST 3504 - Design of Microcomputer Databases

Institution:

CUNY New York City College of Technology

Subject:

Description:

2 cl hrs, 2 lab hrs, 3 cr This course provides a general introduction to database design. The three main phases in database design are covered; that is, conceptual, using Entity Relational Diagram (ERD) and Unified Modeling Language (UML); logical, using relational model; and physical, using a Database Management System. The basics of relational data model (concepts of relation, attribute, primary key and foreign key) are reviewed, and mapping the conceptual model to the relational model is discussed. Advanced concepts of relational theory normalization and denormalization are included. Physical implementation is described with the help of a particular Relational Database Management System (RDBMS). The students must be familiar with SQL. Prerequisites: (MST 2304/MS 304 or CST 2304/CS 304) and CST 2406/CS 406

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lab

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.citytech.cuny.edu

Phone Number:

(718) 260-5500

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.